1. Home
  2. Resources
  3. SAP Tables
  4. PROJS - Standard project definition

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
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
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 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 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
FLGWBS Scheduling method PS_FLGWBS CHAR 1 0
NULL WBS determines dates
X Network determines dates
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
FLGSD Indicator: New structure for each sales order item PS_FLGSD CHAR 1 0
X Yes
NULL No
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 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
1 Bottom-up scenario (pre-defined)
2 Top-down scenario (pre-defined)
NULL Free scheduling
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 ABGSL TKKAA Check Table for Results Analysis Key of RA for Orders ABGSL
PROJS ABGSL PROJS MANDT TKKAA Check Table for Results Analysis Key of RA for Orders MANDT
PROJS ASTNR PROJS MANDT TCJ05 Project applicant MANDT
PROJS ASTNR PROJS ASTNR TCJ05 Project applicant ASTNR
PROJS BPROF 'P' TBP1C Budget/Plan Profile APPLIK
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 ETYPE * T8JG Valid Investment Group FDATE
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 FMPRF '62' TBP1C Budget/Plan Profile WRTTP
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 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 SYST MANDT T8J6A JIB/JIBE Class MANDT
PROJS JIBCL PROJS VBUKR T8J6A JIB/JIBE Class BUKRS
PROJS JIBCL PROJS JIBCL T8J6A JIB/JIBE Class CLASS
PROJS JIBSA PROJS JIBSA T8J6C JIB/JIBE Subclass SUBCLASS
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 KALID PROJS KALID TFACD Factory calendar definition IDENT
PROJS KOSTL PROJS VKOKR CSKS Cost Center Master Data KOKRS
PROJS KOSTL PROJS KOSTL CSKS Cost Center Master Data KOSTL
PROJS KOSTL PROJS PLSEZ CSKS Cost Center Master Data DATBI
PROJS KOSTL PROJS MANDT CSKS Cost Center Master Data MANDT
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 * V_TVPG_S Generated Table for View SPRAS
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 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 MANDT TCJ41 Default Values for Work Breakdown Structure MANDT
PROJS PROFL PROJS PROFL TCJ41 Default Values for Work Breakdown Structure PROFIDPROJ
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 SCPRF TCXPS Control parameters for WBS scheduling PROFIL
PROJS SCPRF PROJS MANDT TCXPS Control parameters for WBS scheduling MANDT
PROJS SMPRF PROJS MANDT TCN54 Simualtion control MANDT
PROJS SMPRF PROJS SMPRF TCN54 Simualtion control VER_PROFIL
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 MANDT TJ20 Status profiles MANDT
PROJS STSPR PROJS STSPR TJ20 Status profiles STSMA
PROJS TXJCD PROJS MANDT TTXJ Check Table for Tax Jurisdiction MANDT
PROJS TXJCD T005 KALSM TTXJ Check Table for Tax Jurisdiction KALSM
PROJS TXJCD PROJS TXJCD TTXJ Check Table for Tax Jurisdiction TXJCD
PROJS TXTSP PROJS TXTSP T002 Language Keys (Component BC-I18) SPRAS
PROJS VBUKR PROJS MANDT T001 Company Codes MANDT
PROJS VBUKR PROJS VBUKR T001 Company Codes BUKRS
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 PROJS VBUKR T8JV Joint Venture BUKRS
PROJS VNAME PROJS VNAME T8JV Joint Venture VNAME
PROJS VNAME SYST MANDT T8JV Joint Venture MANDT
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 MANDT T006 Units of Measurement MANDT
PROJS ZTEHT PROJS ZTEHT T006 Units of Measurement MSEHI