Skip to Content
0
Oct 22, 2019 at 07:06 AM

How to MAP Staging tables of LTMC 1809 to Source tables of SAP 1610

268 Views Last edit Oct 21, 2019 at 06:31 PM 2 rev

HI,

I am trying to transfer data from SAP S/4 Hana 1610 to SAP S/4 Hana 1809 using LTMC and using Informatica as an ETL tool.

As a process, I have created a staging schema in the database and created all the staging tables in the schema. When I am trying to use a Customer object in LTM I have 17 Staging tables that need to be filled from my Legacy system(i.e., S/4 Hana 1610). While doing that I am using Informatica as an ETL tool which will fill the data into Staging tables.

The structure of the staging tables is as follows.

Now my question how can I map all the fields in the staging tables to the S/4 Hana tables in 1610. As there are a lot of fields involved in creating the customer which has to be pulled from different tables like BUT000 or KNA1 or KNB1 etc., Is there any standard tables that can be used to do the fill the data into staging tables.

Also, In my 1610 system, we have created a customer with Internal number range and in the new system we are using External Number ranging as the Business partner number ranging. Will there be any changes barriers while doing the process.

Thank you