Correction of Unique Record Identifier
Case: URI, Unique Records Identifier is basically used to distinguish each record identical. Usually, it is a concatenation of Date, Time, DatapackID, Record number. Scenario: In my Standard DSO, URI got duplicated for more than one record. Somehow, datapackid is blank for both the records. Like below: Duplicated URI Record 1 000020180831115626 000000 0000001226 Record 2 000020180831115626 000000 0000001226 Steps to correct duplicated URI records in G* Layer DSO: 1. Create a copy the Original DSO. 2. Load the selected URI records from main DSO Layer to copy DSO and update with a new URI with below logic in Start Routine. DATA : WA_SOURCE_PACKAGE TYPE _ty_s_SC_1 , lv_pre_uri TYPE /BIC/OIXXXXX0002 , lv_uri TYPE /BIC/OIXXXXX0002 , lv_start TYPE c LENGTH 18 , lv_mid ( 6 ) TYPE N VALUE '000000' , lv_end TYPE c LE