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