1. SAP Tutorial
  2. PS

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

    • VSAUFK_CN related tables

    • VSAFAB_CN : Version: Network relationships
    • VSEVFG_CN : Version: PS EV, percent of completion
    • TCN53 : Valid system status for version profile
    • VSHIST_OK : Transfer history material components
    • TCNVSCT : Customizing: Short description of possible version numbers
    • PROJVS_ENQ : Block key project (project versions)
    • VSPRTE_CN : Version: Scheduling data for project item
    • VSVBAP_CN : Version: Sales document: Item data
    • VSAFVV_CN : Version: Quantities/Dates/Values in order operation
    • VSVBEP_CN : Version: Sales document: Schedule line data
    • TCNVSC : Customizing: Possible version number per version category
    • VSJEST_CN : Version: Individual status per object
    • VSPRHI_CN : Version: WBS, edges (hierarchy pointer)
    • VSFPLA_CN : Version: Billing schedule
    • VSHIST_OV : Transfer history activity
    • VSPSTX_CN : Version: PS texts (header)
    • VSFPLT_CN : Version: Billing schedule: Dates
    • VSKPER_CN : Version: Workforce Planning
    • VSAFFL_CN : Version: Order sequences PP orders
    • VSKOPF : Version: Header – general data for a version –

    VSAUFK_CN related transaction codes under SAP package CNVS

    • CJV1 : Create project version (simulation)
    • CJV6 : Maintenance: Version administration
    • CJV3 : Display Project Version (Simulation)
    • CJV7 : Display transfer log
    • CJV5 : Delete simulation version
    • CJV2 : Change project version (simulation)
    • CN72 : Create Project Version
    • CJV4 : Transfer project

    Related References

    Related Tutorials

    VSKOPF SAP table for – Version: Header – general data for a version –

    VSKOPF table in SAP PS (Simulation in PS) module. This tables is used for storing data of Version: Header -...

    VSKBKO_CN SAP table for – Version: Capacity requirements header for an order

    VSKBKO_CN table in SAP PS (Simulation in PS) module. This tables is used for storing data of Version: Capacity requirements...

    VSPRTE_CN SAP table for – Version: Scheduling data for project item

    VSPRTE_CN table in SAP PS (Simulation in PS) module. This tables is used for storing data of Version: Scheduling data...

    VSAFKO_CN SAP table for – Version: Order header data for PP orders

    VSAFKO_CN table in SAP PS (Simulation in PS) module. This tables is used for storing data of Version: Order header...

    VSSTEU SAP table for – Version: Control table – one entry per version object –

    VSSTEU table in SAP PS (Simulation in PS) module. This tables is used for storing data of Version: Control table...

    VSVBEP_CN SAP table for – Version: Sales document: Schedule line data

    VSVBEP_CN table in SAP PS (Simulation in PS) module. This tables is used for storing data of Version: Sales document:...

    VSVBAK_CN SAP table for – Version: Sales document: Header data

    VSVBAK_CN table in SAP PS (Simulation in PS) module. This tables is used for storing data of Version: Sales document:...

    «
    »