PROJS SAP (Standard project definition) Table details
Dictionary Type: Table
Description: Standard project definition
Description: Standard project definition
Table field list including key, data, relationships and ABAP select examples
PROJS is a standard SAP Table which is used to store Standard project definition data and is available within R/3 SAP systems depending on the version and release level.
The PROJS table consists of various fields, each holding specific information or linking keys about Standard project definition data available in SAP. These include PSPNR (Current number for standard project), PSPID (Project definition for standard project), POST1 (PS: Short description (1st text line)), OBJNR (Object number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP PROJS table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| PSPNR | Current number for standard project | PS_ISPSP | NUMC | 8 | KONPS | PS_ISPSP | |||
| PSPID | Project definition for standard project | PS_SPDID | CHAR | 24 | PROJN | PS_PSPID | SDE | PRSS | |
| POST1 | PS: Short description (1st text line) | PS_POST1 | CHAR | 40 | TEXT40 | ||||
| OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
| AEDAT | Date on which object was last changed | UPDAT | DATS | 8 | DATUM | ||||
| KIMSK | Selection mask for WBS element short IDs | PS_KIMSK | CHAR | 24 | PS_PROID | ||||
| AUTOD | Automatic value transfer from WBS element to project def. | PS_AUTOD | CHAR | 1 | XFELD | ||||
| STSPD | Status profile for project definition | PS_STSPD | CHAR | 8 | TJ20 | J_STSMA | |||
| STSPR | Status profile for WBS element | PS_STSPR | CHAR | 8 | TJ20 | J_STSMA | |||
| VERNR | Number of the responsible person (project manager) | PS_VERNR | NUMC | 8 | TCJ04 | PS_VERNR | |||
| VERNA | Name of responsible person (Project manager) | PS_VERNA | CHAR | 25 | PS_VERNA | ||||
| ASTNR | Applicant number | PS_ASTNR | NUMC | 8 | TCJ05 | PS_ASTNR | |||
| ASTNA | Applicant | PS_ASTNA | CHAR | 25 | PS_ASTNA | ||||
| VBUKR | Company code for the project | PS_VBUKR | CHAR | 4 | T001 | BUKRS | BUK | ||
| VGSBR | Business area for the project | PS_VGSBR | CHAR | 4 | TGSB | GSBER | GSB | ||
| VKOKR | Controlling area for the project | PS_VKOKR | CHAR | 4 | TKA01 | CACCD | CAC | ||
| PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
| PWHIE | WBS currency (project definition) | PS_PWHIE | CUKY | 5 | TCURC | WAERS | |||
| ZUORD | Network assignment | PS_ZUORD | NUMC | 1 | PS_ZUORD | ||||
| TRMEQ | Indicator: WBS dates detailed by activity dates | PS_TRMEQ | CHAR | 1 | X | ||||
| PLFAZ | Project planned start date | PS_PLFAZ | DATS | 8 | DATUM | ||||
| PLSEZ | Project planned finish date | PS_PLSEZ | DATS | 8 | DATUM | ||||
| WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
| KALID | Factory calendar key | FABKL | CHAR | 2 | TFACD | WFCID | |||
| VGPLF | Planning method for project basic dates | PS_VGPLF | NUMC | 1 | PSPLFRM | ||||
| EWPLF | Planning method for project forecast dates | PS_EWPLF | NUMC | 1 | PSPLFRM | ||||
| ZTEHT | Time unit in time scheduling | PS_ZTEHT | UNIT | 3 | T006 | CUNIT | MEINS | ||
| NZANZ | Indicator: Network header visible to end user | NETZOBERFL | CHAR | 1 | X | ||||
| PLNAW | Application of the task list | PLNAW | CHAR | 1 | TCA09 | PLNAW | |||
| VPROF | Network profile | PROFIDNZPL | CHAR | 7 | TCN41 | PROFILID | PNW | ||
| PROFL | Project Profile | PROFIDPROJ | CHAR | 7 | TCJ41 | PROFIDPROJ | PWS | ||
| BPROF | Budget Profile | BP_BPROFIL | CHAR | 6 | TBP1C | BP_PROFIL | BP1 | ||
| TXTSP | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
| KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
| KTRG | Cost Object | KSTRG | CHAR | 12 | CKPH | KSTRG | KTR | ||
| AEDTE | Date of last scheduling of the overall network (basic dates) | PS_AEDTE | DATS | 8 | DATUM | ||||
| AEDTP | Date of last scheduling of the overall network (forecast) | PS_AEDTP | DATS | 8 | DATUM | ||||
| BERST | Authorization key for project master data | PS_BERST | CHAR | 16 | CHAR16 | ||||
| BERTR | Authorization key for project dates (WBS) | PS_BERTR | CHAR | 16 | CHAR16 | ||||
| BERKO | Authorization key for costs and revenues | PS_BERKO | CHAR | 16 | CHAR16 | ||||
| BERBU | Authorization key for project budget | PS_BERBU | CHAR | 16 | CHAR16 | ||||
| SPSNR | Current number for standard project | PS_ISPSP | NUMC | 8 | Assigned to domain | KONPS | PS_ISPSP | ||
| BESTA | Project stock | PS_BESTAND | CHAR | 1 | XFELD | ||||
| SCOPE | Object Class | SCOPE_CV | CHAR | 2 | SCOPE | SCOPE_CV | PCO | ||
| XSTAT | Statistical WBS element | PS_XSTAT | CHAR | 1 | XFELD | ||||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
| ZSCHM | Interest Profile for Project/Order Interest Calculation | PS_ZSCHM | CHAR | 7 | TPI01 | PS_ZSCHM | |||
| SCPRF | Profile for WBS scheduling | PS_SCHDPRF | CHAR | 12 | TCXPS | PS_SCHDPRF | |||
| IMPRF | Investment measure profile | IM_PROFIL | CHAR | 6 | TAPRF | IM_PROFIL | |||
| FMPRF | Payment plan profile | PSFM_PRF | CHAR | 6 | TBP1C | BP_PROFIL | BP1 | ||
| ABGSL | Results Analysis Key | ABGR_SCHL | CHAR | 6 | TKKAA | ABGR_SCHL | ACS | ||
| POSTU | PS: Short description (1st text line) in all caps | PS_POSTU | CHAR | 40 | CHAR40 | ||||
| PPROF | Planning profile | BP_PPROFIL | CHAR | 6 | TBP1C | BP_PROFIL | BP1 | ||
| PLINT | Indicator for Integrated Planning | PLINT | CHAR | 1 | XFELD | ||||
| LOEVM | Deletion Indicator | LOEVM | CHAR | 1 | XFELD | ||||
| INACT | Indicator: Project definition inactive | PS_INACT | CHAR | 1 | XFELD | ||||
| KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | KZBWS | ||||
| SMPRF | Simulation profile | SIM_PROFIL | CHAR | 7 | TCN54 | SIM_PROFIL | |||
| FLGWBS | Scheduling method | PS_FLGWBS | CHAR | 1 | PS_FLGWBS | ||||
| FLGVRG | Indicator: Bottom-up calculation with activity dates | PS_FLGVRG | CHAR | 1 | PS_FLGVRG | ||||
| GRTOP | Indicator: Automatic requirements grouping | GRONTOP | CHAR | 1 | XFELD | ||||
| PGPRF | Distribution profile | PGPROFID | CHAR | 6 | TPGPRF | PGPROFID | |||
| STORT | Location | PS_STORT | CHAR | 10 | T499S | AP_STAND | |||
| FLGSD | Indicator: New structure for each sales order item | PS_FLGSD | CHAR | 1 | XFELD | ||||
| KZERB | Indicator: Project summarization via master data charact. | PS_KZERB | CHAR | 1 | XFELD | ||||
| PARGR | Partner Determination Procedure | PARGR | CHAR | 4 | V_TVPG_S | PARGR | |||
| FUNC_AREA | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
| VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
| VTWEG | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
| SPART | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
| DPPPROF | Dynamic Item Processor Profile | AD01PROFNR | CHAR | 8 | Assigned to domain | AD01PROFNR | AD0 | DIP_PROFILE | |
| VPKSTU | Node level | SEU_LEVEL | NUMC | 2 | SEU_LEVEL | ||||
| SCHTYP | Scheduling scenario | PS_SCHED_TYPE | CHAR | 1 | PS_SCHED_TYPE | ||||
| PSPID_EDIT | Standard Project Number (Extern) Edited | PS_SPDID_EDIT | CHAR | 24 | PS_PSPID_EDIT | ||||
| VNAME | Joint Venture | JV_NAME | CHAR | 6 | T8JV | ALPHA | JV_NAME | JVV | |
| RECID | Recovery Indicator | JV_RECIND | CHAR | 2 | T8JJ | ALPHA | JV_RECIND | ||
| ETYPE | Equity type | JV_ETYPE | CHAR | 3 | T8JG | ALPHA | JV_ETYPE | ||
| OTYPE | Joint Venture Object Type | JV_OTYPE | CHAR | 4 | ALPHA | JV_OTYPE | |||
| JIBCL | JIB/JIBE Class | JV_JIBCL | CHAR | 3 | T8J6A | JV_JIBCL | JIB | ||
| JIBSA | JIB/JIBE Subclass A | JV_JIBSA | CHAR | 5 | T8J6C | JV_JIBSA | JBS |
| Key field | Non-key field |
How do I retrieve data from SAP table PROJS using ABAP code
The following ABAP code Example will allow you to do a basic selection on PROJS to SELECT all data from the tableDATA: WA_PROJS TYPE PROJS.
SELECT SINGLE *
FROM PROJS
INTO CORRESPONDING FIELDS OF WA_PROJS
WHERE...
How to access SAP table PROJS
Within an ECC or HANA version of SAP you can also view further information about PROJS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects