cancel
Showing results for 
Search instead for 
Did you mean: 

Extract Vendor Master Data to Excel sheet

Former Member
0 Kudos

Dear All,

How to extract the vendor master data from SAP to Excel sheet?

Please advice me

Thanks

RS

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

First of all, whats the purppose of your data download?In case, its related to any functional analysis, the functional consultant has to download the data.

Regards,

Shilpa

Former Member
0 Kudos

See every week, here the end user updates the vendor and also creats news in mass.

So they want to be automatic, the vendor detaisl will be keyin by vendors through Webpage, which all the information is stored in SQL Database server, from their ABAP consultant can read the SQL database to create new or update vendor master in SAP?

If this can be done, then they need all the information from SAP with existing vendor master records to be copied in SQL database for update vendor master infor in future.

First is it possible to Have an SQL server database, from which the data are read and create new or update vendor master?

or

SQL server database --> Interface --> SAP (load data to create vendor master automatically)? is this is possible, which interface can be used?

All you valuable suggestions are welcome.

Thanks

RS

Former Member
0 Kudos

Your data store in SQL database,then you need to build a simple transaction using .Net (dot net) software-->using SAP connector , you can link and call a SAP Function module (this function module used to change data in R/3 > act like MK02 or XK02> you can record the transaction using SHDB to get the source code).

In dot net application you map the parameter to SAP Function module parameter.All the trigger of change/process data should be from dot net application, R/3 will be the reciever.

pankaj_singh9
Active Contributor
0 Kudos

Hi,

You need to extract data from tables LFA1, LFB1, LFM1 and consolidate it in excel.

Former Member
0 Kudos

Thanks for your advice, but is it done through ABAPER? or i have to do this, please guide regard this

Regards

RS

former_member581212
Active Contributor
0 Kudos

hi,

Go to SE16 tcode...

Then enter the any of the above tables for eg LFA1 etc...

and press execute..

Then enter your requirements and again execute...

you'll see s=details of vendors...

then go to edit > download > here choose for spreadsheet...and continue...

Hope it helps..

Regards

Priyanka.P