SAP table reference

PROJS

Standard project definition

Explore another table

Enter a table code or keyword to continue exploring.

Explore the structure, fields and relationships of SAP table PROJS.

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

When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.

/ Fields

PROJS fields.

101 fields
FieldDescriptionData typeLengthDecimalsCheck tableData element
Key MANDT ClientCLNT30 T000 MANDT
Key PSPNR Current number for standard projectNUMC80 PS_ISPSP
PSPID Project definition for standard projectCHAR240 PS_SPDID
POST1 PS: Short description (1st text line)CHAR400 PS_POST1
OBJNR Object numberCHAR220 ONR00 J_OBJNR
ERNAM Name of Person Responsible for Creating the ObjectCHAR120 ERNAM
ERDAT Date on which the record was createdDATS80 ERDAT
AENAM Name of Person Who Changed ObjectCHAR120 AENAM
AEDAT Date on which object was last changedDATS80 UPDAT
KIMSK Selection mask for WBS element short IDsCHAR240 PS_KIMSK
AUTOD Automatic value transfer from WBS element to project def.CHAR10 PS_AUTOD
STSPD Status profile for project definitionCHAR80 TJ20 PS_STSPD
STSPR Status profile for WBS elementCHAR80 TJ20 PS_STSPR
VERNR Number of the Responsible Person (Project Manager)NUMC80 TCJ04 PS_VERNR
VERNA Name of responsible person (Project manager)CHAR250 PS_VERNA
ASTNR Applicant numberNUMC80 TCJ05 PS_ASTNR
ASTNA ApplicantCHAR250 PS_ASTNA
VBUKR Company code for the projectCHAR40 T001 PS_VBUKR
VGSBR Business area for the projectCHAR40 TGSB PS_VGSBR
VKOKR Controlling area for the projectCHAR40 TKA01 PS_VKOKR
PRCTR Profit CenterCHAR100 PRCTR
PWHIE WBS currency (project definition)CUKY50 TCURC PS_PWHIE
ZUORD Network assignmentNUMC10 PS_ZUORD
TRMEQ Indicator: WBS dates detailed by activity datesCHAR10 PS_TRMEQ
PLFAZ Project planned start dateDATS80 PS_PLFAZ
PLSEZ Project planned finish dateDATS80 PS_PLSEZ
WERKS PlantCHAR40 T001W WERKS_D
KALID Factory calendar keyCHAR20 TFACD FABKL
VGPLF Planning method for project basic datesNUMC10 PS_VGPLF
EWPLF Planning method for project forecast datesNUMC10 PS_EWPLF
ZTEHT Time unit in time schedulingUNIT30 T006 PS_ZTEHT
NZANZ Indicator: Network header visible to end userCHAR10 NETZOBERFL
PLNAW Application of the task listCHAR10 TCA09 PLNAW
VPROF Network ProfileCHAR70 TCN41 PROFIDNZPL
PROFL Project ProfileCHAR70 TCJ41 PROFIDPROJ
BPROF Budget ProfileCHAR60 TBP1C BP_BPROFIL
TXTSP Language KeyLANG10 T002 SPRAS
KOSTL Cost CenterCHAR100 CSKS KOSTL
KTRG Cost ObjectCHAR120 CKPH KSTRG
AEDTE Date of last scheduling of the overall network (basic dates)DATS80 PS_AEDTE
AEDTP Date of last scheduling of the overall network (forecast)DATS80 PS_AEDTP
BERST Authorization key for project master dataCHAR160 PS_BERST
BERTR Authorization key for project dates (WBS)CHAR160 PS_BERTR
BERKO Authorization key for costs and revenuesCHAR160 PS_BERKO
BERBU Authorization key for project budgetCHAR160 PS_BERBU
SPSNR Current number for standard projectNUMC80 PS_ISPSP
BESTA Project stockCHAR10 PS_BESTAND
SCOPE Object ClassCHAR20 SCOPE_CV
XSTAT Statistical WBS elementCHAR10 PS_XSTAT
TXJCD Tax JurisdictionCHAR150 TTXJ TXJCD
ZSCHM Interest Profile for Project/Order Interest CalculationCHAR70 TPI01 PS_ZSCHM
SCPRF Profile for WBS schedulingCHAR120 TCXPS PS_SCHDPRF
IMPRF Investment Measure ProfileCHAR60 TAPRF IM_PROFIL
FMPRF Payment plan profileCHAR60 TBP1C PSFM_PRF
ABGSL Results Analysis KeyCHAR60 TKKAA ABGR_SCHL
POSTU PS: Short description (1st text line) in all capsCHAR400 PS_POSTU
PPROF Planning ProfileCHAR60 TBP1C BP_PPROFIL
PLINT Indicator for Integrated PlanningCHAR10 PLINT
LOEVM Deletion IndicatorCHAR10 LOEVM
INACT Indicator: Project definition inactiveCHAR10 PS_INACT
KZBWS Valuation of Special StockCHAR10 KZBWS
SMPRF Simulation profileCHAR70 TCN54 SIM_PROFIL
FLGWBS Scheduling methodCHAR10 PS_FLGWBS
FLGVRG Indicator: Bottom-up calculation with activity datesCHAR10 PS_FLGVRG
GRTOP Indicator: Automatic requirements groupingCHAR10 GRONTOP
PGPRF Distribution profileCHAR60 TPGPRF PGPROFID
STORT LocationCHAR100 T499S PS_STORT
FLGSD Indicator: New structure for each sales order itemCHAR10 PS_FLGSD
KZERB Indicator: Project summarization via master data charact.CHAR10 PS_KZERB
PARGR Partner Determination ProcedureCHAR40 V_TVPG_S PARGR
FUNC_AREA Functional AreaCHAR160 FKBER
VKORG Sales OrganizationCHAR40 VKORG
VTWEG Distribution ChannelCHAR20 VTWEG
SPART DivisionCHAR20 SPART
DPPPROF Dynamic Item Processor ProfileCHAR80 AD01PROFNR
VPKSTU Node levelNUMC20 SEU_LEVEL
SCHTYP Scheduling scenarioCHAR10 PS_SCHED_TYPE
PSPID_EDIT Standard Project Number (Extern) EditedCHAR240 PS_SPDID_EDIT
VNAME Joint ventureCHAR60 T8JV JV_NAME
RECID Recovery IndicatorCHAR20 T8JJ JV_RECIND
ETYPE Equity typeCHAR30 T8JG JV_ETYPE
OTYPE Joint Venture Object TypeCHAR40 JV_OTYPE
JIBCL JIB/JIBE ClassCHAR30 T8J6A JV_JIBCL
JIBSA JIB/JIBE Subclass ACHAR50 T8J6C JV_JIBSA
SLWID Key word ID for user-defined fieldsCHAR70 TCN00 SLWID
USR00 User field with 20 charactersCHAR200 USRCHAR20
USR01 User field with 20 charactersCHAR200 USRCHAR20
USR02 User Field with 10 CharactersCHAR100 USRCHAR10
USR03 User Field with 10 CharactersCHAR100 USRCHAR10
USR04 User field for quantity (length 10.3)QUAN133 USRQUAN13
USE04 User field: Unit for quantity fieldsUNIT30 * USRUNIT
USR05 User field for quantity (length 10.3)QUAN133 USRQUAN13
USE05 User field: Unit for quantity fieldsUNIT30 * USRUNIT
USR06 User-defined field for values (length 10,3)CURR133 USRCURR13
USE06 User field: Unit for value fieldsCUKY50 TCURC USRCUKY
USR07 User-defined field for values (length 10,3)CURR133 USRCURR13
USE07 User field: Unit for value fieldsCUKY50 TCURC USRCUKY
USR08 User field for dateDATS80 USRDATE
USR09 User field for dateDATS80 USRDATE
USR10 User-defined field: Indicator for reportsCHAR10 USRFLAG
USR11 User-defined field: Indicator for reportsCHAR10 USRFLAG
/ Relationships

PROJS relationships.

78 relationships
TableFieldCheck tableDescriptionCheck field
PROJSABGSLTKKAACheck Table for Results Analysis Key of RA for OrdersMANDT
PROJSABGSLTKKAACheck Table for Results Analysis Key of RA for OrdersABGSL
PROJSASTNRTCJ05Project applicantMANDT
PROJSBPROFTBP1CBudget/Plan ProfileMANDT
PROJSBPROFTBP1CBudget/Plan ProfilePROFIL
PROJSBPROFTBP1CBudget/Plan ProfileAPPLIK
PROJSBPROFTBP1CBudget/Plan ProfileWRTTP
PROJSETYPET8JGValid Investment GroupMANDT
PROJSETYPET8JGValid Investment GroupBUKRS
PROJSETYPET8JGValid Investment GroupVNAME
PROJSETYPET8JGValid Investment GroupFDATE
PROJSFMPRFTBP1CBudget/Plan ProfileMANDT
PROJSFMPRFTBP1CBudget/Plan ProfilePROFIL
PROJSFMPRFTBP1CBudget/Plan ProfileAPPLIK
PROJSFMPRFTBP1CBudget/Plan ProfileWRTTP
PROJSIMPRFTAPRFCap. inv. measure profile for AuC and dep. simulationMANDT
PROJSIMPRFTAPRFCap. inv. measure profile for AuC and dep. simulationIVPRO
PROJSJIBCLT8J6AJIB/JIBE ClassMANDT
PROJSJIBCLT8J6AJIB/JIBE ClassBUKRS
PROJSJIBCLT8J6AJIB/JIBE ClassCLASS
PROJSJIBSAT8J6CJIB/JIBE SubclassMANDT
PROJSJIBSAT8J6CJIB/JIBE SubclassBUKRS
PROJSKOSTLCSKSCost Center Master RecordMANDT
PROJSKOSTLCSKSCost Center Master RecordKOKRS
PROJSKOSTLCSKSCost Center Master RecordKOSTL
PROJSKOSTLCSKSCost Center Master RecordDATBI
PROJSKTRGCKPHMaster Record: Cost Object ID NumberMANDT
PROJSKTRGCKPHMaster Record: Cost Object ID NumberKSTRG
PROJSKTRGCKPHMaster Record: Cost Object ID NumberDATBI
PROJSOBJNRONR00General Object NumberMANDT
PROJSPARGRV_TVPG_SGenerated Table for ViewMANDT
PROJSPARGRV_TVPG_SGenerated Table for ViewPAOBJ
PROJSPARGRV_TVPG_SGenerated Table for ViewSPRAS
PROJSPGPRFTPGPRFProfile for static pegging and data distributionPROFID
PROJSPLNAWTCA09Task list applicationsMANDT
PROJSPLNAWTCA09Task list applicationsPLNAW
PROJSPPROFTBP1CBudget/Plan ProfileMANDT
PROJSPPROFTBP1CBudget/Plan ProfilePROFIL
PROJSPPROFTBP1CBudget/Plan ProfileAPPLIK
PROJSPPROFTBP1CBudget/Plan ProfileWRTTP
PROJSPROFLTCJ41Default Values for Work Breakdown StructureMANDT
PROJSPWHIETCURCCurrency CodesMANDT
PROJSPWHIETCURCCurrency CodesWAERS
PROJSRECIDT8JJRecovery IndicatorMANDT
PROJSRECIDT8JJRecovery IndicatorBUKRS
PROJSSCPRFTCXPSControl parameters for WBS schedulingMANDT
PROJSSCPRFTCXPSControl parameters for WBS schedulingPROFIL
PROJSSLWIDTCN00Key Word ID for PS User FieldsMANDT
PROJSSMPRFTCN54Simualtion controlMANDT
PROJSSTORTT499SLocationMANDT
PROJSSTORTT499SLocationWERKS
PROJSSTSPDTJ20Status profilesMANDT
PROJSSTSPDTJ20Status profilesSTSMA
PROJSSTSPRTJ20Status profilesMANDT
PROJSSTSPRTJ20Status profilesSTSMA
PROJSTXJCDTTXJCheck Table for Tax JurisdictionMANDT
PROJSTXJCDTTXJCheck Table for Tax JurisdictionKALSM
PROJSTXTSPT002Language Keys (Component BC-I18)SPRAS
PROJSUSE06TCURCCurrency CodesMANDT
PROJSUSE06TCURCCurrency CodesWAERS
PROJSUSE07TCURCCurrency CodesMANDT
PROJSUSE07TCURCCurrency CodesWAERS
PROJSVBUKRT001Company CodesBUKRS
PROJSVERNRTCJ04Person in Responsible for ProjectMANDT
PROJSVERNRTCJ04Person in Responsible for ProjectVERNR
PROJSVGSBRTGSBBusiness AreasMANDT
PROJSVGSBRTGSBBusiness AreasGSBER
PROJSVKOKRTKA01Controlling AreasMANDT
PROJSVNAMET8JVJoint VentureMANDT
PROJSVNAMET8JVJoint VentureBUKRS
PROJSVNAMET8JVJoint VentureVNAME
PROJSVPROFTCN41Network DefaultsMANDT
PROJSVPROFTCN41Network DefaultsPLNAW
PROJSWERKST001WPlants/BranchesMANDT
PROJSWERKST001WPlants/BranchesWERKS
PROJSZSCHMTPI01Interest ProfileMANDT
PROJSZTEHTT006Units of MeasurementMANDT
PROJSZTEHTT006Units of MeasurementMSEHI