Skip to Content
avatar image
Former Member

data load from ECC to R3

there is a z table created in SAP R3. I need to load material data in z table from SAP ECC. Only material numbers. How can I load this table using SAP BODS?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 15, 2015 at 01:31 PM

    Hello,

    I think your best approach is using a RFC connection.

    Take a look at: Overview SAP Interfaces - Enterprise Information Management - SCN Wiki

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 15, 2015 at 05:09 PM

    You can do with 2 datastores:

    • SAP Applications datastore for the source
    • Database-based datastore for the target

    If your source data is in one table only, you can safely use a normal data flow. If the logic is more complex, use an ABAP data flow. In both cases, use the Z-table as target table.

    Add comment
    10|10000 characters needed characters exceeded