SAP table PRPS (WBS (Work Breakdown Structure) Element Master Data)

SAP table PRPS has 2 primary key fields being MANDT,PSPNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PSPNR WBS Element NUMC 8 0 PS_POSNR
POSID Work Breakdown Structure Element (WBS Element) CHAR 24 0 PS_POSID
POST1 PS: Short description (1st text line) CHAR 40 0 PS_POST1
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
PSPHI Current number of the appropriate project NUMC 8 0 PROJ PS_PSPHI
POSKI WBS element short identification CHAR 16 0 PS_POSKI
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Date on which object was last changed DATS 8 0 UPDAT
VERNR Number of the Responsible Person (Project Manager) NUMC 8 0 TCJ04 PS_VERNR
VERNA Name of responsible person (Project manager) CHAR 25 0 PS_VERNA
ASTNR Applicant number NUMC 8 0 TCJ05 PS_ASTNR
ASTNA Applicant CHAR 25 0 PS_ASTNA
PBUKR Company code for WBS element CHAR 4 0 T001 PS_PBUKR
PGSBR Business area for WBS element CHAR 4 0 TGSB PS_PGSBR
PKOKR Controlling area for WBS element CHAR 4 0 TKA01 PS_PKOKR
PRCTR Profit Center CHAR 10 0 CEPC PRCTR
PRART Project Type CHAR 2 0 TCJ1 PS_PRART
STUFE Level in Project Hierarchy INT1 3 0 PS_STUFE
PLAKZ Indicator: Planning element CHAR 1 0 PS_PLAKZ
BELKZ Indicator: Account assignment element CHAR 1 0 PS_BELKZ
FAKKZ Indicator: Billing element CHAR 1 0 PS_FAKKZ
NPFAZ Relationship of network activity to production order CHAR 1 0 PS_NPFAR
ZUORD Network assignment NUMC 1 0 PS_ZUORD
1 For project definition
2 For WBS element
TRMEQ Indicator: WBS dates detailed by activity dates CHAR 1 0 PS_TRMEQ
KVEWE Usage of the condition table CHAR 1 0 T681V KVEWE
KAPPL Application CHAR 2 0 T681A KAPPL
KALSM Costing Sheet CHAR 6 0 T683 AUFKALSM
ZSCHL Overhead key CHAR 6 0 TKZSL AUFZSCHL
ABGSL Results Analysis Key CHAR 6 0 TKKAA ABGR_SCHL
AKOKR Controlling area of requesting cost center CHAR 4 0 TKA01 PS_AKOKR
AKSTL Requesting cost center CHAR 10 0 CSKS PS_AKSTL
FKOKR Responsible Cost Center Controlling Area CHAR 4 0 TKA01 PS_FKOKR
FKSTL Responsible Cost Center CHAR 10 0 CSKS PS_FKSTL
FABKL Factory calendar key CHAR 2 0 TFACD FABKL
PSPRI Priority CHAR 1 0 TCN07 NW_PRIO
EQUNR Equipment Number CHAR 18 0 EQUI EQUNR
TPLNR Functional Location CHAR 30 0 IFLOT TPLNR
PWPOS WBS element currency CUKY 5 0 TCURC PS_PWPOS
WERKS Plant CHAR 4 0 T001W WERKS_D
TXTSP Language Key LANG 1 0 T002 SPRAS
SLWID Key word ID for user-defined fields CHAR 7 0 TCN00 SLWID
USR00 1st user field for 20 characters - WBS element- CHAR 20 0 USR00PRPS
USR01 2nd user field 20 digits - WBS element CHAR 20 0 USR01PRPS
USR02 3rd user-defined field 10 digits -WBS element CHAR 10 0 USR02PRPS
USR03 4th user-defined field 10 digits -WBS element CHAR 10 0 USR03PRPS
USR04 1st user-defined field for quantity(length 10,3) WBS element QUAN 13 3 USR04PRPS
USE04 1st user defined field for quantity field unit - WBS element UNIT 3 0 T006 USE04PRPS
USR05 2nd use field for quantity (length 10,3) WBS element QUAN 13 3 USR05PRPS
USE05 2nd user defined field for quantity field unit - WBS element UNIT 3 0 T006 USE05PRPS
USR06 1st user field for values (length 10,3) WBS element CURR 13 3 USR06PRPS
USE06 1st user defined field for value field unit - WBS element CUKY 5 0 TCURC USE06PRPS
USR07 2nd user field for values (length 10,3) -WBS element CURR 13 3 USR07PRPS
USE07 2nd user defined field for value field unit - WBS element CUKY 5 0 TCURC USE07PRPS
USR08 1st user field for date -WBS element DATS 8 0 USR08PRPS
USR09 2nd user field for date -WBS element DATS 8 0 USR09PRPS
USR10 1st user field for 'Ind. for evaluations' WBS elem. CHAR 1 0 USR10PRPS
USR11 2nd user field for 'Indicator for eval.s' WBS elemnt CHAR 1 0 USR11PRPS
KOSTL Cost center to which costs are actually posted CHAR 10 0 CSKS PS_KOSTL
KTRG Cost Object CHAR 12 0 CKPH KSTRG
BERST Authorization key for project master data CHAR 16 0 PS_BERST
BERTR Authorization key for project dates (WBS) CHAR 16 0 PS_BERTR
BERKO Authorization key for costs and revenues CHAR 16 0 PS_BERKO
BERBU Authorization key for project budget CHAR 16 0 PS_BERBU
CLASF Indicator: WBS element used in project summarization CHAR 1 0 PS_CLASF
SPSNR Std WBS: Internal project item number (w/exit on ID) NUMC 8 0 PRPSS PS_SPSNR
SCOPE Object Class CHAR 2 0 SCOPE_CV
IV Investment
OC Overhead costs
PA Profit analysis
PR Production
XSTAT Statistical WBS element CHAR 1 0 PS_XSTAT
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
ZSCHM Interest Profile for Project/Order Interest Calculation CHAR 7 0 TPI01 PS_ZSCHM
IMPRF Investment Measure Profile CHAR 6 0 TAPRF IM_PROFIL
EVGEW Aggregation weight for POC (PS progress) DEC 8 0 EV_WEIGHTD
AENNR Change Number CHAR 12 0 AENR AENNR
SUBPR Sub-project in work breakdown structure CHAR 12 0 PRTP PS_SUBPR
POSTU PS: Short description (1st text line) in all caps CHAR 40 0 PS_POSTU
PLINT Indicator for Integrated Planning CHAR 1 0 PLINT
LOEVM Deletion Indicator CHAR 1 0 LOEVM
KZBWS Valuation of Special Stock CHAR 1 0 KZBWS
No stock valuation
A Valuation without reference to sales document
M Separate valuation with ref. to sales document/project
FPLNR Billing plan number / invoicing plan number CHAR 10 0 * FPLNR
TADAT Technically complete date DATS 8 0 TABGDAT
IZWEK Reason for Investment CHAR 2 0 T087I IZWEK
ISIZE Scale of investment objects CHAR 2 0 TAIF5 IM_SIZECL
IUMKZ Reason for Environmental Investment CHAR 5 0 T087K AM_UMWKZ
ABUKR Requesting company code CHAR 4 0 T001 IM_ABUKRS
GRPKZ Indicator: Grouping WBS element CHAR 1 0 GRPSPKZ
Not a grouping WBS element
1 Grouping WBS element for all materials
2 Grouping WBS element for selected MRP groups
PGPRF Distribution profile CHAR 6 0 TPGPRF PGPROFID
LOGSYSTEM Logical System CHAR 10 0 * LOGSYSTEM
PSPNR_LOGS Numeric field length 8 NUMC 8 0 NUM08
STORT Location CHAR 10 0 T499S PS_STORT
FUNC_AREA Functional Area CHAR 16 0 TFKB FKBER
KLVAR Costing Variant CHAR 4 0 * CK_KLVAR
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure NUMC 12 0 * CK_KALNR
POSID_EDIT Work Breakdown Structure Element (WBS Element) Edited CHAR 24 0 PS_POSID_EDIT
PSPKZ Indicator: WBS element for production lot CHAR 1 0 PL_PSPKZ
MATNR Material Number CHAR 40 0 MATNR
VLPSP WBS: Reference work breakdown structure element NUMC 8 0 PL_PSP_PNR
VLPKZ Indicator: Reference WBS element for production lot CHAR 1 0 PL_VLPKZ
SORT1 Sort string 1 for production lot CHAR 10 0 PL_SORT1
SORT2 Sort string 2 for production lot CHAR 10 0 PL_SORT2
SORT3 Sort string 3 for production lot CHAR 10 0 PL_SORT3
VNAME Joint venture CHAR 6 0 T8JV JV_NAME
RECID Recovery Indicator CHAR 2 0 T8JJ JV_RECIND
ETYPE Equity type CHAR 3 0 T8JE JV_ETYPE
OTYPE Joint Venture Object Type CHAR 4 0 JV_OTYPE
JIBCL JIB/JIBE Class CHAR 3 0 T8J6A JV_JIBCL
JIBSA JIB/JIBE Subclass A CHAR 5 0 T8J6C JV_JIBSA
CGPL_GUID16 Generic project planning: GUID from external R/3 system RAW 16 0 CGPL_GUID16_R3
CGPL_LOGSYS Generic project planning: Log. system for CGPL_GUID16_R3 CHAR 10 0 * CGPL_LOGSYS
CGPL_OBJTYPE Generic project planning: object type from ext. R/3 system CHAR 3 0 CGPL_OBJECT_TYPE_R3
ADPSP Reference Element PM/PS CHAR 40 0 ADDCOMPARE_CORE
RFIPPNT Reference Point for Relationship Between iPPE and PS CHAR 20 0 TCNRPIP CN_RPIP
EEW_PRPS_PS_DUMMY Dummy function in length 1 CHAR 1 0 DUMMY
RFUND Fund CHAR 10 0 * BP_GEBER
RGRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
FUND_FIX_ASSIGN Indicator for Fund with Fixed Assignment CHAR 1 0 PSM_FUND_FIX_ASSIGNED
GRANT_FIX_ASSIGNED Indicator for Grant with Fixed Assignment CHAR 1 0 PSM_GRANT_FIX_ASSIGNED
FUNC_AREA_FIX_ASSIGNED Indicator for Functional Area with Fixed Assignment CHAR 1 0 PSM_FUNC_AREA_FIX_ASSIGNED
SPONSOREDPROG Sponsored Program CHAR 20 0 * GM_SPONSORED_PROG
CPD_UPDAT Time Stamp DEC 15 0 /CPD/PFP_SC_TSTMP
FERC_IND Regulatory indicator CHAR 4 0 FERC_C7 FE_IND
POSNR_PRPS Sales Document Item NUMC 6 0 POSNR_VA
VBELN_PRPS Sales Document CHAR 10 0 VBELN_VA

PRPS foreign key relationships

Table Field Check Table Check Field
0 PRPS ABGSL TKKAA Check Table for Results Analysis Key of RA for Orders MANDT
0 PRPS ABGSL TKKAA Check Table for Results Analysis Key of RA for Orders ABGSL
1 PRPS ABUKR T001 Company Codes BUKRS
0 PRPS AENNR AENR Change Master AENNR
1 PRPS AKOKR TKA01 Controlling Areas MANDT
0 PRPS AKSTL CSKS Cost Center Master Record MANDT
0 PRPS AKSTL CSKS Cost Center Master Record KOKRS
0 PRPS AKSTL CSKS Cost Center Master Record DATBI
1 PRPS ASTNR TCJ05 Project applicant MANDT
0 PRPS EQUNR EQUI Equipment master data MANDT
1 PRPS ETYPE T8JE Investment Type MANDT
1 PRPS ETYPE T8JE Investment Type BUKRS
1 PRPS ETYPE T8JE Investment Type ETYPE
0 PRPS FERC_IND FERC_C7 Regulatory indicators MANDT
0 PRPS FERC_IND FERC_C7 Regulatory indicators IND
1 PRPS FKOKR TKA01 Controlling Areas MANDT
0 PRPS FKSTL CSKS Cost Center Master Record MANDT
0 PRPS FKSTL CSKS Cost Center Master Record KOKRS
0 PRPS FKSTL CSKS Cost Center Master Record DATBI
1 PRPS FUNC_AREA TFKB Functional areas FKBER
0 PRPS IMPRF TAPRF Cap. inv. measure profile for AuC and dep. simulation MANDT
0 PRPS IMPRF TAPRF Cap. inv. measure profile for AuC and dep. simulation IVPRO
1 PRPS ISIZE TAIF5 Scale of investment objects MANDT
1 PRPS ISIZE TAIF5 Scale of investment objects SIZECL
0 PRPS IUMKZ T087K Reason for investment protecting the environment MANDT
1 PRPS IZWEK T087I Reason for investment MANDT
1 PRPS IZWEK T087I Reason for investment IZWEK
0 PRPS JIBCL T8J6A JIB/JIBE Class MANDT
0 PRPS JIBCL T8J6A JIB/JIBE Class BUKRS
0 PRPS JIBCL T8J6A JIB/JIBE Class CLASS
1 PRPS JIBSA T8J6C JIB/JIBE Subclass MANDT
1 PRPS JIBSA T8J6C JIB/JIBE Subclass BUKRS
0 PRPS KALSM T683 Pricing procedures KAPPL
0 PRPS KALSM T683 Pricing procedures KALSM
1 PRPS KAPPL T681A Conditions: Applications KAPPL
0 PRPS KOSTL CSKS Cost Center Master Record MANDT
0 PRPS KOSTL CSKS Cost Center Master Record KOKRS
0 PRPS KOSTL CSKS Cost Center Master Record KOSTL
0 PRPS KOSTL CSKS Cost Center Master Record DATBI
1 PRPS KTRG CKPH Master Record: Cost Object ID Number MANDT
1 PRPS KTRG CKPH Master Record: Cost Object ID Number KSTRG
1 PRPS KTRG CKPH Master Record: Cost Object ID Number DATBI
0 PRPS KVEWE T681V Conditions: Usages KVEWE
1 PRPS OBJNR ONR00 General Object Number MANDT
0 PRPS PBUKR T001 Company Codes BUKRS
1 PRPS PGPRF TPGPRF Profile for static pegging and data distribution PROFID
0 PRPS PGSBR TGSB Business Areas MANDT
0 PRPS PGSBR TGSB Business Areas GSBER
1 PRPS PKOKR TKA01 Controlling Areas MANDT
0 PRPS PRART TCJ1 "Project Types" MANDT
0 PRPS PRART TCJ1 "Project Types" PRART
1 PRPS PRCTR CEPC Profit Center Master Data Table PRCTR
1 PRPS PRCTR CEPC Profit Center Master Data Table DATBI
1 PRPS PRCTR CEPC Profit Center Master Data Table KOKRS
0 PRPS PSPHI PROJ Project definition MANDT
0 PRPS PSPHI PROJ Project definition PSPNR
1 PRPS PSPRI TCN07 Priority MANDT
1 PRPS PSPRI TCN07 Priority NPRIO
0 PRPS PWPOS TCURC Currency Codes MANDT
0 PRPS PWPOS TCURC Currency Codes WAERS
1 PRPS RECID T8JJ Recovery Indicator MANDT
1 PRPS RECID T8JJ Recovery Indicator BUKRS
0 PRPS RFIPPNT TCNRPIP Reference point for relationship between IPPE & PS. MANDT
0 PRPS RFIPPNT TCNRPIP Reference point for relationship between IPPE & PS. RFPNT
1 PRPS SLWID TCN00 Key Word ID for PS User Fields MANDT
0 PRPS SPSNR PRPSS Standard WBS Element (WBS element) - Master Data MANDT
0 PRPS SPSNR PRPSS Standard WBS Element (WBS element) - Master Data PSPNR
1 PRPS STORT T499S Location MANDT
1 PRPS STORT T499S Location WERKS
0 PRPS SUBPR PRTP Subprojects MANDT
0 PRPS SUBPR PRTP Subprojects SUBPR
1 PRPS TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
1 PRPS TXJCD TTXJ Check Table for Tax Jurisdiction KALSM
0 PRPS TXTSP T002 Language Keys (Component BC-I18) SPRAS
1 PRPS USE04 T006 Units of Measurement MANDT
0 PRPS USE05 T006 Units of Measurement MANDT
1 PRPS USE06 TCURC Currency Codes MANDT
1 PRPS USE06 TCURC Currency Codes WAERS
0 PRPS USE07 TCURC Currency Codes MANDT
0 PRPS USE07 TCURC Currency Codes WAERS
1 PRPS VERNR TCJ04 Person in Responsible for Project MANDT
1 PRPS VERNR TCJ04 Person in Responsible for Project VERNR
0 PRPS VNAME T8JV Joint Venture MANDT
0 PRPS VNAME T8JV Joint Venture BUKRS
0 PRPS VNAME T8JV Joint Venture VNAME
1 PRPS WERKS T001W Plants/Branches MANDT
1 PRPS WERKS T001W Plants/Branches WERKS
0 PRPS ZSCHL TKZSL Overhead Key ZSCHL
1 PRPS ZSCHM TPI01 Interest Profile MANDT