vendor master data upload

[Former Member]

how do we upload vendor master data into SAP from legacy system.can anyone give me a detailed explination.

regards,

deepthi

[Homiar]

Deepthi,

There are several ways you can upload the Vendor Master.

• LSMW (Standard program, Recording, IDoc)

• IDoc

• Custom program (SHDB)

Regards,

Homiar.

[Former Member]

thanks homiar.

can u tell me the procedure either using lsmw or custom program. actually iam getting data in a text file format.

regards,

deepthi

[Homiar]

Deepthi,

LSMW is recommended.

Please write if you are conversant with LSMW or do you want me to details the steps ?

Regards,

Homiar.

[Former Member]

hi,

thanks homair

can u give me the detail steps of uploading vendor master data using lsmw. i have to upload the general data, transaction data, and bank data. these are the fields i am using.

LIFNR BUKRS EKORG KTOKK TITLE_MEDI NAME1 NAME2 SORT1

STREET HOUSE_NUM1 POST_CODE1 CITY1 LAND1 REGIO

AD_TZONE AD_POBX POST_CODE2 POST_CODE3 LANGU

TEL_NUMBER TEL_EXTENS FAX_NUMBER REMARK KUNNR

STCD1 STCD2 BANKS BANKL BANKN BKONT LNRZA AKONT

ZUAWA QSSKZ QLAND QSREC ALTKN PERNR ZTERM TOGRU REPRF ZWELS ZAHLS LNRZB HBKID INCO1 INCO2 KALSK WEBRE

WAERS BSTAE PARVW GPARN

regads,

deepthi

[Homiar]

Deepthi,

The steps would be (in LSMW) :

1 Create a new Project, Subproject (if not existing). Then give a name for the Object, say VendorMaster.

2 On the next screen, you will see several steps (radio buttons) to be performed. You should go in sequential order.

Double click the first, I think its called Maintain Object (sorry don't have access to SAP system right now)

3 On this screen you will see various options/methods (in the second section) for loading the data.

You may select which ever is appropriate or most suitable in your case.

Let's assume you want to use the very first options - Standard program for Direct Input/Batch.

4 Pull down (F4) for the Object & select Vendor Master.

5 Pull down again for the Method & select (I think( Standard). The program name & Type will be populated by LSMW.

If let's say none of the programs in this list satisfies your requirement, then you may decide to go for a Recording or a BAPI (again pull down & select appropriate method) or IDoc (CREMAS).

So now you have decided on the method you want to use for posting the Vendor Master data. Save the information & go back to the main screen of the object.

6 Double click on the next step for maintaining the Source Structure. Give the name(s) of the Source Structure(s).

7 Next step is to define the Source Structure(s) format (fields, attributes etc).

8 Next you maintain the relationship between the Structure(s) - Source & Target. The Target structures depend upon the method elected by you in step 5.

9 Next will be the most important step - ie specifying the mapping/conversion rules for each Target field. You can even write ABAP code by double clicking on the field - it will open up the editor where you can put in your ABAP code. There are also several events available - for instance at the <i>Beginning of Processing</i> or <i>Beginning of Transaction</i> etc. where again you can specify your own logic.

10 In the Next 2 steps you will give the file name & path & also associate the file(s) to the Source structure(s).

The develoment for the object is complete. Now you are ready to read, convert & post your Vendor Master data in SAP.

Let me know if you need additional assistance.

Regards,

Homiar.

[Homiar]

Deepthi,

Let me know if you need additional assistance.

Regards,

Homiar.

[ferry_lianto]

Hi Deepthi,

Have you looked at program <b>RFBIKR00</b>?

Hope this will help.

Regards,

Ferry Lianto

[Former Member]

Hi

I am also trying to upload vendor master data and the program I used was the direct input program RFBIKR00. However this did not suffice because of the following reason .

1. The vendor addresses are centrally managed and has to be loaded before the vendor master data is loaded .

2. Loading of addresses can however be done using a BAPI.

3. But using RFBIKR00, there is no means of passing the address reference that was created . Hence this direct input did not work for me ,

4. I opted to do a BDC recording .

If anybody has done the loading of vendor master using the central address administration , please let me know too ,

Thanks

Bala