1. Home
  2. Resources
  3. SAP Tables
  4. VSEBAN_CN - Version: Purchase requisition

SAP Table VSEBAN_CN

Version: Purchase requisition

VSEBAN_CN (Version: Purchase requisition) 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 VSEBAN_CN to other SAP tables.

VSEBAN_CN table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
VSNMR Number or description of a version VSNMR CHAR 12 0
BANFN Purchase Requisition Number BANFN CHAR 10 0
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 Date on Which Record Was Created ERDAT 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 EMATNR 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
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 Indicator: consumption value is fixed FIXKZ 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
LBLNI Entry Sheet Number LBLNI CHAR 10 0
ADRNR Number of delivery address ADRN2 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
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 T002 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 MDLV CHAR 10 0
UZEIT Delivery Date Time-Spot LZEIT TIMS 6 0
FKBER Functional Area FKBER CHAR 16 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 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
REVNO Version number in Purchasing REVNO CHAR 8 0
BLCKT Reason for Item Block BLCKT CHAR 60 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
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0

VSEBAN_CN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VSEBAN_CN BERID VSEBAN_CN MANDT MDLV Customizing MRP Area MANDT
VSEBAN_CN BERID VSEBAN_CN BERID MDLV Customizing MRP Area BERID
VSEBAN_CN SPRAS VSEBAN_CN SPRAS T002 Language Keys (Component BC-I18) SPRAS