CMM_TPL_EFFECT

Transparent Table Application Table
7 Fields 1 CDS Views

Profit and Loss Effects

CMM_TPL_EFFECT is an SAP database table in S/4HANA. Profit and Loss Effects. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_Pnleffect view from BASIC

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pricing_key CMM_VLOGP_PRICING_KEY Pricing Key
KEY version CMM_MTM_VERSION Version
KEY kposn KPOSN Item
KEY kschl KSCHL Condition Type
KEY kschl_subkey CMM_VLOGP_SUBKEY Subkey
KEY event CMM_EFFECT Elem. Event 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.

-- Profit and Loss Effects
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMM_TPL_EFFECT (
    MANDT,         -- Client [MANDT]
    PRICING_KEY,   -- Pricing Key [CMM_VLOGP_PRICING_KEY]
    VERSION,       -- Version [CMM_MTM_VERSION]
    KPOSN,         -- Item [KPOSN]
    KSCHL,         -- Condition Type [KSCHL]
    KSCHL_SUBKEY,  -- Subkey [CMM_VLOGP_SUBKEY]
    EVENT,         -- Elem. Event Type [CMM_EFFECT]
    PRIMARY KEY (MANDT, PRICING_KEY, VERSION, KPOSN, KSCHL, KSCHL_SUBKEY, EVENT)
);

Learn More