Link between change request number and SAP business partner number

[isabelle1993]

Dear community,

I have a question regarding the link between a change request and the bp number, because I have to create a report which user created which vendor. In table USMD120c I find the change request number and the User. Now I need the link to the created SAP Number regarding the change request.

In which table can I find this information?

Best regards

Isabelle Köhler

[FredericGirod]

You could find yourself using SQL trace with transaction ST05n

[isabelle1993]

With ST05n I get the message "Transaction is unknown".

[achim_stroh]

Hi Isabelle,

creator of the vendor / BP / customer on database (KNA1/LFA1/BUT000) will always be SAP_WFRT (the technical user that is handling the change requests). But there is a specific requestor of the change request and a (maybe different) approver of the change request.

Please have a look at the FIORI App "Change Request Analysis" - maybe this is already what is interesting to the person who asked you to create such a report.

Kind regards,

Achim

[former_member443654 · Accepted solution]

Dear Isabelle,

You can use the MDG related API to fetch the data related to chagne request.

For E.G. cl_usmd_model_ext method read_entity_data_all by providing the Entity name.

table USMD1213 is a temporary table which will be stored in local directory in your system and can be changed in the other systems so it is not the right way to fetch the data directly from USMD1213 istead use the above class and method to read the entity data based on Change request.

Thank you..