PRPS is a standard SAP HANA table in SAP ERP (or) S/4HANA system which stores WBS (Work Breakdown Structure) Element Master Data data. There are total 125 fields in the table. The PRPS 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 |
PRPS Table Fields
The following is the list of fields that are available in SAP PRPS 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 | WBS Element | PS_POSNR | PS_POSNR | NUMC | 8 | |
POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | PS_POSID | CHAR | 24 | |
POST1 | PS: Short description (1st text line) | PS_POST1 | TEXT40 | CHAR | 40 | |
OBJNR | Object number | J_OBJNR | J_OBJNR | ONR00 | CHAR | 22 |
PSPHI | Current number of the appropriate project | PS_PSPHI | PS_PSPNR | PROJ | NUMC | 8 |
POSKI | WBS element short identification | PS_POSKI | PS_PROKI | CHAR | 16 | |
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 | |
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 | |
PBUKR | Company code for WBS element | PS_PBUKR | BUKRS | T001 | CHAR | 4 |
PGSBR | Business area for WBS element | PS_PGSBR | GSBER | TGSB | CHAR | 4 |
PKOKR | Controlling area for WBS element | PS_PKOKR | CACCD | TKA01 | CHAR | 4 |
PRCTR | Profit Center | PRCTR | PRCTR | CEPC | CHAR | 10 |
PRART | Project Type | PS_PRART | PS_PRART | TCJ1 | CHAR | 2 |
STUFE | Level in Project Hierarchy | PS_STUFE | INT1 | INT1 | 3 | |
PLAKZ | Indicator: Planning element | PS_PLAKZ | XFELD | CHAR | 1 | |
BELKZ | Indicator: Account assignment element | PS_BELKZ | XFELD | CHAR | 1 | |
FAKKZ | Indicator: Billing element | PS_FAKKZ | XFELD | CHAR | 1 | |
NPFAZ | Relationship of network activity to production order | PS_NPFAR | XFELD | CHAR | 1 | |
ZUORD | Network assignment | PS_ZUORD | PS_ZUORD | NUMC | 1 | |
TRMEQ | Indicator: WBS dates detailed by activity dates | PS_TRMEQ | X | CHAR | 1 | |
KVEWE | Usage of the condition table | KVEWE | KVEWE | T681V | CHAR | 1 |
KAPPL | Application | KAPPL | KAPPL | T681A | CHAR | 2 |
KALSM | Costing Sheet | AUFKALSM | KALSM | T683 | CHAR | 6 |
ZSCHL | Overhead key | AUFZSCHL | CHAR6 | TKZSL | CHAR | 6 |
ABGSL | Results Analysis Key | ABGR_SCHL | ABGR_SCHL | TKKAA | CHAR | 6 |
AKOKR | Controlling area of requesting cost center | PS_AKOKR | CACCD | TKA01 | CHAR | 4 |
AKSTL | Requesting cost center | PS_AKSTL | KOSTL | CSKS | CHAR | 10 |
FKOKR | Responsible Cost Center Controlling Area | PS_FKOKR | CACCD | TKA01 | CHAR | 4 |
FKSTL | Responsible Cost Center | PS_FKSTL | KOSTL | CSKS | CHAR | 10 |
FABKL | Factory calendar key | FABKL | WFCID | TFACD | CHAR | 2 |
PSPRI | Priority | NW_PRIO | NW_PRIO | TCN07 | CHAR | 1 |
EQUNR | Equipment Number | EQUNR | EQUNR | EQUI | CHAR | 18 |
TPLNR | Functional Location | TPLNR | TPLNR | IFLOT | CHAR | 30 |
PWPOS | WBS element currency | PS_PWPOS | WAERS | TCURC | CUKY | 5 |
WERKS | Plant | WERKS_D | WERKS | T001W | CHAR | 4 |
TXTSP | Language Key | SPRAS | SPRAS | T002 | LANG | 1 |
SLWID | Key word ID for user-defined fields | SLWID | SLWID | TCN00 | CHAR | 7 |
USR00 | 1st user field for 20 characters – WBS element- | USR00PRPS | USRCHAR20 | CHAR | 20 | |
USR01 | 2nd user field 20 digits – WBS element | USR01PRPS | USRCHAR20 | CHAR | 20 | |
USR02 | 3rd user-defined field 10 digits -WBS element | USR02PRPS | USRCHAR10 | CHAR | 10 | |
USR03 | 4th user-defined field 10 digits -WBS element | USR03PRPS | USRCHAR10 | CHAR | 10 | |
USR04 | 1st user-defined field for quantity(length 10,3) WBS element | USR04PRPS | USRQUAN13 | QUAN | 13 | |
USE04 | 1st user defined field for quantity field unit – WBS element | USE04PRPS | MEINS | T006 | UNIT | 3 |
USR05 | 2nd use field for quantity (length 10,3) WBS element | USR05PRPS | USRQUAN13 | QUAN | 13 | |
USE05 | 2nd user defined field for quantity field unit – WBS element | USE05PRPS | MEINS | T006 | UNIT | 3 |
USR06 | 1st user field for values (length 10,3) WBS element | USR06PRPS | USRCURR13 | CURR | 13 | |
USE06 | 1st user defined field for value field unit – WBS element | USE06PRPS | WAERS | TCURC | CUKY | 5 |
USR07 | 2nd user field for values (length 10,3) -WBS element | USR07PRPS | USRCURR13 | CURR | 13 | |
USE07 | 2nd user defined field for value field unit – WBS element | USE07PRPS | WAERS | TCURC | CUKY | 5 |
USR08 | 1st user field for date -WBS element | USR08PRPS | USRDATE | DATS | 8 | |
USR09 | 2nd user field for date -WBS element | USR09PRPS | USRDATE | DATS | 8 | |
USR10 | 1st user field for ‘Ind. for evaluations’ WBS elem. | USR10PRPS | FLAG | CHAR | 1 | |
USR11 | 2nd user field for ‘Indicator for eval.s’ WBS elemnt | USR11PRPS | FLAG | CHAR | 1 | |
KOSTL | Cost center to which costs are actually posted | PS_KOSTL | KOSTL | CSKS | CHAR | 10 |
KTRG | Cost Object | KSTRG | KSTRG | CKPH | CHAR | 12 |
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 | |
CLASF | Indicator: WBS element used in project summarization | PS_CLASF | XFELD | CHAR | 1 | |
SPSNR | Std WBS: Internal project item number (w/exit on ID) | PS_SPSNR | PS_SPSNR | PRPSS | NUMC | 8 |
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 |
IMPRF | Investment Measure Profile | IM_PROFIL | IM_PROFIL | TAPRF | CHAR | 6 |
EVGEW | Aggregation weight for POC (PS progress) | EV_WEIGHTD | DEC8 | DEC | 8 | |
AENNR | Change Number | AENNR | AENNR | AENR | CHAR | 12 |
SUBPR | Sub-project in work breakdown structure | PS_SUBPR | PS_SUBPR | PRTP | CHAR | 12 |
POSTU | PS: Short description (1st text line) in all caps | PS_POSTU | CHAR40 | CHAR | 40 | |
PLINT | Indicator for Integrated Planning | PLINT | XFELD | CHAR | 1 | |
LOEVM | Deletion Indicator | LOEVM | XFELD | CHAR | 1 | |
KZBWS | Valuation of Special Stock | KZBWS | KZBWS | CHAR | 1 | |
FPLNR | Billing plan number / invoicing plan number | FPLNR | FPLNR | * | CHAR | 10 |
TADAT | Technically complete date | TABGDAT | DATUM | DATS | 8 | |
IZWEK | Reason for Investment | IZWEK | IZWEK | T087I | CHAR | 2 |
ISIZE | Scale of investment objects | IM_SIZECL | SIZECL | TAIF5 | CHAR | 2 |
IUMKZ | Reason for Environmental Investment | AM_UMWKZ | AM_UMWKZ | T087K | CHAR | 5 |
ABUKR | Requesting company code | IM_ABUKRS | BUKRS | T001 | CHAR | 4 |
GRPKZ | Indicator: Grouping WBS element | GRPSPKZ | GRPSPKZ | CHAR | 1 | |
PGPRF | Distribution profile | PGPROFID | PGPROFID | TPGPRF | CHAR | 6 |
LOGSYSTEM | Logical System | LOGSYSTEM | LOGSYS | * | CHAR | 10 |
PSPNR_LOGS | Numeric field length 8 | NUM08 | NUM08 | NUMC | 8 | |
STORT | Location | PS_STORT | AP_STAND | T499S | CHAR | 10 |
FUNC_AREA | Functional Area | FKBER | FKBER | TFKB | CHAR | 16 |
KLVAR | Costing Variant | CK_KLVAR | KLVAR | * | CHAR | 4 |
KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | CK_KALNR | * | NUMC | 12 |
POSID_EDIT | Work Breakdown Structure Element (WBS Element) Edited | PS_POSID_EDIT | PS_POSID_EDIT | CHAR | 24 | |
PSPKZ | Indicator: WBS element for production lot | PL_PSPKZ | XFELD | CHAR | 1 | |
MATNR | Material Number | MATNR | MATNR | CHAR | 40 | |
VLPSP | WBS: Reference work breakdown structure element | PL_PSP_PNR | PS_POSNR | NUMC | 8 | |
VLPKZ | Indicator: Reference WBS element for production lot | PL_VLPKZ | XFELD | CHAR | 1 | |
SORT1 | Sort string 1 for production lot | PL_SORT1 | CHAR10 | CHAR | 10 | |
SORT2 | Sort string 2 for production lot | PL_SORT2 | CHAR10 | CHAR | 10 | |
SORT3 | Sort string 3 for production lot | PL_SORT3 | CHAR10 | CHAR | 10 | |
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 |
CGPL_GUID16 | Generic project planning: GUID from external R/3 system | CGPL_GUID16_R3 | SYSUUID | RAW | 16 | |
CGPL_LOGSYS | Generic project planning: Log. system for CGPL_GUID16_R3 | CGPL_LOGSYS | LOGSYS | * | CHAR | 10 |
CGPL_OBJTYPE | Generic project planning: object type from ext. R/3 system | CGPL_OBJECT_TYPE_R3 | CHAR3 | CHAR | 3 | |
ADPSP | Reference Element PM/PS | ADDCOMPARE_CORE | ADDCOMPARE_CORE | CHAR | 40 | |
RFIPPNT | Reference Point for Relationship Between iPPE and PS | CN_RPIP | CN_RFPNT | TCNRPIP | CHAR | 20 |
EEW_PRPS_PS_DUMMY | Dummy function in length 1 | DUMMY | DUMMY | CHAR | 1 | |
RFUND | Fund | BP_GEBER | BP_GEBER | * | CHAR | 10 |
RGRANT_NBR | Grant | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | |
FUND_FIX_ASSIGN | Indicator for Fund with Fixed Assignment | PSM_FUND_FIX_ASSIGNED | BOOLEAN | CHAR | 1 | |
GRANT_FIX_ASSIGNED | Indicator for Grant with Fixed Assignment | PSM_GRANT_FIX_ASSIGNED | BOOLEAN | CHAR | 1 | |
FUNC_AREA_FIX_ASSIGNED | Indicator for Functional Area with Fixed Assignment | PSM_FUNC_AREA_FIX_ASSIGNED | BOOLEAN | CHAR | 1 | |
SPONSOREDPROG | Sponsored Program | GM_SPONSORED_PROG | GM_SPONSORED_PROG | * | CHAR | 20 |
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 |
PRPS_STATUS | Status Combination | ACTCMB_DELE | ACTCMB_DOM | ACTCMB_TAB | INT1 | 3 |
POSNR_PRPS | Sales Document Item | POSNR_VA | POSNR | NUMC | 6 | |
VBELN_PRPS | Sales Document | VBELN_VA | VBELN | CHAR | 10 |
Availability
The SAP HANA table PRPS 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 PRPS table
We’re updating the content all the time, so check back regularly.