VSPRPS_CN SAP table for – Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data

Here we would like to draw your attention to VSPRPS_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). VSPRPS_CN is a SAP standard transparent table used for storing Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data related data in SAP. It comes under the package CNVS.

SAP VSPRPS_CN table

Table VSPRPS_CN technical data

TableVSPRPS_CN
Data storingVersion: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data
ModulePS
ComponentPS-SIM
SAP PackageCNVS
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP VSPRPS_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 VSPRPS_CN table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • SORT1 : (Not Supported) Search Term
    Its data type is C (Character String) with field length 10
  • SORT2 : (Not Supported) Search Term
    Its data type is C (Character String) with field length 10
  • SORT3
    Its data type is C (Character String) with field length 10
  • 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
  • JIBCL
    Its data type is C (Character String) with field length 3
  • POSKI
    Its data type is C (Character String) with field length 16
  • JIBSA
    Its data type is C (Character String) with field length 5
  • ORGKEY
    Its data type is N (Character String with Digits Only) with field length 8
  • INCAT
    Its data type is C (Character String) with field length 1
  • 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
  • AENAM : Name of Person Who Changed Object
    Its data type is C (Character String) with field length 12
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VERNR
    Its data type is N (Character String with Digits Only) with field length 8
  • VERNA
    Its data type is C (Character String) with field length 25
  • ASTNR
    Its data type is N (Character String with Digits Only) with field length 8
  • ASTNA
    Its data type is C (Character String) with field length 25
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is VSKEY_INC
  • PBUKR
    Its data type is C (Character String) with field length 4
  • PGSBR
    Its data type is C (Character String) with field length 4
  • PKOKR
    Its data type is C (Character String) with field length 4
  • PRCTR : Profit Center
    Its data type is C (Character String) with field length 10
  • PRART
    Its data type is C (Character String) with field length 2
  • STUFE : Level (in Multi-Level BOM Explosions)
    Its data type is X (Byte string) with field length 1
  • PLAKZ
    Its data type is C (Character String) with field length 1
  • BELKZ
    Its data type is C (Character String) with field length 1
  • FAKKZ
    Its data type is C (Character String) with field length 1
  • NPFAZ
    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
  • ZUORD
    Its data type is N (Character String with Digits Only) with field length 1
  • TRMEQ
    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
  • ABGSL
    Its data type is C (Character String) with field length 6
  • AKOKR
    Its data type is C (Character String) with field length 4
  • AKSTL
    Its data type is C (Character String) with field length 10
  • FKOKR
    Its data type is C (Character String) with field length 4
  • PSPNR : Standard WBS element
    Its a key field. Its data type is N (Character String with Digits Only) with field length 8
  • FKSTL
    Its data type is C (Character String) with field length 10
  • FABKL
    Its data type is C (Character String) with field length 2
  • PSPRI
    Its data type is C (Character String) with field length 1
  • EQUNR : Equipment Number
    Its data type is C (Character String) with field length 18
  • TPLNR : Flight Scheduling: Actual Aircraft Registration
    Its data type is C (Character String) with field length 30
  • PWPOS
    Its data type is C (Character String) with field length 5
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • TXTSP : Language Key
    Its data type is C (Character String) with field length 1
  • SLWID : Key word ID for user-defined fields
    Its data type is C (Character String) with field length 7
  • USR00 : User field with 20 characters
    Its data type is C (Character String) with field length 20
  • USR01 : User field with 20 characters
    Its data type is C (Character String) with field length 20
  • USR02 : User field with 10 characters
    Its data type is C (Character String) with field length 10
  • USR03 : User field with 10 characters
    Its data type is C (Character String) with field length 10
  • USR04 : User field for quantity (length 10.3)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • USE04 : User field: Unit for quantity fields
    Its data type is C (Character String) with field length 3
  • USR05 : User field for quantity (length 10.3)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • USE05 : User field: Unit for quantity fields
    Its data type is C (Character String) with field length 3
  • USR06 : User-defined field for values (length 10,3)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • USE06 : User field: Unit for value fields
    Its data type is C (Character String) with field length 5
  • USR07 : User-defined field for values (length 10,3)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • POSID
    Its data type is C (Character String) with field length 24
  • USE07 : User field: Unit for value fields
    Its data type is C (Character String) with field length 5
  • USR08 : User field for date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • USR09 : User field for date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • USR10 : User-defined field: Indicator for reports
    Its data type is C (Character String) with field length 1
  • USR11 : User-defined field: Indicator for reports
    Its data type is C (Character String) with field length 1
  • KOSTL : Cost Center
    Its data type is C (Character String) with field length 10
  • KTRG
    Its data type is C (Character String) with field length 12
  • BERST
    Its data type is C (Character String) with field length 16
  • BERTR
    Its data type is C (Character String) with field length 16
  • BERKO
    Its data type is C (Character String) with field length 16
  • POST1
    Its data type is C (Character String) with field length 40
  • BERBU
    Its data type is C (Character String) with field length 16
  • CLASF : Ind.: Take Activity Into Account for Project Summarization
    Its data type is C (Character String) with field length 1
  • SPSNR
    Its data type is N (Character String with Digits Only) with field length 8
  • SCOPE : Object Class
    Its data type is C (Character String) with field length 2
  • XSTAT
    Its data type is C (Character String) with field length 1
  • TXJCD : Tax Jurisdiction
    Its data type is C (Character String) with field length 15
  • ZSCHM
    Its data type is C (Character String) with field length 7
  • IMPRF
    Its data type is C (Character String) with field length 6
  • EVGEW : Aggregation weight for POC (PS progress)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • AENNR : Change Number
    Its data type is C (Character String) with field length 12
  • OBJNR : Object number
    Its data type is C (Character String) with field length 22
  • SUBPR
    Its data type is C (Character String) with field length 12
  • POSTU
    Its data type is C (Character String) with field length 40
  • PLINT
    Its data type is C (Character String) with field length 1
  • LOEVM : Deletion Indicator
    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
  • FPLNR : Billing plan number / invoicing plan number
    Its data type is C (Character String) with field length 10
  • TADAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • IZWEK
    Its data type is C (Character String) with field length 2
  • ISIZE
    Its data type is C (Character String) with field length 2
  • IUMKZ
    Its data type is C (Character String) with field length 5
  • PSPHI
    Its data type is N (Character String with Digits Only) with field length 8
  • ABUKR : Company Code which will be Cleared Against
    Its data type is C (Character String) with field length 4
  • GRPKZ
    Its data type is C (Character String) with field length 1
  • PGPRF
    Its data type is C (Character String) with field length 6
  • LOGSYSTEM
    Its data type is C (Character String) with field length 10
  • STORT
    Its data type is C (Character String) with field length 10
  • PSPKZ
    Its data type is C (Character String) with field length 1
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • VLPSP
    Its data type is N (Character String with Digits Only) with field length 8
  • VLPKZ
    Its data type is C (Character String) with field length 1