SOLMAN - How to get SAP Tables name stored ChaRM I...

S0024924847 · ‎2023 Sep 13

Prerequisite :

During the creation of SAP Change Request Management (ChaRM) for Normal / Urgent / Defect types after selecting the prescribed Change / Phase Cycle ID below mandatory field Configuration Item get selected automatically depending on the cycle ID you selected.

The selection of Configuration Item with respect to Change / Phase Cycle ID process and SAP table used to stored the connection link between them will explain in details step-by-step.

Below the snapshot of one Normal Change ChaRM ID and the respective Phase Cycle ID linked with Configuration Item.

Details Analysis and SAP Table used to Store information Step-By-Step :

Step 1:

Go to Table AIC_RELEASE_CYCL and put RELEASE_NUMBER and get the TASKLIST_ID.

Step 2:

Get SYS CLIENT / SYS NAME and SYS TYPE from table = /TMWFLOW/TTRCKEN by putting TASKLIST. Now noticed SYS_ORDER [ Sort and keep only height number record] here example SYS_ORDER = 002.

Note: This Table will gives you the development landscape flow used for this change 

like DEV/QAS/PRD and respective Client number and name.

Step 3:

Once you get the SYS_NAME / CLIENT / TYPE details go to table AICRM_SYS_DATA put FF0010 = SYS_NAME / FF0016 = SYS_CLIENT & FF0017 = SYS_TYPE get the value if FRG_GUID / FF0014 / FF0015 / FF0016.

Step 4:

Go to table COMM_PR_FRG_REL and put FRAGMENT_GUID = FRG_GIUD to get the value of PRODUCT_GUID

Step 5:

Go to table COMM_PRODUCT and put PRODUCT_GUID = PRODUCT_GUID [ from above table] and pick the PRODUCT_ID [ Configuration Item ].

This PRODUCT_ID is actual Configuration Item get selected while you select the Change Cycle / Phase from the active list cycle.

Now watch closely the Configuration Item is actually displaying the value from the below tables and combination of fields. See the snapshot below.

Conclusion :

This document will helps developer to find the connection and how to get the relevant data from the respective SAP tables.