on 02-17-2009 12:02 PM
Dear All,
How to extract the vendor master data from SAP to Excel sheet?
Please advice me
Thanks
RS
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
Hi,
You need to extract data from tables LFA1, LFB1, LFM1 and consolidate it in excel.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.