SAP Table PRPS_UPDATE_RELEVANT

Fields from PRPS (sim.vers.) that are relevant to the update

PRPS_UPDATE_RELEVANT (Fields from PRPS (sim.vers.) that are relevant to the update) 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_UPDATE_RELEVANT to other SAP tables.

Source: PRPS_UPDATE_RELEVANT (Fields from PRPS (sim.vers.) that are relevant to the update)

PRPS_UPDATE_RELEVANT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 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
POSKI WBS element short identification PS_POSKI CHAR 16 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 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 CHAR 10 0
FKOKR Controlling area of responsible cost center PS_FKOKR TKA01 CHAR 4 0
FKSTL Responsible cost center PS_FKSTL 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 KOSTL CHAR 10 0
KTRG Cost Object KSTRG 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
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
VNAME Joint Venture JV_NAME T8JV CHAR 6 0
RECID Recovery Indicator JV_RECIND T8JJ CHAR 2 0
ETYPE Equity type JV_ETYPE T8JG 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

PRPS_UPDATE_RELEVANT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PRPS_UPDATE_RELEVANT ABGSL PRPS_UPDATE_RELEVANT MANDT TKKAA Check Table for Results Analysis Key of RA for Orders MANDT
PRPS_UPDATE_RELEVANT ABGSL PRPS_UPDATE_RELEVANT ABGSL TKKAA Check Table for Results Analysis Key of RA for Orders ABGSL
PRPS_UPDATE_RELEVANT ABUKR SY MANDT T001 Company Codes MANDT
PRPS_UPDATE_RELEVANT ABUKR PRPS_UPDATE_RELEVANT ABUKR T001 Company Codes BUKRS
PRPS_UPDATE_RELEVANT AENNR PRPS_UPDATE_RELEVANT MANDT AENR Change Master MANDT
PRPS_UPDATE_RELEVANT AENNR PRPS_UPDATE_RELEVANT AENNR AENR Change Master AENNR
PRPS_UPDATE_RELEVANT AKOKR PRPS_UPDATE_RELEVANT MANDT TKA01 Controlling Areas MANDT
PRPS_UPDATE_RELEVANT AKOKR PRPS_UPDATE_RELEVANT AKOKR TKA01 Controlling Areas KOKRS
PRPS_UPDATE_RELEVANT ASTNR PRPS_UPDATE_RELEVANT MANDT TCJ05 Project applicant MANDT
PRPS_UPDATE_RELEVANT ASTNR PRPS_UPDATE_RELEVANT ASTNR TCJ05 Project applicant ASTNR
PRPS_UPDATE_RELEVANT EQUNR PRPS_UPDATE_RELEVANT MANDT EQUI Equipment master data MANDT
PRPS_UPDATE_RELEVANT EQUNR PRPS_UPDATE_RELEVANT EQUNR EQUI Equipment master data EQUNR
PRPS_UPDATE_RELEVANT ETYPE SYST MANDT T8JG Valid Investment Group MANDT
PRPS_UPDATE_RELEVANT ETYPE GJV_OBJDAT BUKRS T8JG Valid Investment Group BUKRS
PRPS_UPDATE_RELEVANT ETYPE PRPS_UPDATE_RELEVANT VNAME T8JG Valid Investment Group VNAME
PRPS_UPDATE_RELEVANT ETYPE PRPS_UPDATE_RELEVANT ETYPE T8JG Valid Investment Group ETYPE
PRPS_UPDATE_RELEVANT ETYPE * T8JG Valid Investment Group FDATE
PRPS_UPDATE_RELEVANT FABKL PRPS_UPDATE_RELEVANT FABKL TFACD Factory calendar definition IDENT
PRPS_UPDATE_RELEVANT FKOKR PRPS_UPDATE_RELEVANT MANDT TKA01 Controlling Areas MANDT
PRPS_UPDATE_RELEVANT FKOKR PRPS_UPDATE_RELEVANT FKOKR TKA01 Controlling Areas KOKRS
PRPS_UPDATE_RELEVANT IMPRF PRPS_UPDATE_RELEVANT MANDT TAPRF Cap. inv. measure profile for AuC and dep. simulation MANDT
PRPS_UPDATE_RELEVANT IMPRF PRPS_UPDATE_RELEVANT IMPRF TAPRF Cap. inv. measure profile for AuC and dep. simulation IVPRO
PRPS_UPDATE_RELEVANT ISIZE SY MANDT TAIF5 Scale of investment objects MANDT
PRPS_UPDATE_RELEVANT ISIZE PRPS_UPDATE_RELEVANT ISIZE TAIF5 Scale of investment objects SIZECL
PRPS_UPDATE_RELEVANT IUMKZ SY MANDT T087K Reason for investment protecting the environment MANDT
PRPS_UPDATE_RELEVANT IUMKZ PRPS_UPDATE_RELEVANT IUMKZ T087K Reason for investment protecting the environment UMWKZ
PRPS_UPDATE_RELEVANT IZWEK SY MANDT T087I Reason for investment MANDT
PRPS_UPDATE_RELEVANT IZWEK PRPS_UPDATE_RELEVANT IZWEK T087I Reason for investment IZWEK
PRPS_UPDATE_RELEVANT JIBCL SYST MANDT T8J6A JIB/JIBE Class MANDT
PRPS_UPDATE_RELEVANT JIBCL GJV_OBJDAT BUKRS T8J6A JIB/JIBE Class BUKRS
PRPS_UPDATE_RELEVANT JIBCL PRPS_UPDATE_RELEVANT JIBCL T8J6A JIB/JIBE Class CLASS
PRPS_UPDATE_RELEVANT JIBSA SYST MANDT T8J6C JIB/JIBE Subclass MANDT
PRPS_UPDATE_RELEVANT JIBSA GJV_OBJDAT BUKRS T8J6C JIB/JIBE Subclass BUKRS
PRPS_UPDATE_RELEVANT JIBSA PRPS_UPDATE_RELEVANT JIBCL T8J6C JIB/JIBE Subclass CLASS
PRPS_UPDATE_RELEVANT JIBSA PRPS_UPDATE_RELEVANT JIBSA T8J6C JIB/JIBE Subclass SUBCLASS
PRPS_UPDATE_RELEVANT KALSM PRPS_UPDATE_RELEVANT MANDT T683 Pricing procedures MANDT
PRPS_UPDATE_RELEVANT KALSM PRPS_UPDATE_RELEVANT KVEWE T683 Pricing procedures KVEWE
PRPS_UPDATE_RELEVANT KALSM PRPS_UPDATE_RELEVANT KAPPL T683 Pricing procedures KAPPL
PRPS_UPDATE_RELEVANT KALSM PRPS_UPDATE_RELEVANT KALSM T683 Pricing procedures KALSM
PRPS_UPDATE_RELEVANT KAPPL PRPS_UPDATE_RELEVANT KAPPL T681A Conditions: Applications KAPPL
PRPS_UPDATE_RELEVANT KVEWE PRPS_UPDATE_RELEVANT KVEWE T681V Conditions: Usages KVEWE
PRPS_UPDATE_RELEVANT PBUKR PRPS_UPDATE_RELEVANT MANDT T001 Company Codes MANDT
PRPS_UPDATE_RELEVANT PBUKR PRPS_UPDATE_RELEVANT PBUKR T001 Company Codes BUKRS
PRPS_UPDATE_RELEVANT PGSBR PRPS_UPDATE_RELEVANT MANDT TGSB Business Areas MANDT
PRPS_UPDATE_RELEVANT PGSBR PRPS_UPDATE_RELEVANT PGSBR TGSB Business Areas GSBER
PRPS_UPDATE_RELEVANT PKOKR PRPS_UPDATE_RELEVANT MANDT TKA01 Controlling Areas MANDT
PRPS_UPDATE_RELEVANT PKOKR PRPS_UPDATE_RELEVANT PKOKR TKA01 Controlling Areas KOKRS
PRPS_UPDATE_RELEVANT PRART PRPS_UPDATE_RELEVANT MANDT TCJ1 "Project Types" MANDT
PRPS_UPDATE_RELEVANT PRART PRPS_UPDATE_RELEVANT PRART TCJ1 "Project Types" PRART
PRPS_UPDATE_RELEVANT PRCTR PRPS_UPDATE_RELEVANT MANDT CEPC Profit Center Master Data Table MANDT
PRPS_UPDATE_RELEVANT PRCTR PRPS_UPDATE_RELEVANT PRCTR CEPC Profit Center Master Data Table PRCTR
PRPS_UPDATE_RELEVANT PRCTR * CEPC Profit Center Master Data Table DATBI
PRPS_UPDATE_RELEVANT PRCTR * CEPC Profit Center Master Data Table KOKRS
PRPS_UPDATE_RELEVANT PSPRI PRPS_UPDATE_RELEVANT MANDT TCN07 Priority MANDT
PRPS_UPDATE_RELEVANT PSPRI PRPS_UPDATE_RELEVANT PSPRI TCN07 Priority NPRIO
PRPS_UPDATE_RELEVANT PWPOS PRPS_UPDATE_RELEVANT MANDT TCURC Currency Codes MANDT
PRPS_UPDATE_RELEVANT PWPOS PRPS_UPDATE_RELEVANT PWPOS TCURC Currency Codes WAERS
PRPS_UPDATE_RELEVANT RECID SYST MANDT T8JJ Recovery Indicator MANDT
PRPS_UPDATE_RELEVANT RECID GJV_OBJDAT BUKRS T8JJ Recovery Indicator BUKRS
PRPS_UPDATE_RELEVANT RECID PRPS_UPDATE_RELEVANT RECID T8JJ Recovery Indicator RECID
PRPS_UPDATE_RELEVANT SLWID PRPS_UPDATE_RELEVANT MANDT TCN00 Key Word ID for PS User Fields MANDT
PRPS_UPDATE_RELEVANT SLWID PRPS_UPDATE_RELEVANT SLWID TCN00 Key Word ID for PS User Fields SLWID
PRPS_UPDATE_RELEVANT SPSNR PRPS_UPDATE_RELEVANT MANDT PRPSS Standard WBS Element (WBS element) - Master Data MANDT
PRPS_UPDATE_RELEVANT SPSNR PRPS_UPDATE_RELEVANT SPSNR PRPSS Standard WBS Element (WBS element) - Master Data PSPNR
PRPS_UPDATE_RELEVANT SUBPR PRPS_UPDATE_RELEVANT MANDT PRTP Subprojects MANDT
PRPS_UPDATE_RELEVANT SUBPR PRPS_UPDATE_RELEVANT SUBPR PRTP Subprojects SUBPR
PRPS_UPDATE_RELEVANT TPLNR PRPS_UPDATE_RELEVANT MANDT IFLOT Functional Location (Table) MANDT
PRPS_UPDATE_RELEVANT TPLNR PRPS_UPDATE_RELEVANT TPLNR IFLOT Functional Location (Table) TPLNR
PRPS_UPDATE_RELEVANT TXJCD PRPS_UPDATE_RELEVANT MANDT TTXJ Check Table for Tax Jurisdiction MANDT
PRPS_UPDATE_RELEVANT TXJCD T005 KALSM TTXJ Check Table for Tax Jurisdiction KALSM
PRPS_UPDATE_RELEVANT TXJCD PRPS_UPDATE_RELEVANT TXJCD TTXJ Check Table for Tax Jurisdiction TXJCD
PRPS_UPDATE_RELEVANT TXTSP PRPS_UPDATE_RELEVANT TXTSP T002 Language Keys (Component BC-I18) SPRAS
PRPS_UPDATE_RELEVANT USE04 PRPS_UPDATE_RELEVANT MANDT T006 Units of Measurement MANDT
PRPS_UPDATE_RELEVANT USE04 PRPS_UPDATE_RELEVANT USE04 T006 Units of Measurement MSEHI
PRPS_UPDATE_RELEVANT USE05 PRPS_UPDATE_RELEVANT MANDT T006 Units of Measurement MANDT
PRPS_UPDATE_RELEVANT USE05 PRPS_UPDATE_RELEVANT USE05 T006 Units of Measurement MSEHI
PRPS_UPDATE_RELEVANT USE06 PRPS_UPDATE_RELEVANT MANDT TCURC Currency Codes MANDT
PRPS_UPDATE_RELEVANT USE06 PRPS_UPDATE_RELEVANT USE06 TCURC Currency Codes WAERS
PRPS_UPDATE_RELEVANT USE07 PRPS_UPDATE_RELEVANT MANDT TCURC Currency Codes MANDT
PRPS_UPDATE_RELEVANT USE07 PRPS_UPDATE_RELEVANT USE07 TCURC Currency Codes WAERS
PRPS_UPDATE_RELEVANT VERNR PRPS_UPDATE_RELEVANT MANDT TCJ04 Person in Responsible for Project MANDT
PRPS_UPDATE_RELEVANT VERNR PRPS_UPDATE_RELEVANT VERNR TCJ04 Person in Responsible for Project VERNR
PRPS_UPDATE_RELEVANT VNAME SYST MANDT T8JV Joint Venture MANDT
PRPS_UPDATE_RELEVANT VNAME GJV_OBJDAT BUKRS T8JV Joint Venture BUKRS
PRPS_UPDATE_RELEVANT VNAME PRPS_UPDATE_RELEVANT VNAME T8JV Joint Venture VNAME
PRPS_UPDATE_RELEVANT WERKS PRPS_UPDATE_RELEVANT MANDT T001W Plants/Branches MANDT
PRPS_UPDATE_RELEVANT WERKS PRPS_UPDATE_RELEVANT WERKS T001W Plants/Branches WERKS
PRPS_UPDATE_RELEVANT ZSCHM PRPS_UPDATE_RELEVANT MANDT TPI01 Interest Profile MANDT
PRPS_UPDATE_RELEVANT ZSCHM PRPS_UPDATE_RELEVANT ZSCHM TPI01 Interest Profile ZSCHM
PRPS_UPDATE_RELEVANT ZZPS01 SYST MANDT ZZZ_PS01 Industry MANDT
PRPS_UPDATE_RELEVANT ZZPS01 SYST LANGU ZZZ_PS01 Industry LANGU
PRPS_UPDATE_RELEVANT ZZPS01 PRPS_UPDATE_RELEVANT ZZPS01 ZZZ_PS01 Industry ZZPS01
PRPS_UPDATE_RELEVANT ZZPS01 * ZZZ_PS01 Industry DESCR
PRPS_UPDATE_RELEVANT ZZPS02 SYST MANDT ZZZ_PS02 Type of Work MANDT
PRPS_UPDATE_RELEVANT ZZPS02 SYST LANGU ZZZ_PS02 Type of Work LANGU
PRPS_UPDATE_RELEVANT ZZPS02 PRPS_UPDATE_RELEVANT ZZPS02 ZZZ_PS02 Type of Work ZZPS02
PRPS_UPDATE_RELEVANT ZZPS02 * ZZZ_PS02 Type of Work DESCR
PRPS_UPDATE_RELEVANT ZZPS03 SYST MANDT ZZZ_PS03 Overall Project Risk MANDT
PRPS_UPDATE_RELEVANT ZZPS03 SYST LANGU ZZZ_PS03 Overall Project Risk LANGU
PRPS_UPDATE_RELEVANT ZZPS03 PRPS_UPDATE_RELEVANT ZZPS03 ZZZ_PS03 Overall Project Risk ZZPS03
PRPS_UPDATE_RELEVANT ZZPS03 * ZZZ_PS03 Overall Project Risk DESCR
PRPS_UPDATE_RELEVANT ZZPS04 SYST MANDT ZZZ_PS04 Financial Risk MANDT
PRPS_UPDATE_RELEVANT ZZPS04 SYST LANGU ZZZ_PS04 Financial Risk LANGU
PRPS_UPDATE_RELEVANT ZZPS04 PRPS_UPDATE_RELEVANT ZZPS04 ZZZ_PS04 Financial Risk ZZPS04
PRPS_UPDATE_RELEVANT ZZPS04 * ZZZ_PS04 Financial Risk DESCR
PRPS_UPDATE_RELEVANT ZZPS05 SYST MANDT ZZZ_PS05 Technical Risk MANDT
PRPS_UPDATE_RELEVANT ZZPS05 SYST LANGU ZZZ_PS05 Technical Risk LANGU
PRPS_UPDATE_RELEVANT ZZPS05 PRPS_UPDATE_RELEVANT ZZPS05 ZZZ_PS05 Technical Risk ZZPS05
PRPS_UPDATE_RELEVANT ZZPS05 * ZZZ_PS05 Technical Risk DESCR