2014 Oct 14 2:19 PM
Hi,
what is the logical relationshiup between the SAP CRM contract number to ISU contract number in the SAP tables as I am unable to view the transaction in tcode CRMD_ORDER with the ISU contract number in the transaction id field.
Dan
2014 Oct 30 6:03 PM
Hi Dan,
as for all questions of this type I'd like to ask you why you need this information on the table level. If you want to use the information in a custom program or methof you should rather use the BOL objects to read this kind of information instead of selecting from the tables directly.
Christian
2014 Oct 15 12:38 AM
Hi Dan,
try t-cd: CRM_ISU_ORDER_READ in CRM.
also, in ISU contract you can see the CRM transaction number where the CRM product number is displayed.
2014 Oct 15 2:27 AM
Hi Dan,
Check table EVER_CRMQ in ISU.
It will give you the link b/w ISU contarct and the CRM transaction number.
Thanks,
Amlan
2014 Oct 15 10:26 PM
Hi Dan
I just checked the table mentioned by Amlan, and it's very sparsely populated in our system.
in ECC the EVERH table has the CRM GUID along with both the ISU contract and ISU installation number, and in CRM there's a couple of useful tables
CRMD_ISUEXTA4 has the GUID and ISU contract number
CRMV_ISU_INDEX_H has the transaction id (OBJECT_ID) and the ISU contract number and the GUID.
Cheers
Astrid
2014 Oct 30 2:48 PM
Hi CRM Guest,
You need to first give the ISU Contract Number in CRMD_ISUEXT4.
Then take the guid from there and give it in CRMD_ORDERADM_I.
This will give you the header guid.
Give this in CRMD_ORDERADM_H.
Cheers,
Devashish
2014 Oct 30 6:03 PM
Hi Dan,
as for all questions of this type I'd like to ask you why you need this information on the table level. If you want to use the information in a custom program or methof you should rather use the BOL objects to read this kind of information instead of selecting from the tables directly.
Christian
2014 Oct 31 4:28 AM
Class : CL_CRM_ISU_ORDER_INFO
Will give you all details related to CRM ISU Contracts POD.
Use method : GET_ISUEXT to get the ISU Contract Number from Item Guid.
User : GET_ORDERADM_H to get CRM Header details.