1. Home
  2. Resources
  3. SAP Tables
  4. PRPS - WBS (Work Breakdown Structure) Element Master Data

SAP Table PRPS

WBS (Work Breakdown Structure) Element Master Data

PRPS (WBS (Work Breakdown Structure) Element Master Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link PRPS to other SAP tables.

PRPS table fields

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

PRPS foreign key relationships

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