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 |
- 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.
2. Go to Infoarea(MANUDATALOADING), right click and then create a Datastore object
3. Specify technical name(MANUDSO) and description of DSO
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
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
6. Expand navigational attributes and check the objects which you require
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)
Load Example Data
Now activate and preview Data
10. Go to Infosources and create a Infosource with the name (MANUEMPLOYIDDSOINFOSRC)
11. Go to Datasource and create a transformation with source as Datasource (MANUEMPLOYIDDSODS) and target as Infosource ( MANUEMPLOYIDDSOINFOSRC)
12. Now Go to Infosource and create a transformation with source as Infosource (MANUEMPLOYIDDSOINFOSRC) and target as DSO (MANUDSO)
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.
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
Click the execute button
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
- Go to request tab
- Highlight your request and object on the upper tab
- First activate the request (in the bottom you can see Activate)
4. Then a pop screen appears
5. Choose your request id and click on the Start button and now you will see the request id has been activated
6. You can see in the bottom a job has been generated
7. Now you come back and click on the bottom refresh
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
11. and click on active data table
12. click on the execute button
13. Come back and click on change log table
14. check the status of the record
15. click on the execute button
16. you can see the data in the Active Data Table
17. Now come back and check the data in the DSO. Right Click DSO (MANUDSO) and click Display Data.
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 munish_dhall@yahoo.com
- SAP Managed Tags:
