Skip to Content
avatar image
Former Member

Extract Vendor Master Data to Excel sheet

Dear All,

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

Please advice me

Thanks

RS

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 17, 2009 at 12:03 PM

    Hi,

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Feb 17, 2009 at 12:29 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.