MLDOCCCS
Material Ledger Document Cost Component Split
MLDOCCCS is an SAP database table in S/4HANA. Material Ledger Document Cost Component Split. It contains 16 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FCML_CCS_R_AVR_DDL | view | inner | CDS View w.struct.of FCML_CCS_REP f. AVR | |
| FCML_CCS_REP_DDL | view | inner | CDS View w.struct. of table FCML_CCS_REP | |
| ML4H_CDS_CONSUMP_CCS | view | left_outer | Sum of consumption CCS with WIP Reduction | |
| ML4H_CDS_MLDOCCCSHD | view | left_outer | CKMLHD x MLDOC x MLDOCCCS | |
| P_DMVCMLDOCCostComponentSplit | view | from | BASIC |
Fields (16)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | docref | ML4H_DOCREF | Document Reference | |||
| KEY | curtp | FINS_EXT_CURTYPE | Crcy Type/Valn View | |||
| KEY | elesmhk | CK_ELESMHK | Cost Comp. Str. | |||
| KEY | element | CK_ELEMENT | Cost Component | |||
| KEY | patnr | NKPRTN | Partner number | |||
| KEY | dipa | CK_DIPA | Direct Partner | |||
| KEY | svrel | ML4H_SVREL | Relev. f. Stock Val. | |||
| KEY | mlcct | ML4H_MLCCT | Cost Comp Split Type | |||
| KEY | keart | KEART | Type of CCS | |||
| waers | WAERS | Currency | ||||
| tot | ML4H_TOTAL | Total Value | ||||
| fix | ML4H_FIX | Fixed Value | ||||
| totll | ML4H_TOTAL_LL | Tot. Val. Lower Lvl. | ||||
| fixll | ML4H_FIX_LL | Fixed Val Lower Lvl | ||||
| _dataaging | DATA_TEMPERATURE | Data Aging |
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.
-- Material Ledger Document Cost Component Split
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MLDOCCCS (
MANDT, -- Client [MANDT]
DOCREF, -- Document Reference [ML4H_DOCREF]
CURTP, -- Crcy Type/Valn View [FINS_EXT_CURTYPE]
ELESMHK, -- Cost Comp. Str. [CK_ELESMHK]
ELEMENT, -- Cost Component [CK_ELEMENT]
PATNR, -- Partner number [NKPRTN]
DIPA, -- Direct Partner [CK_DIPA]
SVREL, -- Relev. f. Stock Val. [ML4H_SVREL]
MLCCT, -- Cost Comp Split Type [ML4H_MLCCT]
KEART, -- Type of CCS [KEART]
WAERS, -- Currency [WAERS]
TOT, -- Total Value [ML4H_TOTAL]
FIX, -- Fixed Value [ML4H_FIX]
TOTLL, -- Tot. Val. Lower Lvl. [ML4H_TOTAL_LL]
FIXLL, -- Fixed Val Lower Lvl [ML4H_FIX_LL]
_DATAAGING, -- Data Aging [DATA_TEMPERATURE]
PRIMARY KEY (MANDT, DOCREF, CURTP, ELESMHK, ELEMENT, PATNR, DIPA, SVREL, MLCCT, KEART)
);
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