Flat File - Transaction Data

Loading Transaction Data from a Flat File into the system is slightly different from loading the master data into the system. Learning how to load transactional data from a Flat File involves the understanding of a scenario. For instance, Steps to load data to the DSO named “DEMO_DSO” with the following fields in the DSO,

Key Fields:

ZCUST - Customer

ZMAT – Material

Data Fields:

ZPRICE – Material Price

ZQTY – Quantity

Steps:

·         In the next screen,

• Navigate to Modeling tab->Source Systems.
• Right click on the folder named FILE and choose “Create” from the context menu.

o   Enter the Logical System Name.

·         o   Go to transaction code RSA1

·         ·         ·         ·         Right-Click on DTP folder and choose the option “Create Data Transfer Process” from the context menu.

·         ·         Load data to the DSO.

• Click Execute tab in the DTP.
• Click the Execute Button to start data load from the DataSource(PSA) to the DSO.