Wednesday, September 4, 2024
Search by table name, fields

PRPS: WBS (Work Breakdown Structure) Element Master Data

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.

EDITOR PICKS

POPULAR POSTS

POPULAR CATEGORY

© 2014-2021 www.saplearners.com.All rights reserved. SAPLearners.COM is not affiliated with SAP SE or any of its subsidiaries.