SAP Table MDSY

Total lines for MRP elements with quantity columns

MDSY (Total lines for MRP elements with quantity columns) 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 MDSY to other SAP tables.

MDSY 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
SORT0 Numeric field length 8 NUM08 NUMC 8 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
DAT00 Receipt/Requirements date DAT00 DATS 8 0
PERKZ Period Indicator PERKZ CHAR 1 0
P Period according to fiscal year variant
M Monthly
W Weekly
T Daily
NULL Initial value
PRPER Forecast period PRPER NUMC 6 0
ANZFD Number of workdays per period ANZFD DEC 5 0
EXTSU Period or segment EXTSU CHAR 22 0
MNG01 Planned independent requirements MNG07 QUAN 13 3
MNG02 Requirements MNG08 QUAN 13 3
MNG03 Receipts MNG09 QUAN 13 3
MNG04 Available quantity MNG10 QUAN 13 3
MNG05 ATP quantity MNG11 QUAN 13 3
MNG06 Sum of receipts that are not available MNG12 QUAN 13 3
MNG07 Total of non-available issues MNG13 QUAN 13 3
ISTRW Statistical range of coverage (range of coverage profile) ISTRW DEC 4 1
SLRWX Target range of coverage SLRWX NUMC 2 0
MIRWX Minimum range of coverage MIRWX NUMC 2 0
MARWX Maximum range of coverage MARWX NUMC 2 0
SLBES Target stock SLBES QUAN 13 3
MDBES Minimum stock MDBES QUAN 13 3
MXBES Maximum stock MXBES QUAN 13 3
TGBED Average daily requirements TGBED QUAN 13 3
TGPRO Average daily production quantity TGPRO QUAN 13 3
BERW1 Actual range of coverage BERW3 DEC 4 1
BERW2 First Receipt Days' Supply BERW2 DEC 4 1
ANZBV Number of order proposals per period ANZBV NUMC 3 0
AZZUG Number of receipts per period AZZUG NUMC 5 0
ALINE Line index for internal table processing XLINE INT4 10 0
ELINE Line index for internal table processing XLINE INT4 10 0
FBYTE Single-Character Indicator CHAR1 CHAR 1 0
AKZ01 Exceptions in column AUSKZ CHAR 1 0
AKZ02 Exceptions in column AUSKZ CHAR 1 0
AKZ03 Exceptions in column AUSKZ CHAR 1 0
AKZ04 Exceptions in column AUSKZ CHAR 1 0
USEX1 Quantity field for user exit USEXQ QUAN 13 3
USEX2 Quantity field for user exit USEXQ QUAN 13 3
USEX3 Field to be filled by user exit USEEX CHAR 30 0
DETAIL_ICON Carrier field for icons ICON_TEXT CHAR 132 0
MEIND Unit of measure for dislay of receipts and issues MEIND UNIT 3 0
MEINV Unit of measure for display of available quantity MEINV UNIT 3 0
INFO Info : Line is stock line INFOZ CHAR 3 0