1. Home
  2. Resources
  3. SAP Tables
  4. MDLA - Generated Table for View

SAP Table MDLA

Generated Table for View

MDLA (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MDLA to other SAP tables.

MDLA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EBELN Purchasing Document Number EBELN EKKO CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
ETENS Sequential Number of Vendor Confirmation ETENS NUMC 4 0
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant EWERK T001W CHAR 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
BSTYP Purchasing Document Category BSTYP CHAR 1 0
A Request for quotation
B Purchase requisition
F Purchase order
I Info record
K Contract
L Scheduling agreement
Q Service entry sheet
W Source list
LOEKZ Deletion Indicator in Purchasing Document ELOEK CHAR 1 0
ELIKZ "Delivery Completed" Indicator ELIKZ CHAR 1 0
X Yes
NULL No
MEINS Purchase Order Unit of Measure BSTME T006 UNIT 3 0
UMREZ Numerator for Conversion of Order Unit to Base Unit UMBSZ DEC 5 0
UMREN Denominator for Conversion of Order Unit to Base Unit UMBSN DEC 5 0
WEBAZ Goods Receipt Processing Time in Days WEBAZ DEC 3 0
PSTYP Item Category in Purchasing Document PSTYP T163 CHAR 1 0
KNTTP Account Assignment Category KNTTP T163K CHAR 1 0
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
EINDT Delivery Date of Vendor Confirmation BBEIN DATS 8 0
UZEIT Delivery Date Time-Spot in Vendor Confirmation BBUZE TIMS 6 0
MENGE Quantity as Per Vendor Confirmation BBMNG QUAN 13 3
DABMG Quantity Reduced (MRP) DABMG QUAN 13 3
ESTKZ Creation Indicator: Vendor Confirmation BBEST CHAR 1 0
1 Manual
2 Shipping Notification
3 EDI
4 Return Delivery
KZDIS Indicator: Confirmation is Relevant to Materials Planning KZDIS CHAR 1 0
X Yes
NULL No
BBLOE Vendor confirmation deletion indicator BBLOE CHAR 1 0
BWTAR Valuation Type BWTAR_D T149D CHAR 10 0
KZBWS Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
REVLV Revision Level REVLV CHAR 2 0
EMLIF Vendor to be supplied/who is to receive delivery EMLIF LFA1 CHAR 10 0
LBLKZ Subcontracting vendor LBLKZ CHAR 1 0
X Yes
NULL No
STATU RFQ status ASTAT CHAR 1 0
NULL No Quotation Exists/Not Created via Sales
A Quotation Exists in Case of RFQ Item
F Created via Production Order
V Created via Sales document
W Created via Allocation Table
BERID MRP Area BERID MDLV CHAR 10 0
ARSNR Settlement reservation number ARSNR NUMC 10 0
ARSPS Item number of the settlement reservation ARSPS NUMC 4 0
INSMK Stock Type INSMK CHAR 1 0
NULL Unrestricted use
X Quality inspection
S Blocked stock
RESLO Issuing Storage Location for Stock Transport Order RESLO T001L CHAR 4 0
CHARG Batch Number CHARG_D CHAR 10 0
UPTYP Subitem Category, Purchasing Document UPTYP TMSI1 CHAR 1 0
FLS_RSTO Store Return with Inbound and Outbound Delivery FLS_RSTO CHAR 1 0
X Yes
NULL No
ITCONS Real-Time Consumption Posting of Subcontracting Components ME_IR_CO_ORDER CHAR 1 0
X Yes
NULL No
STAPO Item is statistical STAPO CHAR 1 0
X Yes
NULL No

MDLA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MDLA BERID SYST MANDT MDLV Customizing MRP Area MANDT
MDLA BERID MDLA BERID MDLV Customizing MRP Area BERID
MDLA BWTAR MDLA MANDT T149D Global Valuation Types MANDT
MDLA BWTAR MDLA BWTAR T149D Global Valuation Types BWTAR
MDLA EBELN MDLA MANDT EKKO Purchasing Document Header MANDT
MDLA EBELN MDLA EBELN EKKO Purchasing Document Header EBELN
MDLA EMLIF MDLA MANDT LFA1 Vendor Master (General Section) MANDT
MDLA EMLIF MDLA EMLIF LFA1 Vendor Master (General Section) LIFNR
MDLA KNTTP MDLA KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
MDLA KNTTP MDLA MANDT T163K Account Assignment Categories in Purchasing Document MANDT
MDLA LGORT MDLA WERKS T001L Storage Locations WERKS
MDLA LGORT MDLA LGORT T001L Storage Locations LGORT
MDLA LGORT MDLA MANDT T001L Storage Locations MANDT
MDLA MANDT MDLA MANDT T000 Clients MANDT
MDLA MATNR MDLA MANDT MARA General Material Data MANDT
MDLA MATNR MDLA MATNR MARA General Material Data MATNR
MDLA MEINS MDLA MANDT T006 Units of Measurement MANDT
MDLA MEINS MDLA MEINS T006 Units of Measurement MSEHI
MDLA PSTYP MDLA MANDT T163 Item Categories in Purchasing Document MANDT
MDLA PSTYP MDLA PSTYP T163 Item Categories in Purchasing Document PSTYP
MDLA RESLO SYST MANDT T001L Storage Locations MANDT
MDLA RESLO EKKO RESWK T001L Storage Locations WERKS
MDLA RESLO MDLA RESLO T001L Storage Locations LGORT
MDLA SOBKZ MDLA SOBKZ T148 Special Stock Indicator SOBKZ
MDLA SOBKZ MDLA MANDT T148 Special Stock Indicator MANDT
MDLA UPTYP MDLA MANDT TMSI1 Sub-Item Category in Purchasing MANDT
MDLA UPTYP MDLA UPTYP TMSI1 Sub-Item Category in Purchasing UPTYP
MDLA WERKS MDLA MANDT T001W Plants/Branches MANDT
MDLA WERKS MDLA WERKS T001W Plants/Branches WERKS