Skip to Content
Jul 29, 2010 at 03:53 PM

Help required in retrieving the category1 & category2 values for CRM SR


Hi Friends,

We are currently working on a requirement where in we need to update the status of Service request having the external reference nbr that is coming from back end ECC System. This number is already stored in the CRM Service request document. The external reference field is added through AET Tool.

The backend application calls our CRM RFC FM and passes the external reference nbr as input parameter. We are trying to query the CRMD_ORDERADM_H table with the external reference number and get the list of all service requests having this number. Now we need to select only those service requests having the category1 as Order and category2 as block.

We have found the table CRMD_SRV_SUBJECT but not able to find the link table that connects the GUID of service request with GUID of CRMD_SRV_SUBJECT.

Any pointers on this would be of great help.