9 Replies Latest reply: Sep 27, 2011 4:56 PM by Kalpesh Pandey RSS

SAP BODS and SAP ECC integration for Vendor data

Kumar B
Currently Being Moderated

Hi  Folks,

 

I have a requirement to extract vendor data from SAP ECC  into SAP BODS. Could you please suggest me a best approach for extraction of vendor data from ECC into SAP BODS.

 

I really appreciate your prompt response.

 

Thanks,

 

Kumar.

  • Re: SAP BODS and SAP ECC integration for Vendor data
    Jeff Prenevost
    Currently Being Moderated

    You don't so much extract ECC data (of whatever sort) "into" BODS as "with" BODS.  You first need to make a connection -- a datastore -- in BODS, pointing at/connecting to your SAP ECC system. If you've never done that before, you'll want to make sure you read the BODS manual having to do with SAP (and you'll want to make sure to be on friendly terms with your local SAP Basis folks ;-).  Once that connection is made, you'll be able to see, from within BODS, SAP tables (along with other things, but, in this case, tables are fine -- vendor master data is fairly simple).  You'll want to import a number of tables, most likely -- KNA1, KNB1, etc.  You create dataflows within which you create ABAP dataflows within which you pull from the ECC tables in question. QED. In short, once you've got the SAP datastore setup correctly in BODS, and all the necessaries setup in SAP itself, the rest is pretty easy -- SAP tables just appear from within BODS as sources from which you can pull data, vendor or otherwise.

     

    Best wishes,

     

    Jeff Prenevost

    • Re: SAP BODS and SAP ECC integration for Vendor data
      Kumar B
      Currently Being Moderated

      Hi Jeff Prenevost,

       

      Thanks for your response. Could you please let me know how do I extract the identified vendor raw table fields in ECC into my local repository. I was told not to use ABAP FLOW transform or BAPI/RFC's. Is there anyother approach to extract the fields into my local repository.

       

      Thanks,

       

      Kumar

      • Re: SAP BODS and SAP ECC integration for Vendor data
        Jeff Prenevost
        Currently Being Moderated

        Once you've established your connection to BODS <> SAP connection, import the LFA1 table into your SAP datastore; suggest doing the import "by name," specifying "LFA1". Create a dataflow and put the LFA1 table there as a source. Pull your data out and put it wherever you want.  It's SAP ECC, yes, but it's not magic -- it's still "just a table," at least in this case. There are a number of other vendor-related tables, but LFA1 will get you started. The sticky part of this work is typically getting the BODS <> SAP connection setup correctly. Once that's done, the rest is pretty easy.

         

        Not sure why someone would have told you to not use an ABAP dataflow.  Seems odd. It's what you typically do, especially if you want to be able to push-down some filtering, group by, or sort to SAP itself (which is often a helpful thing to do). Seems like asking you to fry an egg without using the spatula. Odd.

         

        You don't import "data" into your "repository." In DS, the word "repository" is typically reserved to refer to the special databases that hold Data Services code. You will import metadata about the LFA1 table into a DS repository. Using that metadata, you can then use DS to transfer data per se to or from the table (although it's rare to send data directly into SAP ECC tables).

         

        Best Wishes,

         

        Jeff Prenevost

Actions