SAP table PROJ (Project definition)

SAP table PROJ 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 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
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 FINSC_AVC_PROF 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

PROJ foreign key relationships

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