topic Data transfer feasibility in Application Development and Automation Discussions

Data transfer feasibility

Former Member — Fri, 07 Dec 2007 12:47:57 GMT

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

Re: Data transfer feasibility

Former Member — Mon, 10 Dec 2007 08:07:25 GMT

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

Re: Data transfer feasibility

Former Member — Mon, 10 Dec 2007 10:03:27 GMT

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