PROJ table in SAP ERP or S/4HANA stores Project definition data. There are total 109 fields in PROJ table. The Project definition table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of PROJ table. It is in Operative Work Breakdown Structure (CN_PSP_OPR) ABAP package and is part of the Operative Structures (PS-ST-OPR) module.
SAP PROJ Table Fields
Following is the list of fields that are available in SAP PROJ table. The primary key fields of Project definition table in SAP are MANDT (Client), PSPNR (Project (internal)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT(3) |
| PSPNR | Project (internal) | PS_INTNR | NUMC(8) | |
| PSPID | Project definition | PS_PSPID | CHAR(24) | |
| POST1 | PS: Short description (1st text line) | PS_POST1 | CHAR(40) | |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR(22) |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR(12) | |
| ERDAT | Date on which the record was created | ERDAT | DATS(8) | |
| AENAM | Name of person who changed object | AENAM | CHAR(12) | |
| AEDAT | Date on which object was last changed | UPDAT | DATS(8) | |
| KIMSK | Selection mask for WBS element short IDs | PS_KIMSK | CHAR(24) | |
| AUTOD | Automatic value transfer from WBS element to project def. | PS_AUTOD | CHAR(1) | |
| STSPD | Status profile for project definition | PS_STSPD | TJ20 | CHAR(8) |
| STSPR | Status profile for WBS element | PS_STSPR | TJ20 | CHAR(8) |
| VERNR | Number of the Responsible Person (Project Manager) | PS_VERNR | TCJ04 | NUMC(8) |
| VERNA | Name of responsible person (Project manager) | PS_VERNA | CHAR(25) | |
| ASTNR | Applicant number | PS_ASTNR | TCJ05 | NUMC(8) |
| ASTNA | Applicant | PS_ASTNA | CHAR(25) | |
| VBUKR | Company code for the project | PS_VBUKR | T001 | CHAR(4) |
| VGSBR | Business area for the project | PS_VGSBR | TGSB | CHAR(4) |
| VKOKR | Controlling area for the project | PS_VKOKR | TKA01 | CHAR(4) |
| PRCTR | Profit Center | PRCTR | CEPC | CHAR(10) |
| PWHIE | WBS currency (project definition) | PS_PWHIE | TCURC | CUKY(5) |
| ZUORD | Network assignment | PS_ZUORD | NUMC(1) | |
| TRMEQ | Indicator: WBS dates detailed by activity dates | PS_TRMEQ | CHAR(1) | |
| PLFAZ | Project planned start date | PS_PLFAZ_CHG | DATS(8) | |
| PLSEZ | Project planned finish date | PS_PLSEZ_CHG | DATS(8) | |
| WERKS | Plant | WERKS_D | T001W | CHAR(4) |
| KALID | Factory calendar key | FABKL | TFACD | CHAR(2) |
| VGPLF | Planning method for project basic dates | PS_VGPLF | NUMC(1) | |
| EWPLF | Planning method for project forecast dates | PS_EWPLF | NUMC(1) | |
| ZTEHT | Time unit in time scheduling | PS_ZTEHT | T006 | UNIT(3) |
| NZANZ | Indicator: Network header visible to end user | NETZOBERFL | CHAR(1) | |
| PLNAW | Application of the task list | PLNAW | TCA09 | CHAR(1) |
| VPROF | Network Profile | PROFIDNZPL | TCN41 | CHAR(7) |
| PROFL | Project Profile | PROFIDPROJ | TCJ41 | CHAR(7) |
| BPROF | Budget Profile | BP_BPROFIL | TBP1C | CHAR(6) |
| TXTSP | Language Key | SPRAS | T002 | LANG(1) |
| KOSTL | Cost Center | KOSTL | CSKS | CHAR(10) |
| KTRG | Cost Object | KSTRG | CKPH | CHAR(12) |
| AEDTE | Date of last scheduling of the overall network (basic dates) | PS_AEDTE | DATS(8) | |
| AEDTP | Date of last scheduling of the overall network (forecast) | PS_AEDTP | DATS(8) | |
| BERST | Authorization key for project master data | PS_BERST | CHAR(16) | |
| BERTR | Authorization key for project dates (WBS) | PS_BERTR | CHAR(16) | |
| BERKO | Authorization key for costs and revenues | PS_BERKO | CHAR(16) | |
| BERBU | Authorization key for project budget | PS_BERBU | CHAR(16) | |
| SPSNR | Current number for standard project | PS_ISPSP | PROJS | NUMC(8) |
| BESTA | Project stock | PS_BESTAND | CHAR(1) | |
| SCOPE | Object Class | SCOPE_CV | CHAR(2) | |
| XSTAT | Statistical WBS element | PS_XSTAT | CHAR(1) | |
| TXJCD | Tax Jurisdiction | TXJCD | TTXJ | CHAR(15) |
| ZSCHM | Interest Profile for Project/Order Interest Calculation | PS_ZSCHM | TPI01 | CHAR(7) |
| SCPRF | Profile for WBS scheduling | PS_SCHDPRF | TCXPS | CHAR(12) |
| IMPRF | Investment Measure Profile | IM_PROFIL | TAPRF | CHAR(6) |
| FMPRF | Payment plan profile | PSFM_PRF | TBP1C | CHAR(6) |
| ABGSL | Results Analysis Key | ABGR_SCHL | TKKAA | CHAR(6) |
| POSTU | PS: Short description (1st text line) in all caps | PS_POSTU | CHAR(40) | |
| PPROF | Planning Profile | BP_PPROFIL | TBP1C | CHAR(6) |
| PLINT | Indicator for Integrated Planning | PLINT | CHAR(1) | |
| LOEVM | Deletion Indicator | LOEVM | CHAR(1) | |
| INACT | Indicator: Project definition inactive | PS_INACT | CHAR(1) | |
| KZBWS | Valuation of Special Stock | KZBWS | CHAR(1) | |
| SMPRF | Simulation profile | SIM_PROFIL | TCN54 | CHAR(7) |
| FLGVRG | Indicator: Bottom-up calculation with activity dates | PS_FLGVRG | CHAR(1) | |
| GRTOP | Indicator: Automatic requirements grouping | GRONTOP | CHAR(1) | |
| PGPRF | Distribution profile | PGPROFID | TPGPRF | CHAR(6) |
| STORT | Location | PS_STORT | T499S | CHAR(10) |
| LOGSYSTEM | Logical System | LOGSYSTEM | * | CHAR(10) |
| KZERB | Indicator: Project summarization via master data charact. | PS_KZERB | CHAR(1) | |
| PARGR | Partner Determination Procedure | PARGR | V_TVPG_S | CHAR(4) |
| FUNC_AREA | Functional Area | FKBER | TFKB | CHAR(16) |
| VKORG | Sales Organization | VKORG | TVKO | CHAR(4) |
| VTWEG | Distribution Channel | VTWEG | TVKOV | CHAR(2) |
| SPART | Division | SPART | TVTA | CHAR(2) |
| DPPPROF | Dynamic Item Processor Profile | AD01PROFNR | AD01C_PROF | CHAR(8) |
| VPKSTU | Node level | SEU_LEVEL | NUMC(2) | |
| PSPID_EDIT | Project Number (External) Edited | PS_PSPID_EDIT | CHAR(24) | |
| VNAME | Joint venture | JV_NAME | T8JV | CHAR(6) |
| RECID | Recovery Indicator | JV_RECIND | T8JJ | CHAR(2) |
| ETYPE | Equity type | JV_ETYPE | T8JE | CHAR(3) |
| OTYPE | Joint Venture Object Type | JV_OTYPE | CHAR(4) | |
| JIBCL | JIB/JIBE Class | JV_JIBCL | T8J6A | CHAR(3) |
| JIBSA | JIB/JIBE Subclass A | JV_JIBSA | T8J6C | CHAR(5) |
| EEW_PROJ_PS_DUMMY | Dummy function in length 1 | DUMMY | CHAR(1) | |
| SCHTYP | Scheduling scenario | PS_SCHED_TYPE | CHAR(1) | |
| SPROG | Forecast start date of project definition | PS_SPROG | DATS(8) | |
| EPROG | Forecast finish date for project definition | PS_EPROG | DATS(8) | |
| SLWID | Key word ID for user-defined fields | SLWID | TCN00 | CHAR(7) |
| USR00 | User field with 20 characters | USRCHAR20 | CHAR(20) | |
| USR01 | User field with 20 characters | USRCHAR20 | CHAR(20) | |
| USR02 | User field with 10 characters | USRCHAR10 | CHAR(10) | |
| USR03 | User field with 10 characters | USRCHAR10 | CHAR(10) | |
| USR04 | User field for quantity (length 10.3) | USRQUAN13 | QUAN(13) | |
| USE04 | User field: Unit for quantity fields | USRUNIT | * | UNIT(3) |
| USR05 | User field for quantity (length 10.3) | USRQUAN13 | QUAN(13) | |
| USE05 | User field: Unit for quantity fields | USRUNIT | * | UNIT(3) |
| USR06 | User-defined field for values (length 10,3) | USRCURR13 | CURR(13) | |
| USE06 | User field: Unit for value fields | USRCUKY | TCURC | CUKY(5) |
| USR07 | User-defined field for values (length 10,3) | USRCURR13 | CURR(13) | |
| USE07 | User field: Unit for value fields | USRCUKY | TCURC | CUKY(5) |
| USR08 | User field for date | USRDATE | DATS(8) | |
| USR09 | User field for date | USRDATE | DATS(8) | |
| USR10 | User-defined field: Indicator for reports | USRFLAG | CHAR(1) | |
| USR11 | User-defined field: Indicator for reports | USRFLAG | CHAR(1) | |
| CPD_UPDAT | Time Stamp | /CPD/PFP_SC_TSTMP | DEC(15) | |
| FERC_IND | Regulatory indicator | FE_IND | FERC_C7 | CHAR(4) |
| AVC_PROFILE | Budget Availability Control: Profile | FCO_AVC_PROFILE | FINSC_AVC_PROF | CHAR(6) |
| AVC_ACTIVE | Availability control indicator(AVC) | PS_S4_AVC_IND | CHAR(1) | |
| CPCURR | Custom Project Currency | PS_S4_WAERS | * | CUKY(5) |
| PROJ_STATUS | Status Combination | ACTCMB_DELE | ACTCMB_TAB | INT1(3) |
