CMPB_MAP

Transparent Table Application Table
6 Fields 2 CDS Views

Conversion Table CAIMPAIGN CRM <> CMPGN_ID

CMPB_MAP is an SAP database table in S/4HANA. Conversion Table CAIMPAIGN CRM <> CMPGN_ID. It contains 6 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
V_Wb2_Vbrk_Vbrp_Tpm view left_outer CCS: Business Volume from Sales for TPM
V_WB2_VBRK_VBRP_TPM_1 view inner Business Volume from Billing Document with Campaign

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY campaign cgpl_guid16_r3 CGPL_GUID
cmpgn_id cmpgn_id_r3 Campaign ID
cmpgn_extid cmpgn_extid_r3 Campaign
logsys logsys Logical system
exchange_status cmpgn_exchange_status Exchange Status

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Conversion Table CAIMPAIGN CRM <> CMPGN_ID
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMPB_MAP (
    MANDT,            -- Client [mandt]
    CAMPAIGN,         -- CGPL_GUID [cgpl_guid16_r3]
    CMPGN_ID,         -- Campaign ID [cmpgn_id_r3]
    CMPGN_EXTID,      -- Campaign [cmpgn_extid_r3]
    LOGSYS,           -- Logical system [logsys]
    EXCHANGE_STATUS,  -- Exchange Status [cmpgn_exchange_status]
    PRIMARY KEY (MANDT, CAMPAIGN)
);

Learn More