Lecture 4 Extraction and Data Staging

In this lecture we are going to cover the 

• Extraction of the data records from the pricing condition tables in ERP, 
• the DSO we are going to use as the staging objects and 
• the transformations from the DataSources to the DSO.
• We are also going to view the Process Chain required and add the infopackage and DTP to the chain

The code for the routines and any configuration settings can be found lower down the page.

Configuration Settings

Routines in Transformations

 0AMOUNT

Source Fields

KBETR

KRECH

Routine

if SOURCE_FIELDS-krech = 'A'. "Percentage

    RESULT = SOURCE_FIELDS-kbetr / 10.

else.

    RESULT = SOURCE_FIELDS-kbetr.

endif.

0CURRENCY

Source Fields

KONWA

KRECH

Routine

case SOURCE_FIELDS-krech.

   when 'A'.

      RESULT = ''.

   when others.

      RESULT = SOURCE_FIELDS-konwa.

endcase.

0UNIT

Source Fields

KMEIN

KRECH

Routine

    case source_fields-krech.

      when 'A'.

        result = result = '%'.

      when others.

        result = source_fields-kmein.

    endcase.

LOTSIZE

Source Fields

KPEIN

Routine

    if source_fields-kpein = 0.

      result = 1.    else.      result = source_fields-kpein.    endif.

Transformations

ZBW_SDKOND304

ZBW_SDKOND305

ZBW_SDKOND307

Next: Lecture 5 >>