SAP MLDOC Table in S/4 HANA - Material Ledger Document
MLDOC is a standard SAP Table which is used to store Material Ledger Document data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP MLDOC table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Transparent table
Database Table: MLDOC
MLDOC table structure field list
Below is the full MLDOC field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MANDT | Client | MANDT | CLNT | 3(0) | MANDT | |||||
DOCREF | Document Reference | ML4H_DOCREF | NUMC | 20(0) | NUMC20 | |||||
CURTP | Currency Type | FINS_CURTYPE | CHAR | 2(0) | FINS_CURTYPE | |||||
RUNREF | Reference to Costing Run | ML4H_RUNREF | CHAR | 12(0) | ML4H_RUNREF | |||||
ACC_PRINCIPLE | Accounting Principle | ACCOUNTING_PRINCIPLE | CHAR | 4(0) | ACCOUNTING_PRINCIPLE | ACCOUNTING_PRINCIPLE | ||||
KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12(0) | CK_KALNR | KNR | ||||
JAHRPER | Year / Period YYYYPPP of Posting | ML4H_JAHRPER | NUMC | 7(0) | PERI7 | JAHRPER | ||||
JAHRPER_WIP | Origin Year / Period of Work in Progress | ML4H_JAHRPER_WIP | NUMC | 7(0) | PERI7 | JAHRPER | ||||
CURRENT_PER | Current Year / Period YYYYPPP at Time of Posting | ML4H_JAHRPER_CURRENT | NUMC | 7(0) | PERI7 | JAHRPER | ||||
XABR | Costing Document | ML4H_XABR | CHAR | 1(0) | XFELD | |||||
GLVOR | Business Transaction | GLVOR | CHAR | 4(0) | CHAR4 | |||||
VGART | Material Ledger: Transaction Type | CK_VGART | CHAR | 2(0) | CK_VGART | |||||
POSART | Item type in material ledger document | ML4H_POSART | CHAR | 2(0) | ML4H_POSART | |||||
CATEG | Category in Material Ledger Data Display | CKML_CATEG | CHAR | 2(0) | CKML_CATEG | |||||
PTYP | Process Category for Procurement Alt. or Consuption Alt. | CK_PTYP_BVALT | CHAR | 4(0) | CKML_PROZESS_TYP | |||||
BEWARTGRP | Movement Type Group for ML Update | CKML_MLBWG | CHAR | 2(0) | CKML_MLBWG | |||||
BVALT | Procurement Alternative/Process | CKML_ALPROCNR | NUMC | 12(0) | CK_KALNR | |||||
PROCESS | Production Process | CKML_F_PROCNR | NUMC | 12(0) | CK_KALNR | CKML_PROCNR | ||||
PKALNR | Cost Estimate Number of Output | ML4H_KALNR_PMAT | NUMC | 12(0) | CK_KALNR | |||||
QUANT | Transaction Quantity in Valuation Quantity Unit of Mesure | ML4H_QUANTITY | QUAN | 23(3) | MENGV12 | |||||
MEINS | Quantity Unit for Valuation | ML4H_MEINS | UNIT | 3(0) | CUNIT | MEINS | ||||
STVAL | Inventory Value of Transaction | ML4H_STVAL | CURR | 23(2) | WERTV12 | |||||
PRD | Price Difference | ML4H_PRD | CURR | 23(2) | WERTV12 | |||||
KDM | Exchange Rate Difference | ML4H_KDM | CURR | 23(2) | WERTV12 | |||||
TPPRD | Price Varainance from Transfer Price | ML4H_TPPRD | CURR | 23(2) | WERTV12 | |||||
ALTVAL | Inventory Value at alternative Price (Periodic Unit Price) | ML4H_ALTVAL | CURR | 23(2) | WERTV12 | |||||
WAERS | Currency Key | WAERS | CUKY | 5(0) | WAERS | FWS | ||||
LBKUM | Inventory Quantity in Val. Qty. UoM. before the Transaction | ML4H_LBKUM | QUAN | 23(3) | MENGV12 | |||||
SALK3 | Value of total valuated stock before the transaction | ML4H_SALK3 | CURR | 23(2) | WERTV12 | |||||
SALKV | Alternative value of total val. stock before the transaction | ML4H_SALKV | CURR | 23(2) | WERTV12 | |||||
STPRS | Standard Price before the Transaction | ML4H_STPRS | CURR | 23(2) | WERTV12 | |||||
PVPRS | Moving Average / Periodic Unit price before the Transaction | ML4H_PVPRS | CURR | 23(2) | WERTV12 | |||||
PEINH | Price Unit before the Transaction | ML4H_PRICEUNIT | DEC | 5(0) | PACK3 | |||||
XEKREL | Price and Exchange Rate Var. relevant for Purchasing Account | ML4H_XEKREL | CHAR | 1(0) | XFELD | |||||
XPLREL | Variances are Relevant for Price Limiter Logic | ML4H_XPLREL | CHAR | 1(0) | XFELD | |||||
PLQTY | Price Limiter Quantity | ML4H_PLQTY | QUAN | 23(3) | MENGV12 | |||||
MARKUP | Intercompany Profit | ML4H_MARKUP | CURR | 23(2) | WERTV12 | |||||
XTPREL | Transfer Price Relevant for Profit Center Change | ML4H_XTPREL | CHAR | 1(0) | XFELD | |||||
VKWRT | Sales Value for Actual Costing on Value Article | ML4H_VKWRT | CURR | 23(2) | WERTV12 | |||||
VKSAL | Stock Value at Sales price | ML4H_VKSAL | CURR | 23(2) | WERTV12 | |||||
EQNUM | Equivalence Number for Joint Production | ML4H_EQNUM | D34D | 31(14) | ML4H_EQUINUM | |||||
TIMESTAMP | Time Stamp | ML4H_TIMESTAMP | DEC | 21(7) | TZNTSTMPL | |||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8(0) | DATUM | |||||
CYCLENR | Cycle Number Within a Run | CK_CYCLENR | NUMC | 5(0) | NUMC5 | |||||
AUFNR | Order Number | AUFNR | CHAR | 12(0) | ALPHA | AUFNR | ANR | |||
AUFPS | Order item number | CO_POSNR | NUMC | 4(0) | CO_POSNR | |||||
BELNR | Number of Material Ledger Document | ML4H_BELNR | CHAR | 10(0) | ALPHA | ML4H_BELNR | MLN | ML_BELNR | BELNR | |
KJAHR | Material Ledger Document/Price Change Document: Storage Year | CK_KJAHR | NUMC | 4(0) | GJAHR | GJAHR | MLJ | |||
POSNR | Item in Material Ledger Document | CK_MLPOS | NUMC | 6(0) | NUMC6 | |||||
AWTYP | Reference procedure | AWTYP | CHAR | 5(0) | AWTYP | |||||
AWSYS | Logical system of source document | AWSYS | CHAR | 10(0) | ALPHA | LOGSYS | ||||
AWORG | Reference Organizational Units | AWORG | CHAR | 10(0) | AWORG | |||||
AWREF | Reference document number | AWREF | CHAR | 10(0) | ALPHA | AWREF | ||||
AWITEM | Reference Document Line Item | ML4H_AWITEM | NUMC | 6(0) | NUMC6 | |||||
AWITGRP | Group of Reference Document Line Items | ML4H_AWITGRP | NUMC | 6(0) | NUMC6 | |||||
USNAM | User Name | USNAM | CHAR | 12(0) | XUBNAME | USR | ||||
TCODE | Transaction Code | TCODE | CHAR | 20(0) | TCODE | TCD | ||||
MLVNR | Material Ledger Transaction Number | CK_MLVNR | CHAR | 12(0) | CK_MLVNR | |||||
VGABE | Type of Transaction in the Object History | CKI_VGAAU | CHAR | 1(0) | CKI_VGAAU | |||||
HRKFT | Origin Group as Subdivision of Cost Element | HRKFT | CHAR | 4(0) | HRKFT | |||||
KSTAR | Cost Element | KSTAR | CHAR | 10(0) | ALPHA | KSTAR | KAT | |||
BWART | Movement type (inventory management) | BWART | CHAR | 3(0) | BWART | BWA | ||||
WERKS | Plant | WERKS_D | CHAR | 4(0) | WERKS | WRK | H_T001W_C | WERKS | ||
STORNO | Checkbox | XFELD | CHAR | 1(0) | XFELD | |||||
BSTMG | Purchase Order Quantity | BSTMG | QUAN | 13(3) | MENG13 | |||||
BSTME | Purchase Order Unit of Measure | BSTME | UNIT | 3(0) | CUNIT | MEINS | ||||
AREWR | GR/IR account clearing value in local currency | AREWR | CURR | 13(2) | WERT7 | |||||
REEWR | Invoice Value Entered (in Local Currency) | REEWR | CURR | 13(2) | WRTV7 | |||||
XKDM_NACT | Capitalize Exchange Rate Differences | ML4H_KDM_NACT | CHAR | 1(0) | XFELD | |||||
_DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8(0) | DATA_TEMPERATURE | |||||
KONGR | Account Assignment Reason | CKML_KONGR | CHAR | 3(0) | CHAR3 |
Search for further information about these or an SAP related objects