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

SAP Table MDRS

Generated Table for View

MDRS (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 MDRS to other SAP tables.

MDRS table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
RSPOS Item Number of Reservation/Dependent Requirement RSPOS NUMC 4 0
RSART Record type RSART CHAR 1 0
BDART Requirement type BDART CHAR 2 0
UPSKZ Indicator: sub-items exist UPSKZ CHAR 1 0
X Yes
NULL No
SCHGT Indicator: Bulk Material SCHGT CHAR 1 0
X Yes
NULL No
TXTPS Item text indicator TXTPS CHAR 1 0
X Yes
NULL No
DUMPS Phantom item indicator DUMPS CHAR 1 0
X Yes
NULL No
KFPOS Indicator: "configurable item" KFPOS CHAR 1 0
NULL Blank
. Radio button
X Selection
DBSKZ Direct procurement indicator DBSKZ CHAR 1 0
NULL No direct procurement or direct production
E Direct production
F Direct procurement
XLOEK Item is Deleted XLOEK CHAR 1 0
X Yes
NULL No
XWAOK Goods Movement for Reservation Allowed XWAOK CHAR 1 0
X Yes
NULL No
KZEAR Final Issue for This Reservation KZEAR CHAR 1 0
X Yes
NULL No
RSSTA Status of reservation RSSTA CHAR 1 0
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D T001W CHAR 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
CHARG Batch Number CHARG_D MCHA CHAR 10 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
BDTER Requirement Date for the Component BDTER DATS 8 0
NLFZT Lead-time offset NLFZT DEC 3 0
BDMNG Requirement Quantity BDMNG QUAN 13 3
ALPOS Alternative item indicator ALTPS CHAR 1 0
X Yes
NULL No
EWAHR Usage probability in % (alternative item) EWAHR DEC 3 0
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
ENMNG Quantity Withdrawn ENMNG QUAN 13 3
BAUGR Material number of higher-level assembly BAUGR MARA CHAR 18 0
SERNR BOM explosion number SERNR SNUM CHAR 8 0
KDAUF Sales Order Number KDAUF VBUK CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
KDEIN Delivery Schedule for Sales Order KDEIN NUMC 4 0
PSPEL WBS Element PS_POSNR NUMC 8 0
CUOBJ Configuration (internal object number) CUOBJ NUMC 18 0
PLNUM Planned order number PLNUM PLAF CHAR 10 0
BANFN Purchase Requisition Number BANFN CHAR 10 0
BNFPO Item Number of Purchase Requisition BNFPO EBAN NUMC 5 0
EBELN Purchasing Document Number EBELN EKKO CHAR 10 0
EBELP Item Number of Purchasing Document EBELP EKPO NUMC 5 0
EBELE Delivery Schedule Line Counter EETEN EKET NUMC 4 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
AUFPS Order item number AUFPS CHAR 2 0
UMWRK Receiving/Issuing Plant UMWRK T001W CHAR 4 0
UMLGO Receiving/Issuing Storage Location UMLGO T001L CHAR 4 0
KZAUS Discontinuation type AUSLF CHAR 1 0
1 Simple discontinuation (-> maintain in master record)
2 Parallel discontin. (group) (-> maintain in BOM)
3 Dependent parallel discontin. (-> maintain in BOM)
5 Follow-up mat. within group (-> maintain BOM)
NFEAG Discontinuation group CS_NFEAG CHAR 2 0
NFGRP Follow-up group CS_NFGRP CHAR 2 0
NFPKZ Indicator: Follow-Up Item CS_KZNFP CHAR 1 0
X Yes
NULL No
NAFKZ Indicator: follow-up material active/not active NAFKZ CHAR 1 0
X Yes
NULL No
NOMNG Required quantity NOMNG QUAN 13 3
NFUML NOT USED: Quantity transfer factor for follow-up material NFUML DEC 5 4
NOMAT Follow-Up/Original Material NOMAT MARA CHAR 18 0
POSTP Item Category (Bill of Material) POSTP T418 CHAR 1 0
POSNR BOM item number APOSN CHAR 4 0
SBTER Latest requirements date SBTER DATS 8 0
VERTI MRP Distribution Key SA_VERTL T437V CHAR 4 0
VMENG Confirmed quantity for availability check in SKU VMENG QUAN 15 3
NDISP Effective for Materials Planning NO_DISP_PLUS CHAR 1 0
1 Not relevant to materials planning
X Relevant to materials planning at a defined time
NULL Relevant to materials planning
STLNR Bill of material STNUM CHAR 8 0
XFEHL Missing Part XFEHL CHAR 1 0
X Yes
NULL No
PBDNR Requirements Plan Number PBDNR CHAR 10 0
VRPLA Indicator: planning without final assembly VRPLA CHAR 1 0
X Yes
NULL No
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
UMREZ Numerator for Conversion to Base Units of Measure UMREZ DEC 5 0
UMREN Denominator for conversion to base units of measure UMREN DEC 5 0
ERFME Unit of Entry ERFME T006 UNIT 3 0
ERFMG Quantity in Unit of Entry ERFMG QUAN 13 3
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
TECHS Parameter Variant/Standard Variant TECHS CHAR 12 0
REVLV Revision Level REVLV CHAR 2 0
BWART Movement Type (Inventory Management) BWART T156 CHAR 3 0
UMSOK Special Stock Indicator for Physical Stock Transfer UMSOK CHAR 1 0
STLTY BOM category STLTY CHAR 1 0
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
S Standard BOM
T Functional Location BOM
P Work Breakdown Structure BOM
STLKN BOM item node number STLKN NUMC 8 0
STPOZ Internal counter CIM_COUNT NUMC 8 0
VORAB Ind: Preliminary order VORABKZ CHAR 1 0
X Yes
NULL No
PRIO_URG Requirement Urgency PRIO_URG PURG NUMC 2 0
PRIO_REQ Requirement Priority PRIO_REQ PREQ NUMC 3 0

MDRS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MDRS AUFNR MDRS MANDT AUFK Order master data MANDT
MDRS AUFNR MDRS AUFNR AUFK Order master data AUFNR
MDRS BAUGR MDRS MANDT MARA General Material Data MANDT
MDRS BAUGR MDRS BAUGR MARA General Material Data MATNR
MDRS BNFPO MDRS BANFN EBAN Purchase Requisition BANFN
MDRS BNFPO MDRS BNFPO EBAN Purchase Requisition BNFPO
MDRS BNFPO MDRS MANDT EBAN Purchase Requisition MANDT
MDRS BWART MDRS MANDT T156 Movement Type MANDT
MDRS BWART MDRS BWART T156 Movement Type BWART
MDRS CHARG MDRS WERKS MCHA Batches WERKS
MDRS CHARG MDRS CHARG MCHA Batches CHARG
MDRS CHARG MDRS MANDT MCHA Batches MANDT
MDRS CHARG MDRS MATNR MCHA Batches MATNR
MDRS EBELE MDRS EBELE EKET Scheduling Agreement Schedule Lines ETENR
MDRS EBELE MDRS MANDT EKET Scheduling Agreement Schedule Lines MANDT
MDRS EBELE MDRS EBELN EKET Scheduling Agreement Schedule Lines EBELN
MDRS EBELE MDRS EBELP EKET Scheduling Agreement Schedule Lines EBELP
MDRS EBELN MDRS MANDT EKKO Purchasing Document Header MANDT
MDRS EBELN MDRS EBELN EKKO Purchasing Document Header EBELN
MDRS EBELP MDRS MANDT EKPO Purchasing Document Item MANDT
MDRS EBELP MDRS EBELN EKPO Purchasing Document Item EBELN
MDRS EBELP MDRS EBELP EKPO Purchasing Document Item EBELP
MDRS ERFME MDRS ERFME T006 Units of Measurement MSEHI
MDRS ERFME MDRS MANDT T006 Units of Measurement MANDT
MDRS KDAUF MDRS MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
MDRS KDAUF MDRS KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
MDRS KNTTP MDRS MANDT T163K Account Assignment Categories in Purchasing Document MANDT
MDRS KNTTP MDRS KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
MDRS LGORT MDRS MANDT T001L Storage Locations MANDT
MDRS LGORT MDRS WERKS T001L Storage Locations WERKS
MDRS LGORT MDRS LGORT T001L Storage Locations LGORT
MDRS LIFNR MDRS MANDT LFA1 Vendor Master (General Section) MANDT
MDRS LIFNR MDRS LIFNR LFA1 Vendor Master (General Section) LIFNR
MDRS MANDT MDRS MANDT T000 Clients MANDT
MDRS MATNR MDRS MATNR MARA General Material Data MATNR
MDRS MATNR MDRS MANDT MARA General Material Data MANDT
MDRS MEINS MDRS MANDT T006 Units of Measurement MANDT
MDRS MEINS MDRS MEINS T006 Units of Measurement MSEHI
MDRS NOMAT MDRS MANDT MARA General Material Data MANDT
MDRS NOMAT MDRS NOMAT MARA General Material Data MATNR
MDRS PLNUM MDRS MANDT PLAF Planned Order MANDT
MDRS PLNUM MDRS PLNUM PLAF Planned Order PLNUM
MDRS POSTP MDRS POSTP T418 Item Categories POSTP
MDRS POSTP MDRS MANDT T418 Item Categories MANDT
MDRS PRIO_REQ MDRS MANDT PREQ Requirement Priorities MANDT
MDRS PRIO_REQ MDRS PRIO_REQ PREQ Requirement Priorities PRIO_REQ
MDRS PRIO_URG MDRS MANDT PURG Requirement Urgencies MANDT
MDRS PRIO_URG MDRS PRIO_URG PURG Requirement Urgencies PRIO_URG
MDRS SERNR MDRS MANDT SNUM BOM explosion number MANDT
MDRS SERNR MDRS SERNR SNUM BOM explosion number SERNR
MDRS SOBKZ MDRS MANDT T148 Special Stock Indicator MANDT
MDRS SOBKZ MDRS SOBKZ T148 Special Stock Indicator SOBKZ
MDRS UMLGO MDRS UMLGO T001L Storage Locations LGORT
MDRS UMLGO MDRS MANDT T001L Storage Locations MANDT
MDRS UMLGO MDRS UMWRK T001L Storage Locations WERKS
MDRS UMWRK MDRS MANDT T001W Plants/Branches MANDT
MDRS UMWRK MDRS UMWRK T001W Plants/Branches WERKS
MDRS VERTI MDRS MANDT T437V Distribution key in MRP MANDT
MDRS VERTI MDRS WERKS T437V Distribution key in MRP WERKS
MDRS VERTI MDRS VERTI T437V Distribution key in MRP VERTL
MDRS WERKS MDRS MANDT T001W Plants/Branches MANDT
MDRS WERKS MDRS WERKS T001W Plants/Branches WERKS