CMPB_MAP

Transparent Table Application Table
12 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 12 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 (12)

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
start_date PS_PLFAZ Start date
end_date PS_PLSEZ Finish date
priority CGPL_PRIORITY Priority
is_exclusive CMPGN_EXCLUSIVE Exclusive
validation_stat CMPGN_VALIDATION_STATUS Status
object_type CGPL_OBJECT_TYPE Object Type

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]
    START_DATE,       -- Start date [PS_PLFAZ]
    END_DATE,         -- Finish date [PS_PLSEZ]
    PRIORITY,         -- Priority [CGPL_PRIORITY]
    IS_EXCLUSIVE,     -- Exclusive [CMPGN_EXCLUSIVE]
    VALIDATION_STAT,  -- Status [CMPGN_VALIDATION_STATUS]
    OBJECT_TYPE,      -- Object Type [CGPL_OBJECT_TYPE]
    PRIMARY KEY (MANDT, CAMPAIGN)
);

Learn More