Manipulating Data Records

Use

Use

You want to skip or duplicate data records when you migrate data.

Procedure

Skipping a Record

If you want to skip a record (if you do not want to convert the record and enter it in the output file), enter the following in the code:

if <condition>.
   skip_record.
endif.
            

Skipping All Records of a Transaction

If you want to use a condition to specify that all records of a transaction are skipped, enter the following in the code:

if <condition>.
   skip_transaction.
endif.
            

Duplicating a Record

You want to generate two or more target records from a source record.

Example

Your customer master from the legacy data consists of a record that contains, among other things, a first name, second name, and telephone number for two contacts. In the SAP system, the record BKNVK must be filled for each contact.

Your legacy structure is as follows:

CUST customer master record
   ...
   FIRSTNAME1  First name of first contact
   SECONDNAME1 Second name of first contact
   TELEPHONE1  Telephone number of first contact
   FIRSTNAME2  First name of second contact
   SECONDNAME2 Second name of second contact
   TELEPHONE2  Telephone number of second contact
   ...

            
  1. Create the following conversion rules:

       ...
       BKNVK-NAME1 
      <-CUST-SECONDNAME1 (Move)
       BKNVK-TELF1 
         <-CUST-TELEPHONE1 (Move)
       BKNVK-NAMEV
         <-CUST-FIRSTNAME1 (Move)
    
                      
  2. Insert the following for the processing time:

    __End_of_Record__
       transfer_record.
       ...
       BKNVK-NAME1 = CUST-SECONDNAME2.
       BKNVK-TELF1 = CUST-TELEPHONE2.
       BKNVK-NAMEV = CUST-FIRSTNAME2.
       transfer_record.
    ... 
    
                      

    This generates two BKNVK records.