TPM – Trade Promotion – Tables

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.