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