Same LTMC Staging table throughout the SAP Environments

[imran01]

Hello,

Did anyone across a scenario where we have multiple SAP systems and we have to work with LTMC staging tables. The issue is the name of staging tables get changed in another sap system for same object.

Because of the different table name, we will be having difficulties manages the tables in BODS. Because if we want load data in another sap system, we will need to change the table. For example if we have 10 SAP systems then 10 different staging tables for the same object and we will have to manage those 10 tables each time we execute the BODS job.

Can anyone please explain if you have come across this scenario.

Thanks,

Imran 

[koolspy_ultimate]

You need to use synonym tables to handle this.

As these synonym tables can be used as common target in BODS and these will be remaining unchanged. 

Please find detailed explanation in the below link Click here 

[Sybille]

Hi Imran,

please check blog post

https://community.sap.com/t5/enterprise-resource-planning-blogs-by-sap/sap-s-4hana-migration-cockpit... 

Best regards,

Sybille