Skip to Content

STEPS TO LOAD ATTRIBUTES FROM CSV

Note: Please go through “STEPS TO LOAD MASTER DATA FROM CSV” before working on this topic.

SAP Accepts data in two formats only CSV AND ASCII

In this scenario we are loading attributes 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

EAGE

ECOUNTRY

EDOOR NO

ESTREET

EPOCODE

EDOB

ETOB

EMAILID

EMOBILE NO

E001

CHRIS

25

UK

59

LIVERPOOL STREET

TRE 5RJ

19781120

225535

CHRIS @

  1. TESCO.CO.UK

7945612

E002

ANDREW

29

UK

90

FOIDL STREET

TW3 3AA

19821120

134550

ANDREW@

  1. TESCO.CO.UK 

789456

E003

JOHN

30

UK

1589

TEOLE AVENUE 

E13 45J

19891105

145025

JOHN@

  1. TESCO.CO.UK 

78989

 

  1. Go to InfoObjects and search for the Inforarea MANUDATALOADING. Now create the needed Inforobjects in the respective catalogues. Character Infoobjects in MANUCHAR and Key Figures in MANUKEYFIG. Right click on the MANUCHAR Infoobject to create the below given Infoobjects.
  2. List of Onfoobjects:
    • i. MANUEMP
    • ii. MANUNAME
    • iii. MANUEAGE
    • iv. MMCOUNTRY
    • v. MMDOOR
    • vi. MMSTREET
    • vii. MMPOCODE
    • viii. MANUDOB
    • ix. MANUTOB
    • x. MANUEMAIL
    • xi. MMMOBILE

Below given screenshot is after the infoobjects are created

 

Point2.PNG

 

3.     Now Go to MANUEMP Infoobject and right click and select change. Add the infoobjects in the Attribute section of MANUEMP Infoobject. Check it and activate it.

 

Point3.PNG

 

4.     Now go to Infoprovider and search for MANUEMP under MANUDATALOADING. Go to the Attribute section of MANUEMP. You will find here all the attributes you just added in MANUEMP in “Infoobjects”

5.     Now we will follow the same steps to load attributes data that we have used to load master data in “STEPS TO LOAD MASTER DATA FROM CSV” (Search SDN site with this name)

6.     The loading will be

    1. Data Source => Infosource => Infoobject

7.     Go to DataSources and search for application component ADEMPLOYIDAPPCOMP and then create a new DataSource MANUEMPLOYIDATTDS and in that you can specify in general info all the descriptions.  GO TO THE EXTRACTION TAB, choose adapter type: that data  is coming in text format from local work station, then in that file name attach your flat file and no of rows to be ignored   is  1 AND DATA FORMAT  CHOOSE CSV, DATA SPERATOR CHOOSE(,). THEN GO TO PROPOSAL CLICK ON LOAD EXAMPLE DATA

 

Point7.1.PNG

 

Point7.2.PNG

 

Point7.3.PNG

 

 

8.     NOW GO TO FIELDS CHOOSE NO AND INPUT ALL THE OBJECS IN THE SAME SEQUENCE OF FLAT FILE AND GO T O PREVIEW   AND CHECK AND ACTIVATE AND CLICK ON PREVIEW TO SEE DATA.

 

Point8.PNG

 

9.     GO To Infosources and search for the application component (ADEMPLOYIDAPPCOMP) and then create infosource (MANUEMPLOYIDATTINFOSRC) on that application component. In INFOSOURCE the name of the Infoobjects must match the infoobjects to load. Input all the objects in the same sequence as flat file structure and check it and activate it.

 

Point9.PNG

 

Now from this point onwards, we will create transformations and load the Attributes data

10.     Go to datasource and right click on datasource, choose create transformation make sure you specify source as datasource (MANUEMPLOYIDATTDS) and target as infosources (MANUEMPLOYIDATTINFOSRC). Check and activate transformation.

 

Point10.PNG

 

 

11.     Go to infosources (MANUEMPLOYIDATTINFOSRC) and right click on infosources, choose create transformations make sure you specify source as infosources (MANUEMPLOYIDATTINFOSRC) and target as infoprovider i.e. MANUEMP 

 

 

Point11.PNG

 

12.     Go to datasource, right click create infopackage (MANUEMPLOYIDATT 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.

 

 

Point12.PNG

 

 

13.     Go to datasource (MANUEMPLOYIDATTDS) 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 on top you can find data target administrator, the highlight request id and object name .click on contents. Click on execute button twice.

 

Point13.1.PNG

 

 

Point13.2.PNG

 

Point13.3.PNG

 

 

Point13.4.PNG

 

14.     Right click on infoobjects choose maintain master data to see data or Choose TCODE RSDMD AND TYPE IN TECHNICAL NAME OF infoobjects for which you want to see data.

 

Point14.PNG

 

15.     To check the data flow, go to Infoarea and right click on infoprovider   choose data display (upwards and downwards) click continue.

 

 

 

List of Objects used:

INFOSOURCE:                                    MANUEMPLOYIDATTINFOSRC

DATA SOURCE:                                  MANUEMPLOYIDATTDS

INFOPACKAGE DESCRIPTION:    MANUEMPLOYIDATT INFOPACKAGE

DTP:                                                       MANUEMPLOYIDATTDS / ADEMPLOYID -> MANUEMP

Note:    The next article would be loading the transaction data. In case of any query, you can reach me at munish_dhall@yahoo.com

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply