How to reactivate/adjust MDG staging tables

[Former Member]

Dear Experts,

Can any one let me know how to reativate/adjust the the MDG staging tables?.There are some staging tables in which i have changed the length of domain. Now to reflect the changes of that domain in all tables i need to reactivate/adjust them.

Pls help me on how to achieve this.

Thanks

KH

[shaila_kasha]

Hi, please let me know if anyone were able to solve this issue. I have a similar issue. one of the generated staging table for a type4 entity with active area as MDG, is not getting activating after updating data type from date to time.

se14 is not helping and se11, activation is not working.

is there a way to force activate the structure in MDG. we are on MDG 8

[former_member663017]

Hello,
Please check that the Data Model is Activated, and then execute the following reports.

1. USMD_DATA_MODEL ( You can check the staging table by double-clicking on it)
2. USMD_ADJUST_STAGING

This should reflect the changes

[Former Member]

Try activating the data model.

After activating data model, execute below report

USMD_ADJUST_STAGING

[Former Member]

Thank you.

If i use USMD_ADJUST_STAGING, does it will ask for transport request?.

Because i need to transport the tables to QA,PRD systems.

Thanks

KH

[Former Member]

No it will not ask for transport request. You have to repeat executing USMD_ADJUST_STAGING in QA and PRD systems.

[Former Member]

Hi Katrice,

Whether able to adjust the the MDG staging tables ?

[Former Member]

You can re-activate the tables in SE11. Do not change the tables there; only re-activate.