Load Transaction Data From Flat File:
We will figure out how to stack value-based information from a Flat File with the assistance of a situation.
Situation: Load information to the DSO named "DEMO_DSO". The DSO has the accompanying fields.
Key Fields:

In the following screen,
In the following screen,

Step 2: Create Application segment.




Step 3: Create Data Source.








Step 5: Create Data Transfer Process.


Step 6: Create Infopackage and Schedule dataload to the DataSource(PSA).




Step 7: Load information to the DSO.

Folkstrain offers a best online training for sap bi in usa, uk and globally with professionals in usa, uk and globally with professionals@ sap bi online training
We will figure out how to stack value-based information from a Flat File with the assistance of a situation.
Situation: Load information to the DSO named "DEMO_DSO". The DSO has the accompanying fields.
Key Fields:
- ZCUST - Customer
- ZMAT – Material
- ZPRICE – Material Price
- Gives look access to the Steps to Load information to DSO from Flat record
- Go to exchange code RSA1
- Click the OK catch.
In the following screen,
- Explore to Modeling tab->Source Systems.
- Right tap on the organizer named FILE and pick "Make" from the setting menu.
In the following screen,
- Enter the Logical System Name.
- Enter the Description.Click Continue Button.
Step 2: Create Application segment.
- Go to exchange code RSA1
- Click the OK catch.
- Explore to Modeling tab->Data Sources.
- Pick the Source System.
- Right snap - > Create Application Component.
- Enter the Technical Name.
- Enter the Description.
- Click Continue.
Step 3: Create Data Source.
- Go to exchange code RSA1
- Click the OK catch.
- Explore to Modeling tab->Data Sources.
- Right snap - > Create Data Source.
- Enter Technical Name.
- Pick the DataType DataSource.
- Click Continue.
- Enter the Fields demonstrated as follows. This Structure ought to be the same as the DSO to which exchange information is to be stacked.
- In the Extraction tab, pick the Adapter as "Burden Text-Type File from Local Workstation".
- Pick the record way where the level document to be stacked is set in the framework and enact information source.
- Go to exchange code RSA1.
- Click the OK catch.
- Explore to Modeling tab->InfoProvider.
- Make Transformation.
- Enter Target Object Type.
- Enter Target Object Name.
- Enter Source Object Type.
- Enter Source Object Name.
- Enter the Source System.
- Click Continue.
- Beneath screen demonstrates the change made with programmed mapping of the Source fields to the Target fields.
Step 5: Create Data Transfer Process.
- Right-Click on DTP envelope and pick the alternative "Make Data Transfer Process" from the setting menu.
- Beneath screen demonstrates the DTP made.
Step 6: Create Infopackage and Schedule dataload to the DataSource(PSA).
- Go to exchange code RSA1.
- Click the OK catch.
- Explore to Modeling tab->DataSources.
- Right tap on the DataSource - > Create InfoPackage.
- Enter the InfoPackage Description.
- Click Save.
- Click on Schedule tab.
- Click Start catch to begin the heap from the level record to the Data Source.
Step 7: Load information to the DSO.
- Click Execute tab in the DTP.
- Click the Execute Button to begin information load from the DataSource(PSA) to the DSO.
Folkstrain offers a best online training for sap bi in usa, uk and globally with professionals in usa, uk and globally with professionals@ sap bi online training