PRPS SAP table for – WBS (Work Breakdown Structure) Element Master Data

Here we would like to draw your attention to PRPS table in SAP. As we know it is being mainly used with the SAP PS-ST (Structures in PS) component which is coming under PS module (Project Systems). PRPS is a SAP standard transparent table used for storing WBS (Work Breakdown Structure) Element Master Data related data in SAP. It comes under the package CN.

SAP PRPS table

Table PRPS technical data

TablePRPS
Data storingWBS (Work Breakdown Structure) Element Master Data
ModulePS
ComponentPS-ST
SAP PackageCN
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP PRPS Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in PRPS table.

  • VNAME : Joint venture
    Its data type is C (Character String) with field length 6
  • ETYPE : Equity type
    Its data type is C (Character String) with field length 3
  • JIBCL
    Its data type is C (Character String) with field length 3
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VERNA
    Its data type is C (Character String) with field length 25
  • ASTNA
    Its data type is C (Character String) with field length 25
  • PGSBR
    Its data type is C (Character String) with field length 4
  • PSPNR : Standard WBS element
    Its a key field. Its data type is N (Character String with Digits Only) with field length 8
  • PRCTR : Profit Center
    Its data type is C (Character String) with field length 10
  • STUFE : Level (in Multi-Level BOM Explosions)
    Its data type is X (Byte string) with field length 1
  • PLAKZ
    Its data type is C (Character String) with field length 1
  • BELKZ
    Its data type is C (Character String) with field length 1
  • ZUORD
    Its data type is N (Character String with Digits Only) with field length 1
  • KAPPL : Application
    Its data type is C (Character String) with field length 2
  • KALSM : Costing Sheet
    Its data type is C (Character String) with field length 6
  • ABGSL
    Its data type is C (Character String) with field length 6
  • AKOKR
    Its data type is C (Character String) with field length 4
  • FKOKR
    Its data type is C (Character String) with field length 4
  • FABKL
    Its data type is C (Character String) with field length 2
  • POSID
    Its data type is C (Character String) with field length 24
  • EQUNR : Equipment Number
    Its data type is C (Character String) with field length 18
  • PWPOS
    Its data type is C (Character String) with field length 5
  • TXTSP : Language Key
    Its data type is C (Character String) with field length 1
  • USR00 : User field with 20 characters
    Its data type is C (Character String) with field length 20
  • USR03 : User field with 10 characters
    Its data type is C (Character String) with field length 10
  • USR04 : User field for quantity (length 10.3)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • USE04 : User field: Unit for quantity fields
    Its data type is C (Character String) with field length 3
  • USR05 : User field for quantity (length 10.3)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • USR06 : User-defined field for values (length 10,3)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • USR07 : User-defined field for values (length 10,3)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • USE07 : User field: Unit for value fields
    Its data type is C (Character String) with field length 5
  • USR08 : User field for date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • OBJNR : Object number
    Its data type is C (Character String) with field length 22
  • USR10 : User-defined field: Indicator for reports
    Its data type is C (Character String) with field length 1
  • KOSTL : Cost Center
    Its data type is C (Character String) with field length 10
  • BERST
    Its data type is C (Character String) with field length 16
  • BERKO
    Its data type is C (Character String) with field length 16
  • CLASF : Ind.: Take Activity Into Account for Project Summarization
    Its data type is C (Character String) with field length 1
  • SCOPE : Object Class
    Its data type is C (Character String) with field length 2
  • TXJCD : Tax Jurisdiction
    Its data type is C (Character String) with field length 15
  • IMPRF
    Its data type is C (Character String) with field length 6
  • AENNR : Change Number
    Its data type is C (Character String) with field length 12
  • POSTU
    Its data type is C (Character String) with field length 40
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is PRPS2_INC
  • LOEVM : Deletion Indicator
    Its data type is C (Character String) with field length 1
  • FPLNR : Billing plan number / invoicing plan number
    Its data type is C (Character String) with field length 10
  • IZWEK
    Its data type is C (Character String) with field length 2
  • IUMKZ
    Its data type is C (Character String) with field length 5
  • GRPKZ
    Its data type is C (Character String) with field length 1
  • LOGSYSTEM
    Its data type is C (Character String) with field length 10
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • VLPKZ
    Its data type is C (Character String) with field length 1
  • SORT2 : (Not Supported) Search Term
    Its data type is C (Character String) with field length 10