Step-by-Step tutorial to upload Master Data from Flat File (SourceSystem) to InfoObjects (Master data table)

By Lakshmi MP, Perot Systems 

Basic Steps of Data Flow (ETL process):

  1. Determine the Source System (Flat File/SAP R3/WebServices etc)
  2. Establish an interface w.r.t the Source system used
  3. Create a Data Source – which has a structure similar to the Source structure. Consider two factors : Name of file and Structure same as Source.  
  4. Create Info Provider to transfer data from Data Source to PSA (Persistent staging Area)
  5. Create a Target (Info Provider : InfoObjects/Info Cubes/DSO etc)
  6. Create a Transformation rule to map Source & Target fields.
  7. Create DTP (Data Transfer Process) to transport data stored within PSA , to the final Data Target.  

Transaction Code – RSA1 : Data Warehouse Workbench

 

Source/Input: Create a Flat File of type CSV, with the following structure:  

Customer

Language

Land

City

Name

260

EN

US

SEATTLE

JOHN

261

DE

DE

HAMBURG

SAM

262

DE

DE

WALDORF

MICHEAL

Right click on the InfoProvider column header. Select “Create InfoArea”  

 

Enter the details – InfoArea name and Description  

 

 

The InfoArea – IA for Customer appears on the InfoProvider list.  

Right click on the created InfoArea and create InfoObject Catalog  

 

Enter a suitable Name and Description for InfoObject Catalog.

Select ‘Char.’ or ‘Key Figure’ based on the type of data (Master data/ Trans. Data) needs to be created.

In this case, we are creating Master data. Hence, we need to create Characteristics InfoObject.

Select ‘Char.’

Click on Create.  

The InfoObject Catalog appears right under the InfoArea created earlier.

Now, right click on the InfoObject Catalog and create Info Object.  

Click here to continue...

Please send us your feedback/suggestions at webmaster@SAPTechnical.COM 

HomeContribute About Us Privacy Terms Of Use • Disclaimer • SafeCompanies: Advertise on SAPTechnical.COM | Post JobContact Us  

Graphic Design by Round the Bend Wizards

footer image footer image