SAP DPR_PART Project Participants Table data and field list

DPR_PART is a standard SAP Table which is used to store Project Participants data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The DPR_PART table consists of various fields, each holding specific information or linking keys about Project Participants data available in SAP. These include GUID (Application Object GUID (Entity with Conversion Exit)), PROC_STATUS_OWN (Object Processing Status), PROC_STATUS_SUP (Processing Status of Higher-Level Object), SORT_NUMBER (Sort Number)... 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. .

DPR_PART table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP DPR_PART table 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 DPR_PART 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
CLIENT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
GUID	Application Object GUID (Entity with Conversion Exit)	DPR_TV_ENTITY_GUID	RAW	16		DPRCE	DPR_ENTITY_GUID
PROC_STATUS_OWN	Object Processing Status	DPR_TV_PROC_STATUS_OWN	CHAR	2			DPR_PROC_STATUS
PROC_STATUS_SUP	Processing Status of Higher-Level Object	DPR_TV_PROC_STATUS_SUP	CHAR	2			DPR_PROC_STATUS
SORT_NUMBER	Sort Number	DPR_TV_SORT_NUMBER	NUMC	5
VERSION_NUMBER	Version Number	CGPL_TV_VERSION	CHAR	24			CGPL_VERSION
PARTICIPANT_ROLE	Role Type for Projects	DPR_TV_PARTICIPANT_ROLE	CHAR	15	DPR_PART_ROLE		DPR_PARTICIPANT_ROLE
BEG_TMSTMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TIMESTAMP	DEC	15			TZNTSTMPS
END_TMSTMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TIMESTAMP	DEC	15			TZNTSTMPS
WORK_EFFORT	Demand or Assigned Effort	DPR_TV_EFFORT	QUAN	9(2)			DPR_WORK
WORK_UNIT	Unit for Demand or Effort	DPR_TV_EFFORT_UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
C_OBJID	Object ID	HROBJID	NUMC	8	Assigned to domain		HROBJID	PON
PARTNER_ROLE	BP Role	DPR_TV_BU_ROLE	CHAR	6	Assigned to domain		BU_RLTYP		BUPA_ROLE
VACANT	Vacant Checkbox of Role	DPR_TV_VACANT	CHAR	1			DPR_BOOLEAN
CAND_IN_WORKLIST	Role Is Displayed in Candidate Manager's Worklist	DPR_TV_CANDIDATE_IN_WORKLIST	CHAR	1			DPR_BOOLEAN
STAT_PROFILE_PRT	Status Profile Template	DPR_TV_STAT_PROFILE_PRT	CHAR	8	Assigned to domain		J_STSMA
VC_BUPA_GUID	Application Object GUID	DPR_TV_GUID	RAW	16			DPR_GUID
RATE	Cost Rate/Revenue Rate for Project Costing	DPR_TV_RATE	CHAR	15	Assigned to domain		DPR_RATE_TYPE
REVENUE_RATE	Different Revenue	DPR_TV_REVENUE_RATE_MANUAL	CURR	11(2)			PREIS
CURRENCY	Currency Key	WAERS_CURC	CUKY	5	Assigned to domain		WAERS	FWS
COST_RATE	Different Costs	DPR_TV_COST_RATE_MANUAL	CURR	11(2)			PREIS
CURRENCY_COST	Currency Key	WAERS_CURC	CUKY	5	Assigned to domain		WAERS	FWS
TIME_UNIT	Activity Unit for Deviating Costs and Revenues	DPR_TV_TIME_UNIT_MANUAL	UNIT	3	Assigned to domain	CUNIT	MEINS
ACT_WORK_EFFORT	Confirmation (Insternal Display)	DPR_TV_ACT_WORK	QUAN	16(3)			DPR_WORK_LONG
ACT_WORK_UNIT	Confirmation Unit	DPR_TV_ACT_WRK_UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
ACT_WRK_UNIT_EXT	Confirmation Unit	DPR_TV_ACT_WRK_UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
CONF_GUID	GUID of a Confirmation Document	DPR_TV_CONF_GUID	RAW	16
CONCRETE_ROLE	Shadow Role (= Concrete Role)	DPR_TV_CONCRETE_ROLE	CHAR	1			CHAR1
PARTICIPANT_ID	Role ID	DPR_TV_PART_ID	CHAR	24			CHAR24
URGENCY	Urgency	DPR_TV_URGENCY	CHAR	2			DPR_URGENCY
ROLE_FUNCTION_ID	ID of Role Function	DPR_TV_ROLE_FUNCTION_ID	CHAR	15	DPR_ROLE_FUNC		DPR_ROLE_FUNCTION_ID
LOCATION	Location	DPR_TV_LOCATION	CHAR	4	DPR_LOCATION		DPR_LOCATION
STAFF_PERCENT	Percent Staffed	DPR_TV_STAFF_PERCENT	NUMC	3			NUMC3
EA_DUMMY	Dummy Data Element for Enhanced Proj. Mgmt Attributes	DPR_TV_EA_DUMMY	CHAR	1			CHAR1

Key field

Non-key field

< DPR_OLR3_TS_TAB_ID - Fields for Internal and External Key Description DPR_PART_DIST - Distribute Required Capacity to Project Role >

How do I retrieve data from SAP table DPR_PART using ABAP code

The following ABAP code Example will allow you to do a basic selection on DPR_PART to SELECT all data from the table
DATA: WA_DPR_PART TYPE DPR_PART.

SELECT SINGLE *
FROM DPR_PART
INTO CORRESPONDING FIELDS OF WA_DPR_PART
WHERE...

How to access SAP table DPR_PART

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

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