SAP DPR_TS_PART_PRT Project Participant Data Table data and field list

DPR_TS_PART_PRT 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 Participant Data" 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_DPR_TS_PART_PRT TYPE DPR_TS_PART_PRT.

The DPR_TS_PART_PRT table consists of various fields, each holding specific information or linking keys about Project Participant Data data available in SAP. These include GUID (Application Object GUID), VERSION_NUMBER (Version Number), SCHEDULED_START (Calculated Start Date), SCHEDULED_FINISH (Calculated Finish Date)... 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_TS_PART_PRT structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)

SAP DPR_TS_PART_PRT 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 DPR_TS_PART_PRT 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
IS_TEMPLATE	Template (Yes/No)	DPR_TV_IS_TEMPLATE	CHAR	1			CHAR1
GUID	Application Object GUID	DPR_TV_GUID	RAW	16			DPR_GUID
VERSION_NUMBER	Version Number	CGPL_TV_VERSION	CHAR	24			CGPL_VERSION
SCHEDULED_START	Calculated Start Date	DPR_TV_SCHEDULED_START	DATS	8
SCHEDULED_FINISH	Calculated Finish Date	DPR_TV_SCHEDULED_FINISH	DATS	8
COST_RATE_DEF	Cost per Activity Unit	DPR_TV_COST_VALUE	CURR	11(2)			PREIS
REVENUE_RATE_DEF	Revenues per Activity Unit	DPR_TV_REVENUE_VALUE	CURR	11(2)			PREIS
WORK_UNIT_TEXT	Unit of Measurement Text (Maximum 10 Characters)	MSEHT	CHAR	10			TEXT10
TIME_UNIT_TEXT	Unit of Measurement Text (Maximum 10 Characters)	MSEHT	CHAR	10			TEXT10
ACT_WRK_UNIT_TEXT	Unit of Measurement Text (Maximum 10 Characters)	MSEHT	CHAR	10			TEXT10
CONCRETE_ROLE	Shadow Role (= Concrete Role)	DPR_TV_CONCRETE_ROLE	CHAR	1			CHAR1
AREA	Area	DPR_TV_AREA	CHAR	4	Assigned to domain		DPR_AREA
AREA_TEXT	Area Text	DPR_TV_AREA_TEXT	CHAR	30			TEXT30
OBJNR	GUID of a CRM Order Object	CRMT_OBJECT_GUID	RAW	16			SYSUUID
ISTAT	System status	J_ISTAT	CHAR	5	Assigned to domain		J_ISTAT
ESTAT	User Status	J_ESTAT	CHAR	5	Assigned to domain		J_ESTAT
STSMA	Status Profile	J_STSMA	CHAR	8	Assigned to domain		J_STSMA
SPRAS	Language Key	SPRAS	LANG	1	Assigned to domain	ISOLA	SPRAS	SPR	H_T002
TXT04	Individual status of an object (short form)	J_TXT04	CHAR	4			TEXT4
TXT30	Object status	J_TXT30	CHAR	30			TEXT30
STATTXT	Concatenated Status Text of an Object	DPR_TV_STATUS_TXT	STRG	0
SORT_NUMBER	Sort Number	DPR_TV_SORT_NUMBER	NUMC	5
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	Business Partner GUID	BU_PARTNER_GUID	RAW	16			SYSUUID
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_WRK_EFFORT_EXT	Confirmation	DPR_TV_ACT_WORK_EXT	QUAN	9(2)			DPR_WORK
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
EA_DUMMY	Dummy Data Element for Enhanced Proj. Mgmt Attributes	DPR_TV_EA_DUMMY	CHAR	1			CHAR1
EXTERNAL_ID	Project Planning: External Indentifier of an Element	CGPL_EXTID	CHAR	24			CGPL_EXTID
BEG_DATE	Start Date	BEGDA	DATS	8			DATUM
END_DATE	End Date	ENDDA	DATS	8			DATUM
DESCRIPTION	Language-Dependent Description	CGPL_TEXT1	CHAR	40			TEXT40
PARTICIPANT_ROLE_TEXT	Name of Role Type	DPR_TV_PARTICIPANT_ROLE_TEXT	CHAR	40			DPR_TEXT
PARTICIPANT_ID	Role ID	DPR_TV_PART_ID	CHAR	24			CHAR24
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	Assigned to domain		DPR_LOCATION
URGENCY	Urgency	DPR_TV_URGENCY	CHAR	2			DPR_URGENCY
.INCLU-INT				0
GUIDINT	Application Object GUID	DPR_TV_GUID	RAW	16			DPR_GUID
EXTERNAL_IDINT	Project Planning: External Indentifier of an Element	CGPL_EXTID	CHAR	24			CGPL_EXTID
PROJECT_GUIDINT	Project Planning: 16 Character GUID for Projects	CGPL_PROJECT_GUID	RAW	16		CGPLP	CGPL_PROJECT_GUID
OBJECT_TYPEINT	Object Type in Project Planning	CGPL_OBJECT_TYPE	CHAR	3			CHAR3
PRIORITYINT	Priority	CGPL_PRIORITY	NUMC	3	CGPL_PRIO		NUMC3
ACTUALSTARTINT	Actual Start Date	CGPL_ACTUALSTART	DEC	15		TSTPS	BCOS_TSTMP
ACTUALFINISHINT	Actual Finish Date	CGPL_ACTUALFINISH	DEC	15		TSTPS	BCOS_TSTMP
PLANSTARTINT	Planned start date	CGPL_PLANSTART	DEC	15		TSTPS	BCOS_TSTMP
PLANFINISHINT	Planned Finish Date	CGPL_PLANFINISH	DEC	15		TSTPS	BCOS_TSTMP
COMPLETIONINT	Percentage of Completion	CGPL_COMPLETION	NUMC	3			CGPL_COMPLETION
MILESTONEINT	Milestone indicator	CGPL_MILESTONE	CHAR	1			CHAR1
CONSTRAINT_TYPEINT	Type of Scheduling Constraint	CGPL_CONSTRAINT	CHAR	1			CGPL_CONSTRAINT
CONSTRAINT_TIMEINT	Constraint Date	CGPL_CONSTRAINT_TIME	DEC	15		TSTPS	BCOS_TSTMP
CREATED_BYINT	Name of Person Who Created Object	CGPL_CREATED_BY	CHAR	12			USNAM
CREATED_ONINT	Date When the Object Was Created	CGPL_CREATED_ON	DATS	8			DATUM
CREATED_IN_BWINT	Transfer Object to BW	CGPL_CREATED_BW	CHAR	1			CHAR1
CHANGED_BYINT	Name of Person Who Changed Object	CGPL_CHANGED_BY	CHAR	12			USNAM
CHANGED_ONINT	Date on which object was last changed	CGPL_CHANGED_ON	DATS	8			DATUM
UPDATED_IN_BWINT	Current Object in BW	CGPL_UPDATED_BW	CHAR	1			CHAR1
BWIDENTIFIERINT	Project Planning - BW Identification	CGPL_BWIDENTIFIER	NUMC	8			CGPL_BWIDENTIFIER
PLANGROUPINT	Planning Profile Group	CGPL_SEM_PLGRP	CHAR	4
LATEST_STARTINT	Latest start	CGPL_LATEST_START	DEC	15		TSTPS	BCOS_TSTMP
LATEST_FINISHINT	Latest finish date	CGPL_LATEST_FINISH	DEC	15		TSTPS	BCOS_TSTMP
TOTAL_FLOATINT	Total Float	CGPL_TOTAL_FLOAT	DEC	8(2)			CGPL_FLOAT
DURATIONINT	Duration of Execution	CGPL_DURATION	DEC	8(2)			CGPL_DURATION
DURATION_UNITINT	Time Unit for Execution Duration	CGPL_DURATION_UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
CALENDAR_IDINT	Factory Calendar	WFCID	CHAR	2	Assigned to domain		WFCID	FCI
CONSTR_TYPE_FININT	Type of Scheduling Constraint	CGPL_CONSTRAINT	CHAR	1			CGPL_CONSTRAINT
CONSTR_TIME_FININT	Constraint Date	CGPL_CONSTRAINT_TIME	DEC	15		TSTPS	BCOS_TSTMP
APPLICATIONINT	Application in Project Planning	CGPL_APPLICATION_TYPE	CHAR	3	Assigned to domain		CGPL_APPLICATION_TYPE
FORECAST_STARTINT	Forecast Start	CGPL_FORECAST_START	DEC	15		TSTPS	BCOS_TSTMP
FORECAST_FINISHINT	Forecast Finish	CGPL_FORECAST_FINISH	DEC	15		TSTPS	BCOS_TSTMP
PROC_STATUS_OWNINT	Object Processing Status	DPR_TV_PROC_STATUS_OWN	CHAR	2			DPR_PROC_STATUS
PROC_STATUS_SUPINT	Processing Status of Higher-Level Object	DPR_TV_PROC_STATUS_SUP	CHAR	2			DPR_PROC_STATUS
SORT_NUMBERINT	Sort Number	DPR_TV_SORT_NUMBER	NUMC	5
VERSION_NUMBERINT	Version Number	CGPL_TV_VERSION	CHAR	24			CGPL_VERSION
PARTICIPANT_ROLEINT	Role Type for Projects	DPR_TV_PARTICIPANT_ROLE	CHAR	15	DPR_PART_ROLE		DPR_PARTICIPANT_ROLE
BEG_TMSTMPINT	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TIMESTAMP	DEC	15			TZNTSTMPS
END_TMSTMPINT	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TIMESTAMP	DEC	15			TZNTSTMPS
WORK_EFFORTINT	Demand or Assigned Effort	DPR_TV_EFFORT	QUAN	9(2)			DPR_WORK
WORK_UNITINT	Unit for Demand or Effort	DPR_TV_EFFORT_UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
C_OBJIDINT	Object ID	HROBJID	NUMC	8	Assigned to domain		HROBJID	PON
PARTNER_ROLEINT	BP Role	DPR_TV_BU_ROLE	CHAR	6	Assigned to domain		BU_RLTYP		BUPA_ROLE
VACANTINT	Vacant Checkbox of Role	DPR_TV_VACANT	CHAR	1			DPR_BOOLEAN
CAND_IN_WORKLISTINT	Role Is Displayed in Candidate Manager's Worklist	DPR_TV_CANDIDATE_IN_WORKLIST	CHAR	1			DPR_BOOLEAN
STAT_PROFILE_PRTINT	Status Profile Template	DPR_TV_STAT_PROFILE_PRT	CHAR	8	Assigned to domain		J_STSMA
VC_BUPA_GUIDINT	Application Object GUID	DPR_TV_GUID	RAW	16			DPR_GUID
RATEINT	Cost Rate/Revenue Rate for Project Costing	DPR_TV_RATE	CHAR	15	Assigned to domain		DPR_RATE_TYPE
REVENUE_RATEINT	Different Revenue	DPR_TV_REVENUE_RATE_MANUAL	CURR	11(2)			PREIS
CURRENCYINT	Currency Key	WAERS_CURC	CUKY	5	Assigned to domain		WAERS	FWS
COST_RATEINT	Different Costs	DPR_TV_COST_RATE_MANUAL	CURR	11(2)			PREIS
CURRENCY_COSTINT	Currency Key	WAERS_CURC	CUKY	5	Assigned to domain		WAERS	FWS
TIME_UNITINT	Activity Unit for Deviating Costs and Revenues	DPR_TV_TIME_UNIT_MANUAL	UNIT	3	Assigned to domain	CUNIT	MEINS
ACT_WORK_EFFORTINT	Confirmation (Insternal Display)	DPR_TV_ACT_WORK	QUAN	16(3)			DPR_WORK_LONG
ACT_WORK_UNITINT	Confirmation Unit	DPR_TV_ACT_WRK_UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
ACT_WRK_UNIT_EXTINT	Confirmation Unit	DPR_TV_ACT_WRK_UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
CONF_GUIDINT	GUID of a Confirmation Document	DPR_TV_CONF_GUID	RAW	16
CONCRETE_ROLEINT	Shadow Role (= Concrete Role)	DPR_TV_CONCRETE_ROLE	CHAR	1			CHAR1
PARTICIPANT_IDINT	Role ID	DPR_TV_PART_ID	CHAR	24			CHAR24
URGENCYINT	Urgency	DPR_TV_URGENCY	CHAR	2			DPR_URGENCY
ROLE_FUNCTION_IDINT	ID of Role Function	DPR_TV_ROLE_FUNCTION_ID	CHAR	15	DPR_ROLE_FUNC		DPR_ROLE_FUNCTION_ID
LOCATIONINT	Location	DPR_TV_LOCATION	CHAR	4	DPR_LOCATION		DPR_LOCATION
STAFF_PERCENTINT	Percent Staffed	DPR_TV_STAFF_PERCENT	NUMC	3			NUMC3
EA_DUMMYINT	Dummy Data Element for Enhanced Proj. Mgmt Attributes	DPR_TV_EA_DUMMY	CHAR	1			CHAR1
TEXTS				0
BUPA_LINKS				0
BUPA_FAVOS				0
SKILLS				0
ENTITY_LINKS				0
DOCUMENTS				0
PART_DIST				0
BUPA_DIST				0
OBJECT_LINKS				0

Key field

Non-key field

< DPR_TS_PART_INT - Role Attributes (Internal) DPR_TS_PC_ADM - Attributes of Project Charter (Administrative/Internal Data) >

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

As DPR_TS_PART_PRT 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 DPR_TS_PART_PRT as there is no data to select.

How to access SAP table DPR_TS_PART_PRT

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

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