Temporary key, BP ID and Change number relation Table/API

[varun_jain3]

Hello experts,

We are using Customer master as Reuse model.

I would like to find change request number based on BP ID or temporary key from staging.

Note : Request is not approved  fully and not moved to ECC, still on staging.

Temp key Data element - USMD_TECH_KEY

Thanks & Regards,

Varun

[varun_jain3]

Hi Shankar/Prateek,

I have already looked on table via report USMD_DATA_MODEL.

I could not find any table stores information

Change request no                Temp key

000000120                                $1234

000000300                                $1750

Regards,

Varun

[former_member193350]

Hi Varun,

As mentioned by shankar you can go through SE11 and search the table from that pattern else you  can also run the report USMD_DATA_MODEL  in SE38 t code and gave the Data Model name  as in your case it is BP, then it will show the list of  all the generated tables(staging) with same pattern (1/MD/*) with the corresponding Entity name

Hope it helps.

Regards

Prateek Agarwal.

[former_member188878]

Please go to SE 11 search with in database table

/1MD/*

you will get all the tem tables related to MDG staging.