1. Home
  2. Resources
  3. SAP Tables
  4. MDSTA - Statistic fields for stocks

SAP Table MDSTA

Statistic fields for stocks

MDSTA (Statistic fields for stocks) 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 MDSTA to other SAP tables.

MDSTA table fields

Field Data element Checktable Datatype Length Decimals
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 T439G 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

MDSTA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MDSTA MRPPP SYST MANDT T439G PPplanning periods: header table MANDT
MDSTA MRPPP MDKP PLWRK T439G PPplanning periods: header table WERKS
MDSTA MRPPP MDSTA MRPPP T439G PPplanning periods: header table MRPPP