1. Home
  2. Resources
  3. SAP Tables
  4. MDBA - View: purchase requisition for conversion

SAP Table MDBA

View: purchase requisition for conversion

MDBA (View: purchase requisition for conversion) 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 MDBA to other SAP tables.

MDBA table fields

Field Data element Checktable Datatype Length Decimals
BANNR Purchase Requisition Number BANFN CHAR 10 0
BANPS Item Number of Purchase Requisition BNFPO NUMC 5 0
BSART Order Type (Purchasing) BSART T161 CHAR 4 0
PSTYP Item Category in Purchasing Document PSTYP CHAR 1 0
MATNR Material Number MATNR CHAR 18 0
WERKS Plant WERKS_D CHAR 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
MENGE Quantity to be converted UMMNG QUAN 13 3
MEINS Base Unit of Measure MEINS UNIT 3 0
LFDAT Delivery date LFDAT DATS 8 0
FRGDT Purchase Requisition Release Date FRGDT DATS 8 0
WEBAZ Goods Receipt Processing Time in Days WEBAZ DEC 3 0
RESWK Supplying (Issuing) Plant in Stock Transport Order RESWK CHAR 4 0
EKGRP Purchasing Group EKGRP T024 CHAR 3 0
DISPO MRP Controller (Materials Planner) DISPO T024D CHAR 3 0
LIFNR Desired Vendor WLIEF CHAR 10 0
FLIEF Fixed Vendor FLIEF CHAR 10 0
INFNR Number of Purchasing Info Record INFNR CHAR 10 0
KONNR Number of Principal Purchase Agreement KONNR CHAR 10 0
KONPS Item Number of Principal Purchase Agreement KTPNR NUMC 5 0
WEPOS Goods Receipt Indicator WEPOS CHAR 1 0
X Yes
NULL No
REPOS Invoice Receipt Indicator REPOS CHAR 1 0
X Yes
NULL No
WEUNB Goods Receipt, Non-Valuated WEUNB CHAR 1 0
X Yes
NULL No
KNTTP Account Assignment Category KNTTP T163K CHAR 1 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
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
KDAUF Sales Order Number KDAUF CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
PSPEL WBS Element PS_POSNR NUMC 8 0
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
EKORG Purchasing Organization EKORG CHAR 4 0
QUNUM Number of Quota Arrangement QUNUM CHAR 10 0
QUPOS Quota Arrangement Item QUPOS NUMC 3 0
SERNR BOM explosion number SERNR SNUM CHAR 8 0
FIXKZ Purchase Requisition is Fixed BAFIX CHAR 1 0
X Yes
NULL No
BESKZ Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
REVLV Revision Level REVLV CHAR 2 0
VERID Production Version VERID 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
CUOBJ Configuration (internal object number) CUOBJ NUMC 18 0
TECHS Parameter Variant/Standard Variant TECHS CHAR 12 0
LBLKZ Subcontracting vendor LBLKZ CHAR 1 0
X Yes
NULL No
EMLIF Vendor to be supplied/who is to receive delivery EMLIF CHAR 10 0
EMATN Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 0
ARSNR Settlement reservation number ARSNR NUMC 10 0
ARSPS Item number of the settlement reservation ARSPS NUMC 4 0
BERID MRP Area BERID CHAR 10 0
UMSOK Special Stock Indicator for Physical Stock Transfer UMSOK CHAR 1 0
PLIFZ Planned Delivery Time in Days PLIFZ DEC 3 0
RESLO Issuing Storage Location for Stock Transport Order RESLO CHAR 4 0
PRIO_URG Requirement Urgency PRIO_URG PURG NUMC 2 0
PRIO_REQ Requirement Priority PRIO_REQ PREQ NUMC 3 0
SRM_CONTRACT_ID Central Contract SRM_CONTRACT_ID CHAR 10 0
SRM_CONTRACT_ITM Central Contract Item Number SRM_CONTRACT_ITEM NUMC 10 0
BESWK Procuring Plant BESWK T001W CHAR 4 0
ANZSN Number of serial numbers ANZSN INT4 10 0

MDBA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MDBA BESWK MDBA BESWK T001W Plants/Branches WERKS
MDBA BESWK SYST MANDT T001W Plants/Branches MANDT
MDBA BSART SYST MANDT T161 Purchasing Document Types MANDT
MDBA BSART 'B' T161 Purchasing Document Types BSTYP
MDBA BSART MDBA BSART T161 Purchasing Document Types BSART
MDBA DISPO MDBA DISPO T024D MRP controllers DISPO
MDBA DISPO SY MANDT T024D MRP controllers MANDT
MDBA DISPO MDBA WERKS T024D MRP controllers WERKS
MDBA EKGRP SY MANDT T024 Purchasing Groups MANDT
MDBA EKGRP MDBA EKGRP T024 Purchasing Groups EKGRP
MDBA KNTTP MDBA KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
MDBA KNTTP SY MANDT T163K Account Assignment Categories in Purchasing Document MANDT
MDBA LGORT SYST MANDT T001L Storage Locations MANDT
MDBA LGORT MDBA WERKS T001L Storage Locations WERKS
MDBA LGORT MDBA LGORT T001L Storage Locations LGORT
MDBA PRIO_REQ SYST MANDT PREQ Requirement Priorities MANDT
MDBA PRIO_REQ MDBA PRIO_REQ PREQ Requirement Priorities PRIO_REQ
MDBA PRIO_URG SYST MANDT PURG Requirement Urgencies MANDT
MDBA PRIO_URG MDBA PRIO_URG PURG Requirement Urgencies PRIO_URG
MDBA SERNR SYST MANDT SNUM BOM explosion number MANDT
MDBA SERNR MDBA SERNR SNUM BOM explosion number SERNR