SAP Table PROJS
Standard project definition
PROJS (Standard 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 PROJS to other SAP tables.
PROJS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
PSPNR
Current number for standard project
|
PS_ISPSP |
NUMC
|
8 | 0 | ||||||||||||
|
PSPID
Project definition for standard project
|
PS_SPDID |
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 |
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 |
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 | |||||||||||
|
FLGWBS
Scheduling method
|
PS_FLGWBS |
CHAR
|
1 | 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 | |||||||||||
|
FLGSD
Indicator: New structure for each sales order item
|
PS_FLGSD |
CHAR
|
1 | 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 |
CHAR
|
16 | 0 | ||||||||||||
|
VKORG
Sales Organization
|
VKORG |
CHAR
|
4 | 0 | ||||||||||||
|
VTWEG
Distribution Channel
|
VTWEG |
CHAR
|
2 | 0 | ||||||||||||
|
SPART
Division
|
SPART |
CHAR
|
2 | 0 | ||||||||||||
|
DPPPROF
Dynamic Item Processor Profile
|
AD01PROFNR |
CHAR
|
8 | 0 | ||||||||||||
|
VPKSTU
Node level
|
SEU_LEVEL |
NUMC
|
2 | 0 | ||||||||||||
|
SCHTYP
Scheduling scenario
|
PS_SCHED_TYPE |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
PSPID_EDIT
Standard Project Number (Extern) Edited
|
PS_SPDID_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 | T8JG |
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 | |||||||||||
PROJS foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| PROJS | ABGSL | PROJS | MANDT |
TKKAA
Check Table for Results Analysis Key of RA for Orders
|
MANDT |
| PROJS | ABGSL | PROJS | ABGSL |
TKKAA
Check Table for Results Analysis Key of RA for Orders
|
ABGSL |
| PROJS | ASTNR | PROJS | MANDT |
TCJ05
Project applicant
|
MANDT |
| PROJS | ASTNR | PROJS | ASTNR |
TCJ05
Project applicant
|
ASTNR |
| PROJS | BPROF | '41' |
TBP1C
Budget/Plan Profile
|
WRTTP | |
| PROJS | BPROF | PROJS | MANDT |
TBP1C
Budget/Plan Profile
|
MANDT |
| PROJS | BPROF | PROJS | BPROF |
TBP1C
Budget/Plan Profile
|
PROFIL |
| PROJS | BPROF | 'P' |
TBP1C
Budget/Plan Profile
|
APPLIK | |
| PROJS | ETYPE | SYST | MANDT |
T8JG
Valid Investment Group
|
MANDT |
| PROJS | ETYPE | PROJS | VBUKR |
T8JG
Valid Investment Group
|
BUKRS |
| PROJS | ETYPE | PROJS | VNAME |
T8JG
Valid Investment Group
|
VNAME |
| PROJS | ETYPE | PROJS | ETYPE |
T8JG
Valid Investment Group
|
ETYPE |
| PROJS | ETYPE | * |
T8JG
Valid Investment Group
|
FDATE | |
| PROJS | FMPRF | PROJS | MANDT |
TBP1C
Budget/Plan Profile
|
MANDT |
| PROJS | FMPRF | PROJS | FMPRF |
TBP1C
Budget/Plan Profile
|
PROFIL |
| PROJS | FMPRF | 'P' |
TBP1C
Budget/Plan Profile
|
APPLIK | |
| PROJS | FMPRF | '62' |
TBP1C
Budget/Plan Profile
|
WRTTP | |
| PROJS | IMPRF | PROJS | MANDT |
TAPRF
Cap. inv. measure profile for AuC and dep. simulation
|
MANDT |
| PROJS | IMPRF | PROJS | IMPRF |
TAPRF
Cap. inv. measure profile for AuC and dep. simulation
|
IVPRO |
| PROJS | JIBCL | PROJS | JIBCL |
T8J6A
JIB/JIBE Class
|
CLASS |
| PROJS | JIBCL | SYST | MANDT |
T8J6A
JIB/JIBE Class
|
MANDT |
| PROJS | JIBCL | PROJS | VBUKR |
T8J6A
JIB/JIBE Class
|
BUKRS |
| PROJS | JIBSA | SYST | MANDT |
T8J6C
JIB/JIBE Subclass
|
MANDT |
| PROJS | JIBSA | PROJS | VBUKR |
T8J6C
JIB/JIBE Subclass
|
BUKRS |
| PROJS | JIBSA | PROJS | JIBCL |
T8J6C
JIB/JIBE Subclass
|
CLASS |
| PROJS | JIBSA | PROJS | JIBSA |
T8J6C
JIB/JIBE Subclass
|
SUBCLASS |
| PROJS | KALID | PROJS | KALID |
TFACD
Factory calendar definition
|
IDENT |
| PROJS | KOSTL | PROJS | PLSEZ |
CSKS
Cost Center Master Data
|
DATBI |
| PROJS | KOSTL | PROJS | MANDT |
CSKS
Cost Center Master Data
|
MANDT |
| PROJS | KOSTL | PROJS | VKOKR |
CSKS
Cost Center Master Data
|
KOKRS |
| PROJS | KOSTL | PROJS | KOSTL |
CSKS
Cost Center Master Data
|
KOSTL |
| PROJS | KTRG | PROJS | MANDT |
CKPH
Master Record: Cost Object ID Number
|
MANDT |
| PROJS | KTRG | PROJS | KTRG |
CKPH
Master Record: Cost Object ID Number
|
KSTRG |
| PROJS | KTRG | PROJS | PLSEZ |
CKPH
Master Record: Cost Object ID Number
|
DATBI |
| PROJS | MANDT | PROJS | MANDT |
T000
Clients
|
MANDT |
| PROJS | OBJNR | PROJS | MANDT |
ONR00
General Object Number
|
MANDT |
| PROJS | OBJNR | PROJS | OBJNR |
ONR00
General Object Number
|
OBJNR |
| PROJS | PARGR | PROJS | MANDT |
V_TVPG_S
Generated Table for View
|
MANDT |
| PROJS | PARGR | PROJS | PARGR |
V_TVPG_S
Generated Table for View
|
PARGR |
| PROJS | PARGR | * |
V_TVPG_S
Generated Table for View
|
PAOBJ | |
| PROJS | PARGR | * |
V_TVPG_S
Generated Table for View
|
SPRAS | |
| PROJS | PGPRF | PROJS | MANDT |
TPGPRF
Profile for static pegging and data distribution
|
MANDT |
| PROJS | PGPRF | PROJS | PGPRF |
TPGPRF
Profile for static pegging and data distribution
|
PROFID |
| PROJS | PLNAW | PROJS | MANDT |
TCA09
Task list applications
|
MANDT |
| PROJS | PLNAW | PROJS | PLNAW |
TCA09
Task list applications
|
PLNAW |
| PROJS | PPROF | PROJS | MANDT |
TBP1C
Budget/Plan Profile
|
MANDT |
| PROJS | PPROF | PROJS | PPROF |
TBP1C
Budget/Plan Profile
|
PROFIL |
| PROJS | PPROF | 'P' |
TBP1C
Budget/Plan Profile
|
APPLIK | |
| PROJS | PPROF | '01' |
TBP1C
Budget/Plan Profile
|
WRTTP | |
| PROJS | PROFL | PROJS | PROFL |
TCJ41
Default Values for Work Breakdown Structure
|
PROFIDPROJ |
| PROJS | PROFL | PROJS | MANDT |
TCJ41
Default Values for Work Breakdown Structure
|
MANDT |
| PROJS | PWHIE | PROJS | MANDT |
TCURC
Currency Codes
|
MANDT |
| PROJS | PWHIE | PROJS | PWHIE |
TCURC
Currency Codes
|
WAERS |
| PROJS | RECID | SYST | MANDT |
T8JJ
Recovery Indicator
|
MANDT |
| PROJS | RECID | PROJS | VBUKR |
T8JJ
Recovery Indicator
|
BUKRS |
| PROJS | RECID | PROJS | RECID |
T8JJ
Recovery Indicator
|
RECID |
| PROJS | SCPRF | PROJS | MANDT |
TCXPS
Control parameters for WBS scheduling
|
MANDT |
| PROJS | SCPRF | PROJS | SCPRF |
TCXPS
Control parameters for WBS scheduling
|
PROFIL |
| PROJS | SMPRF | PROJS | SMPRF |
TCN54
Simualtion control
|
VER_PROFIL |
| PROJS | SMPRF | PROJS | MANDT |
TCN54
Simualtion control
|
MANDT |
| PROJS | STORT | SYST | MANDT |
T499S
Location
|
MANDT |
| PROJS | STORT | PROJS | WERKS |
T499S
Location
|
WERKS |
| PROJS | STORT | PROJS | STORT |
T499S
Location
|
STAND |
| PROJS | STSPD | PROJS | MANDT |
TJ20
Status profiles
|
MANDT |
| PROJS | STSPD | PROJS | STSPD |
TJ20
Status profiles
|
STSMA |
| PROJS | STSPR | PROJS | STSPR |
TJ20
Status profiles
|
STSMA |
| PROJS | STSPR | PROJS | MANDT |
TJ20
Status profiles
|
MANDT |
| PROJS | TXJCD | PROJS | TXJCD |
TTXJ
Check Table for Tax Jurisdiction
|
TXJCD |
| PROJS | TXJCD | PROJS | MANDT |
TTXJ
Check Table for Tax Jurisdiction
|
MANDT |
| PROJS | TXJCD | T005 | KALSM |
TTXJ
Check Table for Tax Jurisdiction
|
KALSM |
| PROJS | TXTSP | PROJS | TXTSP |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| PROJS | VBUKR | PROJS | VBUKR |
T001
Company Codes
|
BUKRS |
| PROJS | VBUKR | PROJS | MANDT |
T001
Company Codes
|
MANDT |
| PROJS | VERNR | PROJS | MANDT |
TCJ04
Person in Responsible for Project
|
MANDT |
| PROJS | VERNR | PROJS | VERNR |
TCJ04
Person in Responsible for Project
|
VERNR |
| PROJS | VGSBR | PROJS | MANDT |
TGSB
Business Areas
|
MANDT |
| PROJS | VGSBR | PROJS | VGSBR |
TGSB
Business Areas
|
GSBER |
| PROJS | VKOKR | PROJS | MANDT |
TKA01
Controlling Areas
|
MANDT |
| PROJS | VKOKR | PROJS | VKOKR |
TKA01
Controlling Areas
|
KOKRS |
| PROJS | VNAME | SYST | MANDT |
T8JV
Joint Venture
|
MANDT |
| PROJS | VNAME | PROJS | VBUKR |
T8JV
Joint Venture
|
BUKRS |
| PROJS | VNAME | PROJS | VNAME |
T8JV
Joint Venture
|
VNAME |
| PROJS | VPROF | PROJS | MANDT |
TCN41
Network Defaults
|
MANDT |
| PROJS | VPROF | PROJS | PLNAW |
TCN41
Network Defaults
|
PLNAW |
| PROJS | VPROF | PROJS | VPROF |
TCN41
Network Defaults
|
PROFIDNETZ |
| PROJS | WERKS | PROJS | MANDT |
T001W
Plants/Branches
|
MANDT |
| PROJS | WERKS | PROJS | WERKS |
T001W
Plants/Branches
|
WERKS |
| PROJS | ZSCHM | PROJS | MANDT |
TPI01
Interest Profile
|
MANDT |
| PROJS | ZSCHM | PROJS | ZSCHM |
TPI01
Interest Profile
|
ZSCHM |
| PROJS | ZTEHT | PROJS | ZTEHT |
T006
Units of Measurement
|
MSEHI |
| PROJS | ZTEHT | PROJS | MANDT |
T006
Units of Measurement
|
MANDT |