SAP table PROJS (Standard project definition)

SAP table PROJS has 2 primary key fields being MANDT,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
PSPNR Current number for standard project NUMC 8 0 PS_ISPSP
PSPID Project definition for standard project CHAR 24 0 PS_SPDID
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 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
PLSEZ Project planned finish date DATS 8 0 PS_PLSEZ
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 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
FLGWBS Scheduling method CHAR 1 0 PS_FLGWBS
WBS determines dates
X Network determines dates
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
FLGSD Indicator: New structure for each sales order item CHAR 1 0 PS_FLGSD
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 FKBER
VKORG Sales Organization CHAR 4 0 VKORG
VTWEG Distribution Channel CHAR 2 0 VTWEG
SPART Division CHAR 2 0 SPART
DPPPROF Dynamic Item Processor Profile CHAR 8 0 AD01PROFNR
VPKSTU Node level NUMC 2 0 SEU_LEVEL
SCHTYP Scheduling scenario CHAR 1 0 PS_SCHED_TYPE
Free scheduling
1 Bottom-up scenario (pre-defined)
2 Top-down scenario (pre-defined)
PSPID_EDIT Standard Project Number (Extern) Edited CHAR 24 0 PS_SPDID_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 T8JG 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
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

PROJS foreign key relationships

Table Field Check Table Check Field
0 PROJS ABGSL TKKAA Check Table for Results Analysis Key of RA for Orders MANDT
0 PROJS ABGSL TKKAA Check Table for Results Analysis Key of RA for Orders ABGSL
1 PROJS ASTNR TCJ05 Project applicant MANDT
0 PROJS BPROF TBP1C Budget/Plan Profile MANDT
0 PROJS BPROF TBP1C Budget/Plan Profile PROFIL
0 PROJS BPROF TBP1C Budget/Plan Profile APPLIK
0 PROJS BPROF TBP1C Budget/Plan Profile WRTTP
1 PROJS ETYPE T8JG Valid Investment Group MANDT
1 PROJS ETYPE T8JG Valid Investment Group BUKRS
1 PROJS ETYPE T8JG Valid Investment Group VNAME
1 PROJS ETYPE T8JG Valid Investment Group FDATE
0 PROJS FMPRF TBP1C Budget/Plan Profile MANDT
0 PROJS FMPRF TBP1C Budget/Plan Profile PROFIL
0 PROJS FMPRF TBP1C Budget/Plan Profile APPLIK
0 PROJS FMPRF TBP1C Budget/Plan Profile WRTTP
1 PROJS IMPRF TAPRF Cap. inv. measure profile for AuC and dep. simulation MANDT
1 PROJS IMPRF TAPRF Cap. inv. measure profile for AuC and dep. simulation IVPRO
0 PROJS JIBCL T8J6A JIB/JIBE Class MANDT
0 PROJS JIBCL T8J6A JIB/JIBE Class BUKRS
0 PROJS JIBCL T8J6A JIB/JIBE Class CLASS
1 PROJS JIBSA T8J6C JIB/JIBE Subclass MANDT
1 PROJS JIBSA T8J6C JIB/JIBE Subclass BUKRS
0 PROJS KOSTL CSKS Cost Center Master Record MANDT
0 PROJS KOSTL CSKS Cost Center Master Record KOKRS
0 PROJS KOSTL CSKS Cost Center Master Record KOSTL
0 PROJS KOSTL CSKS Cost Center Master Record DATBI
1 PROJS KTRG CKPH Master Record: Cost Object ID Number MANDT
1 PROJS KTRG CKPH Master Record: Cost Object ID Number KSTRG
1 PROJS KTRG CKPH Master Record: Cost Object ID Number DATBI
0 PROJS OBJNR ONR00 General Object Number MANDT
1 PROJS PARGR V_TVPG_S Generated Table for View MANDT
1 PROJS PARGR V_TVPG_S Generated Table for View PAOBJ
1 PROJS PARGR V_TVPG_S Generated Table for View SPRAS
0 PROJS PGPRF TPGPRF Profile for static pegging and data distribution PROFID
1 PROJS PLNAW TCA09 Task list applications MANDT
1 PROJS PLNAW TCA09 Task list applications PLNAW
0 PROJS PPROF TBP1C Budget/Plan Profile MANDT
0 PROJS PPROF TBP1C Budget/Plan Profile PROFIL
0 PROJS PPROF TBP1C Budget/Plan Profile APPLIK
0 PROJS PPROF TBP1C Budget/Plan Profile WRTTP
1 PROJS PROFL TCJ41 Default Values for Work Breakdown Structure MANDT
0 PROJS PWHIE TCURC Currency Codes MANDT
0 PROJS PWHIE TCURC Currency Codes WAERS
1 PROJS RECID T8JJ Recovery Indicator MANDT
1 PROJS RECID T8JJ Recovery Indicator BUKRS
0 PROJS SCPRF TCXPS Control parameters for WBS scheduling MANDT
0 PROJS SCPRF TCXPS Control parameters for WBS scheduling PROFIL
1 PROJS SLWID TCN00 Key Word ID for PS User Fields MANDT
0 PROJS SMPRF TCN54 Simualtion control MANDT
1 PROJS STORT T499S Location MANDT
1 PROJS STORT T499S Location WERKS
0 PROJS STSPD TJ20 Status profiles MANDT
0 PROJS STSPD TJ20 Status profiles STSMA
1 PROJS STSPR TJ20 Status profiles MANDT
1 PROJS STSPR TJ20 Status profiles STSMA
0 PROJS TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
0 PROJS TXJCD TTXJ Check Table for Tax Jurisdiction KALSM
1 PROJS TXTSP T002 Language Keys (Component BC-I18) SPRAS
0 PROJS USE06 TCURC Currency Codes MANDT
0 PROJS USE06 TCURC Currency Codes WAERS
1 PROJS USE07 TCURC Currency Codes MANDT
1 PROJS USE07 TCURC Currency Codes WAERS
0 PROJS VBUKR T001 Company Codes BUKRS
1 PROJS VERNR TCJ04 Person in Responsible for Project MANDT
1 PROJS VERNR TCJ04 Person in Responsible for Project VERNR
0 PROJS VGSBR TGSB Business Areas MANDT
0 PROJS VGSBR TGSB Business Areas GSBER
1 PROJS VKOKR TKA01 Controlling Areas MANDT
0 PROJS VNAME T8JV Joint Venture MANDT
0 PROJS VNAME T8JV Joint Venture BUKRS
0 PROJS VNAME T8JV Joint Venture VNAME
1 PROJS VPROF TCN41 Network Defaults MANDT
1 PROJS VPROF TCN41 Network Defaults PLNAW
0 PROJS WERKS T001W Plants/Branches MANDT
0 PROJS WERKS T001W Plants/Branches WERKS
1 PROJS ZSCHM TPI01 Interest Profile MANDT
0 PROJS ZTEHT T006 Units of Measurement MANDT
0 PROJS ZTEHT T006 Units of Measurement MSEHI