1. Home
  2. Resources
  3. SAP Tables
  4. VSPROJ_CN - Version: Project definition

SAP Table VSPROJ_CN

Version: Project definition

VSPROJ_CN (Version: Project definition) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VSPROJ_CN to other SAP tables.

Source: VSPROJ_CN (Version: Project definition)

VSPROJ_CN table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VSNMR Number or description of a version VSNMR CHAR 12 0
PSPNR Project definition (internal) PS_INTNR NUMC 8 0
PSPID Project Definition PS_PSPID CHAR 24 0
POST1 PS: Short description (1st text line) PS_POST1 CHAR 40 0
OBJNR Object number J_OBJNR ONR00 CHAR 22 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
AEDAT Date on which object was last changed UPDAT DATS 8 0
KIMSK Selection mask for WBS element short IDs PS_KIMSK CHAR 24 0
AUTOD Automatic value transfer from WBS element to project def. PS_AUTOD CHAR 1 0
X Yes
NULL No
STSPD Status profile for project definition PS_STSPD TJ20 CHAR 8 0
STSPR Status profile for WBS element PS_STSPR TJ20 CHAR 8 0
VERNR Number of the responsible person (project manager) PS_VERNR TCJ04 NUMC 8 0
VERNA Name of responsible person (Project manager) PS_VERNA CHAR 25 0
ASTNR Applicant number PS_ASTNR TCJ05 NUMC 8 0
ASTNA Applicant PS_ASTNA CHAR 25 0
VBUKR Company code for the project PS_VBUKR T001 CHAR 4 0
VGSBR Business area for the project PS_VGSBR TGSB CHAR 4 0
VKOKR Controlling area for the project PS_VKOKR TKA01 CHAR 4 0
PRCTR Profit Center PRCTR CEPC CHAR 10 0
PWHIE WBS currency (project definition) PS_PWHIE TCURC CUKY 5 0
ZUORD Network assignment PS_ZUORD NUMC 1 0
1 For project definition
2 For WBS element
TRMEQ Indicator: WBS dates detailed by activity dates PS_TRMEQ CHAR 1 0
X Yes
NULL No
PLFAZ Project planned start date PS_PLFAZ DATS 8 0
PLSEZ Project planned finish date PS_PLSEZ DATS 8 0
WERKS Plant WERKS_D T001W CHAR 4 0
KALID Factory calendar key FABKL TFACD CHAR 2 0
VGPLF Planning method for project basic dates PS_VGPLF NUMC 1 0
1 Top-down
2 Bottom-up (taking dates of higher-level WBS into account)
3 Open planning
4 Strict bottom-up (without dates of higher-level WBS)
EWPLF Planning method for project forecast dates PS_EWPLF NUMC 1 0
1 Top-down
2 Bottom-up (taking dates of higher-level WBS into account)
3 Open planning
4 Strict bottom-up (without dates of higher-level WBS)
ZTEHT Time unit in time scheduling PS_ZTEHT T006 UNIT 3 0
NZANZ Indicator: Network header visible to end user NETZOBERFL CHAR 1 0
X Yes
NULL No
PLNAW Application of the task list PLNAW TCA09 CHAR 1 0
VPROF Network profile PROFIDNZPL TCN41 CHAR 7 0
PROFL Project Profile PROFIDPROJ TCJ41 CHAR 7 0
BPROF Budget Profile BP_BPROFIL TBP1C CHAR 6 0
TXTSP Language Key SPRAS T002 LANG 1 0
KOSTL Cost Center KOSTL CSKS CHAR 10 0
KTRG Cost Object KSTRG CKPH CHAR 12 0
AEDTE Date of last scheduling of the overall network (basic dates) PS_AEDTE DATS 8 0
AEDTP Date of last scheduling of the overall network (forecast) PS_AEDTP DATS 8 0
BERST Authorization key for project master data PS_BERST CHAR 16 0
BERTR Authorization key for project dates (WBS) PS_BERTR CHAR 16 0
BERKO Authorization key for costs and revenues PS_BERKO CHAR 16 0
BERBU Authorization key for project budget PS_BERBU CHAR 16 0
SPSNR Current number for standard project PS_ISPSP PROJS NUMC 8 0
BESTA Project stock PS_BESTAND CHAR 1 0
X Yes
NULL No
SCOPE Object Class SCOPE_CV CHAR 2 0
OC Overhead costs
IV Investment
PR Production
PA Profit analysis
XSTAT Statistical WBS element PS_XSTAT CHAR 1 0
X Yes
NULL No
TXJCD Tax Jurisdiction TXJCD TTXJ CHAR 15 0
ZSCHM Interest Profile for Project/Order Interest Calculation PS_ZSCHM TPI01 CHAR 7 0
SCPRF Profile for WBS scheduling PS_SCHDPRF TCXPS CHAR 12 0
IMPRF Investment measure profile IM_PROFIL TAPRF CHAR 6 0
FMPRF Payment plan profile PSFM_PRF TBP1C CHAR 6 0
ABGSL Results Analysis Key ABGR_SCHL TKKAA CHAR 6 0
POSTU PS: Short description (1st text line) in all caps PS_POSTU CHAR 40 0
PPROF Planning profile BP_PPROFIL TBP1C CHAR 6 0
PLINT Indicator for Integrated Planning PLINT CHAR 1 0
X Yes
NULL No
LOEVM Deletion Indicator LOEVM CHAR 1 0
X Yes
NULL No
INACT Indicator: Project definition inactive PS_INACT CHAR 1 0
X Yes
NULL No
KZBWS Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
SMPRF Simulation profile SIM_PROFIL TCN54 CHAR 7 0
FLGVRG Indicator: Bottom-up calculation with activity dates PS_FLGVRG CHAR 1 0
NULL without taking activity dates into consideration
1 taking activity dates into consideration
2 Consideration of activity dates by user decision
GRTOP Indicator: Automatic requirements grouping GRONTOP CHAR 1 0
X Yes
NULL No
PGPRF Distribution profile PGPROFID TPGPRF CHAR 6 0
STORT Location PS_STORT T499S CHAR 10 0
LOGSYSTEM Logical System LOGSYSTEM CHAR 10 0
KZERB Indicator: Project summarization via master data charact. PS_KZERB CHAR 1 0
X Yes
NULL No
PARGR Partner Determination Procedure PARGR V_TVPG_S CHAR 4 0
FUNC_AREA Functional Area FKBER TFKB CHAR 16 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVKOV CHAR 2 0
SPART Division SPART TVTA CHAR 2 0
DPPPROF Dynamic Item Processor Profile AD01PROFNR AD01C_PROF CHAR 8 0
VPKSTU Node level SEU_LEVEL NUMC 2 0
PSPID_EDIT Project Number (External) Edited PS_PSPID_EDIT CHAR 24 0
VNAME Joint Venture JV_NAME T8JV CHAR 6 0
RECID Recovery Indicator JV_RECIND T8JJ CHAR 2 0
ETYPE Equity type JV_ETYPE T8JE CHAR 3 0
OTYPE Joint Venture Object Type JV_OTYPE CHAR 4 0
JIBCL JIB/JIBE Class JV_JIBCL T8J6A CHAR 3 0
JIBSA JIB/JIBE Subclass A JV_JIBSA T8J6C CHAR 5 0
ZFILEPATH Character field of length 40 CHAR40 CHAR 40 0
ZFILE1NAME Char 20 CHAR20 CHAR 20 0
ZFILE1EXTE 3-Byte field CHAR3 CHAR 3 0
ZFILE2NAME Char 20 CHAR20 CHAR 20 0
ZFILE2EXTE 3-Byte field CHAR3 CHAR 3 0
ZFILE3NAME Char 20 CHAR20 CHAR 20 0
ZFILE3EXTE 3-Byte field CHAR3 CHAR 3 0
SCHTYP Scheduling scenario PS_SCHED_TYPE CHAR 1 0
1 Bottom-up scenario (pre-defined)
2 Top-down scenario (pre-defined)
NULL Free scheduling
SPROG Forecast start date of project definition PS_SPROG DATS 8 0
EPROG Forecast finish date for project definition PS_EPROG DATS 8 0
ORGKEY Project definition (internal) PS_INTNR NUMC 8 0
INCAT Version inactive indicator VSINACT CHAR 1 0
X Yes
NULL No
PROJ_STATUS Status Combination ACTCMB_DELE ACTCMB_TAB INT1 3 0
FERC_IND Regulatory indicator FE_IND FERC_C7 CHAR 4 0

VSPROJ_CN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VSPROJ_CN ABGSL SYST MANDT TKKAA Check Table for Results Analysis Key of RA for Orders MANDT
VSPROJ_CN ABGSL VSPROJ_CN ABGSL TKKAA Check Table for Results Analysis Key of RA for Orders ABGSL
VSPROJ_CN ASTNR MANDT TCJ05 Project applicant MANDT
VSPROJ_CN ASTNR VSPROJ_CN ASTNR TCJ05 Project applicant ASTNR
VSPROJ_CN BPROF MANDT TBP1C Budget/Plan Profile MANDT
VSPROJ_CN BPROF VSPROJ_CN BPROF TBP1C Budget/Plan Profile PROFIL
VSPROJ_CN BPROF 'P' TBP1C Budget/Plan Profile APPLIK
VSPROJ_CN BPROF '01' TBP1C Budget/Plan Profile WRTTP
VSPROJ_CN DPPPROF SYST MANDT AD01C_PROF DIP profile: Usage MANDT
VSPROJ_CN DPPPROF VSPROJ_CN DPPPROF AD01C_PROF DIP profile: Usage PROFNR
VSPROJ_CN DPPPROF * AD01C_PROF DIP profile: Usage DPUS
VSPROJ_CN ETYPE MANDT T8JE Investment Type MANDT
VSPROJ_CN ETYPE VSPROJ_CN VBUKR T8JE Investment Type BUKRS
VSPROJ_CN ETYPE VSPROJ_CN ETYPE T8JE Investment Type ETYPE
VSPROJ_CN FERC_IND VSPROJ_CN MANDT FERC_C7 Regulatory indicators MANDT
VSPROJ_CN FERC_IND VSPROJ_CN FERC_IND FERC_C7 Regulatory indicators IND
VSPROJ_CN FMPRF SYST MANDT TBP1C Budget/Plan Profile MANDT
VSPROJ_CN FMPRF VSPROJ_CN FMPRF TBP1C Budget/Plan Profile PROFIL
VSPROJ_CN FMPRF 'P' TBP1C Budget/Plan Profile APPLIK
VSPROJ_CN FMPRF '62' TBP1C Budget/Plan Profile WRTTP
VSPROJ_CN FUNC_AREA SYST MANDT TFKB Functional areas MANDT
VSPROJ_CN FUNC_AREA VSPROJ_CN FUNC_AREA TFKB Functional areas FKBER
VSPROJ_CN IMPRF SYST MANDT TAPRF Cap. inv. measure profile for AuC and dep. simulation MANDT
VSPROJ_CN IMPRF VSPROJ_CN IMPRF TAPRF Cap. inv. measure profile for AuC and dep. simulation IVPRO
VSPROJ_CN JIBCL MANDT T8J6A JIB/JIBE Class MANDT
VSPROJ_CN JIBCL VSPROJ_CN VBUKR T8J6A JIB/JIBE Class BUKRS
VSPROJ_CN JIBCL VSPROJ_CN JIBCL T8J6A JIB/JIBE Class CLASS
VSPROJ_CN JIBSA MANDT T8J6C JIB/JIBE Subclass MANDT
VSPROJ_CN JIBSA VSPROJ_CN VBUKR T8J6C JIB/JIBE Subclass BUKRS
VSPROJ_CN JIBSA VSPROJ_CN JIBCL T8J6C JIB/JIBE Subclass CLASS
VSPROJ_CN JIBSA VSPROJ_CN JIBSA T8J6C JIB/JIBE Subclass SUBCLASS
VSPROJ_CN KALID VSPROJ_CN KALID TFACD Factory calendar definition IDENT
VSPROJ_CN KOSTL MANDT CSKS Cost Center Master Data MANDT
VSPROJ_CN KOSTL VSPROJ_CN VKOKR CSKS Cost Center Master Data KOKRS
VSPROJ_CN KOSTL VSPROJ_CN KOSTL CSKS Cost Center Master Data KOSTL
VSPROJ_CN KOSTL VSPROJ_CN PLSEZ CSKS Cost Center Master Data DATBI
VSPROJ_CN KTRG MANDT CKPH Master Record: Cost Object ID Number MANDT
VSPROJ_CN KTRG VSPROJ_CN KTRG CKPH Master Record: Cost Object ID Number KSTRG
VSPROJ_CN KTRG VSPROJ_CN PLSEZ CKPH Master Record: Cost Object ID Number DATBI
VSPROJ_CN MANDT VSPROJ_CN MANDT T000 Clients MANDT
VSPROJ_CN OBJNR VSPROJ_CN MANDT ONR00 General Object Number MANDT
VSPROJ_CN OBJNR VSPROJ_CN OBJNR ONR00 General Object Number OBJNR
VSPROJ_CN PARGR SY MANDT V_TVPG_S Generated Table for View MANDT
VSPROJ_CN PARGR VSPROJ_CN PARGR V_TVPG_S Generated Table for View PARGR
VSPROJ_CN PARGR * V_TVPG_S Generated Table for View PAOBJ
VSPROJ_CN PARGR * V_TVPG_S Generated Table for View SPRAS
VSPROJ_CN PGPRF SY MANDT TPGPRF Profile for static pegging and data distribution MANDT
VSPROJ_CN PGPRF VSPROJ_CN PGPRF TPGPRF Profile for static pegging and data distribution PROFID
VSPROJ_CN PLNAW MANDT TCA09 Task list applications MANDT
VSPROJ_CN PLNAW VSPROJ_CN PLNAW TCA09 Task list applications PLNAW
VSPROJ_CN PPROF SYST MANDT TBP1C Budget/Plan Profile MANDT
VSPROJ_CN PPROF VSPROJ_CN PPROF TBP1C Budget/Plan Profile PROFIL
VSPROJ_CN PPROF 'P' TBP1C Budget/Plan Profile APPLIK
VSPROJ_CN PPROF '01' TBP1C Budget/Plan Profile WRTTP
VSPROJ_CN PRCTR MANDT CEPC Profit Center Master Data Table MANDT
VSPROJ_CN PRCTR VSPROJ_CN PRCTR CEPC Profit Center Master Data Table PRCTR
VSPROJ_CN PRCTR VSPROJ_CN AEDAT CEPC Profit Center Master Data Table DATBI
VSPROJ_CN PRCTR * CEPC Profit Center Master Data Table KOKRS
VSPROJ_CN PROFL MANDT TCJ41 Default Values for Work Breakdown Structure MANDT
VSPROJ_CN PROFL VSPROJ_CN PROFL TCJ41 Default Values for Work Breakdown Structure PROFIDPROJ
VSPROJ_CN PROJ_STATUS SYST MANDT ACTCMB_TAB table for status combination MANDT
VSPROJ_CN PROJ_STATUS VSPROJ_CN PROJ_STATUS ACTCMB_TAB table for status combination ACTCMB
VSPROJ_CN PWHIE MANDT TCURC Currency Codes MANDT
VSPROJ_CN PWHIE VSPROJ_CN PWHIE TCURC Currency Codes WAERS
VSPROJ_CN RECID MANDT T8JJ Recovery Indicator MANDT
VSPROJ_CN RECID VSPROJ_CN VBUKR T8JJ Recovery Indicator BUKRS
VSPROJ_CN RECID VSPROJ_CN RECID T8JJ Recovery Indicator RECID
VSPROJ_CN SCPRF SYST MANDT TCXPS Control parameters for WBS scheduling MANDT
VSPROJ_CN SCPRF VSPROJ_CN SCPRF TCXPS Control parameters for WBS scheduling PROFIL
VSPROJ_CN SMPRF PROJ MANDT TCN54 Simualtion control MANDT
VSPROJ_CN SMPRF VSPROJ_CN SMPRF TCN54 Simualtion control VER_PROFIL
VSPROJ_CN SPART SYST MANDT TVTA Organizational Unit: Sales Area(s) MANDT
VSPROJ_CN SPART VSPROJ_CN VKORG TVTA Organizational Unit: Sales Area(s) VKORG
VSPROJ_CN SPART VSPROJ_CN VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
VSPROJ_CN SPART VSPROJ_CN SPART TVTA Organizational Unit: Sales Area(s) SPART
VSPROJ_CN SPSNR MANDT PROJS Standard project definition MANDT
VSPROJ_CN SPSNR VSPROJ_CN SPSNR PROJS Standard project definition PSPNR
VSPROJ_CN STORT SYST MANDT T499S Location MANDT
VSPROJ_CN STORT VSPROJ_CN WERKS T499S Location WERKS
VSPROJ_CN STORT VSPROJ_CN STORT T499S Location STAND
VSPROJ_CN STSPD MANDT TJ20 Status profiles MANDT
VSPROJ_CN STSPD VSPROJ_CN STSPD TJ20 Status profiles STSMA
VSPROJ_CN STSPR MANDT TJ20 Status profiles MANDT
VSPROJ_CN STSPR VSPROJ_CN STSPR TJ20 Status profiles STSMA
VSPROJ_CN TXJCD MANDT TTXJ Check Table for Tax Jurisdiction MANDT
VSPROJ_CN TXJCD T005 KALSM TTXJ Check Table for Tax Jurisdiction KALSM
VSPROJ_CN TXJCD VSPROJ_CN TXJCD TTXJ Check Table for Tax Jurisdiction TXJCD
VSPROJ_CN TXTSP VSPROJ_CN TXTSP T002 Language Keys (Component BC-I18) SPRAS
VSPROJ_CN VBUKR MANDT T001 Company Codes MANDT
VSPROJ_CN VBUKR VSPROJ_CN VBUKR T001 Company Codes BUKRS
VSPROJ_CN VERNR MANDT TCJ04 Person in Responsible for Project MANDT
VSPROJ_CN VERNR VSPROJ_CN VERNR TCJ04 Person in Responsible for Project VERNR
VSPROJ_CN VGSBR MANDT TGSB Business Areas MANDT
VSPROJ_CN VGSBR VSPROJ_CN VGSBR TGSB Business Areas GSBER
VSPROJ_CN VKOKR MANDT TKA01 Controlling Areas MANDT
VSPROJ_CN VKOKR VSPROJ_CN VKOKR TKA01 Controlling Areas KOKRS
VSPROJ_CN VKORG SYST MANDT TVKO Organizational Unit: Sales Organizations MANDT
VSPROJ_CN VKORG VSPROJ_CN VKORG TVKO Organizational Unit: Sales Organizations VKORG
VSPROJ_CN VNAME MANDT T8JV Joint Venture MANDT
VSPROJ_CN VNAME VSPROJ_CN VBUKR T8JV Joint Venture BUKRS
VSPROJ_CN VNAME VSPROJ_CN VNAME T8JV Joint Venture VNAME
VSPROJ_CN VPROF MANDT TCN41 Network Defaults MANDT
VSPROJ_CN VPROF VSPROJ_CN PLNAW TCN41 Network Defaults PLNAW
VSPROJ_CN VPROF VSPROJ_CN VPROF TCN41 Network Defaults PROFIDNETZ
VSPROJ_CN VTWEG SYST MANDT TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
VSPROJ_CN VTWEG VSPROJ_CN VKORG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
VSPROJ_CN VTWEG VSPROJ_CN VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
VSPROJ_CN WERKS MANDT T001W Plants/Branches MANDT
VSPROJ_CN WERKS VSPROJ_CN WERKS T001W Plants/Branches WERKS
VSPROJ_CN ZSCHM SY MANDT TPI01 Interest Profile MANDT
VSPROJ_CN ZSCHM VSPROJ_CN ZSCHM TPI01 Interest Profile ZSCHM
VSPROJ_CN ZTEHT MANDT T006 Units of Measurement MANDT
VSPROJ_CN ZTEHT VSPROJ_CN ZTEHT T006 Units of Measurement MSEHI