Data transfer feasibility

[Former Member]

Hi Experts,

We are looking for a solution to a problem.

We want to transfer data form EDW system to CRM system. For this we are thinking to use ETL(Extract Transform Load).

We are trying to connect the EDW database which is on DB2 to the CRM data base which is also on DB2 through ETL.

Through this connection we want to populate some Z-tables in SAP-CRM. We will use this Z-Tables to further populate SAP-Standard table.

Is this solution feasible???

Please let us know your valuable suggestions.

Help will be appreciated.

Thanks and Regards

Sourabh Verma

[Former Member]

hi ,

TABLE LEVEL updation is not preferable in sap .

because many tables get updated u may not consider all those things.

if u want to upload ztable data into sap tables . by using this ztable data you can go for data transfer using tcodes through bdc , bapi .

rgds

Chalam

[Former Member]

Hi Simha,

This Z-table will just work as a container for holding the data. The updation will only take place through standard method of BAPI or BDC. Is this approach right?

Regards

Sourabh Verma