1. Home
  2. Resources
  3. SAP Tables
  4. MDCS - Transfer Structure for Grouped Lists in MD04

SAP Table MDCS

Transfer Structure for Grouped Lists in MD04

MDCS (Transfer Structure for Grouped Lists in MD04) 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 MDCS to other SAP tables.

MDCS table fields

Field Data element Checktable Datatype Length Decimals
MATNR Material Number MATNR CHAR 18 0
WERKS Plant WERKS_D CHAR 4 0
BERID MRP Area BERID CHAR 10 0
MAKTX Material Description (Short Text) MAKTX CHAR 40 0
CM61M CM61M STRU 0 0
BANER Creation Indicator for Purchase Requisitions BANER CHAR 1 0
1 Purchase requisitions
2 Purchase requisitions in opening period
3 Planned orders
LIFKZ Automatic Schedule Lines (Scheduling Agreements) LIFKZ CHAR 1 0
1 No schedule lines
2 Schedule lines in the opening period
3 Schedule lines
DISER Creation Indicator for MRP Lists DISER CHAR 1 0
1 MRP list
2 Depending on the exception messages
3 No MRP list
WERTU Value Update in Material Master Record WERTU CHAR 1 0
X Yes
NULL No
MENGU Quantity Updating in Material Master Record MENGU CHAR 1 0
X Yes
NULL No
ANDEC No. of decimal places to which rounding should be performed ANDEC INT2 5 0
USEQU Quota arrangement usage USEQU CHAR 1 0
SBDIS Share of safety stock which can be used for planning SBDIS NUMC 3 0
ICBED Reorder point planning with external requirements ICBED CHAR 1 0
NULL External reqmts are not taken into account
1 External reqmts in total horizon
2 External reqmts within replenishment lead time
FXART Firming Type of the Planning Result FXART CHAR 1 0
0 Planning results not firmed
1 Automatic firming and order proposals rescheduled out
2 Automatic firming without order proposal
3 Manual firming and order proposals rescheduled out
4 Manual firming without order proposal
NULL
FXHOR Planning time fence FXHOR NUMC 3 0
FIXTR End of planning time fence (date) FIXTR DATS 8 0
MFHKZ Planning time fence set manually (MFXDT) MFHKZ CHAR 1 0
X Yes
NULL No
RESPL Indicator: delete firm planned orders RESPL CHAR 1 0
NULL Do not delete firm planned orders
1 Delete firm planned orders
RESHZ Roll forward period for the master plan RESHZ DEC 2 0
RSTER End of roll forward period RSTER DATS 8 0
UMTHZ Rescheduling horizon UMTHZ NUMC 3 0
UMTER End of rescheduling horizon (date) UMTER DATS 8 0
VWVOR Tolerance value for bringing forward receipt elements VWVOR NUMC 2 0
VWVER Tolerance value for displacement in the future VWVER NUMC 2 0
PLAHZ Planning horizon PLAHZ NUMC 3 0
PLTER End of planning horizon PLTER DATS 8 0
WZTER End of replenishment lead time WZTER DATS 8 0
KZREG Indicator: plan material regularly KZREG CHAR 1 0
X Yes
NULL No
ANDIS Number of Days After Which the Material Must Be Planned ANDIS INT2 5 0
RHDAT Next planning date for time-phased planning RHDAT DATS 8 0
RHEND End of the requirements period for time-phased MRP RHEND DATS 8 0
RYBED Time-phased planning with requirements (MRP) RYBED CHAR 1 0
X Yes
NULL No
VRMOD Consumption mode VRMOD CHAR 1 0
1 Backward consumption only
2 Backward/forward consumption
3 Forward consumption only
4 Forward/backward consumption
VINT1 Consumption period: backward VINT1 NUMC 3 0
VINT2 Consumption period: forward VINT2 NUMC 3 0
VPLAN Single-Character Indicator CHAR1 CHAR 1 0
VPLAV Single-Character Indicator CHAR1 CHAR 1 0
VTYPE Planning Variant XVPLB CHAR 1 0
X Yes
NULL No
STDPD Configurable material STDPD CHAR 18 0
RVPKZ Adjustment of Planned Independent Requirements RVPKZ CHAR 1 0
NULL No adjustment
1 Adjustment in the future
2 Adjustment in the past
3 Adjustment in the future - only indep.reqmts w. consumption
4 Adjustment in the past - only indep. reqmts w. consumption
RESVP Period of adjustment for planned independent requirements RESVP DEC 3 0
RVPTR End of adjustment period for planned independent reqmts RVPTR DATS 8 0
EXSGT Do Not Explode Bulk Material Items EXSGT CHAR 1 0
NULL Blank
. Radio button
X Selection
BESAL Determine Explosion Date for BOM and Routing BESAL CHAR 1 0
NULL BOM explosion number/order start date
1 Order start date
2 Order finish date
3 BOM explosion number/order start date
4 BOM explosion number/order finish date
GTERM Scheduling according to purchasing info record or agreement GTERM CHAR 1 0
X Yes
NULL No
KZDRB Indicator: direct procurement/production MRP KZDRB CHAR 1 0
NULL Direct procurement only when creating production order
1 Trigger direct procurement in requirements planning
2 Direct procurement only when creating production order
3 Trigger direct procurement in requirements planning
SETYP Single-Character Indicator CHAR1 CHAR 1 0
PLNKZ Planning Indicator PLNKZ CHAR 1 0
1 Net requirements planning
2 Gross requirements planning
3 Single-item planning
OSELT Above selection date OSELT DATS 8 0
PRREG Checking Rule for Availability Check PRREG CHAR 2 0
SUMAU Total sales order requirements SUMAU CHAR 1 0
A Single records
B Totals records per day
C Totals records per week, reqs date on Monday of current week
D Totals records per week, reqs date on Monday of fol. week
RWFLG Calculate safety stock based on range of coverage RWFLG CHAR 1 0
X Yes
NULL No
RWPER Period for Calculating the Dynamic Safety Stock RWPER CHAR 1 0
M Month
W Week
K PP planning calendar
RWANZ Number of periods for determining the average RWANZ NUMC 2 0
RWART Period length type for calculating the average RWART CHAR 1 0
1 Workdays
2 Calendar days
3 Standard days
RWNTG Number of days per range of coverage period RWNTG NUMC 2 0
RW1TG Target Range of Coverage in Period 01 RW1TG NUMC 2 0
RW1DT Planning horizon for range of coverage 01 RW1DT DATS 8 0
RW2TG Target Range of Coverage in Period 02 RW2TG NUMC 2 0
RW2DT Planning horizon for range of coverage 02 RW2DT DATS 8 0
RW3TG Target Range of Coverage in the Rest of the Period RW3TG NUMC 2 0
MIRW1 Target Range of Coverage in Period 01 RW1TG NUMC 2 0
MIRW2 Target Range of Coverage in Period 01 RW1TG NUMC 2 0
MIRW3 Target Range of Coverage in Period 01 RW1TG NUMC 2 0
MARW1 Target Range of Coverage in Period 01 RW1TG NUMC 2 0
MARW2 Target Range of Coverage in Period 01 RW1TG NUMC 2 0
MARW3 Target Range of Coverage in Period 01 RW1TG NUMC 2 0
XFAT1 Firm Only Schedule Lines Transmitted to Vendor by Purchasing XFAT1 CHAR 1 0
X Yes
NULL No
PLIFZ Planned Delivery Time in Days PLIFZ DEC 3 0
KZBED Indicator for Requirements Grouping KZBED CHAR 1 0
T Display of dependent requirements as a daily total
0 In rep. mfg, individual record in addn to total requirements
PLSEL Issue Storage Location Selection PLSEL CHAR 1 0
1 Only components
2 Only assemblies
3 1st components / 2nd assemblies
4 1st assemblies / 2nd components
BSART MRP:doc.type purchase requisitions for standard purchase ord BBSRT_NB CHAR 4 0
BARTL MRP: Document type purchase requisition for subcontracting BBSRT_LB CHAR 4 0
BARTU MRP: purchase requisition for stock transfer - document type BBSRT_UL CHAR 4 0
AGREQ Aggregated dependent requirements AGRES CHAR 1 0
NULL No totaling of dependent requirements
X Totaling of dependent requirements
OPFDT Date of firm planned order last copied from MRP OPFDT DATS 8 0
MFXDT Manual firming date MFXDT DATS 8 0
MFNAM Set manual firming date: User MFNAM CHAR 12 0
MFDAT Set manual firming date: Date to set MFDAT DATS 8 0
MFXKZ Indicator: MFXDT changed MFXKZ CHAR 1 0
X Yes
NULL No
OPFKZ Indicator:OPFDT changed OPFKZ CHAR 1 0
X Yes
NULL No
NODUM No requirements for phantom assembly NODUM CHAR 1 0
X Yes
NULL No
BBBED Material staging reqmts (subcontr. reqmts) MRP element BB BBBED CHAR 1 0
X Yes
NULL No
U1BED Release for stock transfer order U1BED CHAR 1 0
X Yes
NULL No
U2BED Delivery schedule for a stock transfer requisition U2BED CHAR 1 0
X Yes
NULL No
U4BED Delivery schedule for stock transport scheduling agreement U4BED CHAR 1 0
X Yes
NULL No
A1BED Dependent reservation - standard orders A1BED CHAR 1 0
X Yes
NULL No
A2BED Dependent reservation - plant maintenance orders and network A2BED CHAR 1 0
X Yes
NULL No
GRREL Relevant for requirements grouping for project stock GRREL CHAR 1 0
X Yes
NULL No
AHDIS MRP relevancy for dependent requirements AHDIS CHAR 1 0
NULL Materials for dependent requirements are planned
1 Materials for dependent requirements are not planned
VERTR Start date of order proposals allowed in the past VERTR CHAR 1 0
X Yes
NULL No
ENDWZ End of replenishment lead time WZTER DATS 8 0
FKOBS ATP check by full confirmation logic FKOBS CHAR 1 0
X Yes
NULL No
PSTMP Last Change to Planned Order: Time Stamp PSTMP DEC 15 0
SCFLG Indicator: General Subcontracting Logic MD_SCFLG CHAR 1 0
X Yes
NULL No
UMLDB Indicator for Stock Transfer with MRP Areas MD_UMLDB CHAR 1 0
NULL Stock Transfer Reservations from the Plant to the MRP Area
1 Purchase Requisitions from the Plant to the MRP Area
FABKL Material-Specific Calendar (Range of Coverage) MD_FABKL_COV CHAR 2 0
CNDIF Reduction from Confirmation of Different Planned Orders MD_MES_CNF_DIF CHAR 1 0
MDSTA MDSTA STRU 0 0
KZSTA Single-Character Indicator CHAR1 CHAR 1 0
LABST Valuated Unrestricted-Use Stock LABST QUAN 13 3
INSME Stock in Quality Inspection INSME QUAN 13 3
SPEME Blocked Stock SPEME QUAN 13 3
EINME Total Stock of All Restricted Batches EINME QUAN 13 3
RETME Blocked Stock Returns RETME QUAN 13 3
WESPB Blocked Stock from Goods Receipt WESPB QUAN 13 3
REBST Reservations REBST QUAN 13 3
KLABS Unrestricted-Use Consignment Stock KLABS QUAN 13 3
KINSM Consignment Stock in Quality Inspection KINSM QUAN 13 3
KEINM Restricted-Use Consignment Stock KEINM QUAN 13 3
KSPEM Blocked Consignment Stock KSPEM QUAN 13 3
SLLAB Valuated unrestricted-use stock at vendor SLLAB QUAN 13 3
SLINS Stock in quality inspection at vendors SLINS QUAN 13 3
KDBST Sales requirements KDBST QUAN 13 3
BEBST Purchase orders BEBST QUAN 13 3
BEBSK Consignment order BEBSK QUAN 13 3
BANFB Purchase requisitions BANFB QUAN 13 3
PLAFB Planned orders PLAFB QUAN 13 3
FEAUB Production orders in total FEAUB QUAN 13 3
RESBZ Receipt reservation RESBZ QUAN 13 3
UMREB Stock transfer reservations UMREB QUAN 13 3
UMABR Stock transfer release orders UMABR QUAN 13 3
UMABG Stock Transfer Releases (Planned) UMABG QUAN 13 3
PRBED Forecast requirements PRBED QUAN 13 3
VBEDA Requests for quotations VBEDA QUAN 13 3
VBEDB Quotations VBEDB QUAN 13 3
VBEDC Orders VBEDC QUAN 13 3
VBEDE Scheduling agreements VBEDE QUAN 13 3
VBEDG Contracts VBEDG QUAN 13 3
VBEDI Deliveries free of charge VBEDI QUAN 13 3
VBEDJ Deliveries VBEDJ QUAN 13 3
SKBED Dependent requirements SKBED_D QUAN 13 3
UMREN Denominator for conversion to base units of measure UMREN DEC 5 0
UMREZ Numerator for Conversion to Base Units of Measure UMREZ DEC 5 0
SKBEZ Total quantity of the receipt dependent requirements SKBEZ QUAN 13 3
PRIMB Planned independent requirements PRIMB QUAN 13 3
SUM01 Warehouse stock / total (including special stor.locs) SUM01 QUAN 13 3
SUM02 Total of promised receipts SUM02 QUAN 13 3
SUM03 Total of planned receipts SUM03 QUAN 13 3
SUM04 Total of promised issues SUM04 QUAN 13 3
SUM05 Total of planned issues SUM05 QUAN 13 3
UMLMC Stock in Transfer (Plant to Plant) UMLME QUAN 13 3
TRAME Stock in Transit TRAME QUAN 13 3
UMLME Stock in transfer (from one storage location to another) UMLMD QUAN 13 3
BSRET Returns BSRET QUAN 13 3
RETRL Release Orders for Returns RETRL QUAN 13 3
REQDUE Requirement Quantity Subject to Delay MD_REQDUE QUAN 13 3
REQCUR Requirement Quantity in Current Period MD_REQCUR QUAN 13 3
REQNX1 Requirement Quantity Next Period MD_REQNX1 QUAN 13 3
REQNX2 Requirement Quantity Period After Next MD_REQNX2 QUAN 13 3
RECDUE Receipt Quantity Subject to Delay MD_RECDUE QUAN 13 3
RECCUR Receipt Quantity in Current Period MD_RECCUR QUAN 13 3
RECNX1 Receipt Quantity in Next Period MD_RECNX1 QUAN 13 3
RECNX2 Receipt Quantity in Period After Next MD_RECNX2 QUAN 13 3
REQSUM Total Requirements in Periods (Including Safety Stock) MD_RQSUM QUAN 13 3
RECSUM Total of Receipts in Periods Plus Stock MD_RCSUM QUAN 13 3
PCURR Current Period MD_PCURR CHAR 10 0
PNEX1 Next Period MD_PNEX1 CHAR 10 0
PNEX2 Period After Next MD_PNEX2 CHAR 10 0
PZCURR Current Period MD_PCURR CHAR 10 0
PZNEX1 Next Period MD_PNEX1 CHAR 10 0
PZNEX2 Period After Next MD_PNEX2 CHAR 10 0
PERKZ Period Indicator PERKZ_MRP CHAR 1 0
P Period According to Fiscal Year Variant
M Monthly
W Weekly
T Daily
NULL Initial Value
K Planning According to Planning Calendar
MRPPP PPC planning calendar MRPPP CHAR 3 0
CUTDT Evaluation End Date for Statistics MD_CUTDT DATS 8 0
KEBST Total Individual Sales Order Stocks MD_KEBST QUAN 13 3
PRBST Total Individual Project Stocks MD_PRBST QUAN 13 3
EZBST Total of Individual Stocks (Project and Sales Order) MD_EZBST QUAN 13 3
KOBST Total Consignment Stock MD_KOBST QUAN 13 3
UMBST Stock in Transfer (Total) MD_UMBST QUAN 13 3
LBBST Total Subcontracting Stock MD_LBBST QUAN 13 3
GSBST Total of All Stocks Including Individual Stocks MD_GSBST QUAN 13 3
ABBED Stock Transfer Releases (Total) MD_ABBED QUAN 13 3
EISBE Safety Stock EISBE QUAN 13 3
SLUML Stock in Transfer for Subcontracting (Plant to Plant) UMLME_O QUAN 13 3
BWESB Valuated Goods Receipt Blocked Stock BWESB QUAN 13 3
MDKP MDKP STRU 0 0
MANDT Client MANDT CLNT 3 0
DTART Type of MRP list DTART CHAR 2 0
MD Material requirements planning
LP Long-Term Planning
MATNR Material Number MATNR CHAR 18 0
PLWRK Plant WERKS_D CHAR 4 0
PLSCN Planning Scenario of Long-Term Planning PLSCN NUMC 3 0
DTNUM Number of material requirements planning table DTNUM NUMC 10 0
DSDAT MRP date DSDAT DATS 8 0
BDBKZ Selection indicator for processed MRP lists BDBKZ CHAR 1 0
X Yes
NULL No
SLKZ1 Selection indicator for exception groups SLKZX CHAR 1 0
SLKZ2 Selection indicator for exception groups SLKZX CHAR 1 0
SLKZ3 Selection indicator for exception groups SLKZX CHAR 1 0
SLKZ4 Selection indicator for exception groups SLKZX CHAR 1 0
SLKZ5 Selection indicator for exception groups SLKZX CHAR 1 0
SLKZ6 Selection indicator for exception groups SLKZX CHAR 1 0
SLKZ7 Selection indicator for exception groups SLKZX CHAR 1 0
SLKZ8 Selection indicator for exception groups SLKZX CHAR 1 0
VRKZ1 Processing indicator 01 VRKZ1 CHAR 1 0
X Yes
NULL No
VRKZ2 Processing indicator 02 VRKZ2 CHAR 1 0
X Yes
NULL No
VRKZ3 Processing indicator - 03 VRKZ3 CHAR 1 0
X Yes
NULL No
MTART Material Type MTART CHAR 4 0
MEINS Base Unit of Measure MEINS UNIT 3 0
DISST Low-Level Code DISST CHAR 3 0
BESKZ Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
SOBSL Special procurement type SOBSL CHAR 2 0
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
WRK02 Planning/production plant WRK02 CHAR 4 0
DISMM MRP Type DISMM CHAR 2 0
DISVF MRP procedure DISVF CHAR 1 0
B Reorder point planning
D Material requirements planning
N No MRP
S Forecast-based planning
M Master production scheduling
R Time-phased materials planning
W Replenishment (IS Retail)
X Without MRP, with BOM explosion
DISPO MRP Controller (Materials Planner) DISPO CHAR 3 0
PLDIS Planning controller (no longer used) PLDIS CHAR 3 0
EKGRP Purchasing Group EKGRP CHAR 3 0
MTWZT Material replenishment lead time MTWZT DEC 3 0
WEBAZ Goods Receipt Processing Time in Days WEBAZ DEC 3 0
BEAZT Processing time for purchase order proposal BEAZT DEC 3 0
FIXTR End of planning time fence (date) FIXTR DATS 8 0
MFHKZ Planning time fence set manually (MFXDT) MFHKZ CHAR 1 0
X Yes
NULL No
DISLS Lot size (materials planning) DISLS CHAR 2 0
LOSVF Lot-sizing procedure for short-term period LOSVF CHAR 1 0
S Static lot-sizing procedure
P Period lot-sizing procedure
O Optimum lot-sizing procedure
LOSKZ Lot-size indicator for the short-term period LOSKZ CHAR 1 0
W Period lot size: weekly lot/dyn. lot-sizing: least unit cost
F Fixed lot size
E Lot-for-lot order quantity
H Replenish to maximum stock level
T Daily lot size
M Monthly lot size
P Period lot sizes according to posting periods
D Dynamic lot size creation
G Groff reorder procedure
S Stat.lot size: fixed w. splitting/dyn.lot size: part pd bal.
K Period lot size as in PPC planning calendar
PERAZ Number of periods for the short-term area PERAZ DEC 3 0
EISBE Safety Stock EISBE QUAN 13 3
MINBE Reorder Point MINBE QUAN 13 3
HOEBE Maximum stock level MABST QUAN 13 3
BSTMI Minimum Lot Size BSTMI QUAN 13 3
BSTMA Maximum Lot Size BSTMA QUAN 13 3
BSTFX Fixed lot size BSTFE QUAN 13 3
BSTRF Rounding value for purchase order quantity BSTRF QUAN 13 3
SUM01 Plant stock / only plant segment SUM01W QUAN 13 3
SUM02 No longer used/do not use!! NOUSE QUAN 13 3
SUM03 No longer used/do not use!! NOUSE QUAN 13 3
SUM04 No longer used/do not use!! NOUSE QUAN 13 3
SUM05 No longer used/do not use!! NOUSE QUAN 13 3
NEGBS Negative stock NEGBS QUAN 13 3
MSGID Message identification MSGID CHAR 20 0
MSGAR Message Type MSGTY CHAR 1 0
S Message on next screen
I Information
A Cancel
E Error
W Warning
MSGNR Message number MSGNR CHAR 3 0
MSGV1 Message variable 01 MSGV1 CHAR 50 0
MSGV2 Message variable 02 MSGV2 CHAR 50 0
MSGV3 Message variable 03 MSGV3 CHAR 50 0
MSGV4 Message variable 04 MSGV4 CHAR 50 0
DISGR MRP Group DISGR CHAR 4 0
PERIV Fiscal Year Variant PERIV CHAR 2 0
MRPPP PPC planning calendar MRPPP CHAR 3 0
BDARF Requirements quantity from material requirements planning BDARF QUAN 13 3
LFRHY Planning cycle LFRHY CHAR 3 0
RDPRF Rounding Profile RDPRF CHAR 4 0
BERW1 Stock Days' Supply Without Receipts BERW1 DEC 4 1
BERW2 First Receipt Days' Supply BERW2 DEC 4 1
KZAUS Discontinuation indicator KZAUS CHAR 1 0
1 Single/parallel discontinued part/material
3 Dependent parallel discontinued part/material
AUSDT Effective-Out Date AUSDT DATS 8 0
NFMAT Follow-Up Material NFMAT CHAR 18 0
AUSZ1 Exception group in the MRP list AUSZX CHAR 2 0
AUSZ2 Exception group in the MRP list AUSZX CHAR 2 0
AUSZ3 Exception group in the MRP list AUSZX CHAR 2 0
AUSZ4 Exception group in the MRP list AUSZX CHAR 2 0
AUSZ5 Exception group in the MRP list AUSZX CHAR 2 0
AUSZ6 Exception group in the MRP list AUSZX CHAR 2 0
AUSZ7 Exception group in the MRP list AUSZX CHAR 2 0
AUSZ8 Exception group in the MRP list AUSZX CHAR 2 0
BEADA MRP list processing date BEADA DATS 8 0
NAUKZ Indicator: new exception in the MRP list NAUKZ CHAR 1 0
SAUFT Ind.: Repetitive mfg allowed SA_SAUFT CHAR 1 0
X Yes
NULL No
KZPROMO Indicator: Material in promotion KZPROMO CHAR 1 0
SHFLG Safety time indicator (with or without safety time) SHFLG CHAR 1 0
NULL Ignore safety time
1 Safety time for independent reqmts
2 Safety time for all requirements
SHZET Safety time (in workdays) SHZET NUMC 2 0
FABKZ Indicator: Item Relevant to JIT Delivery Schedules FABKZ CHAR 1 0
NULL No JIT
1 Automatically
MFXDT Manual firming date MFXDT DATS 8 0
BSKFL Flag whether stock correction factors exist BSKFL CHAR 1 0
NULL Blank
. Radio button
X Selection
MAABC ABC Indicator MAABC CHAR 1 0
CFLAG Aggregated MRP list COMPMRPL CHAR 1 0
X Yes
NULL No
GRREL Relevant for requirements grouping for project stock GRREL CHAR 1 0
X Yes
NULL No
RWPRO Range of coverage profile RWPRO CHAR 3 0
SHPRO Period Profile for Safety Time SHPRO CHAR 3 0
AHDIS MRP relevancy for dependent requirements AHDIS CHAR 1 0
NULL Materials for dependent requirements are planned
1 Materials for dependent requirements are not planned
BERW4 Second Receipt Days' Supply BERW4 DEC 4 1
BADON Indicator: BAdI is Active MD_BADI_ON CHAR 1 0
X Yes
NULL No
HANAON HANA Optimizations Active / Inactive PPH_HANA_ON CHAR 1 0
X Yes
NULL No