The Trade Promotion is saved in SAP table as GUID.
To convert the Trade Promotion ID to GUID, you can use this FM:
'CONVERSION_EXIT_CGPLP_IN_API'.
If you need to know how is the R/3 destination from the CRM, you can use this FM:
'CRM_GET_ERP_SYSTEM'.
Spends Amounts: Table CRMD_MKTPL_COSTA using PROJECT_GUID = GUID.
Master Data: Table CGPL_PROJECT using EXTERNAL_ID =GUID
Spends: Table CRMC_MKTPL_STFT
Funds associated to the Trade: CRMD_MKTPL_FUNDS using PROJECT_GUID = GUID
Funds Master Data: Table CRMD_ORDERADM_H using GUID = funds_guid
Funds Partner GUID: Table CRMD_LINK using GUID_HI = funds_guid
Funds Partner Master Data: Table CRMD_PARTNER using GUID = CRMD_LINK-GUID_SET
Personnel Number of Partner:
GV_SOBID = but000-partner.
SELECT SINGLE *
FROM HRP1001
INTO WA_BP
WHERE OTYPE = 'CP'
AND BEGDA <= SY-DATUM
AND ENDDA >= SY-DATUM
AND SCLAS = 'BP'
AND SOBID = GV_SOBID.
IF SY-SUBRC NE 0.
CONTINUE.
ENDIF.
SELECT SINGLE *
FROM HRP1001
INTO WA_CP
WHERE OTYPE = 'CP'
AND BEGDA <= SY-DATUM
AND ENDDA >= SY-DATUM
AND OBJID = WA_BP-OBJID
AND SCLAS = 'US'.
IF SY-SUBRC NE 0.
CONTINUE.
ENDIF.
WA_CP-SOBID = Personnal Number
For Sales Organization ID and Distribution Channel and Division, use the Table CRM_MKTPL_TPATTR.
