SAP Tabel PRPSS (Standard WBS Element (WBS element) - Master Data)

SAP table PRPSS 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 Std WBS: Internal project item number (w/exit on ID) NUMC 8 0 PS_SPSNR
POSID WBS element in standard project CHAR 24 0 PS_SPSID
POST1 PS: Short description (1st text line) CHAR 40 0 PS_POST1
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
PSPHI Current number for standard project NUMC 8 0 PROJS PS_ISPSP
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 * 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 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 Project priority CHAR 1 0 PS_PRIOR
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 * 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
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
STORT Location CHAR 10 0 T499S PS_STORT
FUNC_AREA Functional Area CHAR 16 0 * FKBER
POSID_EDIT Standard Work Breakdown Structure (S WBS Element) Edited CHAR 24 0 PS_SPSID_EDIT
VNAME Joint venture CHAR 6 0 T8JV JV_NAME
RECID Recovery Indicator CHAR 2 0 T8JJ JV_RECIND
ETYPE Equity type CHAR 3 0 T8JG 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
ADPSP Reference Element PM/PS CHAR 40 0 * ADDCOMPARE_CORE

PRPSS foreign key relationships

Table Field Check Table Check Field
0 PRPSS ABGSL TKKAA Check Table for Results Analysis Key of RA for Orders MANDT
0 PRPSS ABGSL TKKAA Check Table for Results Analysis Key of RA for Orders ABGSL
1 PRPSS AENNR AENR Change Master AENNR
0 PRPSS AKOKR TKA01 Controlling Areas MANDT
1 PRPSS AKSTL CSKS Cost Center Master Record MANDT
1 PRPSS AKSTL CSKS Cost Center Master Record KOKRS
1 PRPSS AKSTL CSKS Cost Center Master Record DATBI
0 PRPSS ASTNR TCJ05 Project applicant MANDT
1 PRPSS EQUNR EQUI Equipment master data MANDT
0 PRPSS ETYPE T8JG Valid Investment Group MANDT
0 PRPSS ETYPE T8JG Valid Investment Group BUKRS
0 PRPSS ETYPE T8JG Valid Investment Group VNAME
0 PRPSS ETYPE T8JG Valid Investment Group FDATE
1 PRPSS FKOKR TKA01 Controlling Areas MANDT
0 PRPSS FKSTL CSKS Cost Center Master Record MANDT
0 PRPSS FKSTL CSKS Cost Center Master Record KOKRS
0 PRPSS FKSTL CSKS Cost Center Master Record DATBI
1 PRPSS IMPRF TAPRF Cap. inv. measure profile for AuC and dep. simulation MANDT
1 PRPSS IMPRF TAPRF Cap. inv. measure profile for AuC and dep. simulation IVPRO
0 PRPSS JIBCL T8J6A JIB/JIBE Class MANDT
0 PRPSS JIBCL T8J6A JIB/JIBE Class BUKRS
0 PRPSS JIBCL T8J6A JIB/JIBE Class CLASS
1 PRPSS JIBSA T8J6C JIB/JIBE Subclass MANDT
1 PRPSS JIBSA T8J6C JIB/JIBE Subclass BUKRS
0 PRPSS KALSM T683 Pricing procedures KAPPL
0 PRPSS KALSM T683 Pricing procedures KALSM
1 PRPSS KAPPL T681A Conditions: Applications KAPPL
0 PRPSS KOSTL CSKS Cost Center Master Record MANDT
0 PRPSS KOSTL CSKS Cost Center Master Record KOKRS
0 PRPSS KOSTL CSKS Cost Center Master Record KOSTL
0 PRPSS KOSTL CSKS Cost Center Master Record DATBI
1 PRPSS KTRG CKPH Master Record: Cost Object ID Number MANDT
1 PRPSS KTRG CKPH Master Record: Cost Object ID Number KSTRG
1 PRPSS KTRG CKPH Master Record: Cost Object ID Number DATBI
0 PRPSS KVEWE T681V Conditions: Usages KVEWE
1 PRPSS OBJNR ONR00 General Object Number MANDT
0 PRPSS PBUKR T001 Company Codes BUKRS
1 PRPSS PGPRF TPGPRF Profile for static pegging and data distribution PROFID
0 PRPSS PGSBR TGSB Business Areas MANDT
0 PRPSS PGSBR TGSB Business Areas GSBER
1 PRPSS PKOKR TKA01 Controlling Areas MANDT
0 PRPSS PRART TCJ1 "Project Types" MANDT
0 PRPSS PRART TCJ1 "Project Types" PRART
1 PRPSS PSPHI PROJS Standard project definition MANDT
1 PRPSS PSPHI PROJS Standard project definition PSPNR
0 PRPSS PWPOS TCURC Currency Codes MANDT
0 PRPSS PWPOS TCURC Currency Codes WAERS
1 PRPSS RECID T8JJ Recovery Indicator MANDT
1 PRPSS RECID T8JJ Recovery Indicator BUKRS
0 PRPSS SLWID TCN00 Key Word ID for PS User Fields MANDT
1 PRPSS STORT T499S Location MANDT
1 PRPSS STORT T499S Location WERKS
0 PRPSS SUBPR PRTP Subprojects MANDT
0 PRPSS SUBPR PRTP Subprojects SUBPR
1 PRPSS TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
1 PRPSS TXJCD TTXJ Check Table for Tax Jurisdiction KALSM
0 PRPSS TXTSP T002 Language Keys (Component BC-I18) SPRAS
1 PRPSS USE04 T006 Units of Measurement MANDT
0 PRPSS USE05 T006 Units of Measurement MANDT
1 PRPSS USE06 TCURC Currency Codes MANDT
1 PRPSS USE06 TCURC Currency Codes WAERS
0 PRPSS USE07 TCURC Currency Codes MANDT
0 PRPSS USE07 TCURC Currency Codes WAERS
1 PRPSS VERNR TCJ04 Person in Responsible for Project MANDT
1 PRPSS VERNR TCJ04 Person in Responsible for Project VERNR
0 PRPSS VNAME T8JV Joint Venture MANDT
0 PRPSS VNAME T8JV Joint Venture BUKRS
0 PRPSS VNAME T8JV Joint Venture VNAME
1 PRPSS WERKS T001W Plants/Branches MANDT
1 PRPSS WERKS T001W Plants/Branches WERKS
0 PRPSS ZSCHM TPI01 Interest Profile MANDT