SAP table MDPS (Item in MRP document)

Field Description Data Type Length Decimals Checktable Data Element
PLAAB Material requirements planning segment NUMC 2 0 PLAAB
PLANR Planning segment number CHAR 20 0 PLANR
DAT00 Receipt/Requirements date DATS 8 0 DAT00
TAG00 Daily shift (sort indicator 0) NUMC 2 0 TAG00
SORT1 Sort indicator 01 CHAR 1 0 SORT1
SORT2 Sort indicator 02 CHAR 2 0 SORT2
DELKZ MRP element CHAR 2 0 DELKZ
AR Dependent reservation
BA Purchase requisition
BB Subcontractor requirements of material provided
BE Order item schedule line
BP Gross requirements planning
BR Process order
C1 Customer stock
C2 Subcontr. Customer Stock
C3 Subcontr. Customer Order Stock
C4 Subcontr. Project Stock
CH Batch stock
CS SegmentBatchSLoc
DD Effective-out date
E1 Subcontracting purchasing
ER End of replenishment lead time
FE Production order
FH End of planning time fence
HS SegmentBatchStock
IH Maintenance order
IM Actual goods receipt quantity
IW In Plant (Shipping Notification)
JI JIT call
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
LS SegmentSLocStock
M2 Material Transfer
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
SD Safety Demand
SF Safety requirement
SG Stock Gain
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
WS SegmentStock
VSTAT Processing Status CHAR 1 0 VSTAT_D
VRFKZ Availability indicator CHAR 1 0 VRFKZ
PLUMI Receipt/issue indicator CHAR 1 0 PLUMI
MNG01 Quantity received or quantity required QUAN 13 3 MNG01
MNG02 Variable scrap quantity QUAN 13 3 MNG02
MNG03 Shortage Quantity QUAN 13 3 MNG03
MNG04 ATP quantity QUAN 13 3 MNG04
DAT01 Delivery/order finish date DATS 8 0 DAT01
DAT02 Start/release date DATS 8 0 DAT02
DAT03 Opening date DATS 8 0 DAT03
PERKZ Period indicator CHAR 1 0 MD_PERKZ
PRPER Forecast period NUMC 6 0 PRPER
WEBAZ Goods receipt processing time in days DEC 3 0 WEBAZ
UKZ01 Indicator: MRP element can be brought forward CHAR 1 0 UKZ01
UMDAT Rescheduling date DATS 8 0 UMDAT
UMDA2 Rescheduling date DATS 8 0 UMDAT
RDMNG Excess stock quantity QUAN 13 3 RDMNG
FIX01 Indicator: Fixing of Lot Size in Planned Order CHAR 1 0 FIX01
FIX02 Indicator: fixing explosion in planned order CHAR 1 0 FIX02
BAART P.O./Order type CHAR 4 0 BAART
PLART Planning type CHAR 1 0 PLART
BESKZ Procurement Type CHAR 1 0 BESKZ
No Procurement
E In-House Production
F External Procurement
X Both Procurement Types
SOBES Special procurement type CHAR 1 0 SOBES
0 Standard external procurement
2 Consignment
3 Subcontracting
7 Stock transfer
9 IS-OIL only: Stock transfer reservation
E Standard in-house production
P Production in plant 2
ESOBS Special procurement - external display CHAR 1 0 ESOBS
UMSKZ Planned Order Conversion Indicator CHAR 1 0 PLUMS
AUSSL Exception message key CHAR 2 0 AUSSL
OLDSL Key of the second exception message CHAR 2 0 OLDSL
ABEKZ Exception indicator CHAR 1 0 ABEKZ
WRK01 Planning Plant CHAR 4 0 PLWRK
WRK02 Production Plant CHAR 4 0 PWWRK
LGORT Storage location CHAR 4 0 LGORT_D
CHARG Batch Number CHAR 10 0 CHARG_D
LSOBS Special procurement type at storage location level CHAR 2 0 LSOBS
DELNR MRP element number CHAR 10 0 DELNR
DEL12 MRP element number CHAR 12 0 DEL12
DELPS MRP element item NUMC 6 0 DELPS
DELET Schedule Line Number MRP Element NUMC 4 0 DELET
VPZUO Allocation Indicator CHAR 1 0 VPZUO
ZUVKZ Consumption Indicator CHAR 1 0 DZUVKZ
VERVP Consumption indicator for planning requirements CHAR 1 0 VERVP
No Allocation
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)
VERSB Version Number for Independent Requirements CHAR 2 0 VERSB
AKTAL Current explosion available CHAR 1 0 AKTAL
RSNUM Number of reservation/dependent requirements NUMC 10 0 RSNUM
SERNR BOM explosion number CHAR 8 0 SERNR
PALTR Explosion date DATS 8 0 PALTR
TECHS Parameter Variant/Standard Variant CHAR 12 0 TECHS
REVLV Revision Level CHAR 2 0 REVLV
VERID Production Version CHAR 4 0 VERID
STLAN BOM Usage CHAR 1 0 STLAN
STALT Alternative BOM CHAR 2 0 STALT
STSTA Bill of Material Status NUMC 2 0 STLST
NFPKZ Indicator: Follow-Up Item CHAR 1 0 CS_KZNFP
KZAUS Discontinuation indicator CHAR 1 0 KZAUS
1 Single/parallel discontinued part/material
3 Dependent parallel discontinued part/material
NFEAG Discontinuation group CHAR 2 0 CS_NFEAG
NFGRP Follow-up group CHAR 2 0 CS_NFGRP
NAFKZ Indicator: follow-up material active/not active CHAR 1 0 NAFKZ
NFMNG Follow-up quantity QUAN 13 3 NFMNG
NFMAT Follow-Up Material CHAR 40 0 NFMAT
AENNR Change Number CHAR 12 0 AENNR
DELVR MRP element CHAR 2 0 DELKZ
AR Dependent reservation
BA Purchase requisition
BB Subcontractor requirements of material provided
BE Order item schedule line
BP Gross requirements planning
BR Process order
C1 Customer stock
C2 Subcontr. Customer Stock
C3 Subcontr. Customer Order Stock
C4 Subcontr. Project Stock
CH Batch stock
CS SegmentBatchSLoc
DD Effective-out date
E1 Subcontracting purchasing
ER End of replenishment lead time
FE Production order
FH End of planning time fence
HS SegmentBatchStock
IH Maintenance order
IM Actual goods receipt quantity
IW In Plant (Shipping Notification)
JI JIT call
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
LS SegmentSLocStock
M2 Material Transfer
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
SD Safety Demand
SF Safety requirement
SG Stock Gain
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
WS SegmentStock
AUFVR Source number for order CHAR 10 0 AUFVR
POSVR Source item number NUMC 6 0 POSVR
EINVR Source schedule line number NUMC 4 0 EINVR
BAUGR Higher-Level Assembly Material CHAR 40 0 BAUGR
KNTTP Account Assignment Category CHAR 1 0 KNTTP
KZVBR Consumption posting CHAR 1 0 KZVBR
No consumption
A Asset
E Sales order
P Project
V Consumption
SOBKZ Special Stock Indicator CHAR 1 0 SOBKZ
KDAUF Sales Order Number CHAR 10 0 KDAUF
KDPOS Item number in Sales Order NUMC 6 0 KDPOS
PSPEL WBS Element NUMC 8 0 PS_POSNR
CUOBJ Configuration (internal object number) NUMC 18 0 CUOBJ
AUFNR Run schedule header number CHAR 12 0 SA_AUFNR
VERTO Distribution key for quantity produced CHAR 4 0 SA_VERTO
QUNUM Number of quota arrangement CHAR 10 0 QUNUM
QUPOS Quota arrangement item NUMC 3 0 QUPOS
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
EKORG Purchasing organization CHAR 4 0 EKORG
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EBELP
VRTYP Purchasing Document Category CHAR 1 0 BSTYP
A Request for quotation
B Purchase requisition
C Central Contract
F Purchase order
I Info record
K Contract
L Scheduling agreement
N Central Request for Quotation
O Quotation
Q Service entry sheet
R Request for Quotation
S Simplified service entry sheet
T Central Quotation
W Source list
AUTET Source List Usage in Materials Planning CHAR 1 0 AUTET
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 DATS 8 0 BEDAT
ETMEN Scheduled Quantity QUAN 13 3 ETMEN
GLMNG Quantity Delivered (Stock Transfer) QUAN 13 3 GLMNG
FRTHW Production note in the planned order CHAR 1 0 FRTHW
1 Initiate procurements of non-stock components !
2 Purch.req.with unknown acct assig. for non-stock component !
AKTFT Indicator "Detailed scheduling available" CHAR 1 0 AKTFT
BEDID ID of the Capacity Requirements Record NUMC 12 0 BEDID
TRMER Scheduling error CHAR 2 0 TRMER
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 Detailed scheduling and sequencing active at same time
AKTRT Indicator "Detailed scheduling available" CHAR 1 0 AKTFT
RATID -INVALID FOR S/4- Index for the rslts of schedg prod. rates NUMC 12 0 RATID
RATER -INVALID FOR S/4- Schedg error in schedg production rates CHAR 2 0 RATER
AKTGT -INVALID FOR S/4- Indicator: "rough-cut schedg available" CHAR 1 0 AKTGT
GROID -INVALID FOR S/4- Index for rough scheduling results NUMC 12 0 GROID
GROER -INVALID FOR S/4- Scheduling error in rough scheduling CHAR 2 0 GROER
AUFTM MRP element: order quantity QUAN 13 3 AUFTM
ARSNR Settlement reservation number NUMC 10 0 ARSNR
ARSPS Item number of the settlement reservation NUMC 4 0 ARSPS
PRNKZ Ind.: Leading order in collective order is planned ordre CHAR 1 0 PRNKZ
KAPFX Indicator: Capacity for Planned Order is Dispatched CHAR 1 0 KAPFX
PSTTI Planned Order Start Time TIMS 6 0 PSTTI
PEDTI Planned Order End Time TIMS 6 0 PEDTI
RSART Record type CHAR 1 0 RSART
XFEHL Missing Part CHAR 1 0 XFEHL
MONKZ Indicator: For Assembly Order Procedures CHAR 1 0 MONKZ
MDFST Production order status: internal ind. for MRP CHAR 1 0 MDFST
VRPLA Indicator: planning without final assembly CHAR 1 0 VRPLA
PBDNR Requirements Plan CHAR 10 0 PBDNR
KUNNR Customer Number CHAR 10 0 KUNNR
KZBWS Valuation of Special Stock CHAR 1 0 KZBWS
No stock valuation
A Valuation without reference to sales document
M Separate valuation with ref. to sales document/project
MDMNG MRP: quantity field (stock in transit, receipt qty, ...) QUAN 13 3 MDMNG
WAMNG Issued Quantity QUAN 13 3 WAMNG
EDGNO Internal number for edge of object dependencies tree NUMC 17 0 EDGNO
TPMNG Overall quantity MRP element (for static pegging) QUAN 13 3 TPQTY
EMATN Material number corresponding to manufacturer part number CHAR 40 0 EMATN
UMREZ Numerator for Conversion to Base Units of Measure DEC 5 0 UMREZ
UMREN Denominator for conversion to base units of measure DEC 5 0 UMREN
ERFME Unit of entry UNIT 3 0 * ERFME
ERFMG Quantity in unit of entry QUAN 13 3 ERFMG
PRSCH Planned order: scheduling using production dates CHAR 1 0 MD_PRSCHED
LVSCH Planned order: leading scheduling level (determines dates) CHAR 1 0 MD_LVSCHED
DBSKZ Direct procurement indicator CHAR 1 0 DBSKZ
No direct procurement or direct production
E Direct production
F Direct procurement
STLTY BOM category CHAR 1 0 STLTY
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
P Work Breakdown Structure BOM
S Standard BOM
T Functional Location BOM
STLNR Bill of Material CHAR 8 0 STNUM
STLKN BOM item node number NUMC 8 0 STLKN
STPOZ Internal counter NUMC 8 0 CIM_COUNT
EKGRP Purchasing Group CHAR 3 0 EKGRP
MATKL Material Group CHAR 9 0 MATKL
PLIFZ Planned Delivery Time in Days DEC 3 0 PLIFZ
PSTMP Last Change to Planned Order: Time Stamp DEC 15 0 PSTMP
EXTNL Indicator for External Procurement CHAR 1 0 EXTNL
ADINF Field for Additional Information CHAR 4 0 MD_ADINF
STAEX Status information on BOM explosion in planned order CHAR 2 0 MD_STAEX
01 Alternative explosion (IPPE) active
02 Bulk material items not exploded
RESLO Issuing Storage Location for Stock Transport Order CHAR 4 0 RESLO
PRIO_URG Requirement Urgency NUMC 2 0 PURG PRIO_URG
PRIO_REQ Requirement Priority NUMC 3 0 PREQ PRIO_REQ
000 Restriction Due to APO (Format INT1); 000 Only Internal
MDMAT Material Number CHAR 40 0 MATNR
MDLOC Location of MRP Element CHAR 20 0 MDLOC
MDWRK Plant CHAR 4 0 WERKS_D
MDBER MRP Area CHAR 10 0 BERID
SRM_CONTRACT_ID Central Contract CHAR 10 0 SRM_CONTRACT_ID
SRM_CONTRACT_ITM Central Contract Item Number NUMC 10 0 SRM_CONTRACT_ITEM
SGT_CATV Segmentation Value CHAR 40 0 SGT_CATV
SGT_RCAT Requirement Segment CHAR 40 0 SGT_RCAT
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
BOM_VERSN BOM Version CHAR 4 0 CS_VERSN
DISUB_SOBKZ Special Stock Indicator CHAR 1 0 * SOBKZ
IMWERK Delivery has Status 'In Plant' CHAR 1 0 IMWRK
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
ATRKZ Request ID CHAR 1 0 ATRKZ
Standard request
B TOI - Order (created using BAPI)
E MOP - Order (previously EOG)
L LPP - Order
M Multi-Item Order
T Segmentation Order
U Original Order
Z Combined Order
M_MRP Indicator: Matrix Is Activated CHAR 1 0 MMRP_ACTIVE
MPNMT Material Number CHAR 40 0 MATNR
PCMNG Excess stock quantity QUAN 13 3 RDMNG
PVGUID Internal Number of the PVS Variant RAW 16 0 PVS_PVGUID

MDPS foreign key relationships

Table Field Check Table Check Field
0 MDPS PRIO_REQ PREQ Requirement Priorities MANDT
0 MDPS PRIO_REQ PREQ Requirement Priorities PRIO_REQ
1 MDPS PRIO_URG PURG Requirement Urgencies MANDT