SAP DPR_PROJECT Project Definition Table data and field list

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

The DPR_PROJECT table consists of various fields, each holding specific information or linking keys about Project Definition 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), PROJECT_ID (Project 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_PROJECT 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_PROJECT 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_PROJECT 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
PROJECT_ID	Project Number	DPR_TV_PROJECT_ID	CHAR	24			CGPL_EXTID
VERSION_NUMBER	Version Number	CGPL_TV_VERSION	CHAR	24			CGPL_VERSION
PRO_CATEGORY	Project Category	DPR_TV_PRO_CATEGORY	CHAR	1	DPR_PRO_CATEG		DPR_PROJECT_CATEGORY
PRO_TYPE	Project Type	DPR_TV_PRO_TYPE	CHAR	15	DPR_PRO_TYPE		DPR_TYPE		DPR_PROJECT_TYPE
CAUSE	Reason for Project	DPR_TV_CAUSE	CHAR	15	DPR_CAUSE		DPR_CAUSE
GROUPING	Grouping	DPR_TV_GROUPING	CHAR	40
SEARCH_FIELD	Search Field	DPR_TV_SEARCH_FIELD	CHAR	40
MASTER_LANGUAGE	Text Language	DPR_TV_MASTER_LANGUAGE	LANG	1		ISOLA	LANGU
TEMPLATE_ADMIN	Template Responsible	DPR_TV_TEMPLATE_ADMIN	RAW	16	Assigned to domain		SYSUUID
TEMPLATE_GUID	Application Object GUID (Entity with Conversion Exit)	DPR_TV_ENTITY_GUID	RAW	16	Assigned to domain	DPRCE	DPR_ENTITY_GUID
RELEASED_ON	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit)	DPR_TV_TIMESTAMP	DEC	15		TSTPS	BCOS_TSTMP
RESCHEDULE	Rescheduling Required	DPR_TV_RESCHEDULE	CHAR	1			DPR_BOOLEAN
SCHEDULE_IND	Status of Scheduling Data	PPM_SCHEDULE_INDICATOR	CHAR	1			PPM_SCHEDULE_INDICATOR
SCHEDULE_TYPE	Scheduling Type	DPR_TV_SCHEDULE_TYPE	CHAR	1			DPR_SCHEDULE_TYPE
SCHED_BEHAVIOUR	Scheduling Behavior	DPR_TV_SCHED_BEHAVIOUR	CHAR	1			DPR_SCHEDULE_BEHAVIOUR
SUMMARY_TASKS	Task Nodes Are Summary Tasks	DPR_TV_SUMMARY_TASKS	CHAR	1			BOOLE
PERIODTYPE	Period Type (Weekly/Monthly/Generic Interval)	DPR_TV_PERIOD_TYPE	NUMC	2			DPR_PERIOD_TYPE
ALLOCATION_UNIT	Distribution Unit	DPR_TV_ALLOCATION_UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
LOCATION	Location	DPR_TV_LOCATION	CHAR	4	Assigned to domain		DPR_LOCATION
CUSTOMER	Business Partner GUID	BU_PARTNER_GUID	RAW	16			SYSUUID
SOLD_TO_PARTY	Business Partner GUID	BU_PARTNER_GUID	RAW	16			SYSUUID
LAST_CHANGED_ON	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit)	DPR_TV_TIMESTAMP	DEC	15		TSTPS	BCOS_TSTMP
LAST_CHANGED_BY	User Who Changed Project Data Last	DPR_TV_LAST_CHANGED_BY	CHAR	12			USNAM
SORT_OVERALL	Sort Mode	DPR_TV_SORT_OVERALL	CHAR	1			CHAR1
PLVAR	Plan Version	PLVAR	CHAR	2	Assigned to domain		PLVAR	POP
OTYPE	Object Type	OTYPE	CHAR	2	Assigned to domain		OTYPE	POT
RESP_ORG_UNIT	Organization Responsible	DPR_TV_RESP_ORGANIZATION	NUMC	8	Assigned to domain		HROBJID	PON	DPR_ORG_UNIT_COLL
STAT_PROFILE_PRO	Status Profile Template	DPR_TV_STAT_PROFILE_PRO	CHAR	8	Assigned to domain		J_STSMA
ACT_WORK_EFFORT	Confirmation (Insternal Display)	DPR_TV_ACT_WORK	QUAN	16(3)			DPR_WORK_LONG
ACT_WORK_UNIT	Unit	DPR_TV_UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
ACT_WRK_UNIT_EXT	Unit	DPR_TV_UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
CONF_GUID	GUID of a Confirmation Document	DPR_TV_CONF_GUID	RAW	16
ACTUAL2PLAN	Overwrite Planned Dates by Actual Dates	DPR_TV_ACTUAL2PLAN	CHAR	1			DPR_ACTUAL2PLAN
EA_DUMMY	Dummy Data Element for Enhanced Proj. Mgmt Attributes	DPR_TV_EA_DUMMY	CHAR	1			CHAR1

Key field

Non-key field

< DPR_PROCESS_T - Texts for Processes DPR_PROJ_IO_OLD - Projects with 'Old' IO Scenario >

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

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

SELECT SINGLE *
FROM DPR_PROJECT
INTO CORRESPONDING FIELDS OF WA_DPR_PROJECT
WHERE...

How to access SAP table DPR_PROJECT

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

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