LTMC and tables/structures

[YogiKalra]

Hi friends,

We are new to S/4 and working on LTMC. Previously in LSMW we had to run the transaction and could get the table names/structures required to upload to. While LTMC of course, seems a lot more easily doable and user friendly, we find that in the template the table or structure name is missing. There is a LTMC structure but not the actual table or structure (BUT000, KNA1, ADRC etc).

1. How can we get this actual table/structure also in the download?

2. How do we manage upload to custom (Z) tables and/or screens and/or fields that are going to be a part of every project?

Many thanks!

Yogi

[Vincent_Zhu]

Hi Yogesh,

When you said you plan to load via Excel/API, are you planning to use LTMC? or you will develop your own migration programs?

In LTMC, it eventually calls internal BAPIs to create data in S/4HANA. So it will map the data from staging tables like S_CUST_G to the import parameters of the BAPIs. It's not table to table mapping.

Thanks,

Vincent

[Vincent_Zhu]

And regarding question 2, the Migration Cockpit (or LTMC) can also handle custom tables(Z-tables).

We will need to use the Migration Object Modeler (transaction LTMOM) to create custom migration object, and then you can download the migration template for the custom object to start the migration.

I would strongly recommended you to check the following page for more details about Migration Object Modeler:

https://help.sap.com/viewer/ffaed9ee977247e689972af70212149e/SHIP/en-US/aa522d5e44934907a3530e68b5cb...

Thanks,

Vincent

[Vincent_Zhu]

Hi Yogesh,

The way how LTMC (or Migration Cockpit) works is different from LSMW. Using Migration Cockpit, you don't need to care about the target tables(BUT000, MARA, etc.), as we are not directly migrating data into tables. However, Migration Cockpit will use APIs to migrate data. So it will go through all the checks while migrating the data, like you create the data from UI. It will ensure the data consistency and correctness.

All you need to do is to map the data correctly in the template from business perspective.

However, there is one tip I can share is that, in the migration template, under "Field List" sheet, you can unhide the two columns(like screenshot below), SAP structure and SAP field. If you are familiar with SAP table names and fields names, these information will definitely help you to map the data correctly.

Thanks,

Vincent

[YogiKalra]

Hi Vincent!

Thank you for your reply. Yes, we did go through this and I understand what you are saying about not needing the actual table. But we plan to load via Excel/API so need to know the actual tables - BUT000, KNA1 etc. Obviously that is known somewhere in the LTMC code as that is where it finally send the data from the staging tables like the S_CUST_G(eneral?) above so somewhere this is a mapping of this staging table with the actual tables...we need that...programmatically/automatically if possible.

Thanks!

Yogi