Follow us on LinkedIn for your next SAP project

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 Possible values
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
BELKZ
Indicator: Account assignment element
PS_BELKZ
CHAR
1 0
FAKKZ
Indicator: Billing element
PS_FAKKZ
CHAR
1 0
NPFAZ
Relationship of network activity to production order
PS_NPFAR
CHAR
1 0
ZUORD
Network assignment
PS_ZUORD
NUMC
1 0
TRMEQ
Indicator: WBS dates detailed by activity dates
PS_TRMEQ
CHAR
1 0
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
USR11
2nd user field for 'Indicator for eval.s' WBS elemnt
USR11PRPS
CHAR
1 0
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
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
XSTAT
Statistical WBS element
PS_XSTAT
CHAR
1 0
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
LOEVM
Deletion Indicator
LOEVM
CHAR
1 0
KZBWS
Valuation of Special Stock
KZBWS
CHAR
1 0
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
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
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
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 ABGSL TKKAA
Check Table for Results Analysis Key of RA for Orders
ABGSL
PRPS ABGSL PRPS MANDT TKKAA
Check Table for Results Analysis Key of RA for Orders
MANDT
PRPS ABUKR SYST MANDT T001
Company Codes
MANDT
PRPS ABUKR PRPS ABUKR T001
Company Codes
BUKRS
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 MANDT CSKS
Cost Center Master Data
MANDT
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 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 PBUKR T8JE
Investment Type
BUKRS
PRPS ETYPE PRPS ETYPE T8JE
Investment Type
ETYPE
PRPS ETYPE PRPS MANDT T8JE
Investment Type
MANDT
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 MANDT TKA01
Controlling Areas
MANDT
PRPS FKOKR PRPS FKOKR TKA01
Controlling Areas
KOKRS
PRPS FKSTL PRPS FKOKR CSKS
Cost Center Master Data
KOKRS
PRPS FKSTL PRPS FKSTL CSKS
Cost Center Master Data
KOSTL
PRPS FKSTL * CSKS
Cost Center Master Data
DATBI
PRPS FKSTL PRPS MANDT CSKS
Cost Center Master Data
MANDT
PRPS FUNC_AREA PRPS FUNC_AREA TFKB
Functional areas
FKBER
PRPS FUNC_AREA SYST MANDT TFKB
Functional areas
MANDT
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 SY MANDT T087I
Reason for investment
MANDT
PRPS IZWEK PRPS IZWEK T087I
Reason for investment
IZWEK
PRPS JIBCL PRPS JIBCL T8J6A
JIB/JIBE Class
CLASS
PRPS JIBCL PRPS MANDT T8J6A
JIB/JIBE Class
MANDT
PRPS JIBCL PRPS PBUKR T8J6A
JIB/JIBE Class
BUKRS
PRPS JIBSA PRPS MANDT T8J6C
JIB/JIBE Subclass
MANDT
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 KALSM PRPS KVEWE T683
Pricing procedures
KVEWE
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 KAPPL PRPS KAPPL T681A
Conditions: Applications
KAPPL
PRPS KOSTL * CSKS
Cost Center Master Data
DATBI
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 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 MANDT TCJ1
"Project Types"
MANDT
PRPS PRART PRPS PRART TCJ1
"Project Types"
PRART
PRPS PRCTR * CEPC
Profit Center Master Data Table
DATBI
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 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 PSPHI PROJ
Project definition
PSPNR
PRPS PSPHI PRPS MANDT PROJ
Project definition
MANDT
PRPS PSPRI PRPS PSPRI TCN07
Priority
NPRIO
PRPS PSPRI PRPS MANDT TCN07
Priority
MANDT
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 MANDT PRPSS
Standard WBS Element (WBS element) - Master Data
MANDT
PRPS SPSNR PRPS SPSNR PRPSS
Standard WBS Element (WBS element) - Master Data
PSPNR
PRPS STORT PRPS WERKS T499S
Location
WERKS
PRPS STORT PRPS STORT T499S
Location
STAND
PRPS STORT SYST MANDT T499S
Location
MANDT
PRPS SUBPR PRPS MANDT PRTP
Subprojects
MANDT
PRPS SUBPR PRPS SUBPR PRTP
Subprojects
SUBPR
PRPS TPLNR PRPS MANDT IFLOT
Functional Location (Table)
MANDT
PRPS TPLNR PRPS TPLNR IFLOT
Functional Location (Table)
TPLNR
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 USE05 T006
Units of Measurement
MSEHI
PRPS USE05 PRPS MANDT T006
Units of Measurement
MANDT
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 MANDT T8JV
Joint Venture
MANDT
PRPS VNAME PRPS PBUKR T8JV
Joint Venture
BUKRS
PRPS VNAME PRPS VNAME T8JV
Joint Venture
VNAME
PRPS WERKS PRPS WERKS T001W
Plants/Branches
WERKS
PRPS WERKS PRPS MANDT T001W
Plants/Branches
MANDT
PRPS ZSCHL PRPS MANDT TKZSL
Overhead Key
MANDT
PRPS ZSCHL PRPS ZSCHL TKZSL
Overhead Key
ZSCHL
PRPS ZSCHM PRPS ZSCHM TPI01
Interest Profile
ZSCHM
PRPS ZSCHM PRPS MANDT TPI01
Interest Profile
MANDT
PRPS ZZPS01 SYST LANGU ZZZ_PS01
Industry
LANGU
PRPS ZZPS01 PRPS ZZPS01 ZZZ_PS01
Industry
ZZPS01
PRPS ZZPS01 * ZZZ_PS01
Industry
DESCR
PRPS ZZPS01 SYST MANDT ZZZ_PS01
Industry
MANDT
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