Transformation Routine to convert single record into multiple

[Former Member]

All,

I need your help with ABAP Syntax. My requirement is to take a single record and convert it to multiple records into a DSO with a condition to not create a record if a KF value is 0.

R/3 Data Record:

Employee | Date | Char1 | KF1 | Char2 | KF2 | Char3 | KF3 | Char4 | KF4

Conversion Result into DSO:

Employee | Date | Char1 | KF1

Employee | Date | Char2 | KF2

Employee | Date | Char3 | KF3

Employee | Date | Char4 | KF4 (This record will not be written if no value is in KF4)

I have read about the result table in update rules, however within BI 7.0 Transformations I am unfamiliar as to where the RESULT_TABLE function applies. Has this been replaced by the Expert Routine?

Could any ABAP expert provide sample code as to how I would perform this conversion in a Transformation Routine?

Thanks,

David

[Former Member · Accepted solution]

it seems you can perform it in start routine. use operator APPEND

Alex

[Former Member · Accepted solution]

Thanks Alex for your response.

I did find a solution to this as it turns out to be fairly simple, however I executed the routine as an Expert Routine instead of a Start Routine. I was advised to do the transformation here.

The basic concept is defined below:

Loop at source_package assigning -kf2.

          Append result_fields to result_package.

       Endif.

-- Kf3u2026  and so on

Endloop.

Basically the APPEND statement is used to create the additional records.