Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Sap BI: Load Transaction Data From Flat File

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:
  • ZCUST - Customer
  • ZMAT – Material
Information Fields:
  • ZPRICE – Material Price
  • Gives look access to the Steps to Load information to DSO from Flat record
Step 1: Create source framework for level document.
  • 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.
Step 4: Create change between Data Source(Source) and DSO(Target).
  • 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 [email protected] sap bi online training


This post first appeared on Sap Crm: Account Management, please read the originial post: here

Share the post

Sap BI: Load Transaction Data From Flat File

×

Subscribe to Sap Crm: Account Management

Get updates delivered right to your inbox!

Thank you for your subscription

×