data load from ECC to R3

[Former Member]

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?

[former_member187605]

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.

[Former Member]

Hi Dirk,

Right now , I do not have direct access to underlying database for R3. So I have two datastores with SAP Apllications as the type. One datastore is for ECC. Other datastore is connects to R3. If I want to load data in R3 table (it is a z table) , how can I do that? I cannot load data in a normal dataflow as the target table is a R3 table. I cannot use IDOC as it is a z table.

[former_member187605]

That's why you need direct access to the underlying database.

Your other option would be to write a BAPI to fill the Z-table and call it from DS.

[Former Member]

Hello,

I think your best approach is using a RFC connection.

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