SAP BW - Master data load via flat file

MASTER DATA LOAD TO ATTRIBUTES & TEXTS USING FLAT FILE - Yasmin Banu A

MASTER DATA (ATTRIBUTES) LOAD VIA FLAT FILE

INTRODUCTION:  Let’s firstly describe the scenario. We will be creating an Info Object (ZMATERIAL) for which we have load the master data  This Info Object contains Material related information. The master data is Material and attributes are created on, created by, material type, net weight and weight unit  This Info Object contains text where we will load employee names. There are two CSV files. One contains the master data attributes and other contains master data texts  Following are the detailed procedure for loading master data

STEPS TO LOAD MASTER DATA ATTRIBUTES

STEPS :TO LOAD DATA INTO PSA WITH INFO PACKAGE To load data into PSA, we will need to create a data source. Since, we have two types of data, Master Data Attribute and Master Data Text, we will need to create two data sources. Let’s firstly load the Master Data Attributes

MASTER DATA ATTRIBUTES STEPS :  Step 1 : Login to the BW server. Type in the t-code RSA1 in the command prompt. From the left side panel, choose Data Source. Then, from the Source system selection, choose the flat file

MASTER DATA ATTRIBUTES STEPS :  Step 2 : Choose or create an application accordingly. Then right click on the application component and choose ‘Create Datasource’

MASTER DATA ATTRIBUTES STEPS :  Step 3 : A pop-up will appear. Give a technical name for the data source. Choose the source system as FF and Data Type as Master Data Attributes. Then click continue.

MASTER DATA ATTRIBUTES STEPS :  Step 4 : Data Source has been created. Give a description in the General Info tab

MASTER DATA ATTRIBUTES STEPS :  Step 5 : Go to the Extraction tab, and specify the following fields 1) Delta Process : Full Upload 2) Direct Access : Allowed 3) Adapter : Load Text-Type from Local Workstation 4) File Name : Path where the source file resides in the computer 5) Header rows to be ignored : 1 (If a csv file doesn’t have a header, we need not mention 1) 6) Data Format : Separated with separator 7) Data Separator : ,

MASTER DATA ATTRIBUTES STEPS :

MASTER DATA ATTRIBUTES STEPS :  Step 6 : Go to the next tab, Proposal. Click on Load Example Data

MASTER DATA ATTRIBUTES STEPS :  Step 7 : Check and activate the data source.  Step 8 : In the Preview tab, click on ‘Read Preview Data’

MASTER DATA ATTRIBUTES STEPS :  Step 9 : Right click on the data source, and create an Info Package

MASTER DATA ATTRIBUTES STEPS :  Step 10 : In the pop-up, give the description for the info package. Click on Save button

MASTER DATA ATTRIBUTES STEPS :  Step 11 : Info Package is created. In order to load data into PSA, we will need to execute the info package. To run that info package, go to schedule tab and click on start.

MASTER DATA ATTRIBUTES STEPS :  Step 12 :In order to check the status of the load, go to info package monitor and check all data are loaded or not

MASTER DATA ATTRIBUTES STEPS : Step 13 : Create the necessary Info Objects in order to map with the fields of the data source. In our example, have created the following Info Objects (attributes): a) ZCREATEON (Created On) b) ZCREATEBY (Created By) c) ZMATLTYPE (Material Type)

MASTER DATA ATTRIBUTES STEPS :  Step 14 : Create the Material Info Object now. In general tab, specify the Data Type, length

MASTER DATA ATTRIBUTES STEPS :  Step 15 : In the attributes tab, add the above created info objects as attributes

MASTER DATA ATTRIBUTES STEPS : Step 16 : Check and activate the Material Info Object Step 17 : In order to make, this info object ZMATERIAL as an Info Provider, go to ‘Info Providers’ in the left hand menu, choose the Info Area and right click to choose the option ‘Insert Characteristics as Info Provider’

MASTER DATA ATTRIBUTES STEPS :  Step 18 : A pop-up appears as below. Specify the ZMATERIAL info object as we want to make it as our Info Provider. Click ok.

MASTER DATA ATTRIBUTES STEPS :  Step 19 : Right click on the Material Attributes & Create Transformation

MASTER DATA ATTRIBUTES STEPS :  Step 20 : A pop up appears, Give the Object type as Data source and Name as the name of the created Data source. Click ok

MASTER DATA ATTRIBUTES STEPS :  Step 21 : Create the transformations

MASTER DATA ATTRIBUTES STEPS :  Step 22 : Right click on the Data Transfer processes & create DTP

MASTER DATA ATTRIBUTES STEPS :  The following pop up appears, check the data source and target, then click ok

MASTER DATA ATTRIBUTES STEPS :  Step 23 :DTP has been created. Change the Extraction Mode to Full and activate the DTP

MASTER DATA ATTRIBUTES STEPS :  In the Update tab, change the error handling option as shown below. Check and activate the DTP

MASTER DATA ATTRIBUTES STEPS :  Step 24 : Click on the execute button of the DTP

MASTER DATA ATTRIBUTES STEPS : o Step 25 : By clicking execute, data will be loaded from PSA to Master Data Attribute. Right click on Material_Attr, choose ‘Manage’

MASTER DATA ATTRIBUTES STEPS :  Step 26 : In order to check the contents of master data attributes, go to ‘Info Object’, choose ZMATERIAL, select master data/texts tab, double click on /BIC/MZMATERIAL

MASTER DATA ATTRIBUTES STEPS :  Step 27 : It displays the table structure, choose “Contents”

MASTER DATA (TEXTS) LOAD VIA FLAT FILE

MASTER DATA TEXTS STEPS :  Step 1 : Go to Data Source in modelling, and create one for loading texts

MASTER DATA TEXTS STEPS :  Step 2 : Give a technical name & data source data type for data source. Click Continue

MASTER DATA TEXTS STEPS :  Step 3 : In general tab, provide the short, medium and long description.

MASTER DATA TEXTS STEPS :  Step 4 : In extraction tab, enter all the highlighted information

MASTER DATA TEXTS STEPS :  Step 5 : In proposal tab, Click ‘Load Example Data’

MASTER DATA TEXTS STEPS :  Step 6 : In Fields tab, map the source fields to the info objects

MASTER DATA TEXTS STEPS :  Step 7 : Save & Activate Data Source. Go to Preview tab, and click ‘Read Preview Data’

MASTER DATA TEXTS STEPS :  Step 8 : Create Info Package to load data from flat file to PSA

MASTER DATA TEXTS STEPS :  Step 9 : Give a description for Info Package

MASTER DATA TEXTS STEPS :  Step 10 : Start the load to PSA, by clicking on Start

MASTER DATA ATTRIBUTES STEPS :  Step 11 : Data load is successfully loaded to PSA

MASTER DATA TEXTS STEPS :  Step 12 : Go to info providers and choose the texts for material,

MASTER DATA TEXTS STEPS :  Step 13 : Give the data source information

MASTER DATA TEXTS STEPS :  Step 14 : Give the transformations. Check & Activate

MASTER DATA ATTRIBUTES STEPS :  Step 15 : Right click and create DTP

MASTER DATA TEXTS STEPS :  Step 16 : Click Continue

MASTER DATA TEXTS STEPS :  Step 17 : In Extraction Tab, Change the extraction mode to full update

MASTER DATA TEXTS STEPS : :  Step 18 : In Update tab, change the error handling to ‘2 Update Valid Records, Reporting possible (Request Green)

MASTER DATA TEXTS STEPS :  Step 19 : Check & Activate the DTP. Then click, execute

MASTER DATA ATTRIBUTES STEPS :  Step 20 : Check Manage Screen. Then, to check the Master Data Texts, go to Info objects, double click on the highlighted table

MASTER DATA TEXTS STEPS :  Step 21 : Choose Contents

MASTER DATA TEXTS STEPS :  Step 22 : The texts data loaded for material are shown in the table

SAP BW - Master data load via flat file

More Related Content

What's hot

Viewers also liked

Similar to SAP BW - Master data load via flat file

Recently uploaded

SAP BW - Master data load via flat file