SAP table VSPROJ_CN (Version: Project definition)

SAP table VSPROJ_CN has 3 primary key fields being MANDT,VSNMR,PSPNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
VSNMR Number or description of a version CHAR 12 0 VSNMR
PSPNR Project (internal) NUMC 8 0 PS_INTNR
PSPID Project definition CHAR 24 0 PS_PSPID
POST1 PS: Short description (1st text line) CHAR 40 0 PS_POST1
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Date on which object was last changed DATS 8 0 UPDAT
KIMSK Selection mask for WBS element short IDs CHAR 24 0 PS_KIMSK
AUTOD Automatic value transfer from WBS element to project def. CHAR 1 0 PS_AUTOD
STSPD Status profile for project definition CHAR 8 0 TJ20 PS_STSPD
STSPR Status profile for WBS element CHAR 8 0 TJ20 PS_STSPR
VERNR Number of the Responsible Person (Project Manager) NUMC 8 0 TCJ04 PS_VERNR
VERNA Name of responsible person (Project manager) CHAR 25 0 PS_VERNA
ASTNR Applicant number NUMC 8 0 TCJ05 PS_ASTNR
ASTNA Applicant CHAR 25 0 PS_ASTNA
VBUKR Company code for the project CHAR 4 0 T001 PS_VBUKR
VGSBR Business area for the project CHAR 4 0 TGSB PS_VGSBR
VKOKR Controlling area for the project CHAR 4 0 TKA01 PS_VKOKR
PRCTR Profit Center CHAR 10 0 CEPC PRCTR
PWHIE WBS currency (project definition) CUKY 5 0 TCURC PS_PWHIE
ZUORD Network assignment NUMC 1 0 PS_ZUORD
1 For project definition
2 For WBS element
TRMEQ Indicator: WBS dates detailed by activity dates CHAR 1 0 PS_TRMEQ
PLFAZ Project planned start date DATS 8 0 PS_PLFAZ_CHG
PLSEZ Project planned finish date DATS 8 0 PS_PLSEZ_CHG
WERKS Plant CHAR 4 0 T001W WERKS_D
KALID Factory calendar key CHAR 2 0 TFACD FABKL
VGPLF Planning method for project basic dates NUMC 1 0 PS_VGPLF
EWPLF Planning method for project forecast dates NUMC 1 0 PS_EWPLF
ZTEHT Time unit in time scheduling UNIT 3 0 T006 PS_ZTEHT
NZANZ Indicator: Network header visible to end user CHAR 1 0 NETZOBERFL
PLNAW Application of the task list CHAR 1 0 TCA09 PLNAW
VPROF Network Profile CHAR 7 0 TCN41 PROFIDNZPL
PROFL Project Profile CHAR 7 0 TCJ41 PROFIDPROJ
BPROF Budget Profile CHAR 6 0 TBP1C BP_BPROFIL
TXTSP Language Key LANG 1 0 T002 SPRAS
KOSTL Cost Center CHAR 10 0 CSKS KOSTL
KTRG Cost Object CHAR 12 0 CKPH KSTRG
AEDTE Date of last scheduling of the overall network (basic dates) DATS 8 0 PS_AEDTE
AEDTP Date of last scheduling of the overall network (forecast) DATS 8 0 PS_AEDTP
BERST Authorization key for project master data CHAR 16 0 PS_BERST
BERTR Authorization key for project dates (WBS) CHAR 16 0 PS_BERTR
BERKO Authorization key for costs and revenues CHAR 16 0 PS_BERKO
BERBU Authorization key for project budget CHAR 16 0 PS_BERBU
SPSNR Current number for standard project NUMC 8 0 PROJS PS_ISPSP
BESTA Project stock CHAR 1 0 PS_BESTAND
SCOPE Object Class CHAR 2 0 SCOPE_CV
IV Investment
OC Overhead costs
PA Profit analysis
PR Production
XSTAT Statistical WBS element CHAR 1 0 PS_XSTAT
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
ZSCHM Interest Profile for Project/Order Interest Calculation CHAR 7 0 TPI01 PS_ZSCHM
SCPRF Profile for WBS scheduling CHAR 12 0 TCXPS PS_SCHDPRF
IMPRF Investment Measure Profile CHAR 6 0 TAPRF IM_PROFIL
FMPRF Payment plan profile CHAR 6 0 TBP1C PSFM_PRF
ABGSL Results Analysis Key CHAR 6 0 TKKAA ABGR_SCHL
POSTU PS: Short description (1st text line) in all caps CHAR 40 0 PS_POSTU
PPROF Planning Profile CHAR 6 0 TBP1C BP_PPROFIL
PLINT Indicator for Integrated Planning CHAR 1 0 PLINT
LOEVM Deletion Indicator CHAR 1 0 LOEVM
INACT Indicator: Project definition inactive CHAR 1 0 PS_INACT
KZBWS Valuation of Special Stock CHAR 1 0 KZBWS
No stock valuation
A Valuation without reference to sales document
M Separate valuation with ref. to sales document/project
SMPRF Simulation profile CHAR 7 0 TCN54 SIM_PROFIL
FLGVRG Indicator: Bottom-up calculation with activity dates CHAR 1 0 PS_FLGVRG
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 CHAR 1 0 GRONTOP
PGPRF Distribution profile CHAR 6 0 TPGPRF PGPROFID
STORT Location CHAR 10 0 T499S PS_STORT
LOGSYSTEM Logical System CHAR 10 0 * LOGSYSTEM
KZERB Indicator: Project summarization via master data charact. CHAR 1 0 PS_KZERB
PARGR Partner Determination Procedure CHAR 4 0 V_TVPG_S PARGR
FUNC_AREA Functional Area CHAR 16 0 TFKB FKBER
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVKOV VTWEG
SPART Division CHAR 2 0 TVTA SPART
DPPPROF Dynamic Item Processor Profile CHAR 8 0 AD01C_PROF AD01PROFNR
VPKSTU Node level NUMC 2 0 SEU_LEVEL
PSPID_EDIT Project Number (External) Edited CHAR 24 0 PS_PSPID_EDIT
VNAME Joint venture CHAR 6 0 T8JV JV_NAME
RECID Recovery Indicator CHAR 2 0 T8JJ JV_RECIND
ETYPE Equity type CHAR 3 0 T8JE JV_ETYPE
OTYPE Joint Venture Object Type CHAR 4 0 JV_OTYPE
JIBCL JIB/JIBE Class CHAR 3 0 T8J6A JV_JIBCL
JIBSA JIB/JIBE Subclass A CHAR 5 0 T8J6C JV_JIBSA
EEW_PROJ_PS_DUMMY Dummy function in length 1 CHAR 1 0 DUMMY
SCHTYP Scheduling scenario CHAR 1 0 PS_SCHED_TYPE
Free scheduling
1 Bottom-up scenario (pre-defined)
2 Top-down scenario (pre-defined)
SPROG Forecast start date of project definition DATS 8 0 PS_SPROG
EPROG Forecast finish date for project definition DATS 8 0 PS_EPROG
ORGKEY Project (internal) NUMC 8 0 * PS_INTNR
INCAT Version inactive indicator CHAR 1 0 VSINACT
PROJ_STATUS Status Combination INT1 3 0 ACTCMB_TAB ACTCMB_DELE
SLWID Key word ID for user-defined fields CHAR 7 0 TCN00 SLWID
USR00 User field with 20 characters CHAR 20 0 USRCHAR20
USR01 User field with 20 characters CHAR 20 0 USRCHAR20
USR02 User Field with 10 Characters CHAR 10 0 USRCHAR10
USR03 User Field with 10 Characters CHAR 10 0 USRCHAR10
USR04 User field for quantity (length 10.3) QUAN 13 3 USRQUAN13
USE04 User field: Unit for quantity fields UNIT 3 0 * USRUNIT
USR05 User field for quantity (length 10.3) QUAN 13 3 USRQUAN13
USE05 User field: Unit for quantity fields UNIT 3 0 * USRUNIT
USR06 User-defined field for values (length 10,3) CURR 13 3 USRCURR13
USE06 User field: Unit for value fields CUKY 5 0 TCURC USRCUKY
USR07 User-defined field for values (length 10,3) CURR 13 3 USRCURR13
USE07 User field: Unit for value fields CUKY 5 0 TCURC USRCUKY
USR08 User field for date DATS 8 0 USRDATE
USR09 User field for date DATS 8 0 USRDATE
USR10 User-defined field: Indicator for reports CHAR 1 0 USRFLAG
USR11 User-defined field: Indicator for reports CHAR 1 0 USRFLAG
CPD_UPDAT Time Stamp DEC 15 0 /CPD/PFP_SC_TSTMP
FERC_IND Regulatory indicator CHAR 4 0 FERC_C7 FE_IND
AVC_PROFILE Budget Availability Control: Profile CHAR 6 0 * FCO_AVC_PROFILE
AVC_ACTIVE Availability control indicator(AVC) CHAR 1 0 PS_S4_AVC_IND
CPCURR Custom Project Currency CUKY 5 0 * PS_S4_WAERS

VSPROJ_CN foreign key relationships

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