1. Home
  2. Resources
  3. SAP Tables
  4. BAPI_MRP_ITEMS - MRP: MRP Document Item

SAP Table BAPI_MRP_ITEMS

MRP: MRP Document Item

BAPI_MRP_ITEMS (MRP: MRP Document Item) 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 BAPI_MRP_ITEMS to other SAP tables.

BAPI_MRP_ITEMS table fields

Field Data element Checktable Datatype Length Decimals
PLNGSEGMT Material requirements planning segment PLAAB NUMC 2 0
PLNGSEGNO Planning segment number PLANR CHAR 20 0
AVAIL_DATE Receipt/Requirements date DAT00 DATS 8 0
SORTIND_00 Daily shift (sort indicator 0) TAG00 NUMC 2 0
SORTIND_01 Sort indicator 01 SORT1 CHAR 1 0
SORTIND_02 Sort indicator 02 SORT2 CHAR 2 0
MRP_ELEMENT_IND 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
PR_STATUS Processing Status VSTAT_D CHAR 1 0
AVAILABLE Availability indicator VRFKZ CHAR 1 0
PLUS_MINUS Receipt/issue indicator PLUMI CHAR 1 0
REC_REQD_QTY Quantity received or quantity required MNG01 QUAN 13 3
SCRAP Variable scrap quantity MNG02 QUAN 13 3
SHORTAGE_QTY Shortage Quantity MNG03 QUAN 13 3
ATP_QTY ATP quantity MNG04 QUAN 13 3
FINISH_DATE Delivery/order finish date DAT01 DATS 8 0
START_DATE Start/release date DAT02 DATS 8 0
OPEN_DATE Opening date DAT03 DATS 8 0
PERIOD Period indicator MD_PERKZ CHAR 1 0
M Monthly
W Weekly
T Daily
P Period according to fiscal year variant
K Period according to PP planning calendar
R Individual period split
FORECAST_PERIOD Forecast period PRPER NUMC 6 0
GR_PR_TIME Goods Receipt Processing Time in Days WEBAZ DEC 3 0
BRINGFORWD Indicator: MRP element can be brought forward UKZ01 CHAR 1 0
X Yes
NULL No
RESCHED_DATE1 Rescheduling date UMDAT DATS 8 0
RESCHED_DATE2 Rescheduling date UMDAT DATS 8 0
EXCESS_STK_QTY Excess stock quantity RDMNG QUAN 13 3
FIRMED Indicator: fixeing lot size in planned order FIX01 CHAR 1 0
X Yes
NULL No
FIX_EXPL Indicator: fixing explosion in planned order FIX02 CHAR 1 0
X Yes
NULL No
ORDER_TYPE P.O./Order type BAART CHAR 4 0
PLANNING_TYPE Planning type PLART CHAR 1 0
PROC_TYPE Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
SPPROCTYPE 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
EXT_SPPROCTYPE Special procurement - external display ESOBS CHAR 1 0
CONVERSION_INDICATOR Conversion indicator for planned order PLUMS CHAR 1 0
X Yes
NULL No
EXCMSGKEY01 Exception message key AUSSL CHAR 2 0
EXCMSGKEY02 Key of the second exception message OLDSL CHAR 2 0
EXCEP_IND Exception indicator ABEKZ CHAR 1 0
PLAN_PLANT Planning Plant PLWRK CHAR 4 0
PROD_PLANT Production plant in planned order PWWRK CHAR 4 0
STORAGE_LOC Storage Location LGORT_D CHAR 4 0
BATCH Batch Number CHARG_D CHAR 10 0
SPEC_PROC Special procurement type at storage location level LSOBS CHAR 2 0
MRP_NO MRP element number DELNR CHAR 10 0
MRP_NO12 MRP element number DEL12 CHAR 12 0
MRP_POS MRP element item DELPS NUMC 6 0
MRP_ITEM Schedule Line Number MRP Element DELET NUMC 4 0
ALLOC_IND Allocation Indicator VPZUO CHAR 1 0
NULL No consumption with customer requirements
1 Consume planning with assembly
2 Consume planning w/o assembly
3 Consume planning material (w/o assembly)
CONSUMP_IND Consumption indicator DZUVKZ CHAR 1 0
NULL No consumption with customer requirements
1 Consume planning with assembly
2 Consume planning w/o assembly
3 Consume planning material (w/o assembly)
PIR_CONS_IND Consumption indicator for planning requirements VERVP CHAR 1 0
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)
NULL No Allocation
PIR_VERSION Version number for independent requirements VERSB CHAR 2 0
CURR_EXPL_AVAIL Current explosion available AKTAL CHAR 1 0
NULL Blank
. Radio button
X Selection
RESERV_NO Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
BOMEXPL_NO BOM explosion number SERNR CHAR 8 0
BOM_EXPL_DATE Explosion date PALTR DATS 8 0
VALIDITY_OBJECT Parameter Variant/Standard Variant TECHS CHAR 12 0
REV_LEVEL Revision Level REVLV CHAR 2 0
PROD_VERSION Production Version VERID CHAR 4 0
BOM_USAGE BOM Usage STLAN CHAR 1 0
ALTERNATIVE_BOM Alternative BOM STALT CHAR 2 0
BOM_STATUS BOM status STLST NUMC 2 0
FOLLOW_UP_ITEM_IND Indicator: Follow-Up Item CS_KZNFP CHAR 1 0
X Yes
NULL No
DISCONTINU Discontinuation indicator KZAUS CHAR 1 0
1 Single/parallel discontinued part/material
3 Dependent parallel discontinued part/material
DISCON_GROUP Discontinuation group CS_NFEAG CHAR 2 0
FOLLOW_UP_GROUP Follow-up group CS_NFGRP CHAR 2 0
DISCON_ACTIVE Indicator: follow-up material active/not active NAFKZ CHAR 1 0
X Yes
NULL No
FOLLOW_UP_QTY Follow-up quantity NFMNG QUAN 13 3
FOLLOW_UP Follow-Up Material NFMAT CHAR 18 0
CHANGE_NO Change Number AENNR CHAR 12 0
SRC_MRP_ELEM_IND 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
SOURCE_NO Source number for order AUFVR CHAR 10 0
SOURCE_ITEM Source item number POSVR NUMC 6 0
SOURCE_SCHED_LINE Source schedule line number EINVR NUMC 4 0
PEGGEDRQMT Material number of higher-level assembly BAUGR CHAR 18 0
ACCTASSCAT Account Assignment Category KNTTP CHAR 1 0
CONSUMPT Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
SPEC_STOCK Special Stock Indicator SOBKZ CHAR 1 0
SALES_ORD Sales Order Number KDAUF CHAR 10 0
S_ORD_ITEM Item Number in Sales Order KDPOS NUMC 6 0
WBS_ELEM WBS Element PS_POSNR NUMC 8 0
INT_OBJ_NO Configuration (internal object number) CUOBJ NUMC 18 0
RUNSCHD_HD Run schedule header number SA_AUFNR CHAR 12 0
DISTR_KEY_FOR_PROD_QUANTITIES Distribution key for quantity produced SA_VERTO CHAR 4 0
QUOTA_ARR Number of Quota Arrangement QUNUM CHAR 10 0
QUOTARRITM Quota Arrangement Item QUPOS NUMC 3 0
VENDOR_NO Account Number of Vendor or Creditor LIFNR CHAR 10 0
PURCH_ORG Purchasing Organization EKORG CHAR 4 0
PO_NUMBER Purchasing Document Number EBELN CHAR 10 0
PO_ITEM Item Number of Purchasing Document EBELP NUMC 5 0
DOC_CAT Purchasing Document Category BSTYP CHAR 1 0
A Request for quotation
B Purchase requisition
F Purchase order
I Info record
K Contract
L Scheduling agreement
Q Service entry sheet
W Source list
SOURCE_LIST_USAGE Source List Usage in Materials Planning AUTET CHAR 1 0
NULL Source list record not relevant to MRP
1 Record relevant to MRP
2 Record relevant to MRP. Sched. lines generated automatically
PO_DATE Purchase Order Date BEDAT DATS 8 0
QUANTITY Scheduled Quantity ETMEN QUAN 13 3
DL_QTY_TRSP Quantity Delivered (Stock Transfer) GLMNG QUAN 13 3
PRODUCTION_NOTE Production note in the planned order FRTHW CHAR 1 0
1 Initiate procurements of non-stock components !
2 Purch.req.with unknown acct assig. for non-stock component !
ACT_SCHEDULING Indicator "Detailed scheduling available" AKTFT CHAR 1 0
X Yes
NULL No
SCHEDULING_INDEX ID of the capacity requirements record BEDID NUMC 12 0
SCHEDULING_ERROR Scheduling error TRMER CHAR 2 0
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 Det./rate-based sched. and sequencing active at same time
ACT_SCHED_PR Indicator: "scheduling rates of production" available AKTRT CHAR 1 0
X Yes
NULL No
SCHED_INDEX_PR Index for the results of scheduling production rates RATID NUMC 12 0
SCHED_ERROR_PR Scheduling error in scheduling production rates RATER CHAR 2 0
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 Det./rate-based sched. and sequencing active at same time
ACT_SCHED_RS Indicator: "rough-cut scheduling available" AKTGT CHAR 1 0
X Yes
NULL No
SCHED_INDEX_RS Index for rough scheduling results GROID NUMC 12 0
SCHED_ERROR_RS Scheduling error in rough scheduling GROER CHAR 2 0
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 Det./rate-based sched. and sequencing active at same time
MRP_ORD_QTY MRP element: order quantity AUFTM QUAN 13 3
SETRESERNO Settlement reservation number ARSNR NUMC 10 0
SETTLITMNO Item number of the settlement reservation ARSPS NUMC 4 0
PLND_ORD_LEADS_COLL_ORD_IND Ind.: Leading order in collective order is planned ordre PRNKZ CHAR 1 0
X
NULL
DISP_CAP_IND Indicator: capacity for planned order dispatched KAPFX CHAR 1 0
X Yes
NULL No
ORDER_START_TIME Start Time of Planned Order PSTTI TIMS 6 0
ORDER_FIN_TIME End Time of Planned Order PEDTI TIMS 6 0
RES_TYPE Record type RSART CHAR 1 0
MISS_PART Missing Part XFEHL CHAR 1 0
X Yes
NULL No
ASS_ORD_IND Indicator: for assembly order procedures MONKZ CHAR 1 0
X Yes
NULL No
PRD_ORD_STATUS Production order status: internal ind. for MRP MDFST CHAR 1 0
PLN_WO_FIN_ASSY Indicator: planning without final assembly VRPLA CHAR 1 0
X Yes
NULL No
REQUIREMENTS_PLAN_NO Requirements Plan Number PBDNR CHAR 10 0
CUSTOMER Customer Number KUNNR CHAR 10 0
VALUATION_SPEC_STOCK Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
MRP_STK_IN_TRS MRP: quantity field (stock in transit, receipt qty, ...) MDMNG QUAN 13 3
WITHDR_QTY Issued Quantity WAMNG QUAN 13 3
OBJ_DEPEND_TREE Internal number for edge of object dependencies tree EDGNO NUMC 17 0
OVERALL_QTY Overall quantity MRP element (for static pegging) TPQTY QUAN 13 3
MPN Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 0
NUMERATOR Numerator for Conversion to Base Units of Measure UMREZ DEC 5 0
DENOMINATR Denominator for conversion to base units of measure UMREN DEC 5 0
ENTRY_UOM Unit of Entry ERFME UNIT 3 0
ENTRY_UOM_ISO ISO code for unit of measurement ISOCD_UNIT CHAR 3 0
ENTRY_QNT Quantity in Unit of Entry ERFMG QUAN 13 3
SCHED_PROD_DATES Planned order: scheduling using production dates MD_PRSCHED CHAR 1 0
X Yes
NULL No
LEAD_SCHED_LEVEL Planned order: leading scheduling level (determines dates) MD_LVSCHED CHAR 1 0
1 Detailed planning
2 Rate-based planning
3 Rough-cut planning
DIR_PROC Direct procurement indicator DBSKZ CHAR 1 0
NULL No direct procurement or direct production
E Direct production
F Direct procurement
BOM_TYPE BOM category STLTY CHAR 1 0
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
S Standard BOM
T Functional Location BOM
P Work Breakdown Structure BOM
BOM_NO Bill of material STNUM CHAR 8 0
ITEM_NODE BOM item node number STLKN NUMC 8 0
COUNTER Internal counter CIM_COUNT NUMC 8 0
PUR_GROUP Purchasing Group EKGRP CHAR 3 0
MATL_GROUP Material Group MATKL CHAR 9 0
PLND_DELRY Planned Delivery Time in Days PLIFZ DEC 3 0
TIME_STAMP Last Change to Planned Order: Time Stamp PSTMP DEC 15 0
IND_EXT_PROC Indicator for External Procurement EXTNL CHAR 1 0
X Yes
NULL No
ADDNL_INFO Field for Additional Information MD_ADINF CHAR 4 0
EXPL_STATUS Status information on BOM explosion in planned order MD_STAEX CHAR 2 0
01 Alternative explosion (IPPE) active
02 Bulk material items not exploded
ISS_STOR_LOC Issuing Storage Location for Stock Transport Order RESLO CHAR 4 0
FOLLOW_UP_EXTERNAL Long Material Number for field FOLLOW_UP MGV_FOLLOW_UP_EXTERNAL CHAR 40 0
FOLLOW_UP_GUID External GUID for FOLLOW_UP Field MGV_FOLLOW_UP_GUID CHAR 32 0
FOLLOW_UP_VERSION Version Number for FOLLOW_UP Field MGV_FOLLOW_UP_VERSION CHAR 10 0
MPN_EXTERNAL Long Material Number (Future Development) for MPN Field MGV_MPN_EXTERNAL CHAR 40 0
MPN_GUID External GUID (Future Development) for MPN Field MGV_MPN_GUID CHAR 32 0
MPN_VERSION Version Number (Future Development) for MPN Field MGV_MPN_VERSION CHAR 10 0
PEGGEDRQMT_EXTERNAL Long Material Number (Future Development) for PEGGE Field MGV_PEGGEDRQMT_EXTERNAL CHAR 40 0
PEGGEDRQMT_GUID External GUID (Future Development) for PEGGEDRQMT Field MGV_PEGGEDRQMT_GUID CHAR 32 0
PEGGEDRQMT_VERSION Version Number (Future Development) for PEGGEDRQMT Field MGV_PEGGEDRQMT_VERSION CHAR 10 0