|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
Step-by-Step tutorial to upload Master Data from Flat File (SourceSystem) to InfoObjects (Master data table)
Source System à
<Flat File source system name>
click on the header and Create Application Component.
name and description for Application Component.
technical name of Application component APC_CUSTOMER now gets saved as
click on the Application component and create DataSource
suitable DataSource name : DS_Cust
Source System : Flatfile
Data Type of DataSource : Master Data attributes à
as we are creating master data table.
Master Data Attributes, while you are uploading Master Data from file (DS1)
Master Data Text, while you are uploading Text Descriptions for the Master Data
right Window, you can view the Data Source properties.
In a Data source, we need to mention 2 details:
Name of Flat File
(ASCII or CSV) to be uploaded
(Layout) of the input file, mentioning the fields.
make the following changes:
name of file using F4, search for the file on you local desktop
rows to be ignored = ‘1’ (if file
has a header row as column titles)
= ‘0’ (if file has no header row)
Data Format as – “Separated with Separator (for ex CSV)”.
Enter the Data Separator as ‘ , ‘.
Click on the ‘Load Example’ tab. The details can be viewed in the
In the Template
Info field, enter the field names (characteristics/attributes).
[Enter] or [Save]
[Copy] : all
properties of the characteristics ( ex: data types, length etc) are copied here.
fields 0LANGU and 0TXTSH are the standard SAP defined characteristics
Click on “Read
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards