MMPUR_CCTR_DET

Transparent Table Application Table

Temporary Persistence for Subordinate Central Contracts

MMPUR_CCTR_DET is an SAP database table in S/4HANA. Temporary Persistence for Subordinate Central Contracts. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SubordCntrlContrStaging view from BASIC Temporary Persistence of Subordinate Central Contracts

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY documentparentid ebeln Purchasing Doc.
KEY procmthubcompanycodegroupingid mmpur_d_cc_grouping_id Grouping ID
subordinatecentralcontract ebeln Purchasing Doc.
companycode bukrs Company Code
purchasingorganization ekorg Purchasing Org.
purchasingroup ekgrp Purch. Group
purchasecontracttype bsart Order Type
purchasindocumentsubtype bsakz Control
validitystartdate kdatb Validity Start
validityenddate kdate Validity End
cntrlpurcontrdescription contract_description Contract Name

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.

-- Temporary Persistence for Subordinate Central Contracts
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_CCTR_DET (
    MANDT,                           -- Client [mandt]
    DOCUMENTPARENTID,                -- Purchasing Doc. [ebeln]
    PROCMTHUBCOMPANYCODEGROUPINGID,  -- Grouping ID [mmpur_d_cc_grouping_id]
    SUBORDINATECENTRALCONTRACT,      -- Purchasing Doc. [ebeln]
    COMPANYCODE,                     -- Company Code [bukrs]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [ekorg]
    PURCHASINGROUP,                  -- Purch. Group [ekgrp]
    PURCHASECONTRACTTYPE,            -- Order Type [bsart]
    PURCHASINDOCUMENTSUBTYPE,        -- Control [bsakz]
    VALIDITYSTARTDATE,               -- Validity Start [kdatb]
    VALIDITYENDDATE,                 -- Validity End [kdate]
    CNTRLPURCONTRDESCRIPTION,        -- Contract Name [contract_description]
    PRIMARY KEY (MANDT, DOCUMENTPARENTID, PROCMTHUBCOMPANYCODEGROUPINGID)
);