SAP Table

PROJS Standard project definition

SAP table PROJS has 2 primary key fields being MANDT,PSPNR.

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

PROJS columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyPSPNR Current number for standard project NUMC 8 0 PS_ISPSP
PSPID Project definition for standard project CHAR 24 0 PS_SPDID
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 PRCTR
PWHIE WBS currency (project definition) CUKY 5 0 TCURC PS_PWHIE
ZUORD Network assignment NUMC 1 0 PS_ZUORD
TRMEQ Indicator: WBS dates detailed by activity dates CHAR 1 0 PS_TRMEQ
PLFAZ Project planned start date DATS 8 0 PS_PLFAZ
PLSEZ Project planned finish date DATS 8 0 PS_PLSEZ
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 PS_ISPSP
BESTA Project stock CHAR 1 0 PS_BESTAND
SCOPE Object Class CHAR 2 0 SCOPE_CV
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
SMPRF Simulation profile CHAR 7 0 TCN54 SIM_PROFIL
FLGWBS Scheduling method CHAR 1 0 PS_FLGWBS
FLGVRG Indicator: Bottom-up calculation with activity dates CHAR 1 0 PS_FLGVRG
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
FLGSD Indicator: New structure for each sales order item CHAR 1 0 PS_FLGSD
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 FKBER
VKORG Sales Organization CHAR 4 0 VKORG
VTWEG Distribution Channel CHAR 2 0 VTWEG
SPART Division CHAR 2 0 SPART
DPPPROF Dynamic Item Processor Profile CHAR 8 0 AD01PROFNR
VPKSTU Node level NUMC 2 0 SEU_LEVEL
SCHTYP Scheduling scenario CHAR 1 0 PS_SCHED_TYPE
PSPID_EDIT Standard Project Number (Extern) Edited CHAR 24 0 PS_SPDID_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 T8JG 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
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
/ Relationships

PROJS foreign keys.

Table Field Check Table Description Check Field
PROJS ABGSL TKKAA Check Table for Results Analysis Key of RA for Orders MANDT
PROJS ABGSL TKKAA Check Table for Results Analysis Key of RA for Orders ABGSL
PROJS ASTNR TCJ05 Project applicant MANDT
PROJS BPROF TBP1C Budget/Plan Profile MANDT
PROJS BPROF TBP1C Budget/Plan Profile PROFIL
PROJS BPROF TBP1C Budget/Plan Profile APPLIK
PROJS BPROF TBP1C Budget/Plan Profile WRTTP
PROJS ETYPE T8JG Valid Investment Group MANDT
PROJS ETYPE T8JG Valid Investment Group BUKRS
PROJS ETYPE T8JG Valid Investment Group VNAME
PROJS ETYPE T8JG Valid Investment Group FDATE
PROJS FMPRF TBP1C Budget/Plan Profile MANDT
PROJS FMPRF TBP1C Budget/Plan Profile PROFIL
PROJS FMPRF TBP1C Budget/Plan Profile APPLIK
PROJS FMPRF TBP1C Budget/Plan Profile WRTTP
PROJS IMPRF TAPRF Cap. inv. measure profile for AuC and dep. simulation MANDT
PROJS IMPRF TAPRF Cap. inv. measure profile for AuC and dep. simulation IVPRO
PROJS JIBCL T8J6A JIB/JIBE Class MANDT
PROJS JIBCL T8J6A JIB/JIBE Class BUKRS
PROJS JIBCL T8J6A JIB/JIBE Class CLASS
PROJS JIBSA T8J6C JIB/JIBE Subclass MANDT
PROJS JIBSA T8J6C JIB/JIBE Subclass BUKRS
PROJS KOSTL CSKS Cost Center Master Record MANDT
PROJS KOSTL CSKS Cost Center Master Record KOKRS
PROJS KOSTL CSKS Cost Center Master Record KOSTL
PROJS KOSTL CSKS Cost Center Master Record DATBI
PROJS KTRG CKPH Master Record: Cost Object ID Number MANDT
PROJS KTRG CKPH Master Record: Cost Object ID Number KSTRG
PROJS KTRG CKPH Master Record: Cost Object ID Number DATBI
PROJS OBJNR ONR00 General Object Number MANDT
PROJS PARGR V_TVPG_S Generated Table for View MANDT
PROJS PARGR V_TVPG_S Generated Table for View PAOBJ
PROJS PARGR V_TVPG_S Generated Table for View SPRAS
PROJS PGPRF TPGPRF Profile for static pegging and data distribution PROFID
PROJS PLNAW TCA09 Task list applications MANDT
PROJS PLNAW TCA09 Task list applications PLNAW
PROJS PPROF TBP1C Budget/Plan Profile MANDT
PROJS PPROF TBP1C Budget/Plan Profile PROFIL
PROJS PPROF TBP1C Budget/Plan Profile APPLIK
PROJS PPROF TBP1C Budget/Plan Profile WRTTP
PROJS PROFL TCJ41 Default Values for Work Breakdown Structure MANDT
PROJS PWHIE TCURC Currency Codes MANDT
PROJS PWHIE TCURC Currency Codes WAERS
PROJS RECID T8JJ Recovery Indicator MANDT
PROJS RECID T8JJ Recovery Indicator BUKRS
PROJS SCPRF TCXPS Control parameters for WBS scheduling MANDT
PROJS SCPRF TCXPS Control parameters for WBS scheduling PROFIL
PROJS SLWID TCN00 Key Word ID for PS User Fields MANDT
PROJS SMPRF TCN54 Simualtion control MANDT
PROJS STORT T499S Location MANDT
PROJS STORT T499S Location WERKS
PROJS STSPD TJ20 Status profiles MANDT
PROJS STSPD TJ20 Status profiles STSMA
PROJS STSPR TJ20 Status profiles MANDT
PROJS STSPR TJ20 Status profiles STSMA
PROJS TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
PROJS TXJCD TTXJ Check Table for Tax Jurisdiction KALSM
PROJS TXTSP T002 Language Keys (Component BC-I18) SPRAS
PROJS USE06 TCURC Currency Codes MANDT
PROJS USE06 TCURC Currency Codes WAERS
PROJS USE07 TCURC Currency Codes MANDT
PROJS USE07 TCURC Currency Codes WAERS
PROJS VBUKR T001 Company Codes BUKRS
PROJS VERNR TCJ04 Person in Responsible for Project MANDT
PROJS VERNR TCJ04 Person in Responsible for Project VERNR
PROJS VGSBR TGSB Business Areas MANDT
PROJS VGSBR TGSB Business Areas GSBER
PROJS VKOKR TKA01 Controlling Areas MANDT
PROJS VNAME T8JV Joint Venture MANDT
PROJS VNAME T8JV Joint Venture BUKRS
PROJS VNAME T8JV Joint Venture VNAME
PROJS VPROF TCN41 Network Defaults MANDT
PROJS VPROF TCN41 Network Defaults PLNAW
PROJS WERKS T001W Plants/Branches MANDT
PROJS WERKS T001W Plants/Branches WERKS
PROJS ZSCHM TPI01 Interest Profile MANDT
PROJS ZTEHT T006 Units of Measurement MANDT
PROJS ZTEHT T006 Units of Measurement MSEHI