Follow us on LinkedIn for your next SAP project

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 Possible values
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
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
TRMEQ
Indicator: WBS dates detailed by activity dates
PS_TRMEQ
CHAR
1 0
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
EWPLF
Planning method for project forecast dates
PS_EWPLF
NUMC
1 0
ZTEHT
Time unit in time scheduling
PS_ZTEHT T006
UNIT
3 0
NZANZ
Indicator: Network header visible to end user
NETZOBERFL
CHAR
1 0
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
SCOPE
Object Class
SCOPE_CV
CHAR
2 0
XSTAT
Statistical WBS element
PS_XSTAT
CHAR
1 0
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
LOEVM
Deletion Indicator
LOEVM
CHAR
1 0
INACT
Indicator: Project definition inactive
PS_INACT
CHAR
1 0
KZBWS
Valuation of Special Stock
KZBWS
CHAR
1 0
SMPRF
Simulation profile
SIM_PROFIL TCN54
CHAR
7 0
FLGVRG
Indicator: Bottom-up calculation with activity dates
PS_FLGVRG
CHAR
1 0
GRTOP
Indicator: Automatic requirements grouping
GRONTOP
CHAR
1 0
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
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
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