MLHD

Transparent Table Application Table
23 Fields 4 CDS Views

Material-Ledger-Beleg: Kopf

MLHD is an SAP database table in S/4HANA. Material-Ledger-Beleg: Kopf. It contains 23 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
FMLV_MLXXV_UCT view inner FMLV_MLXXV_UCT
FMLV_MLXXV_UCT_UNION view inner ML Document: Items and posting periods w. correct CURTP
ML4H_CDS_MLIT_CL view inner Select all closing documents
P_MaterialLedgerDocumentHeader view from BASIC

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY belnr ck_belnr Document Number
KEY kjahr ck_kjahr Document Year
vgart ck_vgart ML Trans. Type
ldgrp fagl_ldgrp Ledger Group
awtyp awtyp Ref. procedure
awref awref Reference Doc.
aworg aworg Refer. Org.Unit
awsys logsystem Logical System
storno ck_storno Revers.Document
umbew ck_umbewerten Revaluate
bldat bldat Document Date
cpudt cpudt Entered On
cputm cputm Entered at
usnam usnam User Name
tcode tcode Transaction Code
glvor glvor Bus.transaction
logsys logsystem Logical System
pvers sysaprl SAP Release
xcobl_cons ckml_xcobl_cons CO Acc. Assign.
bktxt bktxt Doc.Header Text
kongr ckml_kongr Reason
acc_principle accounting_principle Accounting Principle

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-Beleg: Kopf
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MLHD (
    MANDT,          -- Client [mandt]
    BELNR,          -- Document Number [ck_belnr]
    KJAHR,          -- Document Year [ck_kjahr]
    VGART,          -- ML Trans. Type [ck_vgart]
    LDGRP,          -- Ledger Group [fagl_ldgrp]
    AWTYP,          -- Ref. procedure [awtyp]
    AWREF,          -- Reference Doc. [awref]
    AWORG,          -- Refer. Org.Unit [aworg]
    AWSYS,          -- Logical System [logsystem]
    STORNO,         -- Revers.Document [ck_storno]
    UMBEW,          -- Revaluate [ck_umbewerten]
    BLDAT,          -- Document Date [bldat]
    CPUDT,          -- Entered On [cpudt]
    CPUTM,          -- Entered at [cputm]
    USNAM,          -- User Name [usnam]
    TCODE,          -- Transaction Code [tcode]
    GLVOR,          -- Bus.transaction [glvor]
    LOGSYS,         -- Logical System [logsystem]
    PVERS,          -- SAP Release [sysaprl]
    XCOBL_CONS,     -- CO Acc. Assign. [ckml_xcobl_cons]
    BKTXT,          -- Doc.Header Text [bktxt]
    KONGR,          -- Reason [ckml_kongr]
    ACC_PRINCIPLE,  -- Accounting Principle [accounting_principle]
    PRIMARY KEY (MANDT, BELNR, KJAHR)
);

Learn More