SAP MLHD Material Ledger Document: Header Table data and field list

MLHD is a standard SAP Table which is used to store Material Ledger Document: Header data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The MLHD table consists of various fields, each holding specific information or linking keys about Material Ledger Document: Header data available in SAP. These include BELNR (Number of a Material Ledger Document/Price Change Document), KJAHR (Material Ledger Document/Price Change Document: Storage Year), VGART (Material ledger: transaction type), AWTYP (Reference Transaction)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

MLHD table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified

SAP MLHD table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the MLHD table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
BELNR	Number of a Material Ledger Document/Price Change Document	CK_BELNR	CHAR	10		ALPHA	BELNR	MLN	ML_BELNR
KJAHR	Material Ledger Document/Price Change Document: Storage Year	CK_KJAHR	NUMC	4		GJAHR	GJAHR	MLJ
VGART	Material ledger: transaction type	CK_VGART	CHAR	2			CK_VGART
AWTYP	Reference Transaction	AWTYP	CHAR	5	Assigned to domain		AWTYP
AWREF	Reference Document Number	AWREF	CHAR	10		ALPHA	AWREF
AWORG	Reference Organizational Units	AWORG	CHAR	10			AWORG
AWSYS	Logical System	LOGSYSTEM	CHAR	10	Assigned to domain	ALPHA	LOGSYS
STORNO	Indicator: material ledger reversal document	CK_STORNO	CHAR	1			XFELD
UMBEW	The materials should be revaluated	CK_UMBEWERTEN	CHAR	1			XFELD
BLDAT	Document Date in Document	BLDAT	DATS	8			DATUM
CPUDT	Day On Which Accounting Document Was Entered	CPUDT	DATS	8			DATUM
CPUTM	Time of Entry	CPUTM	TIMS	6			UZEIT
USNAM	User name	USNAM	CHAR	12	Assigned to domain		XUBNAME	USR
TCODE	Transaction Code	TCODE	CHAR	20	Assigned to domain		TCODE	TCD
GLVOR	Business Transaction	GLVOR	CHAR	4			CHAR4
LOGSYS	Logical System	LOGSYSTEM	CHAR	10	Assigned to domain	ALPHA	LOGSYS
PVERS	Release of SAP System	SYSAPRL	CHAR	4			SYCHAR04
XCOBL_CONS	CO Acc. Assignmt for Revaluation of Single Level Consumption	CKML_XCOBL_CONS	CHAR	1			XFELD
BKTXT	Document Header Text	BKTXT	CHAR	25			TEXT25
KONGR	Account Assignment Reason	CKML_KONGR	CHAR	3			CHAR3

Key field

Non-key field

< MLGUT - Indicator for Full Product MLHD_AWKEY - Structure of Field AWKEY for OBJECT Type MLHD >

How do I retrieve data from SAP table MLHD using ABAP code

The following ABAP code Example will allow you to do a basic selection on MLHD to SELECT all data from the table
DATA: WA_MLHD TYPE MLHD.

SELECT SINGLE *
FROM MLHD
INTO CORRESPONDING FIELDS OF WA_MLHD
WHERE...

How to access SAP table MLHD

Within an ECC or HANA version of SAP you can also view further information about MLHD and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).