1. Home
  2. Resources
  3. SAP Tables
  4. MDPS - Item in MRP document

SAP Table MDPS

Item in MRP document

MDPS (Item in MRP document) 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 MDPS to other SAP tables.

MDPS table fields

Field Data element Checktable Datatype Length Decimals
PLAAB Material requirements planning segment PLAAB NUMC 2 0
PLANR Planning segment number PLANR CHAR 20 0
DAT00 Receipt/Requirements date DAT00 DATS 8 0
TAG00 Daily shift (sort indicator 0) TAG00 NUMC 2 0
SORT1 Sort indicator 01 SORT1 CHAR 1 0
SORT2 Sort indicator 02 SORT2 CHAR 2 0
DELKZ MRP element DELKZ CHAR 2 0
AR Dependent reservation
BA Purchase requisition
BB Subcontractor requirements of material provided
BE Order item schedule line
BP Gross requirements planning
BR Process order
CH Batch stock
ER End of replenishment lead time
E1 Subcontracting purchasing
FE Production order
FH End of planning time fence
IH Maintenance order
JI JIT call
IM Actual goods receipt quantity
IW In plant (only relevant for IS Automotive)
KB Individual customer stock
KD Customer independent requirement (currently not used)
KK Consignment stock for customer (availability check)
LA Shipping notification
LB Storage location stock
LC Batch/storage location stock
LE SA schedule line
LF JIT delivery schedule
LK Stock with subcontractor
LL Forecast delivery schedule
MB Goods issue
MR Reservation
MS Direct production
NE Network order
PA Planned order
PB Project stock
PP Planned independent requirement
PR Forecast requirement
QM Inspection lot for quality management
RP Returns item
RR MRP requirement (only relevant for IS-Automotive)
RU Confirmation
S2 Simulated requirement from availability check
SA Simulation order
SB Dependent requirement
SF Safety requirement
SH Safety stock
SI Simulation requirement
SM Sim. dependent reqmts
SU Total requirements
TB Transfer requirements WMS
U1 Release order for a stock transfer order
U2 Release order for a stock transfer requisition
U3 Transfer requirement for simulation order
U4 Release order for stock transport scheduling agreement
UB Unplanned requirement
UL Reservation in another plant
UR Stock transfer reservation
VA Request for quotation
VB Quotation
VC Order
VE SD scheduling agreement
VF SD scheduling agreement; external service agent
VG Contract
VH Returns from Consignation Stock at Customer
VI Delivery Free of Charge
VJ Delivery
VP Planning
VT Returns (availability check)
VW External sales order
VZ Unverified delivery
WA Goods issue
WB Plant stock
WE Goods receipt
WH End replenishment period
DD Effective-out date
C3 Subcontr. Customer Order Stock
C4 Subcontr. Project Stock
VSTAT Processing Status VSTAT_D CHAR 1 0
VRFKZ Availability indicator VRFKZ CHAR 1 0
PLUMI Receipt/issue indicator PLUMI CHAR 1 0
MNG01 Quantity received or quantity required MNG01 QUAN 13 3
MNG02 Variable scrap quantity MNG02 QUAN 13 3
MNG03 Shortage Quantity MNG03 QUAN 13 3
MNG04 ATP quantity MNG04 QUAN 13 3
DAT01 Delivery/order finish date DAT01 DATS 8 0
DAT02 Start/release date DAT02 DATS 8 0
DAT03 Opening date DAT03 DATS 8 0
PERKZ Period indicator MD_PERKZ CHAR 1 0
M Monthly
W Weekly
T Daily
P Period according to fiscal year variant
K Period according to PP planning calendar
R Individual period split
PRPER Forecast period PRPER NUMC 6 0
WEBAZ Goods Receipt Processing Time in Days WEBAZ DEC 3 0
UKZ01 Indicator: MRP element can be brought forward UKZ01 CHAR 1 0
X Yes
NULL No
UMDAT Rescheduling date UMDAT DATS 8 0
UMDA2 Rescheduling date UMDAT DATS 8 0
RDMNG Excess stock quantity RDMNG QUAN 13 3
FIX01 Indicator: fixeing lot size in planned order FIX01 CHAR 1 0
X Yes
NULL No
FIX02 Indicator: fixing explosion in planned order FIX02 CHAR 1 0
X Yes
NULL No
BAART P.O./Order type BAART CHAR 4 0
PLART Planning type PLART CHAR 1 0
BESKZ Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
SOBES Special procurement type SOBES CHAR 1 0
0 Standard external procurement
2 Consignment
3 Subcontracting
7 Stock transfer
E Standard in-house production
P Production in plant 2
9 IS-OIL only: Stock transfer reservation
ESOBS Special procurement - external display ESOBS CHAR 1 0
UMSKZ Conversion indicator for planned order PLUMS CHAR 1 0
X Yes
NULL No
AUSSL Exception message key AUSSL CHAR 2 0
OLDSL Key of the second exception message OLDSL CHAR 2 0
ABEKZ Exception indicator ABEKZ CHAR 1 0
WRK01 Planning Plant PLWRK CHAR 4 0
WRK02 Production plant in planned order PWWRK CHAR 4 0
LGORT Storage Location LGORT_D CHAR 4 0
CHARG Batch Number CHARG_D CHAR 10 0
LSOBS Special procurement type at storage location level LSOBS CHAR 2 0
DELNR MRP element number DELNR CHAR 10 0
DEL12 MRP element number DEL12 CHAR 12 0
DELPS MRP element item DELPS NUMC 6 0
DELET Schedule Line Number MRP Element DELET NUMC 4 0
VPZUO Allocation Indicator VPZUO CHAR 1 0
NULL No consumption with customer requirements
1 Consume planning with assembly
2 Consume planning w/o assembly
3 Consume planning material (w/o assembly)
ZUVKZ Consumption indicator DZUVKZ CHAR 1 0
NULL No consumption with customer requirements
1 Consume planning with assembly
2 Consume planning w/o assembly
3 Consume planning material (w/o assembly)
VERVP Consumption indicator for planning requirements VERVP CHAR 1 0
1 Consume only with customer requirements
2 Only consume reservations, dependent requirements
3 Consume customer reqmts, reserv., dependent reqmts
4 Flexible Consumption for Different MRP Elements (BAdI)
NULL No Allocation
VERSB Version number for independent requirements VERSB CHAR 2 0
AKTAL Current explosion available AKTAL CHAR 1 0
NULL Blank
. Radio button
X Selection
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
SERNR BOM explosion number SERNR CHAR 8 0
PALTR Explosion date PALTR DATS 8 0
TECHS Parameter Variant/Standard Variant TECHS CHAR 12 0
REVLV Revision Level REVLV CHAR 2 0
VERID Production Version VERID CHAR 4 0
STLAN BOM Usage STLAN CHAR 1 0
STALT Alternative BOM STALT CHAR 2 0
STSTA BOM status STLST NUMC 2 0
NFPKZ Indicator: Follow-Up Item CS_KZNFP CHAR 1 0
X Yes
NULL No
KZAUS Discontinuation indicator KZAUS CHAR 1 0
1 Single/parallel discontinued part/material
3 Dependent parallel discontinued part/material
NFEAG Discontinuation group CS_NFEAG CHAR 2 0
NFGRP Follow-up group CS_NFGRP CHAR 2 0
NAFKZ Indicator: follow-up material active/not active NAFKZ CHAR 1 0
X Yes
NULL No
NFMNG Follow-up quantity NFMNG QUAN 13 3
NFMAT Follow-Up Material NFMAT CHAR 18 0
AENNR Change Number AENNR CHAR 12 0
DELVR MRP element DELKZ CHAR 2 0
AR Dependent reservation
BA Purchase requisition
BB Subcontractor requirements of material provided
BE Order item schedule line
BP Gross requirements planning
BR Process order
CH Batch stock
ER End of replenishment lead time
E1 Subcontracting purchasing
FE Production order
FH End of planning time fence
IH Maintenance order
JI JIT call
IM Actual goods receipt quantity
IW In plant (only relevant for IS Automotive)
KB Individual customer stock
KD Customer independent requirement (currently not used)
KK Consignment stock for customer (availability check)
LA Shipping notification
LB Storage location stock
LC Batch/storage location stock
LE SA schedule line
LF JIT delivery schedule
LK Stock with subcontractor
LL Forecast delivery schedule
MB Goods issue
MR Reservation
MS Direct production
NE Network order
PA Planned order
PB Project stock
PP Planned independent requirement
PR Forecast requirement
QM Inspection lot for quality management
RP Returns item
RR MRP requirement (only relevant for IS-Automotive)
RU Confirmation
S2 Simulated requirement from availability check
SA Simulation order
SB Dependent requirement
SF Safety requirement
SH Safety stock
SI Simulation requirement
SM Sim. dependent reqmts
SU Total requirements
TB Transfer requirements WMS
U1 Release order for a stock transfer order
U2 Release order for a stock transfer requisition
U3 Transfer requirement for simulation order
U4 Release order for stock transport scheduling agreement
UB Unplanned requirement
UL Reservation in another plant
UR Stock transfer reservation
VA Request for quotation
VB Quotation
VC Order
VE SD scheduling agreement
VF SD scheduling agreement; external service agent
VG Contract
VH Returns from Consignation Stock at Customer
VI Delivery Free of Charge
VJ Delivery
VP Planning
VT Returns (availability check)
VW External sales order
VZ Unverified delivery
WA Goods issue
WB Plant stock
WE Goods receipt
WH End replenishment period
DD Effective-out date
C3 Subcontr. Customer Order Stock
C4 Subcontr. Project Stock
AUFVR Source number for order AUFVR CHAR 10 0
POSVR Source item number POSVR NUMC 6 0
EINVR Source schedule line number EINVR NUMC 4 0
BAUGR Material number of higher-level assembly BAUGR CHAR 18 0
KNTTP Account Assignment Category KNTTP CHAR 1 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
KDAUF Sales Order Number KDAUF CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
PSPEL WBS Element PS_POSNR NUMC 8 0
CUOBJ Configuration (internal object number) CUOBJ NUMC 18 0
AUFNR Run schedule header number SA_AUFNR CHAR 12 0
VERTO Distribution key for quantity produced SA_VERTO CHAR 4 0
QUNUM Number of Quota Arrangement QUNUM CHAR 10 0
QUPOS Quota Arrangement Item QUPOS NUMC 3 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
EKORG Purchasing Organization EKORG CHAR 4 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
VRTYP 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
AUTET Source List Usage in Materials Planning AUTET CHAR 1 0
NULL Source list record not relevant to MRP
1 Record relevant to MRP
2 Record relevant to MRP. Sched. lines generated automatically
BEDAT Purchase Order Date BEDAT DATS 8 0
ETMEN Scheduled Quantity ETMEN QUAN 13 3
GLMNG Quantity Delivered (Stock Transfer) GLMNG QUAN 13 3
FRTHW Production note in the planned order FRTHW CHAR 1 0
1 Initiate procurements of non-stock components !
2 Purch.req.with unknown acct assig. for non-stock component !
AKTFT Indicator "Detailed scheduling available" AKTFT CHAR 1 0
X Yes
NULL No
BEDID ID of the capacity requirements record BEDID NUMC 12 0
TRMER Scheduling error TRMER CHAR 2 0
0 Scheduling carried out successfully
1 Scheduling parameters are not maintained in customizing
2 No capacity requirements determined, see customizing
3 Routing does not exist
4 No valid routing can be selected
5 Scheduling terminated, see log
6 Scheduling carried out, see log for error messages
7 Scheduling carried out, see log for information messages
8 Det./rate-based sched. and sequencing active at same time
AKTRT Indicator "Detailed scheduling available" AKTFT CHAR 1 0
X Yes
NULL No
RATID Index for the results of scheduling production rates RATID NUMC 12 0
RATER Scheduling error in scheduling production rates RATER CHAR 2 0
0 Scheduling carried out successfully
1 Scheduling parameters are not maintained in customizing
2 No capacity requirements determined, see customizing
3 Routing does not exist
4 No valid routing can be selected
5 Scheduling terminated, see log
6 Scheduling carried out, see log for error messages
7 Scheduling carried out, see log for information messages
8 Det./rate-based sched. and sequencing active at same time
AKTGT Indicator: "rough-cut scheduling available" AKTGT CHAR 1 0
X Yes
NULL No
GROID Index for rough scheduling results GROID NUMC 12 0
GROER Scheduling error in rough scheduling GROER CHAR 2 0
0 Scheduling carried out successfully
1 Scheduling parameters are not maintained in customizing
2 No capacity requirements determined, see customizing
3 Routing does not exist
4 No valid routing can be selected
5 Scheduling terminated, see log
6 Scheduling carried out, see log for error messages
7 Scheduling carried out, see log for information messages
8 Det./rate-based sched. and sequencing active at same time
AUFTM MRP element: order quantity AUFTM QUAN 13 3
ARSNR Settlement reservation number ARSNR NUMC 10 0
ARSPS Item number of the settlement reservation ARSPS NUMC 4 0
PRNKZ Ind.: Leading order in collective order is planned ordre PRNKZ CHAR 1 0
X
NULL
KAPFX Indicator: capacity for planned order dispatched KAPFX CHAR 1 0
X Yes
NULL No
PSTTI Start Time of Planned Order PSTTI TIMS 6 0
PEDTI End Time of Planned Order PEDTI TIMS 6 0
RSART Record type RSART CHAR 1 0
XFEHL Missing Part XFEHL CHAR 1 0
X Yes
NULL No
MONKZ Indicator: for assembly order procedures MONKZ CHAR 1 0
X Yes
NULL No
MDFST Production order status: internal ind. for MRP MDFST CHAR 1 0
VRPLA Indicator: planning without final assembly VRPLA CHAR 1 0
X Yes
NULL No
PBDNR Requirements Plan Number PBDNR CHAR 10 0
KUNNR Customer Number KUNNR 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
MDMNG MRP: quantity field (stock in transit, receipt qty, ...) MDMNG QUAN 13 3
WAMNG Issued Quantity WAMNG QUAN 13 3
EDGNO Internal number for edge of object dependencies tree EDGNO NUMC 17 0
TPMNG Overall quantity MRP element (for static pegging) TPQTY QUAN 13 3
EMATN Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 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 UNIT 3 0
ERFMG Quantity in Unit of Entry ERFMG QUAN 13 3
PRSCH Planned order: scheduling using production dates MD_PRSCHED CHAR 1 0
X Yes
NULL No
LVSCH Planned order: leading scheduling level (determines dates) MD_LVSCHED CHAR 1 0
1 Detailed planning
2 Rate-based planning
3 Rough-cut planning
DBSKZ Direct procurement indicator DBSKZ CHAR 1 0
NULL No direct procurement or direct production
E Direct production
F Direct procurement
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
STLNR Bill of material STNUM CHAR 8 0
STLKN BOM item node number STLKN NUMC 8 0
STPOZ Internal counter CIM_COUNT NUMC 8 0
EKGRP Purchasing Group EKGRP CHAR 3 0
MATKL Material Group MATKL CHAR 9 0
PLIFZ Planned Delivery Time in Days PLIFZ DEC 3 0
PSTMP Last Change to Planned Order: Time Stamp PSTMP DEC 15 0
EXTNL Indicator for External Procurement EXTNL CHAR 1 0
X Yes
NULL No
ADINF Field for Additional Information MD_ADINF CHAR 4 0
STAEX Status information on BOM explosion in planned order MD_STAEX CHAR 2 0
01 Alternative explosion (IPPE) active
02 Bulk material items not exploded
RESLO Issuing Storage Location for Stock Transport Order RESLO CHAR 4 0
PRIO_URG Requirement Urgency PRIO_URG PURG NUMC 2 0
PRIO_REQ Requirement Priority PRIO_REQ PREQ NUMC 3 0
MDMAT Material Number MATNR CHAR 18 0
MDLOC Location of MRP Element MDLOC CHAR 20 0
MDWRK Plant WERKS_D CHAR 4 0
MDBER MRP Area BERID CHAR 10 0
SRM_CONTRACT_ID Central Contract SRM_CONTRACT_ID CHAR 10 0
SRM_CONTRACT_ITM Central Contract Item Number SRM_CONTRACT_ITEM NUMC 10 0
DISUB_SOBKZ Special Stock Indicator SOBKZ CHAR 1 0

MDPS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MDPS PRIO_REQ SYST MANDT PREQ Requirement Priorities MANDT
MDPS PRIO_REQ MDPS PRIO_REQ PREQ Requirement Priorities PRIO_REQ
MDPS PRIO_URG SYST MANDT PURG Requirement Urgencies MANDT
MDPS PRIO_URG MDPS PRIO_URG PURG Requirement Urgencies PRIO_URG