SAP PRPS_R Project Hierarchy Reporting Structure Table data and field list

PRPS_R is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Project Hierarchy Reporting Structure" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_PRPS_R TYPE PRPS_R.

The PRPS_R table consists of various fields, each holding specific information or linking keys about Project Hierarchy Reporting Structure data available in SAP. These include MANDT (Client), PSPNR (WBS Element), POSID (Work Breakdown Structure Element (WBS Element)), POST1 (PS: Short description (1st text line))... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

PRPS_R structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP PRPS_R structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the PRPS_R table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
PSPNR	WBS Element	PS_POSNR	NUMC	8	Assigned to domain	ABPSP	PS_POSNR
POSID	Work Breakdown Structure Element (WBS Element)	PS_POSID	CHAR	24		PROJN	PS_POSID	PRO
POST1	PS: Short description (1st text line)	PS_POST1	CHAR	40			TEXT40
OBJNR	Object number	J_OBJNR	CHAR	22	ONR00		J_OBJNR	ONR
PSPHI	Current number of the appropriate project	PS_PSPHI	NUMC	8	PROJ	KONPD	PS_PSPNR
POSKI	WBS element short identification	PS_POSKI	CHAR	16			PS_PROKI
ERNAM	Name of Person who Created the Object	ERNAM	CHAR	12			USNAM
ERDAT	Date on Which Record Was Created	ERDAT	DATS	8			DATUM
AENAM	Name of Person Who Changed Object	AENAM	CHAR	12			USNAM
AEDAT	Date on which object was last changed	UPDAT	DATS	8			DATUM
VERNR	Number of the responsible person (project manager)	PS_VERNR	NUMC	8	TCJ04		PS_VERNR
VERNA	Name of responsible person (Project manager)	PS_VERNA	CHAR	25			PS_VERNA
ASTNR	Applicant number	PS_ASTNR	NUMC	8	TCJ05		PS_ASTNR
ASTNA	Applicant	PS_ASTNA	CHAR	25			PS_ASTNA
PBUKR	Company code for WBS element	PS_PBUKR	CHAR	4	T001		BUKRS	BUK
PGSBR	Business area for WBS element	PS_PGSBR	CHAR	4	TGSB		GSBER	GSB
PKOKR	Controlling area for WBS element	PS_PKOKR	CHAR	4	TKA01		CACCD	CAC
PRCTR	Profit Center	PRCTR	CHAR	10	CEPC	ALPHA	PRCTR	PRC	PRCTR_EMPTY
PRART	Project type	PS_PRART	CHAR	2	TCJ1		PS_PRART
STUFE	Level in Project Hierarchy	PS_STUFE	INT1	3			INT1
PLAKZ	Indicator: Planning element	PS_PLAKZ	CHAR	1			XFELD
BELKZ	Indicator: Account assignment element	PS_BELKZ	CHAR	1			XFELD
FAKKZ	Indicator: Billing element	PS_FAKKZ	CHAR	1			XFELD
NPFAZ	Relationship of network activity to production order	PS_NPFAR	CHAR	1			XFELD
ZUORD	Network assignment	PS_ZUORD	NUMC	1			PS_ZUORD
TRMEQ	Indicator: WBS dates detailed by activity dates	PS_TRMEQ	CHAR	1			X
KVEWE	Usage of the condition table	KVEWE	CHAR	1	T681V		KVEWE	KVW
KAPPL	Application	KAPPL	CHAR	2	T681A		KAPPL	KAP
KALSM	Costing Sheet	AUFKALSM	CHAR	6	T683		KALSM
ZSCHL	Overhead key	AUFZSCHL	CHAR	6	TKZSL		CHAR6
ABGSL	Results Analysis Key	ABGR_SCHL	CHAR	6	TKKAA		ABGR_SCHL	ACS
AKOKR	Controlling area of requesting cost center	PS_AKOKR	CHAR	4	TKA01		CACCD	CAC
AKSTL	Requesting cost center	PS_AKSTL	CHAR	10	CSKS	ALPHA	KOSTL	KOS
FKOKR	Controlling area of responsible cost center	PS_FKOKR	CHAR	4	TKA01		CACCD	CAC
FKSTL	Responsible cost center	PS_FKSTL	CHAR	10	CSKS	ALPHA	KOSTL	KOS
FABKL	Factory calendar key	FABKL	CHAR	2	TFACD		WFCID
PSPRI	Priority	NW_PRIO	CHAR	1	TCN07		NW_PRIO
EQUNR	Equipment Number	EQUNR	CHAR	18	EQUI	ALPHA	EQUNR	EQN	EQUI
TPLNR	Functional Location	TPLNR	CHAR	30	IFLOT	TPLNR	TPLNR	IFL	IFLM
PWPOS	WBS element currency	PS_PWPOS	CUKY	5	TCURC		WAERS
WERKS	Plant	WERKS_D	CHAR	4	T001W		WERKS	WRK	H_T001W_C
TXTSP	Language Key	SPRAS	LANG	1	T002	ISOLA	SPRAS	SPR	H_T002
SLWID	Key word ID for user-defined fields	SLWID	CHAR	7	TCN01		SLWID
USR00	1st user field for 20 characters - WBS element-	USR00PRPS	CHAR	20			USRCHAR20
USR01	2nd user field 20 digits - WBS element	USR01PRPS	CHAR	20			USRCHAR20
USR02	3rd user-defined field 10 digits -WBS element	USR02PRPS	CHAR	10			USRCHAR10
USR03	4th user-defined field 10 digits -WBS element	USR03PRPS	CHAR	10			USRCHAR10
USR04	1st user-defined field for quantity(length 10,3) WBS element	USR04PRPS	QUAN	13(3)			USRQUAN13
USE04	1st user defined field for quantity field unit - WBS element	USE04PRPS	UNIT	3	T006	CUNIT	MEINS
USR05	2nd use field for quantity (length 10,3) WBS element	USR05PRPS	QUAN	13(3)			USRQUAN13
USE05	2nd user defined field for quantity field unit - WBS element	USE05PRPS	UNIT	3	T006	CUNIT	MEINS
USR06	1st user field for values (length 10,3) WBS element	USR06PRPS	CURR	13(3)			USRCURR13
USE06	1st user defined field for value field unit - WBS element	USE06PRPS	CUKY	5	TCURC		WAERS
USR07	2nd user field for values (length 10,3) -WBS element	USR07PRPS	CURR	13(3)			USRCURR13
USE07	2nd user defined field for value field unit - WBS element	USE07PRPS	CUKY	5	TCURC		WAERS
USR08	1st user field for date -WBS element	USR08PRPS	DATS	8			USRDATE
USR09	2nd user field for date -WBS element	USR09PRPS	DATS	8			USRDATE
USR10	1st user field for 'Ind. for evaluations' WBS elem.	USR10PRPS	CHAR	1			FLAG
USR11	2nd user field for 'Indicator for eval.s' WBS elemnt	USR11PRPS	CHAR	1			FLAG
KOSTL	Cost center to which costs are actually posted	PS_KOSTL	CHAR	10	CSKS	ALPHA	KOSTL
KTRG	Cost Object	KSTRG	CHAR	12	CKPH		KSTRG	KTR
BERST	Authorization key for project master data	PS_BERST	CHAR	16			CHAR16
BERTR	Authorization key for project dates (WBS)	PS_BERTR	CHAR	16			CHAR16
BERKO	Authorization key for costs and revenues	PS_BERKO	CHAR	16			CHAR16
BERBU	Authorization key for project budget	PS_BERBU	CHAR	16			CHAR16
CLASF	Indicator: WBS element used in project summarization	PS_CLASF	CHAR	1			XFELD
SPSNR	Std WBS: Internal project item number (w/exit on ID)	PS_SPSNR	NUMC	8	PRPSS	KONPT	PS_SPSNR
SCOPE	Object Class	SCOPE_CV	CHAR	2		SCOPE	SCOPE_CV	PCO
XSTAT	Statistical WBS element	PS_XSTAT	CHAR	1			XFELD
TXJCD	Tax Jurisdiction	TXJCD	CHAR	15	TTXJ		TXJCD	TXJ
ZSCHM	Interest Profile for Project/Order Interest Calculation	PS_ZSCHM	CHAR	7	TPI01		PS_ZSCHM
IMPRF	Investment measure profile	IM_PROFIL	CHAR	6	TAPRF		IM_PROFIL
EVGEW	Aggregation weight for POC (PS progress)	EV_WEIGHTD	DEC	8			DEC8
AENNR	Change Number	AENNR	CHAR	12	AENR	AENNR	AENNR	AEN
SUBPR	Sub-project in work breakdown structure	PS_SUBPR	CHAR	12	PRTP		PS_SUBPR
POSTU	PS: Short description (1st text line) in all caps	PS_POSTU	CHAR	40			CHAR40
PLINT	Indicator for Integrated Planning	PLINT	CHAR	1			XFELD
LOEVM	Deletion Indicator	LOEVM	CHAR	1			XFELD
KZBWS	Valuation of Special Stock	KZBWS	CHAR	1			KZBWS
FPLNR	Billing plan number / invoicing plan number	FPLNR	CHAR	10	Assigned to domain		FPLNR
TADAT	Technically complete date	TABGDAT	DATS	8			DATUM
IZWEK	Reason for investment	IZWEK	CHAR	2	T087I		IZWEK
ISIZE	Scale of investment objects	IM_SIZECL	CHAR	2	TAIF5	ALPHA	SIZECL
IUMKZ	Reason for environmental investment	AM_UMWKZ	CHAR	5	T087K		AM_UMWKZ
ABUKR	Requesting company code	IM_ABUKRS	CHAR	4	T001		BUKRS	BUK
GRPKZ	Indicator: Grouping WBS element	GRPSPKZ	CHAR	1			GRPSPKZ
PGPRF	Distribution profile	PGPROFID	CHAR	6	TPGPRF		PGPROFID
LOGSYSTEM	Logical System	LOGSYSTEM	CHAR	10	Assigned to domain	ALPHA	LOGSYS
PSPNR_LOGS	Numeric field length 8	NUM08	NUMC	8			NUM08
STORT	Location	PS_STORT	CHAR	10	T499S		AP_STAND
FUNC_AREA	Functional Area	FKBER	CHAR	16	TFKB		FKBER	FBE
KLVAR	Costing Variant	CK_KLVAR	CHAR	4	Assigned to domain		KLVAR	KRT
KALNR	Cost Estimate Number for Cost Est. w/o Qty Structure	CK_KALNR	NUMC	12	Assigned to domain		CK_KALNR	KNR
POSID_EDIT	Work Breakdown Structure Element (WBS Element) Edited	PS_POSID_EDIT	CHAR	24			PS_POSID_EDIT
PSPKZ	Indicator: WBS element for production lot	PL_PSPKZ	CHAR	1			XFELD
MATNR	Material Number	MATNR	CHAR	18	Assigned to domain	MATN1	MATNR	MAT	S_MAT1
VLPSP	WBS: Reference work breakdown structure element	PL_PSP_PNR	NUMC	8	Assigned to domain	KONPR	PS_POSNR
VLPKZ	Indicator: Reference WBS element for production lot	PL_VLPKZ	CHAR	1			XFELD
SORT1	Sort string 1 for production lot	PL_SORT1	CHAR	10			CHAR10
SORT2	Sort string 2 for production lot	PL_SORT2	CHAR	10			CHAR10
SORT3	Sort string 3 for production lot	PL_SORT3	CHAR	10			CHAR10
VNAME	Joint Venture	JV_NAME	CHAR	6	T8JV	ALPHA	JV_NAME	JVV
RECID	Recovery Indicator	JV_RECIND	CHAR	2	T8JJ	ALPHA	JV_RECIND
ETYPE	Equity type	JV_ETYPE	CHAR	3	T8JE	ALPHA	JV_ETYPE
OTYPE	Joint Venture Object Type	JV_OTYPE	CHAR	4		ALPHA	JV_OTYPE
JIBCL	JIB/JIBE Class	JV_JIBCL	CHAR	3	T8J6A		JV_JIBCL	JIB
JIBSA	JIB/JIBE Subclass A	JV_JIBSA	CHAR	5	T8J6C		JV_JIBSA	JBS
CGPL_GUID16	Generic project planning: GUID from external R/3 system	CGPL_GUID16_R3	RAW	16			SYSUUID
CGPL_LOGSYS	Generic project planning: Log. system for CGPL_GUID16_R3	CGPL_LOGSYS	CHAR	10	Assigned to domain	ALPHA	LOGSYS
CGPL_OBJTYPE	Generic project planning: object type from ext. R/3 system	CGPL_OBJECT_TYPE_R3	CHAR	3			CHAR3
ADPSP	Reference Element PM/PS	ADDCOMPARE_CORE	CHAR	40	Assigned to domain		ADDCOMPARE_CORE		ADCP
RFIPPNT	Reference Point for Relationship Between iPPE and PS	CN_RPIP	CHAR	20	TCNRPIP		CN_RFPNT
.INCLU--AP				0
CPD_UPDAT	Time Stamp	/CPD/PFP_TSTMP	DEC	15		TSTLC	/CPD/PFP_TSTMP
.INCLU--AP				0
FERC_IND	Regulatory indicator	FE_IND	CHAR	4	FERC_C7	ALPHA	FE_IND
.INCLU--AP				0
PRPS_STATUS	Status Combination	ACTCMB_DELE	INT1	3	ACTCMB_TAB		ACTCMB_DOM
PSPCODE	WBS code for project hierarchy	PS_PSPCODE	CHAR	50			PS_PSPCODE
ABOVE	Number of the superior WBS element	PS_PHIUP	NUMC	8	Assigned to domain	KONPR	PS_POSNR
LEFT	Number of the left adjacent position in WBS	PS_PHILE	NUMC	8	Assigned to domain	KONPR	PS_POSNR
INCAT	Version inactive indicator	VSINACT	CHAR	1			XFELD

Key field

Non-key field

< PRPS_NODEL - Fields from ACT01 also displayed w/o authorizations (PSJ) PRPS_REF - Reference structurte for source and target WBS element >

How do I retrieve data from SAP structure PRPS_R using ABAP code?

As PRPS_R is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on PRPS_R as there is no data to select.

How to access SAP table PRPS_R

Within an ECC or HANA version of SAP you can also view further information about PRPS_R and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to PRPS_R

    ARKOPF - Archiving run header data
        VSKOPF - Version: Header - general data for a
    VBUP - Sales Document: Item Status
    CKIP1 - Periodic Values for Unit Costing Item
    COSP1 - CO Object: Cost Totals for External Postings
        COVP11 - CO object: Line items with doc. header (by period)
            COEPD11 - CO object: Unvaluated ln. item settlement w/status
                COEPBR11 - CO Object: Valuated Line Item Settlement
        COVJ11 - CO object: Line items with doc header (by year)
        COVO1 - CO Object: Open Items for Line Items (w/o doc.Hdr)
    COSPD1 - CO object: External cost totals - calculated
    COSPP - Transfer of Order in the COSP Table to the Project
    COKS1 - CO Object: Control Data for Secondary Planning
    VBKDPO - Sales document: Business item data (POSNR > 0)
    HEAD13 - SAPscript: Text Header
        LINE13 - SAPscript: Text Lines
    COSS1 - CO Object: Cost Totals for Internal Postings
        COVP12 - CO object: Line items with doc. header (by period)
            COEPD12 - CO object: Unvaluated ln. item settlement w/status
                COEPBR12 - CO Object: Valuated Line Item Settlement
        COVJ12 - CO object: Line items with doc header (by year)
        COVO12 - CO object: Fxd price agreement commitment ln items
    COSSD1 - CO object: Internal cost totals - calculated
    COSSP - Transfer of the Order COSS Table to the Project
    FPLA - Billing plan
    COKR1 - CO Object: Control Data for Statistical Key Figs
        HEAD14 - SAPscript: Text Header
            LINE14 - SAPscript: Text Lines
    COSR1 - CO Object: Statistical Key Figure Totals
        COVPR1 - CO object: Stat. key figure line items by period
        COVJR1 - CO object: Line items stat. key figures (by year)
    COSL1 - CO Object: Activity Type Totals
        COVPL1 - CO object: Activity type line items by period
        COVJL1 - CO object: Line items for acty types (by year)
    COSLD - CO object: Activity type sums - calculated
    FPLT - Billing Plan: Dates
    COSB1 - CO Object: Total Variances/Results Analyses
        COVPB1 - CO object: Variance/accrual line items by period
    COSBD1 - CO object: Sums of variance/accrual - calculated
    ANIA1 - Depr. simulation for invest. projects
        ANIB1 - Invest. projects: Depr. simulation analysis report
    ANLI1 - Link table for capital investment measure -> AuC
    FMSU1 - FM totals records for financial data
        COVFP1 - CO object: Financial data line items with doc. hdr
    TPI031 - CO Objects: Date of Last Interest Run
    EKKO - Purchasing Document Header
    PSDYVB - LDB PSJ: Dummy structure under VBAP
    EKPO - Purchasing Document Item
        EKET - Scheduling Agreement Schedule Lines
        EKKN - Account Assignment in Purchasing Document
        EKBE - Purchasing Document History
    EBAN - Purchase requisition
        EBKN - Purchase Requisition Account Assignment
    FPLAPS - Billing plan for PSP network plan
        FPLTPS - Billing plan for PSP/network (dates)
    LIKP - SD Document: Delivery Header Data
        LIPS - SD document: Delivery: Item data
    PSDYVK - LDB PSJ: Dummy structure under VBAK
    PSMERK - Characteristics for summarization wo.classificatn
    DRAD - Document-object link
    PRPS_R - Project Hierarchy Reporting Structure
        PRTE - Scheduling Data for Project Item
        PSMLST - Milestone I/O Table
        PSTX - PS Texts (Header)
    RSTHIE - BRST structure of the hierarchy table
        PLAF - Planned order
        PSMERK_PRPS - Characteristics for Summarization for WBS Elements
    KBED04 - Capacity Requirement Recs for Planned Orders (LDB)
    RESB04 - Reservation/dependent reqs for plan order (LDB)
        PSDYPR - LDB PSJ: Dummy structure under PRPS_R
    AUFK - Order master data
        AFKO - Order Header Data PP Orders
            AFPO - Order Item
            AFFL - Work order sequence
                ACT01 - Activity for LDB 01
    PSDYRH - LDB PSJ: Dummy structure under RSTHIE
    AFAB01 - Network Relationship (for LDB) - 01
    MLSTD - Milestone I/O Table
    PSTX1 - PS Texts (Header) for Activity (1)
    AFFH01 - Order PRT Data (for LDB) - 01
    KBED01 - Capacity Requirement Records (for LDB) - 01
        KBEZ - Additional data for table KBED (for ind.req/split)
            KPER - Additional data for KBEZ (person split in days)
        AFRU02 - Order Confirmations (for LDB) -02
    RESB01 - Reservation/Dependent Requirement for LDB-01
        PSDYOK - LDB PSJ: Dummy structure under RESB01
    PROJ - Project definition
    AFRU01 - Order Confirmations (for LDB) - 01
    PSMERK_ACT - Charactersitics for Summarization for Activity
    PSDYNV - LDB PSJ: Dummy structure under ACT01
        AFIH - Maintenance order header
        PSDYNP - LDB PSJ: Dummy structure under AUFK
    IMTP - Investment programs
        IMPR - Investment Program Positions
            PSDYIP - LDB PSJ: Dummy structure under IMPR
        PSDYPG - LDB PSJ: Dummy structure under IMTP
    PEGOB - Peg (master data of the CO object)
    PSDYPD - LDB PSJ: Dummy structure under PROJ
    PEGQTY - Assigned pegging object quantities
    PSDYPEG - LDB PSJ: Dummy Structure Under PEGOB
    ELM_PS - Additional data for hierarchy nodes (LDB PSJ)
        JSTO - Status object information
            PSTAT - Condensed status display
            JCDO - Change Documents for Status Object (Table JSTO)
            JEST - Individual Status per Object
                JCDS - Change docs. for system/user status (table JEST)
        ONR00 - General Object Number
            RPSCO1 - Summarization Table for Project Reporting
    VBAK - Sales Document: Header Data
            RPSQT - Summarization table for project reporting (quants)
            EV_PARAM - Object parameters for earned value analysis
            EV_POC - Earned value analysis: percentage of completion
            EV_VAL - Earned value analysis: earned value
            COBRA - Settlement Rule for Order Settlement
                COBRB - Distribution rules for sett. rule for order sett.
            BPHI1 - Cross-hierarchy data Control
            BPTR1 - Object Data Control
                BPGE1 - Totals record total value Control
                    BPVG1 - Table Generated for View BPVG1
    VBUK - Sales Doc.: Header Status and Administrative Data
                    BKHS1 - Header - Unit Costing (Control + Totals)
                        HEAD10 - SAPscript: Text Header
                            LINE10 - SAPscript: Text Lines
                        BKHT1 - Texts for CKHS
                        BKIS1 - Individual calculation/verification item gen.
                            BKIT1 - Texts for CKIS
                        BKIP1 - Periodic Values for Unit Costing Item
                BPJA1 - Totals record for total year value Control
                    BPVJ1 - Table Generated for View BPVJ1
                    BKHS2 - Header - Unit Costing (Control + Totals)
    VBKD - Sales Document: Business Data
    HEAD20 - SAPscript: Text Header
        LINE20 - SAPscript: Text Lines
    BKHT2 - Texts for CKHS
    BKIS2 - Individual calculation/verification item gen.
        BKIT2 - Texts for CKIS
    BKIP2 - Periodic Values for Unit Costing Item
                BPPE1 - Totals Record for Period Values Control
                    BPVP1 - Table Generated for View BPVP1
                BPIG1 - Budget Object Index (Overall Budget)
                BPIJ1 - Budget Object Index (Annual Budget)
    VBAP - Sales Document: Item Data
            COKA1 - CO Object: Cost Element Control Data
            COKP1 - CO Object: Primary Planning Control Data
                HEAD11 - SAPscript: Text Header
                    LINE11 - SAPscript: Text Lines
                CKHS1 - Header - Unit Costing (Control + Totals)
                    CKHT1 - Texts for CKHS
                    HEAD12 - SAPscript: Text Header
                        LINE12 - SAPscript: Text Lines
                    CKIS1 - Individual calculation/verification item gen.
                        CKIT1 - Texts for CKIS