1. Home
  2. Resources
  3. SAP Tables
  4. PROJ - Project definition

SAP Table PROJ

Project definition

PROJ (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 PROJ to other SAP tables.

PROJ table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 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
CPD_UPDAT Time Stamp /CPD/PFP_TSTMP DEC 15 0
FERC_IND Regulatory indicator FE_IND FERC_C7 CHAR 4 0
PROJ_STATUS Status Combination ACTCMB_DELE ACTCMB_TAB INT1 3 0

PROJ foreign key relationships

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