VSEBAN_CN SAP table for – Version: Purchase requisition

Here we would like to draw your attention to VSEBAN_CN table in SAP. As we know it is being mainly used with the SAP PS-SIM (Simulation in PS) component which is coming under PS module (Project Systems). VSEBAN_CN is a SAP standard transparent table used for storing Version: Purchase requisition related data in SAP. It comes under the package CNVS.

SAP VSEBAN_CN table

Table VSEBAN_CN technical data

TableVSEBAN_CN
Data storingVersion: Purchase requisition
ModulePS
ComponentPS-SIM
SAP PackageCNVS
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP VSEBAN_CN Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in VSEBAN_CN table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • STATU
    Its data type is C (Character String) with field length 1
  • KZBWS : Valuation of Special Stock
    Its data type is C (Character String) with field length 1
  • WAERS : Currency Key
    Its data type is C (Character String) with field length 5
  • IDNLF
    Its data type is C (Character String) with field length 35
  • GSFRG
    Its data type is C (Character String) with field length 1
  • MPROF
    Its data type is C (Character String) with field length 4
  • KZFME
    Its data type is C (Character String) with field length 1
  • SPRAS : Language Key
    Its data type is C (Character String) with field length 1
  • TECHS : Parameter Variant/Standard Variant
    Its data type is C (Character String) with field length 12
  • MFRPN : Manufacturer Part Number
    Its data type is C (Character String) with field length 40
  • MFRNR
    Its data type is C (Character String) with field length 10
  • ESTKZ
    Its data type is C (Character String) with field length 1
  • EMNFR : External manufacturer code name or number
    Its data type is C (Character String) with field length 10
  • FORDN : Framework Order
    Its data type is C (Character String) with field length 10
  • FORDP : Item of framework order
    Its data type is N (Character String with Digits Only) with field length 5
  • PLIFZ : Planned delivery time in days
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • BERID : MRP Area
    Its data type is C (Character String) with field length 10
  • UZEIT : System Time
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • FKBER : Functional Area
    Its data type is C (Character String) with field length 16
  • GRANT_NBR : Grant
    Its data type is C (Character String) with field length 20
  • MEMORY
    Its data type is C (Character String) with field length 1
  • BANPR
    Its data type is C (Character String) with field length 2
  • FRGKZ
    Its data type is C (Character String) with field length 1
  • RLWRT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BLCKD
    Its data type is C (Character String) with field length 1
  • REVNO
    Its data type is C (Character String) with field length 8
  • BLCKT
    Its data type is C (Character String) with field length 60
  • BESWK
    Its data type is C (Character String) with field length 4
  • EPROFILE
    Its data type is C (Character String) with field length 2
  • EPREFDOC
    Its data type is C (Character String) with field length 10
  • EPREFITM
    Its data type is N (Character String with Digits Only) with field length 5
  • GMMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • WRTKZ : Indicator: Characteristic value assigned
    Its data type is C (Character String) with field length 1
  • FRGZU
    Its data type is C (Character String) with field length 8
  • RESLO
    Its data type is C (Character String) with field length 4
  • BUDGET_PD : FM: Budget Period
    Its data type is C (Character String) with field length 10
  • FRGST
    Its data type is C (Character String) with field length 2
  • EKGRP : Purchasing group for external processing
    Its data type is C (Character String) with field length 3
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AFNAM : Name of requisitioner/requester
    Its data type is C (Character String) with field length 12
  • TXZ01
    Its data type is C (Character String) with field length 40
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is VSKEY_INC
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • EMATN
    Its data type is C (Character String) with field length 18
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • LGORT : Storage location
    Its data type is C (Character String) with field length 4
  • BEDNR : Requirement Tracking Number
    Its data type is C (Character String) with field length 10
  • MATKL : Material Group
    Its data type is C (Character String) with field length 9
  • RESWK : Supplying (issuing) plant in case of stock transport order
    Its data type is C (Character String) with field length 4
  • MENGE : Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MEINS : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • BUMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • VSNMR
    Its a key field. Its data type is C (Character String) with field length 12
  • BADAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LPEIN
    Its data type is C (Character String) with field length 1
  • LFDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FRGDT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • WEBAZ : Goods receipt processing time in days
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • PREIS : Price
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • PEINH : Price unit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • PSTYP : Item category in purchasing document
    Its data type is C (Character String) with field length 1
  • KNTTP : Account assignment category
    Its data type is C (Character String) with field length 1
  • KZVBR : Consumption posting
    Its data type is C (Character String) with field length 1
  • BANFN : Purchase requisition number
    Its a key field. Its data type is C (Character String) with field length 10
  • KFLAG
    Its data type is C (Character String) with field length 1
  • VRTKZ
    Its data type is C (Character String) with field length 1
  • TWRKZ
    Its data type is C (Character String) with field length 1
  • WEPOS : Goods Receipt Indicator
    Its data type is C (Character String) with field length 1
  • WEUNB : Goods Receipt, Non-Valuated
    Its data type is C (Character String) with field length 1
  • REPOS
    Its data type is C (Character String) with field length 1
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10
  • FLIEF
    Its data type is C (Character String) with field length 10
  • EKORG : Purchasing organization
    Its data type is C (Character String) with field length 4
  • VRTYP
    Its data type is C (Character String) with field length 1
  • BNFPO : Item number of the purchase requisition in the order
    Its a key field. Its data type is N (Character String with Digits Only) with field length 5
  • KONNR
    Its data type is C (Character String) with field length 10
  • KTPNR
    Its data type is N (Character String with Digits Only) with field length 5
  • INFNR : Number of purchasing info record
    Its data type is C (Character String) with field length 10
  • ZUGBA
    Its data type is C (Character String) with field length 1
  • QUNUM : Number of quota arrangement
    Its data type is C (Character String) with field length 10
  • QUPOS : Quota arrangement item
    Its data type is N (Character String with Digits Only) with field length 3
  • DISPO : MRP controller
    Its data type is C (Character String) with field length 3
  • SERNR : BOM explosion number
    Its data type is C (Character String) with field length 8
  • BVDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BATOL
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • BSART
    Its data type is C (Character String) with field length 4
  • BVDRK
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 4
  • EBELN : Purchasing Document Number
    Its data type is C (Character String) with field length 10
  • EBELP : Item Number of Purchasing Document
    Its data type is N (Character String with Digits Only) with field length 5
  • BEDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BSMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BWTAR : Valuation type
    Its data type is C (Character String) with field length 10
  • XOBLR
    Its data type is C (Character String) with field length 1
  • EBAKZ
    Its data type is C (Character String) with field length 1
  • RSNUM : Number of reservation/dependent requirements
    Its data type is N (Character String with Digits Only) with field length 10
  • SOBKZ : Special Stock Indicator
    Its data type is C (Character String) with field length 1
  • BSTYP
    Its data type is C (Character String) with field length 1
  • ARSNR : Number of reservation/dependent requirements
    Its data type is N (Character String with Digits Only) with field length 10
  • ARSPS : Order item number
    Its data type is N (Character String with Digits Only) with field length 4
  • FIXKZ
    Its data type is C (Character String) with field length 1
  • BMEIN
    Its data type is C (Character String) with field length 3
  • REVLV : Revision Level
    Its data type is C (Character String) with field length 2
  • VORAB
    Its data type is C (Character String) with field length 1
  • PACKNO : Package number
    Its data type is N (Character String with Digits Only) with field length 10
  • KANBA
    Its data type is C (Character String) with field length 1
  • BPUEB
    Its data type is C (Character String) with field length 1
  • CUOBJ : Configuration (internal object number)
    Its data type is N (Character String with Digits Only) with field length 18
  • BSAKZ
    Its data type is C (Character String) with field length 1
  • FRGGR
    Its data type is C (Character String) with field length 2
  • FRGRL
    Its data type is C (Character String) with field length 1
  • AKTNR
    Its data type is C (Character String) with field length 10
  • CHARG : Batch Number
    Its data type is C (Character String) with field length 10
  • UMSOK
    Its data type is C (Character String) with field length 1
  • VERID : Production Version
    Its data type is C (Character String) with field length 4
  • FIPOS : Commitment Item
    Its data type is C (Character String) with field length 14
  • FISTL : Funds Center
    Its data type is C (Character String) with field length 16
  • GEBER : Fund
    Its data type is C (Character String) with field length 10
  • KZKFG
    Its data type is C (Character String) with field length 1
  • LOEKZ : CHAR01 data element for SYST
    Its data type is C (Character String) with field length 1
  • SATNR
    Its data type is C (Character String) with field length 18
  • MNG02
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • DAT01
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ATTYP
    Its data type is C (Character String) with field length 2
  • LBLNI
    Its data type is C (Character String) with field length 10
  • ADRNR : Addresses: Address Number
    Its data type is C (Character String) with field length 10
  • ADRN2
    Its data type is C (Character String) with field length 10
  • KUNNR : Customer number
    Its data type is C (Character String) with field length 10
  • EMLIF
    Its data type is C (Character String) with field length 10
  • LBLKZ
    Its data type is C (Character String) with field length 1