SAP Table

PRPSS Standard WBS Element (WBS element) - Master Data

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

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

/ Fields

PRPSS columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyPSPNR 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
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
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
GRPKZ Indicator: Grouping WBS element CHAR 1 0 GRPSPKZ
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
/ Relationships

PRPSS foreign keys.

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