The PRPSS table in SAP ERP or S/4HANA stores Standard WBS Element (WBS element) – Master Data data. There are total 92 fields in PRPSS table. The Standard WBS Element (WBS element) – Master Data table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of PRPSS table. It is in Standard Work Breakdown Structure (CN_PSP_STD) ABAP package and is part of the Templates (PS-ST-TMP) module.
SAP PRPSS Table Fields
Following is the list of fields that are available in SAP PRPSS table. The primary key fields of Standard WBS Element (WBS element) – Master Data table in SAP are MANDT (Client), PSPNR (Std WBS: Internal project item number (w/exit on ID)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| PSPNR | Std WBS: Internal project item number (w/exit on ID) | PS_SPSNR | NUMC (8) | |
| POSID | WBS element in standard project | PS_SPSID | CHAR (24) | |
| POST1 | PS: Short description (1st text line) | PS_POST1 | CHAR (40) | |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR (22) |
| PSPHI | Current number for standard project | PS_ISPSP | PROJS | NUMC (8) |
| POSKI | WBS element short identification | PS_POSKI | CHAR (16) | |
| 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) | |
| 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) | |
| PBUKR | Company code for WBS element | PS_PBUKR | T001 | CHAR (4) |
| PGSBR | Business area for WBS element | PS_PGSBR | TGSB | CHAR (4) |
| PKOKR | Controlling area for WBS element | PS_PKOKR | TKA01 | CHAR (4) |
| PRCTR | Profit Center | PRCTR | * | CHAR (10) |
| PRART | Project Type | PS_PRART | TCJ1 | CHAR (2) |
| STUFE | Level in Project Hierarchy | PS_STUFE | INT1 (3) | |
| PLAKZ | Indicator: Planning element | PS_PLAKZ | CHAR (1) | |
| BELKZ | Indicator: Account assignment element | PS_BELKZ | CHAR (1) | |
| FAKKZ | Indicator: Billing element | PS_FAKKZ | CHAR (1) | |
| NPFAZ | Relationship of network activity to production order | PS_NPFAR | CHAR (1) | |
| ZUORD | Network assignment | PS_ZUORD | NUMC (1) | |
| TRMEQ | Indicator: WBS dates detailed by activity dates | PS_TRMEQ | CHAR (1) | |
| KVEWE | Usage of the condition table | KVEWE | T681V | CHAR (1) |
| KAPPL | Application | KAPPL | T681A | CHAR (2) |
| KALSM | Costing Sheet | AUFKALSM | T683 | CHAR (6) |
| ZSCHL | Overhead key | AUFZSCHL | CHAR (6) | |
| ABGSL | Results Analysis Key | ABGR_SCHL | TKKAA | CHAR (6) |
| AKOKR | Controlling area of requesting cost center | PS_AKOKR | TKA01 | CHAR (4) |
| AKSTL | Requesting cost center | PS_AKSTL | CSKS | CHAR (10) |
| FKOKR | Responsible Cost Center Controlling Area | PS_FKOKR | TKA01 | CHAR (4) |
| FKSTL | Responsible Cost Center | PS_FKSTL | CSKS | CHAR (10) |
| FABKL | Factory calendar key | FABKL | TFACD | CHAR (2) |
| PSPRI | Project priority | PS_PRIOR | CHAR (1) | |
| EQUNR | Equipment Number | EQUNR | EQUI | CHAR (18) |
| TPLNR | Functional Location | TPLNR | IFLOT | CHAR (30) |
| PWPOS | WBS element currency | PS_PWPOS | TCURC | CUKY (5) |
| WERKS | Plant | WERKS_D | T001W | CHAR (4) |
| TXTSP | Language Key | SPRAS | T002 | LANG (1) |
| SLWID | Key word ID for user-defined fields | SLWID | TCN00 | CHAR (7) |
| USR00 | 1st user field for 20 characters – WBS element- | USR00PRPS | CHAR (20) | |
| USR01 | 2nd user field 20 digits – WBS element | USR01PRPS | CHAR (20) | |
| USR02 | 3rd user-defined field 10 digits -WBS element | USR02PRPS | CHAR (10) | |
| USR03 | 4th user-defined field 10 digits -WBS element | USR03PRPS | CHAR (10) | |
| USR04 | 1st user-defined field for quantity(length 10,3) WBS element | USR04PRPS | QUAN (13) | |
| USE04 | 1st user defined field for quantity field unit – WBS element | USE04PRPS | T006 | UNIT (3) |
| USR05 | 2nd use field for quantity (length 10,3) WBS element | USR05PRPS | QUAN (13) | |
| USE05 | 2nd user defined field for quantity field unit – WBS element | USE05PRPS | T006 | UNIT (3) |
| USR06 | 1st user field for values (length 10,3) WBS element | USR06PRPS | CURR (13) | |
| USE06 | 1st user defined field for value field unit – WBS element | USE06PRPS | TCURC | CUKY (5) |
| USR07 | 2nd user field for values (length 10,3) -WBS element | USR07PRPS | CURR (13) | |
| USE07 | 2nd user defined field for value field unit – WBS element | USE07PRPS | TCURC | CUKY (5) |
| USR08 | 1st user field for date -WBS element | USR08PRPS | DATS (8) | |
| USR09 | 2nd user field for date -WBS element | USR09PRPS | DATS (8) | |
| USR10 | 1st user field for ‘Ind. for evaluations’ WBS elem. | USR10PRPS | CHAR (1) | |
| USR11 | 2nd user field for ‘Indicator for eval.s’ WBS elemnt | USR11PRPS | CHAR (1) | |
| KOSTL | Cost center to which costs are actually posted | PS_KOSTL | CSKS | CHAR (10) |
| KTRG | Cost Object | KSTRG | CKPH | CHAR (12) |
| 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) | |
| CLASF | Indicator: WBS element used in project summarization | PS_CLASF | CHAR (1) | |
| SPSNR | Std WBS: Internal project item number (w/exit on ID) | PS_SPSNR | * | NUMC (8) |
| 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) |
| IMPRF | Investment Measure Profile | IM_PROFIL | TAPRF | CHAR (6) |
| EVGEW | Aggregation weight for POC (PS progress) | EV_WEIGHTD | DEC (8) | |
| AENNR | Change Number | AENNR | AENR | CHAR (12) |
| SUBPR | Sub-project in work breakdown structure | PS_SUBPR | PRTP | CHAR (12) |
| POSTU | PS: Short description (1st text line) in all caps | PS_POSTU | CHAR (40) | |
| PLINT | Indicator for Integrated Planning | PLINT | CHAR (1) | |
| LOEVM | Deletion Indicator | LOEVM | CHAR (1) | |
| KZBWS | Valuation of Special Stock | KZBWS | CHAR (1) | |
| GRPKZ | Indicator: Grouping WBS element | GRPSPKZ | CHAR (1) | |
| PGPRF | Distribution profile | PGPROFID | TPGPRF | CHAR (6) |
| STORT | Location | PS_STORT | T499S | CHAR (10) |
| FUNC_AREA | Functional Area | FKBER | * | CHAR (16) |
| POSID_EDIT | Standard Work Breakdown Structure (S WBS Element) Edited | PS_SPSID_EDIT | CHAR (24) | |
| VNAME | Joint venture | JV_NAME | T8JV | CHAR (6) |
| RECID | Recovery Indicator | JV_RECIND | T8JJ | CHAR (2) |
| ETYPE | Equity type | JV_ETYPE | T8JG | 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) |
| ADPSP | Reference Element PM/PS | ADDCOMPARE_CORE | * | CHAR (40) |
