SAP VSEBAN_CN Version: Purchase requisition Table

Overview

VSEBAN_CN is a standard SAP S/4HANA table that stores Version: Purchase requisition data. There are total 130 fields in the VSEBAN_CN table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VSEBAN_CN belongs to Simulation (PS-SIM) module and is located in the package R/3 Application development: Version Management (CNVS).

In addition, following links provide an overview of foreign key relationships, if any, that link VSEBAN_CN to other SAP tables and standard CDS views available based on VSEBAN_CN table in S/4HANA 2020.

Techincal Settings of VSEBAN_CN

Below are technical details of the table VSEBAN_CN

Buffering not allowed
No buffering
Storage type is Column Store

List of VSEBAN_CN Fields

The following table gives you an overview of the fields available in VSEBAN_CN

Field	Description	Data Element	Check Table	Data Type	Length
MANDT	Client	MANDT		CLNT	3
VSNMR	Number or description of a version	VSNMR		CHAR	12
BANFN	Purchase Requisition Number	BANFN		CHAR	10
BNFPO	Item number of purchase requisition	BNFPO		NUMC	5
BSART	Purchase Requisition Document Type	BBSRT		CHAR	4
BSTYP	Purchasing Document Category	BSTYP		CHAR	1
BSAKZ	Control indicator for purchasing document type	BSAKZ		CHAR	1
LOEKZ	Deletion indicator in purchasing document	ELOEK		CHAR	1
STATU	Processing status of purchase requisition	BANST		CHAR	1
ESTKZ	Creation indicator (purchase requisition/schedule lines)	ESTKZ		CHAR	1
FRGKZ	Release Indicator	FRGKZ		CHAR	1
FRGZU	Release State	FRGZU		CHAR	8
FRGST	Release strategy in the purchase requisition	FRGST		CHAR	2
EKGRP	Purchasing Group	EKGRP		CHAR	3
ERNAM	Name of Person who Created the Object	ERNAM		CHAR	12
ERDAT	Date on which the record was created	ERDAT		DATS	8
AFNAM	Name of requisitioner/requester	AFNAM		CHAR	12
TXZ01	Short Text	TXZ01		CHAR	40
MATNR	Material Number	MATNR		CHAR	40
EMATN	Material number	EMATNR		CHAR	40
WERKS	Plant	EWERK		CHAR	4
LGORT	Storage location	LGORT_D		CHAR	4
BEDNR	Requirement Tracking Number	BEDNR		CHAR	10
MATKL	Material Group	MATKL		CHAR	9
RESWK	Supplying (issuing) plant in case of stock transport order	RESWK		CHAR	4
MENGE	Purchase requisition quantity	BAMNG		QUAN	13
MEINS	Purchase requisition unit of measure	BAMEI		UNIT	3
BUMNG	Shortage (stock undercoverage) quantity	BUMNG		QUAN	13
BADAT	Requisition (request) date	BADAT		DATS	8
LPEIN	Category of delivery date	LPEIN		CHAR	1
LFDAT	Item delivery date	EINDT		DATS	8
FRGDT	Purchase Requisition Release Date	FRGDT		DATS	8
WEBAZ	Goods receipt processing time in days	WEBAZ		DEC	3
PREIS	Price in Purchase Requisition	BAPRE		CURR	11
PEINH	Price unit	EPEIN		DEC	5
PSTYP	Item category in purchasing document	PSTYP		CHAR	1
KNTTP	Account Assignment Category	KNTTP		CHAR	1
KZVBR	Consumption posting	KZVBR		CHAR	1
KFLAG	Acct.asst.modifiable	KFLAG		CHAR	1
VRTKZ	Distribution Indicator for Multiple Account Assignment	VRTKZ		CHAR	1
TWRKZ	Partial invoice indicator	TWRKZ		CHAR	1
WEPOS	Goods Receipt Indicator	WEPOS		CHAR	1
WEUNB	Goods Receipt Non-Valuated	WEUNB		CHAR	1
REPOS	Invoice receipt indicator	REPOS		CHAR	1
LIFNR	Desired Vendor	WLIEF		CHAR	10
FLIEF	Fixed vendor	FLIEF		CHAR	10
EKORG	Purchasing organization	EKORG		CHAR	4
VRTYP	Purchasing Document Category	BSTYP		CHAR	1
KONNR	Number of principal purchase agreement	KONNR		CHAR	10
KTPNR	Item number of principal purchase agreement	KTPNR		NUMC	5
INFNR	Number of purchasing info record	INFNR		CHAR	10
ZUGBA	Assigned Source of Supply	DZUGBA		CHAR	1
QUNUM	Number of quota arrangement	QUNUM		CHAR	10
QUPOS	Quota arrangement item	QUPOS		NUMC	3
DISPO	MRP Controller	DISPO		CHAR	3
SERNR	BOM explosion number	SERNR		CHAR	8
BVDAT	Date of last resubmission	BVDAT		DATS	8
BATOL	Resubmission interval of purchase requisition	BATOL		DEC	3
BVDRK	Number of resubmissions	BVDRK		DEC	7
EBELN	Purchase order number	BSTNR		CHAR	10
EBELP	Purchase order item number	BSTPO		NUMC	5
BEDAT	Purchase Order Date	BEDAT		DATS	8
BSMNG	Quantity ordered against this purchase requisition	BSMNG		QUAN	13
BWTAR	Valuation Type	BWTAR_D		CHAR	10
XOBLR	Item affects commitments	XOBLR		CHAR	1
EBAKZ	Purchase requisition closed	EBAKZ		CHAR	1
RSNUM	Number of reservation/dependent requirements	RSNUM		NUMC	10
SOBKZ	Special Stock Indicator	SOBKZ		CHAR	1
ARSNR	Settlement reservation number	ARSNR		NUMC	10
ARSPS	Item number of the settlement reservation	ARSPS		NUMC	4
FIXKZ	Indicator: consumption value is fixed	FIXKZ		CHAR	1
BMEIN	Purchase Order Unit of Measure	BSTME		UNIT	3
REVLV	Revision Level	REVLV		CHAR	2
VORAB	Advance procurement: project stock	VORAB		CHAR	1
PACKNO	Package number	PACKNO		NUMC	10
KANBA	Kanban Indicator	KBNKZ		CHAR	1
BPUEB	Use Requisition Price in Purchase Order	BPUEB		CHAR	1
CUOBJ	Configuration (internal object number)	CUOBJ		NUMC	18
FRGGR	Release group	FRGGR		CHAR	2
FRGRL	Release Not Yet Completely Effected	FRGRL		CHAR	1
AKTNR	Promotion	WAKTION		CHAR	10
CHARG	Batch Number	CHARG_D		CHAR	10
UMSOK	Special stock indicator for physical stock transfer	UMSOK		CHAR	1
VERID	Production Version	VERID		CHAR	4
FIPOS	Commitment Item	FIPOS		CHAR	14
FISTL	Funds Center	FISTL		CHAR	16
GEBER	Fund	BP_GEBER		CHAR	10
KZKFG	Origin of Configuration	KZCUH		CHAR	1
SATNR	Cross-Plant Configurable Material	SATNR		CHAR	40
MNG02	Committed Quantity	MNG06		QUAN	13
DAT01	Committed date	DAT05		DATS	8
ATTYP	Material Category	ATTYP		CHAR	2
LBLNI	Entry Sheet Number	LBLNI		CHAR	10
ADRNR	Number of delivery address	ADRN2		CHAR	10
ADRN2	Number of delivery address	ADRN2		CHAR	10
KUNNR	Customer	EKUNNR		CHAR	10
EMLIF	Supplier to be Supplied/Who is to Receive Delivery	EMLIF		CHAR	10
LBLKZ	Subcontracting Supplier	LBLKZ		CHAR	1
KZBWS	Valuation of Special Stock	KZBWS		CHAR	1
WAERS	Currency Key	WAERS		CUKY	5
IDNLF	Material Number Used by Supplier	IDNLF		CHAR	35
GSFRG	Overall release of purchase requisitions	GSFRG		CHAR	1
MPROF	Mfr part profile	MPROF		CHAR	4
KZFME	Units of measure usage	KZWSO		CHAR	1
SPRAS	Language Key	SPRAS	T002	LANG	1
TECHS	Parameter Variant/Standard Variant	TECHS		CHAR	12
MFRPN	Manufacturer Part Number	MFRPN		CHAR	40
MFRNR	Manufacturer number	MFRNR		CHAR	10
EMNFR	External manufacturer code name or number	EMNFR		CHAR	10
FORDN	Framework Order	SFORDN		CHAR	10
FORDP	Item of framework order	FORDP		NUMC	5
PLIFZ	Planned Delivery Time in Days	PLIFZ		DEC	3
BERID	MRP Area	BERID	MDLV	CHAR	10
UZEIT	Delivery Date Time-Spot	LZEIT		TIMS	6
FKBER	Functional Area	FKBER		CHAR	16
GRANT_NBR	Grant	GM_GRANT_NBR		CHAR	20
MEMORY	Purchase Requisition not yet Complete	MEMBF		CHAR	1
BANPR	Requisition Processing State	BANPR		CHAR	2
RLWRT	Total value at time of release	RLWRT		CURR	15
BLCKD	Purchase Requisition Blocked	BLCKD		CHAR	1
REVNO	Version number in Purchasing	REVNO		CHAR	8
BLCKT	Reason for Item Block	BLCKT		CHAR	60
BESWK	Procuring Plant	BESWK		CHAR	4
EPROFILE	External Procurement Profile	MEPROFILE		CHAR	2
EPREFDOC	External Procurement Reference Document	EPREFDOC		CHAR	10
EPREFITM	External Procurement Reference Item	EPREFITM		NUMC	5
GMMNG	PO Quantity of Purchase Requisition in POs on Hold	GMMNG		QUAN	13
WRTKZ	Value-Based Commitment Reduction for Service Purchase Reqs	WRTKZ		CHAR	1
RESLO	Issuing Storage Location for Stock Transport Order	RESLO		CHAR	4
BUDGET_PD	Budget Period	FM_BUDGET_PERIOD		CHAR	10

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VSEBAN_CN

Table Name	Field	Cardinality	Check Table
VSEBAN_CN	BERID	1: CN	MDLV
VSEBAN_CN	SPRAS	1: N	T002

SAP VSEBAN_CN Version: Purchase requisition Table

Overview

Techincal Settings of VSEBAN_CN

List of VSEBAN_CN Fields

Foreign Key Relationships

Other References