Currently Being Moderated

STEPS TO LOAD DATA IN DSO - DOc-#4

STEPS TO LOAD DATA USING DSO

 

SAP Accepts data in two formats only CSV AND ASCII 

In this scenario we are loading master data, where our source system is a Flat file, as the data is coming from Flat file in CSV format 

Note:    Save the below given extract. When you are saving the data in flat file it should be saved as .CSV and type of file CSV. 

EID

ENAME

GSALARY

CURRENCY

NI CONTRIBUTIONS

TAX

E001

CHRIS

50000

GBP

10000

2000

E002

ANDREW

65000

GBP

15000

3000

E003

JOHN

75000

GBP

20000

4000

E004

RAM

85000

GBP

25000

5000

E005

GAURAV

95000

GBP

19000

6000

E006

VISHU

75000

GBP

35000

7000

E007

SUBHAS

50000

GBP

40000

8000

E008

MOHIT

65000

GBP

45000

9000

E009

RISHI

75000

GBP

50000

3000

E010

DALJEET

50000

GBP

55000

4000

E011

GAURAV

65000

GBP

60000

5000

E012

DEEPAK

75000

GBP

65000

6000

E013

JOHN

50000

GBP

70000

7000

E014

VIJAY

65000

GBP

75000

8000

E015

PETER

75000

GBP

80000

9000

E016

GHOSAL

50000

GBP

85000

3000

E017

RAM

65000

GBP

90000

4000

E018

RAJAT

75000

GBP

95000

5000

E019

RAJANI

75000

GBP

100000

6000

E020

NIM

90000

GBP

105000

3000

E021

SAPNA

95000

GBP

110000

4000

E022

RAPNA

102500

GBP

115000

5000

E023

ASHISH

110000

GBP

120000

6000

E024

SAI

117500

GBP

125000

3000

E025

RAGHAV

1000

GBP

130000

5000

 

 

 

  1. Below given are the infoobjects you need to load the data in the DSO

Note:    Refer “STEPS TO LOAD MASTER DATA USING CSV” to learn to create Infoobjects, Infoobject Catalogue and Infoarea.

 

Point1.PNG

 

2.     Go to Infoarea(MANUDATALOADING), right click and then create a Datastore object

3.     Specify technical name(MANUDSO) and description of DSO

 

point3.1.PNG

 

point3.2.PNG

4.     ON THE right hand side navigation drop down settings, make sure  you choose type of DSO as  a standard DSO and make sure you check below options  based on requirement and then drop down key fields 

 

point4.PNG

 

5.     Now insert the  primary objects to in to key fields by clicking infoobjects catalogue for char  and then insert remaining characteristics and key fields in to data fields  by clicking  respective infoobjects catalogue of  char and keyfigures 

 

point5.PNG

 

6.     Expand navigational attributes and check the objects which you require

 

point6.PNG

 

7.     Check and activate the DSO.

Now from this stage we will start loading data in the DSO

8.     The steps of the data flow is :

               Datasource=> Infosource=>Standard DSO

9.     Go to DataSources and create a datasource with the name (MANUEMPLOYIDDSODS)

 

Point9.1.PNG

 

 

Point9.2.PNG

 

Point9.3.PNG

 

Load Example Data

 

Point9.4.PNG

 

Point9.5.PNG

 

Now activate and preview Data

 

Point9.6.PNG

 

Point9.7.PNG

 

10.     Go to Infosources and create a Infosource with the name (MANUEMPLOYIDDSOINFOSRC)

 

Point10.1.PNG

 

Point10.2.PNG

 

 

Point10.3.PNG

 

 

11.     Go to Datasource and create a transformation with source as Datasource (MANUEMPLOYIDDSODS) and target as Infosource ( MANUEMPLOYIDDSOINFOSRC)

 

Point11.1.PNG

 

Point11.2.PNG

 

12.     Now Go to Infosource and create a transformation with source as Infosource (MANUEMPLOYIDDSOINFOSRC) and target as DSO (MANUDSO)

 

Point12.1.PNG

 

Point12.2.PNG

 

 

13.     Go to datasource MANUEMPLOYIDDSODS, right click create  infopackage (MANUEMPLOYIDSO INFOPACKAGE)   and load the data to PSA, same like datasource steps and you can see data in PSA by clicking top monitor button.

EXTRACTON TAB FOLLOW THE SAME STEPS AS DATASOURCE

PROCESSIG (NOTHING TO DO)

UPDATE FULL UPDATE 

SCHEDULE- CLICK ON START DATA LOAD

Once data has been loaded in to PSA you can see bottom of the page data was requested. On the top of the screen you can see monitor symbol. Click on that and you can see data has been loaded successfully in to PSA

If the request is green then data load is successful, Red means failed and yellow means it is still in staging process then click on refresh button until you see red or green. 

Monitor tab has been divided Header, status and details

Header: all the information about data load

Status: all the stages of loads 

Details:  all the IDOCS

On the top of the screen you can find a button called PSA maintenance. Then you can see the data in PSA. 

 

 

Point13.1.PNG

 

Point13.2.PNG

 

Point13.3.PNG

 

Point13.4.PNG

 

Point13.5.PNG

 

 

 

    Point13.6.PNG

 

14.     Go to datasource (MANUEMPLOYIDDSODS) right click create DTP to bring the data from PSA to infoprovider make sure it is full or delta and check it and activate it. Click one execute button to bring the data to infoprovider. Once you click on execute button, system will prompt you to display monitor screen, Click on yes , which will take you to the monitor screen

Note: Every data load will have unique request id ex: 3656

THEN CHECK DATA LOAD IS SUCCESFULL

 

Point14.1.PNG

 

Point14.2.PNG

 

Point14.3.PNG

 

Click the execute button

 

Point14.4.PNG

 

15.     Once you have scheduled DTP  and bought the data to DSO (STANDARD DSO: MANUDSO) make sure you activate request id to bring the  data from inactive table to active table and at the same time check the status of the record in the change log table (Note: mainly record mode symbol)

 

Steps to activate the request id

  1. Go to request tab 
  2. Highlight your request and object  on the upper tab
  3. First  activate the request (in the bottom you can see Activate) 

 

npoint3.PNG

 

4.     Then  a pop screen appears

 

npoint4.PNG

 

5.     Choose your request id  and click on the Start button and now you will see the request id has been activated 

 

npoint5.PNG

 

6.     You can see in the bottom a job has been generated

7.     Now you come back and click on the bottom refresh

 

npoint7.PNG

 

Note: until you activate request id you can’t push the data to active table

8.     Now click on contents tab 

9.     you can see bottom  new data table 

10.     click on that  execute it 

 

npoint10.PNG

 

11.     and click on active data table 

12.     click  on the execute button 

 

npoint12.PNG

 

13.     Come back  and click on change log table 

14.     check the status of the record 

15.     click on the execute button

 

npoint15.PNG

 

16.     you can see the data in the Active Data Table

 

npoint16.PNG

 

17.     Now come back and check the data in the DSO. Right Click DSO (MANUDSO) and click Display Data.

 

npoint17.PNG

 

 

List of objects used:

 

DSO:                      MANUDSO

INFOSOURCE:    MANUEMPLOYIDDSOINFOSRC

DATA SOURCE:  MANUEMPLOYIDDSODS

INFOPACKAGE DESCRIPTION:    MANUEMPLOYIDSO INFOPACKAGE

DATA TRANSFER PROCEDURE:   MANUEMPLOYIDDSODS / ADEMPLOYID -> MANUDSO

 

 

Note:    The next article would be re-scheduling data in the DSO and then load data in INFOCUBE from DSO. In case of any query, you can reach me at munishsap@yahoo.com

Comments

Delete Document

Are you sure you want to delete this document?

Actions