a table with direct relation among the Request for Change, Change Types and TRs

[SAPSupport]

Hi Team,

We want to generate a report with relation between a Request for Change --> Normal Change --> All the TRs associated with it (in separate rows)

As of now, we export the data from the CRM_UI page, however, the relationship between the three is not available and we map that manually.

Can you please help us guide a way in which we can extract the data and create a report with relationship among the three or please let us know if a table is available with direct relation among the Request for Change, Change Types and TRs.

Regards,

KPMG Team

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[stephane_bustarret1]

Hello, were are Ovee (French ALM company) and we could help you with this inquiry. We actually have developed a tool allowing to support Auditor's work in that area. If you are interested, feel free to reach out to us and I will be glad to make a demo for you.

[SAPSupport · Accepted solution]

Hi team,

• In standard, there is no such single table to display those data. In standard, you could go to sm_workcenter->admin cockpit->tab 'search', under the enterprise search, you could search all the data you required, like request for change ID, change type and TRs. All these data could be searched/displayed there. 
• The tables for checking transaction type could be CRMD_ORDERADM_H, and for transport request of related changes, the related tables are /TMWFLOW/TRORD_N and /TMWFLOW/TRACK_N.

BR,

Shawn