VSAUFK_CN SAP table for – Version: Order master data

Here we would like to draw your attention to VSAUFK_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). VSAUFK_CN is a SAP standard transparent table used for storing Version: Order master data related data in SAP. It comes under the package CNVS.

SAP VSAUFK_CN table

Table VSAUFK_CN technical data

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

SAP VSAUFK_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 VSAUFK_CN table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • AENAM : Name of Person Who Changed Object
    Its data type is C (Character String) with field length 12
  • JV_JIBCL : JIB/JIBE Class
    Its data type is C (Character String) with field length 3
  • JV_JIBSA : JIB/JIBE Subclass A
    Its data type is C (Character String) with field length 5
  • JV_OCO : JV original cost object
    Its data type is C (Character String) with field length 1
  • ORGKEY
    Its data type is C (Character String) with field length 12
  • EXT_AUFNR
    Its data type is C (Character String) with field length 12
  • INACT : Indicator: Planned confirmation
    Its data type is C (Character String) with field length 1
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • KTEXT
    Its data type is C (Character String) with field length 40
  • LTEXT
    Its data type is C (Character String) with field length 1
  • BUKRS : Company Code
    Its data type is C (Character String) with field length 4
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • GSBER : Business Area
    Its data type is C (Character String) with field length 4
  • KOKRS : Controlling Area
    Its data type is C (Character String) with field length 4
  • CCKEY
    Its data type is C (Character String) with field length 23
  • KOSTV : Responsible cost center
    Its data type is C (Character String) with field length 10
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is VSKEY_INC
  • STORT
    Its data type is C (Character String) with field length 10
  • SOWRK
    Its data type is C (Character String) with field length 4
  • ASTKZ
    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
  • ASTNR
    Its data type is N (Character String with Digits Only) with field length 2
  • STDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ESTNR
    Its data type is N (Character String with Digits Only) with field length 2
  • PHAS0
    Its data type is C (Character String) with field length 1
  • PHAS1
    Its data type is C (Character String) with field length 1
  • PHAS2
    Its data type is C (Character String) with field length 1
  • VSNMR
    Its a key field. Its data type is C (Character String) with field length 12
  • PHAS3
    Its data type is C (Character String) with field length 1
  • PDAT1
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PDAT2
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PDAT3
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • IDAT1
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • IDAT2
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • IDAT3
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • OBJID : Accrual Object (Internal Display in Form of a GUID)
    Its data type is C (Character String) with field length 1
  • VOGRP
    Its data type is C (Character String) with field length 4
  • LOEKZ : CHAR01 data element for SYST
    Its data type is C (Character String) with field length 1
  • AUFNR : Order Number
    Its a key field. Its data type is C (Character String) with field length 12
  • PLGKZ
    Its data type is C (Character String) with field length 1
  • KVEWE
    Its data type is C (Character String) with field length 1
  • KAPPL : Application
    Its data type is C (Character String) with field length 2
  • KALSM : Costing Sheet
    Its data type is C (Character String) with field length 6
  • ZSCHL : Overhead key
    Its data type is C (Character String) with field length 6
  • ABKRS
    Its data type is N (Character String with Digits Only) with field length 2
  • KSTAR : Cost Element
    Its data type is C (Character String) with field length 10
  • KOSTL : Cost Center
    Its data type is C (Character String) with field length 10
  • SAKNR : G/L Account Number
    Its data type is C (Character String) with field length 10
  • SETNM
    Its data type is C (Character String) with field length 12
  • AUART : Order Type
    Its data type is C (Character String) with field length 4
  • CYCLE
    Its data type is C (Character String) with field length 10
  • SDATE : Created on
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SEQNR : Flight Scheduling: Flight Sequence Number
    Its data type is N (Character String with Digits Only) with field length 4
  • USER0
    Its data type is C (Character String) with field length 20
  • USER1 : User Name in User Master Record
    Its data type is C (Character String) with field length 20
  • USER2
    Its data type is C (Character String) with field length 20
  • USER3
    Its data type is C (Character String) with field length 20
  • USER4
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • USER5
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • USER6
    Its data type is C (Character String) with field length 15
  • AUTYP : Order category
    Its data type is N (Character String with Digits Only) with field length 2
  • USER7
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • USER8
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • USER9
    Its data type is C (Character String) with field length 1
  • OBJNR : Object number
    Its data type is C (Character String) with field length 22
  • PRCTR : Profit Center
    Its data type is C (Character String) with field length 10
  • PSPEL
    Its data type is N (Character String with Digits Only) with field length 8
  • AWSLS
    Its data type is C (Character String) with field length 6
  • ABGSL
    Its data type is C (Character String) with field length 6
  • TXJCD : Tax Jurisdiction
    Its data type is C (Character String) with field length 15
  • SCOPE : Object Class
    Its data type is C (Character String) with field length 2
  • REFNR
    Its data type is C (Character String) with field length 12
  • PLINT
    Its data type is C (Character String) with field length 1
  • KDAUF : Sales Order Number
    Its data type is C (Character String) with field length 10
  • KDPOS : Item number in Sales Order
    Its data type is N (Character String with Digits Only) with field length 6
  • AUFEX
    Its data type is C (Character String) with field length 20
  • IVPRO
    Its data type is C (Character String) with field length 6
  • LOGSYSTEM
    Its data type is C (Character String) with field length 10
  • FLG_MLTPS
    Its data type is C (Character String) with field length 1
  • ABUKR : Company Code which will be Cleared Against
    Its data type is C (Character String) with field length 4
  • AKSTL
    Its data type is C (Character String) with field length 10
  • SIZECL
    Its data type is C (Character String) with field length 2
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • IZWEK
    Its data type is C (Character String) with field length 2
  • UMWKZ
    Its data type is C (Character String) with field length 5
  • KSTEMPF
    Its data type is C (Character String) with field length 1
  • ZSCHM
    Its data type is C (Character String) with field length 7
  • PKOSA
    Its data type is C (Character String) with field length 12
  • PROCNR
    Its data type is N (Character String with Digits Only) with field length 12
  • PROTY
    Its data type is C (Character String) with field length 4
  • RSORD
    Its data type is C (Character String) with field length 1
  • BEMOT : Accounting Indicator
    Its data type is C (Character String) with field length 2
  • ADRNRA
    Its data type is C (Character String) with field length 10
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ERFZEIT
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • AEZEIT
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • VNAME : Joint venture
    Its data type is C (Character String) with field length 6
  • RECID : Recovery Indicator
    Its data type is C (Character String) with field length 2
  • ETYPE : Equity type
    Its data type is C (Character String) with field length 3
  • OTYPE : Object Type
    Its data type is C (Character String) with field length 4
  • [ FREE ] SUBSCRIBE
    RECEIVE UPDATES & SAP ARTICLES RIGHT IN YOUR INBOX.