1. Home
  2. Resources
  3. SAP Tables
  4. MEREQ_ITEM - OO Purchase Requisition: Item Status

SAP Table MEREQ_ITEM

OO Purchase Requisition: Item Status

MEREQ_ITEM (OO Purchase Requisition: Item Status) 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 MEREQ_ITEM to other SAP tables.

MEREQ_ITEM table fields

Field Data element Checktable Datatype Length Decimals
BNFPO Item Number of Purchase Requisition BNFPO NUMC 5 0
BSART Purchase Requisition Document Type BBSRT CHAR 4 0
BSTYP 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
BSAKZ Control indicator for purchasing document type BSAKZ CHAR 1 0
T Transport
R Purchase requisition for outline agreement
LOEKZ Deletion Indicator in Purchasing Document ELOEK CHAR 1 0
STATU Processing status of purchase requisition BANST CHAR 1 0
N Not edited
B PO created
A RFQ created
K Contract created
L Scheduling agreement created
S Service entry sheet created
E RFQ sent to external system for sourcing
ESTKZ Creation Indicator (Purchase Requisition/Schedule Lines) ESTKZ CHAR 1 0
B Material requirements planning
D Direct procurement
F Production order
G Store order
R Realtime (manual)
U Converted planned order
V Sales and distribution document
M Compression (monthly basis)
Y Compression (annual basis)
A SAP APO
FRGKZ Release Indicator FRGKZ CHAR 1 0
FRGZU Release status FRGZU CHAR 8 0
FRGST Release Strategy in Purchase Requisition FRGST CHAR 2 0
EKGRP Purchasing Group EKGRP CHAR 3 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Changed On AEDAT DATS 8 0
AFNAM Name of Requisitioner/Requester AFNAM CHAR 12 0
TXZ01 Short Text TXZ01 CHAR 40 0
MATNR Material Number MATNR CHAR 18 0
EMATN Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 0
WERKS Plant EWERK CHAR 4 0
LGORT Storage Location LGORT_D CHAR 4 0
BEDNR Requirement Tracking Number BEDNR CHAR 10 0
MATKL Material Group MATKL CHAR 9 0
RESWK Supplying (Issuing) Plant in Stock Transport Order RESWK CHAR 4 0
MENGE Purchase Requisition Quantity BAMNG QUAN 13 3
MEINS Purchase Requisition Unit of Measure BAMEI UNIT 3 0
BUMNG Shortage (stock undercoverage) quantity BUMNG QUAN 13 3
BADAT Requisition (Request) Date BADAT DATS 8 0
LPEIN Category of Delivery Date LPEIN CHAR 1 0
LFDAT Item Delivery Date EINDT DATS 8 0
FRGDT Purchase Requisition Release Date FRGDT DATS 8 0
WEBAZ Goods Receipt Processing Time in Days WEBAZ DEC 3 0
PREIS Price in Purchase Requisition BAPRE CURR 11 2
PEINH Price Unit EPEIN DEC 5 0
PSTYP Item Category in Purchasing Document PSTYP CHAR 1 0
KNTTP Account Assignment Category KNTTP CHAR 1 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
KFLAG Acct.asst.changeable KFLAG CHAR 1 0
X Yes
NULL No
VRTKZ Distribution indicator for multiple account assignment VRTKZ CHAR 1 0
NULL Single account assignment
1 Distrib. on quantity basis
2 Distribution by percentage
TWRKZ Partial Invoice Indicator TWRKZ CHAR 1 0
NULL No multiple account assignment
1 Apportion IR quantities to GR quantities one after another
2 Apportion IR quantities to GR quantities proportionately
WEPOS Goods Receipt Indicator WEPOS CHAR 1 0
X Yes
NULL No
WEUNB Goods Receipt, Non-Valuated WEUNB CHAR 1 0
X Yes
NULL No
REPOS Invoice Receipt Indicator REPOS CHAR 1 0
X Yes
NULL No
LIFNR Desired Vendor WLIEF CHAR 10 0
FLIEF Fixed Vendor FLIEF CHAR 10 0
EKORG Purchasing Organization EKORG CHAR 4 0
VRTYP 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
KONNR Number of Principal Purchase Agreement KONNR CHAR 10 0
KTPNR Item Number of Principal Purchase Agreement KTPNR NUMC 5 0
INFNR Number of Purchasing Info Record INFNR CHAR 10 0
ZUGBA Assigned Source of Supply DZUGBA CHAR 1 0
X Yes
NULL No
QUNUM Number of Quota Arrangement QUNUM CHAR 10 0
QUPOS Quota Arrangement Item QUPOS NUMC 3 0
DISPO MRP Controller (Materials Planner) DISPO CHAR 3 0
SERNR BOM explosion number SERNR CHAR 8 0
BVDAT Date of last resubmission BVDAT DATS 8 0
BATOL Resubmission Interval of Purchase Requisition BATOL DEC 3 0
BVDRK Number of resubmissions BVDRK DEC 7 0
EBELN Purchase Order Number BSTNR CHAR 10 0
EBELP Purchase Order Item Number BSTPO NUMC 5 0
BEDAT Purchase Order Date BEDAT DATS 8 0
BSMNG Quantity Ordered Against this Purchase Requisition BSMNG QUAN 13 3
LBLNI Entry Sheet Number LBLNI CHAR 10 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
XOBLR Item affects commitments XOBLR CHAR 1 0
X Yes
NULL No
EBAKZ Purchase Requisition Closed EBAKZ CHAR 1 0
X Yes
NULL No
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
ARSNR Settlement reservation number ARSNR NUMC 10 0
ARSPS Item number of the settlement reservation ARSPS NUMC 4 0
FIXKZ Purchase Requisition is Fixed BAFIX CHAR 1 0
X Yes
NULL No
BMEIN Purchase Order Unit of Measure BSTME UNIT 3 0
REVLV Revision Level REVLV CHAR 2 0
VORAB Advance procurement: project stock VORAB CHAR 1 0
X Yes
NULL No
PACKNO Package number PACKNO NUMC 10 0
KANBA Kanban Indicator KBNKZ CHAR 1 0
X Replenishment Element for Kanban
Y Scheduling Agreement for Summarized JIT Call
BPUEB Adopt Requisition Price in Purchase Order BPUEB CHAR 1 0
NULL Do not adopt
1 As gross price
2 As net price
CUOBJ Configuration (internal object number) CUOBJ NUMC 18 0
FRGGR Release group FRGGR CHAR 2 0
FRGRL Release Not Yet Completely Effected FRGRL CHAR 1 0
X Yes
NULL No
AKTNR Promotion WAKTION CHAR 10 0
CHARG Batch Number CHARG_D CHAR 10 0
UMSOK Special Stock Indicator for Physical Stock Transfer UMSOK CHAR 1 0
VERID Production Version VERID CHAR 4 0
FIPOS Commitment Item FIPOS CHAR 14 0
FISTL Funds Center FISTL CHAR 16 0
GEBER Fund BP_GEBER CHAR 10 0
KZKFG Origin of Configuration KZCUH CHAR 1 0
NULL External configuration
1 Configurable, but not yet configured
2 Own configuration
SATNR Cross-Plant Configurable Material SATNR CHAR 18 0
MNG02 Committed Quantity MNG06 QUAN 13 3
DAT01 Committed Date DAT05 DATS 8 0
ATTYP Material Category ATTYP CHAR 2 0
NULL Single material (industry)
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
ADRNR Manual address number in purchasing document item ADRNR_MM CHAR 10 0
ADRN2 Number of delivery address ADRN2 CHAR 10 0
KUNNR Customer EKUNNR CHAR 10 0
EMLIF Vendor to be supplied/who is to receive delivery EMLIF CHAR 10 0
LBLKZ Subcontracting vendor LBLKZ CHAR 1 0
X Yes
NULL No
KZBWS 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
GSWRT Total Value of Item GSWRT CURR 13 2
WAERS Currency Key WAERS CUKY 5 0
IDNLF Material Number Used by Vendor IDNLF CHAR 35 0
GSFRG Overall release of purchase requisitions GSFRG CHAR 1 0
X Yes
NULL No
MPROF Manufacturer Part Profile MPROF CHAR 4 0
KZFME Units of measure usage KZWSO CHAR 1 0
NULL Alternative unit of measure
A Proportion unit
B Product unit
SPRAS Language Key SPRAS LANG 1 0
TECHS Parameter Variant/Standard Variant TECHS CHAR 12 0
MFRPN Manufacturer Part Number MFRPN CHAR 40 0
MFRNR Number of a Manufacturer MFRNR CHAR 10 0
EMNFR External manufacturer code name or number EMNFR CHAR 10 0
FORDN Framework Order SFORDN CHAR 10 0
FORDP Item of framework order FORDP NUMC 5 0
PLIFZ Planned Delivery Time in Days PLIFZ DEC 3 0
BERID MRP Area BERID CHAR 10 0
UZEIT Delivery Date Time-Spot LZEIT TIMS 6 0
REF_BANFN Number of Reference Purchase Requisition REFBN CHAR 10 0
REF_BNFPO Item of Reference Purchase Requisition RFBPS NUMC 5 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
FKBER Functional Area FKBER CHAR 16 0
MEMORY Purchase Requisition not yet Complete MEMBF CHAR 1 0
X Yes
NULL No
BANPR Requisition Processing State BANPR CHAR 2 0
01 Version in Process
02 Active
03 In Release
04 For Overall Release
05 Release Completed
08 Release Refused
RLWRT Total value at time of release RLWRT CURR 15 2
BLCKD Purchase Requisition Blocked BLCKD CHAR 1 0
1 Blocked by Requester
NULL Not Blocked
BLCKT Reason for Item Block BLCKT CHAR 60 0
REVNO Version number in Purchasing REVNO CHAR 8 0
BESWK Procuring Plant BESWK CHAR 4 0
EPROFILE External Procurement Profile MEPROFILE CHAR 2 0
EPREFDOC External Procurement Reference Document EPREFDOC CHAR 10 0
EPREFITM External Procurement Reference Item EPREFITM NUMC 5 0
GMMNG PO Quantity of Purchase Requisition in POs on Hold GMMNG QUAN 13 3
WRTKZ Value-Based Commitment Reduction for Service Purchase Reqs WRTKZ CHAR 1 0
X Yes
NULL No
RESLO Issuing Storage Location for Stock Transport Order RESLO CHAR 4 0
KBLNR Document Number for Earmarked Funds KBLNR CHAR 10 0
KBLPOS Earmarked Funds: Document Item KBLPOS NUMC 3 0
PRIO_URG Requirement Urgency PRIO_URG PURG NUMC 2 0
PRIO_REQ Requirement Priority PRIO_REQ PREQ NUMC 3 0
ANZSN Number of serial numbers ANZSN INT4 10 0
SERNP Serial Number Profile SERAIL CHAR 4 0
MHDRZ Minimum Remaining Shelf Life MHDRZ DEC 4 0
IPRKZ Period Indicator for Shelf Life Expiration Date DATTP CHAR 1 0
MEMORYTYPE Category of Incompleteness MEMORYTYPE CHAR 1 0
NULL Document Saved as Complete
P Document Parked
H Document on Hold
EXT_PROC_STATUS Processing State MEREQ_PROC_STATUS CHAR 1 0
0 Do Not Send to External System
1 Sent to External System, in Process
2 Transferred By External System
3 Rejected By External System
EXT_PROC_DATE Timestamp MMPUR_UTC CHAR 14 0
PROC_STATUS Processing State MEREQ_PROC_TYPE CHAR 1 0
E External Source-of-Supply Assignment
R Bid Invitation
PROC_DATE Timestamp MMPUR_UTC CHAR 14 0
EXT_DOC_NUMBER Document Number of External Document ME_PUR_EXT_DOC_ID CHAR 35 0
EXT_DOC_ITEM Item Number of External Document ME_PUR_EXT_DOC_ITEM_ID CHAR 10 0
EXT_DOC_TYPE External Document Type ME_PUR_EXT_DOC_TYPE CHAR 4 0
NODISP Ind: Reserv. not applicable to MRP;Purc. req. not created NODISP CHAR 1 0
X Yes
NULL No
SRM_CONTRACT_ID Central Contract SRM_CONTRACT_ID CHAR 10 0
SRM_CONTRACT_ITM Central Contract Item Number SRM_CONTRACT_ITEM NUMC 10 0
SC_OBJECT_ID Object ID - Document Number /SRMERP/OBJECT_ID CHAR 10 0
SC_ITM_NO Internal Shopping Cart Item Number /SRMERP/SC_ITM_NO INT4 10 0
MEREQITEMDUMMY Checkbox XFELD CHAR 1 0
X Yes
NULL No
DUMMY1 Type of consolidation of investments method XFELD1 CHAR 1 0
X Yes
NULL No
J_1BMATUSE Usage of the material J_1BMATUSE CHAR 1 0
0 Resale
1 Industrialisation
2 Consumption
3 Asset
J_1BOWNPRO Produced in-house J_1BOWNPRO CHAR 1 0
X Yes
NULL No
J_1BMATORG Origin of the material J_1BMATORG CHAR 1 0
1 Foreign - imported directly
2 Foreign - acquired nationally
0 National - except indicated for codes 3, 4, 5 or 8
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
J_1BINDUST Material CFOP category J_1BINDUS3 CHAR 2 0
00 material
01 electricity
02 communication
03 transportation
04 animal
J_1BNBM Brazilian NCM Code J_1BNBMCO1 CHAR 16 0
J_1AINDXP Inflation Index J_1AINDXP CHAR 5 0
J_1AIDATEP Inflation Index Date J_1AIDATEP DATS 8 0
LAND1 Country Key LAND1 CHAR 3 0
PEROP_BEG Period of Performance Start FM_PEROP_LOW DATS 8 0
PEROP_END Period of Performance End FM_PEROP_HIGH DATS 8 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
ADVCODE Advice Code /ISDFPS/ADVCODE /ISDFPS/ADVCODE2 CHAR 2 0
STACODE Status Code /ISDFPS/STACODE /ISDFPS/CSTACODE CHAR 2 0
BANFN_CS Cross-System PReq Number /ISDFPS/BANFN_CS CHAR 10 0
BNFPO_CS Cross-System PReq Item /ISDFPS/BNFPO_CS NUMC 5 0
ITEM_CS Cross-System Item Category /ISDFPS/ITEM_CS CHAR 1 0
NULL System-Internal PReq Item
S Sender PReq Item
R Recipient PReq Item
X PReq Active in Other Systems
BSMNG_SND PO Quantity Sender /ISDFPS/BSMNG_SND QUAN 13 3
NO_MARD_DATA No Storage Location Data Exists for Material /ISDFPS/NO_MARD_DATA CHAR 1 0
X Yes
NULL No
ADMOI Model ID code ADMOI CHAR 4 0
ADPRI Order priority ADPRI CHAR 3 0
ADACN Aircraft registration number ADACN CHAR 5 0
PNSTAT Flag for the S1PNSTAT message ADSPC_PNSTAT CHAR 1 0
SERRU Type of subcontracting SERRU CHAR 1 0
NULL Subcontracting
1 Refurbishment with unchanged material number
2 Refurbishment with changed material number
3 Replacement
DISUB_SOBKZ Special stock indicator Subcontracting - for help DISUB_SOBKZ_LB2 CHAR 1 0
NULL Normal stock
E Orders on hand
M Ret.trans.pkg vendor
K Consignment (vendor)
Q Project stock
DISUB_PSPNR WBS Element DISUB_PS_POSNR2 PRPS NUMC 8 0
DISUB_KUNNR Customer Number DISUB_KUNNR2 KNA1 CHAR 10 0
DISUB_VBELN Sales Document DISUB_VBELN_VA2 VBUK CHAR 10 0
DISUB_POSNR Item number of the SD document DISUB_POSNR2 VBUP NUMC 6 0
DISUB_OWNER Owner of stock DISUB_OWNER_D LFA1 CHAR 10 0
IUID_RELEVANT IUID-Relevant IUID_RELEVANT CHAR 1 0
X Relevant
NULL Not Relevant
OITAXFROM Excise duty tax key for 'from' location OIH_TAXFRO CHAR 2 0
OIHANTYP Excise Duty Handling Type OIH_HANTYP CHAR 2 0
OITAXTO Excise duty tax key for 'to' location OIH_TAXTO CHAR 2 0
OITAXGRP Excise Duty Group OIH_TAXGRP CHAR 2 0
OIOILCON Oil content in a material as a percentage OIH_OILCON DEC 5 2
0 Range of permissible values for Mineral Oil Content %
OIINEX Code for internal or external excise duty rate determination OIH_INEX CHAR 2 0
OIPRICIE ED pricing: external (indicator) OIH_PRICIE CHAR 1 0
X Yes
NULL No
OIO_SPROC Supply Process OIO_SPROC CHAR 4 0
OIO_STATUS Supply chain status OIO_SC_STATUS CHAR 1 0
NULL Unprocessed
1 Processed by supply chain
2 Created by supply chain
OIO_REF_BANFN Reference requisition number OIO_REF_BANFN CHAR 10 0
OIO_REF_BNFPO Reference requisition item OIO_REF_BNFPO NUMC 5 0
OIO_HOLD Indicator: Hold Delivery Onshore OIO_HOLD CHAR 1 0
X Yes
NULL No

MEREQ_ITEM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MEREQ_ITEM ADVCODE MEREQ_ITEM ADVCODE /ISDFPS/ADVCODE2 Advice Code with Document Type ADVCODE
MEREQ_ITEM ADVCODE SYST MANDT /ISDFPS/ADVCODE2 Advice Code with Document Type MANDT
MEREQ_ITEM ADVCODE MEREQ_ITEM BSART /ISDFPS/ADVCODE2 Advice Code with Document Type BSART
MEREQ_ITEM DISUB_KUNNR SYST MANDT KNA1 General Data in Customer Master MANDT
MEREQ_ITEM DISUB_KUNNR MEREQ_ITEM DISUB_KUNNR KNA1 General Data in Customer Master KUNNR
MEREQ_ITEM DISUB_OWNER SYST MANDT LFA1 Vendor Master (General Section) MANDT
MEREQ_ITEM DISUB_OWNER MEREQ_ITEM DISUB_OWNER LFA1 Vendor Master (General Section) LIFNR
MEREQ_ITEM DISUB_POSNR MEREQ_ITEM DISUB_VBELN VBUP Sales Document: Item Status VBELN
MEREQ_ITEM DISUB_POSNR MEREQ_ITEM DISUB_POSNR VBUP Sales Document: Item Status POSNR
MEREQ_ITEM DISUB_POSNR SYST MANDT VBUP Sales Document: Item Status MANDT
MEREQ_ITEM DISUB_PSPNR MEREQ_ITEM DISUB_PSPNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
MEREQ_ITEM DISUB_PSPNR SYST MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
MEREQ_ITEM DISUB_VBELN SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
MEREQ_ITEM DISUB_VBELN MEREQ_ITEM DISUB_VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
MEREQ_ITEM PRIO_REQ SYST MANDT PREQ Requirement Priorities MANDT
MEREQ_ITEM PRIO_REQ MEREQ_ITEM PRIO_REQ PREQ Requirement Priorities PRIO_REQ
MEREQ_ITEM PRIO_URG SYST MANDT PURG Requirement Urgencies MANDT
MEREQ_ITEM PRIO_URG MEREQ_ITEM PRIO_URG PURG Requirement Urgencies PRIO_URG
MEREQ_ITEM STACODE SYST MANDT /ISDFPS/CSTACODE Status Code MANDT
MEREQ_ITEM STACODE MEREQ_ITEM STACODE /ISDFPS/CSTACODE Status Code STACODE