SAP DPR_PART_DIST Distribute Required Capacity to Project Role Table data and field list

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

The DPR_PART_DIST table consists of various fields, each holding specific information or linking keys about Distribute Required Capacity to Project Role data available in SAP. These include GUID (Application Object GUID (Entity with Conversion Exit)), ENDDA (Valid-To Date), CREATED_BY (Created By), CREATED_ON (UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit))... 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_DIST 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: Cannot Be Enhanced

SAP DPR_PART_DIST 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_DIST 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
ENDDA	Valid-To Date	DPR_TV_ENDDATE	DATS	8			DATS
CREATED_BY	Created By	DPR_TV_CREATED_BY	CHAR	12	Assigned to domain		XUBNAME
CREATED_ON	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit)	DPR_TV_TIMESTAMP	DEC	15		TSTPS	BCOS_TSTMP
CHANGED_BY	Last Changed By	DPR_TV_CHANGED_BY	CHAR	12	Assigned to domain		XUBNAME
CHANGED_ON	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit)	DPR_TV_TIMESTAMP	DEC	15		TSTPS	BCOS_TSTMP
ENTITY_GUID	Application Object GUID	DPR_TV_GUID	RAW	16			DPR_GUID
ALLOCATION_UNIT	Distribution Unit	DPR_TV_ALLOCATION_UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
PERIODTYPE	Period Type (Weekly/Monthly/Generic Interval)	DPR_TV_PERIOD_TYPE	NUMC	2			DPR_PERIOD_TYPE
BEGDA	Valid-From Date	DPR_TV_BEGDATE	DATS	8			DATS
DIST_WORK_EFFORT	Demand or Assigned Effort	DPR_TV_EFFORT	QUAN	9(2)			DPR_WORK

Key field

Non-key field

< DPR_PART - Project Participants DPR_PART_Q - Role Qualifications >

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

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

SELECT SINGLE *
FROM DPR_PART_DIST
INTO CORRESPONDING FIELDS OF WA_DPR_PART_DIST
WHERE...

How to access SAP table DPR_PART_DIST

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

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