Vendor Master Record - Extracting Data?

[Former Member]

Is there some way to extract all data from the Vendor Master Records in a cleansing client, so that it can then be loaded to the production client?

[Former Member · Accepted solution]

Hi,

you can get the vendor master and its field names from below tables, to upload the master data you can use LSMW /BDC option. For BDC ,abapor can help you.

LFA1- General section

LFAS -VAT registration numbers general section

LFB1 -Company code

LFB5 -Dunning data

LFBK -Bank details

LFC1 -Transaction figures

LFC3 -Special G/L transaction figures

Thanks & Regards,

Sandesh Sawant

LFM1 -Record purchasing organization data

[Former Member]

Thank you, both!

[Former Member]

We also have a load system to already load all legacy data to the cleansing client. Once in the cleansing client, we will be going through a de-duping process. I'm researching on how to move the clean data in the cleansing client to the production client then.

[JL23]

I would use an ALE scenario.

...either for direct load

-.. or to extract the data as IDOCs into a text file, which then could be used as source for LSMW to load the data as well by IDOC method.