Follow us on LinkedIn for your next SAP project

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 Possible values
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
LIFKZ
Automatic Schedule Lines (Scheduling Agreements)
LIFKZ
CHAR
1 0
DISER
Creation Indicator for MRP Lists
DISER
CHAR
1 0
WERTU
Value Update in Material Master Record
WERTU
CHAR
1 0
MENGU
Quantity Updating in Material Master Record
MENGU
CHAR
1 0
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
FXART
Firming Type of the Planning Result
FXART
CHAR
1 0
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
RESPL
Indicator: delete firm planned orders
RESPL
CHAR
1 0
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
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
VRMOD
Consumption mode
VRMOD
CHAR
1 0
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
STDPD
Configurable material
STDPD
CHAR
18 0
RVPKZ
Adjustment of Planned Independent Requirements
RVPKZ
CHAR
1 0
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
BESAL
Determine Explosion Date for BOM and Routing
BESAL
CHAR
1 0
GTERM
Scheduling according to purchasing info record or agreement
GTERM
CHAR
1 0
KZDRB
Indicator: direct procurement/production MRP
KZDRB
CHAR
1 0
SETYP
Single-Character Indicator
CHAR1
CHAR
1 0
PLNKZ
Planning Indicator
PLNKZ
CHAR
1 0
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
RWFLG
Calculate safety stock based on range of coverage
RWFLG
CHAR
1 0
RWPER
Period for Calculating the Dynamic Safety Stock
RWPER
CHAR
1 0
RWANZ
Number of periods for determining the average
RWANZ
NUMC
2 0
RWART
Period length type for calculating the average
RWART
CHAR
1 0
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
PLIFZ
Planned Delivery Time in Days
PLIFZ
DEC
3 0
KZBED
Indicator for Requirements Grouping
KZBED
CHAR
1 0
PLSEL
Issue Storage Location Selection
PLSEL
CHAR
1 0
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
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
OPFKZ
Indicator:OPFDT changed
OPFKZ
CHAR
1 0
NODUM
No requirements for phantom assembly
NODUM
CHAR
1 0
BBBED
Material staging reqmts (subcontr. reqmts) MRP element BB
BBBED
CHAR
1 0
U1BED
Release for stock transfer order
U1BED
CHAR
1 0
U2BED
Delivery schedule for a stock transfer requisition
U2BED
CHAR
1 0
U4BED
Delivery schedule for stock transport scheduling agreement
U4BED
CHAR
1 0
A1BED
Dependent reservation - standard orders
A1BED
CHAR
1 0
A2BED
Dependent reservation - plant maintenance orders and network
A2BED
CHAR
1 0
GRREL
Relevant for requirements grouping for project stock
GRREL
CHAR
1 0
AHDIS
MRP relevancy for dependent requirements
AHDIS
CHAR
1 0
VERTR
Start date of order proposals allowed in the past
VERTR
CHAR
1 0
ENDWZ
End of replenishment lead time
WZTER
DATS
8 0
FKOBS
ATP check by full confirmation logic
FKOBS
CHAR
1 0
PSTMP
Last Change to Planned Order: Time Stamp
PSTMP
DEC
15 0
SCFLG
Indicator: General Subcontracting Logic
MD_SCFLG
CHAR
1 0
UMLDB
Indicator for Stock Transfer with MRP Areas
MD_UMLDB
CHAR
1 0
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
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
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
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
VRKZ2
Processing indicator 02
VRKZ2
CHAR
1 0
VRKZ3
Processing indicator - 03
VRKZ3
CHAR
1 0
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
SOBSL
Special procurement type
SOBSL
CHAR
2 0
SOBES
Special procurement type
SOBES
CHAR
1 0
WRK02
Planning/production plant
WRK02
CHAR
4 0
DISMM
MRP Type
DISMM
CHAR
2 0
DISVF
MRP procedure
DISVF
CHAR
1 0
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
DISLS
Lot size (materials planning)
DISLS
CHAR
2 0
LOSVF
Lot-sizing procedure for short-term period
LOSVF
CHAR
1 0
LOSKZ
Lot-size indicator for the short-term period
LOSKZ
CHAR
1 0
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
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
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
KZPROMO
Indicator: Material in promotion
KZPROMO
CHAR
1 0
SHFLG
Safety time indicator (with or without safety time)
SHFLG
CHAR
1 0
SHZET
Safety time (in workdays)
SHZET
NUMC
2 0
FABKZ
Indicator: Item Relevant to JIT Delivery Schedules
FABKZ
CHAR
1 0
MFXDT
Manual firming date
MFXDT
DATS
8 0
BSKFL
Flag whether stock correction factors exist
BSKFL
CHAR
1 0
MAABC
ABC Indicator
MAABC
CHAR
1 0
CFLAG
Aggregated MRP list
COMPMRPL
CHAR
1 0
GRREL
Relevant for requirements grouping for project stock
GRREL
CHAR
1 0
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
BERW4
Second Receipt Days' Supply
BERW4
DEC
4 1
BADON
Indicator: BAdI is Active
MD_BADI_ON
CHAR
1 0
HANAON
HANA Optimizations Active / Inactive
PPH_HANA_ON
CHAR
1 0