The entries in the SAP S/4 HANA staging tables aren't visible in SAP S/4 HANA Migration Cockpit.

[bogdan_popescu]

Dear all,

I created various jobs for data migration from SAP ECC System to SAP S/4 HANA System using SAP Data Services into S/4 HANA staging tables.

After successfully populating the S/4 HANA staging tables with values, the next step would be to ' start transfer ' using migration cockpit, transaction LTMC.

The entries in the staging tables are visible in SAP Data Services and SAP S/4 HANA ( Transaction SE16 ), but not in migration cockpit, transaction LTMC. Please see the below screenshots for more information.

entries-visible-in-s4hana.png

entries-arent-visible-in-ltmc.png

Could it have an impact that the user name of the Datastore is different than the Owner of the staging tables, which has been changed from BODSSYSM to SAPHANADB?

Please let me know if you require additional information.

Thank you,

Bogdan Popescu

dbconnection.jpg

datastorehana.jpg

ownerstagingtables.jpg

[former_member210043]

Hi ,

I am also Facing the same Issue. Any help please.

Thanks,

Nikil

[guna91]

For us the solution is to change connection type(DB Connection Name) in LTMC. If you use, underlying HANA DB of S4HANA for staging table generation, please use 'Default' connection.

[guna91]

Hi, I too have same error. I see records in Staging tables but when I transfer from LTMC it shows 0 unprocessed records. Anyone please help.

[former_member713524]

Hi,

Any update on this? I have the same issue for the "VC - Variant Configuration" object. The first table is fine, but for the following tables it's showing 0 entries. I debugged until the kernel function: CL_SQL_STATEMENT-->execute_query() and there it is returning 0 entries...

/1LT/DSQS4000699 49

/1LT/DSQS4000700 0

/1LT/DSQS4000701 0

/1LT/DSQS4000702 0