MMPUR_CCTR_DET
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_SubordCntrlContrStaging | view | from | BASIC | Temporary Persistence of Subordinate Central Contracts |
Fields (12)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA