PRPSS SAP (Standard WBS Element (WBS element) - Master Data) Table details
Dictionary Type: Table
Description: Standard WBS Element (WBS element) - Master Data
Description: Standard WBS Element (WBS element) - Master Data
Table field list including key, data, relationships and ABAP select examples
PRPSS is a standard SAP Table which is used to store Standard WBS Element (WBS element) - Master Data data and is available within R/3 SAP systems depending on the version and release level.
The PRPSS table consists of various fields, each holding specific information or linking keys about Standard WBS Element (WBS element) - Master Data data available in SAP. These include PSPNR (Std WBS: Internal project item number (w/exit on ID)), POSID (WBS element in 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 PRPSS 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 | Std WBS: Internal project item number (w/exit on ID) | PS_SPSNR | NUMC | 8 | KONPT | PS_SPSNR | |||
POSID | WBS element in standard project | PS_SPSID | CHAR | 24 | ABPSN | PS_POSID | SEE | PRST | |
POST1 | PS: Short description (1st text line) | PS_POST1 | CHAR | 40 | TEXT40 | ||||
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
PSPHI | Current number for standard project | PS_ISPSP | NUMC | 8 | PROJS | KONPS | PS_ISPSP | ||
POSKI | WBS element short identification | PS_POSKI | CHAR | 16 | PS_PROKI | ||||
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 | ||||
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 | ||||
PBUKR | Company code for WBS element | PS_PBUKR | CHAR | 4 | T001 | BUKRS | BUK | ||
PGSBR | Business area for WBS element | PS_PGSBR | CHAR | 4 | TGSB | GSBER | GSB | ||
PKOKR | Controlling area for WBS element | PS_PKOKR | CHAR | 4 | TKA01 | CACCD | CAC | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PRART | Project type | PS_PRART | CHAR | 2 | TCJ1 | PS_PRART | |||
STUFE | Level in Project Hierarchy | PS_STUFE | INT1 | 3 | INT1 | ||||
PLAKZ | Indicator: Planning element | PS_PLAKZ | CHAR | 1 | XFELD | ||||
BELKZ | Indicator: Account assignment element | PS_BELKZ | CHAR | 1 | XFELD | ||||
FAKKZ | Indicator: Billing element | PS_FAKKZ | CHAR | 1 | XFELD | ||||
NPFAZ | Relationship of network activity to production order | PS_NPFAR | CHAR | 1 | XFELD | ||||
ZUORD | Network assignment | PS_ZUORD | NUMC | 1 | PS_ZUORD | ||||
TRMEQ | Indicator: WBS dates detailed by activity dates | PS_TRMEQ | CHAR | 1 | X | ||||
KVEWE | Usage of the condition table | KVEWE | CHAR | 1 | T681V | KVEWE | KVW | ||
KAPPL | Application | KAPPL | CHAR | 2 | T681A | KAPPL | KAP | ||
KALSM | Costing Sheet | AUFKALSM | CHAR | 6 | T683 | KALSM | |||
ZSCHL | Overhead key | AUFZSCHL | CHAR | 6 | CHAR6 | ||||
ABGSL | Results Analysis Key | ABGR_SCHL | CHAR | 6 | TKKAA | ABGR_SCHL | ACS | ||
AKOKR | Controlling area of requesting cost center | PS_AKOKR | CHAR | 4 | TKA01 | CACCD | CAC | ||
AKSTL | Requesting cost center | PS_AKSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
FKOKR | Controlling area of responsible cost center | PS_FKOKR | CHAR | 4 | TKA01 | CACCD | CAC | ||
FKSTL | Responsible cost center | PS_FKSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
FABKL | Factory calendar key | FABKL | CHAR | 2 | TFACD | WFCID | |||
PSPRI | Project priority | PS_PRIOR | CHAR | 1 | CHAR1 | ||||
EQUNR | Equipment Number | EQUNR | CHAR | 18 | EQUI | ALPHA | EQUNR | EQN | EQUI |
TPLNR | Functional Location | TPLNR | CHAR | 30 | IFLOT | TPLNR | TPLNR | IFL | IFLM |
PWPOS | WBS element currency | PS_PWPOS | CUKY | 5 | TCURC | WAERS | |||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
TXTSP | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
SLWID | Key word ID for user-defined fields | SLWID | CHAR | 7 | TCN00 | SLWID | |||
USR00 | 1st user field for 20 characters - WBS element- | USR00PRPS | CHAR | 20 | USRCHAR20 | ||||
USR01 | 2nd user field 20 digits - WBS element | USR01PRPS | CHAR | 20 | USRCHAR20 | ||||
USR02 | 3rd user-defined field 10 digits -WBS element | USR02PRPS | CHAR | 10 | USRCHAR10 | ||||
USR03 | 4th user-defined field 10 digits -WBS element | USR03PRPS | CHAR | 10 | USRCHAR10 | ||||
USR04 | 1st user-defined field for quantity(length 10,3) WBS element | USR04PRPS | QUAN | 13(3) | USRQUAN13 | ||||
USE04 | 1st user defined field for quantity field unit - WBS element | USE04PRPS | UNIT | 3 | T006 | CUNIT | MEINS | ||
USR05 | 2nd use field for quantity (length 10,3) WBS element | USR05PRPS | QUAN | 13(3) | USRQUAN13 | ||||
USE05 | 2nd user defined field for quantity field unit - WBS element | USE05PRPS | UNIT | 3 | T006 | CUNIT | MEINS | ||
USR06 | 1st user field for values (length 10,3) WBS element | USR06PRPS | CURR | 13(3) | USRCURR13 | ||||
USE06 | 1st user defined field for value field unit - WBS element | USE06PRPS | CUKY | 5 | TCURC | WAERS | |||
USR07 | 2nd user field for values (length 10,3) -WBS element | USR07PRPS | CURR | 13(3) | USRCURR13 | ||||
USE07 | 2nd user defined field for value field unit - WBS element | USE07PRPS | CUKY | 5 | TCURC | WAERS | |||
USR08 | 1st user field for date -WBS element | USR08PRPS | DATS | 8 | USRDATE | ||||
USR09 | 2nd user field for date -WBS element | USR09PRPS | DATS | 8 | USRDATE | ||||
USR10 | 1st user field for 'Ind. for evaluations' WBS elem. | USR10PRPS | CHAR | 1 | FLAG | ||||
USR11 | 2nd user field for 'Indicator for eval.s' WBS elemnt | USR11PRPS | CHAR | 1 | FLAG | ||||
KOSTL | Cost center to which costs are actually posted | PS_KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | ||
KTRG | Cost Object | KSTRG | CHAR | 12 | CKPH | KSTRG | KTR | ||
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 | ||||
CLASF | Indicator: WBS element used in project summarization | PS_CLASF | CHAR | 1 | XFELD | ||||
SPSNR | Std WBS: Internal project item number (w/exit on ID) | PS_SPSNR | NUMC | 8 | Assigned to domain | KONPT | PS_SPSNR | ||
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 | |||
IMPRF | Investment measure profile | IM_PROFIL | CHAR | 6 | TAPRF | IM_PROFIL | |||
EVGEW | Aggregation weight for POC (PS progress) | EV_WEIGHTD | DEC | 8 | DEC8 | ||||
AENNR | Change Number | AENNR | CHAR | 12 | AENR | AENNR | AENNR | AEN | |
SUBPR | Sub-project in work breakdown structure | PS_SUBPR | CHAR | 12 | PRTP | PS_SUBPR | |||
POSTU | PS: Short description (1st text line) in all caps | PS_POSTU | CHAR | 40 | CHAR40 | ||||
PLINT | Indicator for Integrated Planning | PLINT | CHAR | 1 | XFELD | ||||
LOEVM | Deletion Indicator | LOEVM | CHAR | 1 | XFELD | ||||
KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | KZBWS | ||||
GRPKZ | Indicator: Grouping WBS element | GRPSPKZ | CHAR | 1 | GRPSPKZ | ||||
PGPRF | Distribution profile | PGPROFID | CHAR | 6 | TPGPRF | PGPROFID | |||
STORT | Location | PS_STORT | CHAR | 10 | T499S | AP_STAND | |||
FUNC_AREA | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
POSID_EDIT | Standard Work Breakdown Structure (S WBS Element) Edited | PS_SPSID_EDIT | CHAR | 24 | PS_POSID_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 | ||
ADPSP | Reference Element PM/PS | ADDCOMPARE_CORE | CHAR | 40 | Assigned to domain | ADDCOMPARE_CORE | ADCP |
Key field | Non-key field |
How do I retrieve data from SAP table PRPSS using ABAP code
The following ABAP code Example will allow you to do a basic selection on PRPSS to SELECT all data from the tableDATA: WA_PRPSS TYPE PRPSS.
SELECT SINGLE *
FROM PRPSS
INTO CORRESPONDING FIELDS OF WA_PRPSS
WHERE...
How to access SAP table PRPSS
Within an ECC or HANA version of SAP you can also view further information about PRPSS 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