SAP DPR_TS_DX_PROJECT Excel Upload: Project Data Table data and field list

DPR_TS_DX_PROJECT 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 "Excel Upload: Project 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_DX_PROJECT TYPE DPR_TS_DX_PROJECT.

The DPR_TS_DX_PROJECT table consists of various fields, each holding specific information or linking keys about Excel Upload: Project Data data available in SAP. These include VERSION_NUMBER (Version Number), PROJECT_NUMBER (Project Number), DESCRIPTION (Project Element Name), PROJECT_TYPE (Project Type)... 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_DX_PROJECT 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_DX_PROJECT 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_DX_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
VERSION_NUMBER	Version Number	CGPL_TV_VERSION	CHAR	24			CGPL_VERSION
PROJECT_NUMBER	Project Number	DPR_TV_PROJECT_ID	CHAR	24			CGPL_EXTID
DESCRIPTION	Project Element Name	DPR_TV_NAME	CHAR	40			TEXT40
PROJECT_TYPE	Project Type	DPR_TV_PRO_TYPE	CHAR	15	DPR_PRO_TYPE		DPR_TYPE		DPR_PROJECT_TYPE
PROJECT_TYPE_TEXT	Project Type Text	DPR_TV_PRO_TYPE_TEXT	CHAR	40			DPR_TEXT
PROJECT_CAUSE	Reason for Project	DPR_TV_CAUSE	CHAR	15	DPR_CAUSE		DPR_CAUSE
PROJECT_CAUSE_TEXT	Description of Project Reason	DPR_TV_CAUSE_TEXT	CHAR	40			DPR_TEXT
MASTER_LANGUAGE	External Language Key	DPR_TV_LANGU_EXT	CHAR	2			CHAR2
PRIORITY	Priority	CGPL_PRIORITY	NUMC	3	CGPL_PRIO		NUMC3
FIXED_START_DATE	Fixed Start Date	DPR_TV_START_DATE_FIX	DATS	8
FIXED_FINISH_DATE	Fixed Predefined Finish Date	DPR_TV_FINISH_DATE_FIX	DATS	8
CONSTRAINT_TYPE	Constraint on Start Date	DPR_TV_START_CONSTRAINT	CHAR	1			DPR_START_CONSTRAINT
CONSTR_TYPE_FIN	Constraint on Finish Date	DPR_TV_FINISH_CONSTRAINT	CHAR	1			DPR_FINISH_CONSTRAINT
CONSTR_START_DATE	Constraint Start Date	DPR_TV_START_DATE_CONSTRAINT	DATS	8
CONSTR_FINISH_DATE	Predefined Finish Date	DPR_TV_FINISH_DATE_CONSTRAINT	DATS	8
CALCULATED_START_DATE	Calculated Start Date	DPR_TV_SCHEDULED_START	DATS	8
CALCULATED_FINISH_DATE	Calculated Finish Date	DPR_TV_SCHEDULED_FINISH	DATS	8
CALENDAR	Calendar	DPR_TV_CALENDAR_ID	CHAR	2	TFACD		WFCID
CALENDAR_TEXT	Factory calendar name	SC_TXTFAC	CHAR	40			TEXT40
SOLD_TO_PARTY_NUMBER	Sold-to Party Number	DPR_TV_SOLD_TO_PARTY_ID	CHAR	10	Assigned to domain	ALPHA	BU_PARTNER	BPA	BUPA
SOLD_TO_PARTY_NAME	Sold-to Party	DPR_TV_SOLD_TO_PARTY_NAME	CHAR	80			TEXT80
CUSTOMER_NUMBER	Customer Number	DPR_TV_CUSTOMER_ID	CHAR	10	BUT000	ALPHA	BU_PARTNER	BPA	BUPA
CUSTOMER_NAME	Customer	DPR_TV_CUSTOMER_NAME	CHAR	80			TEXT80
GROUPING	Grouping	DPR_TV_GROUPING	CHAR	40
SEARCH_FIELD	Search Field	DPR_TV_SEARCH_FIELD	CHAR	40
ACTUAL_WORK	Confirmation	DPR_TV_ACT_WORK_EXT	QUAN	9(2)			DPR_WORK
ACTUAL_WORK_UNIT	Confirmation Unit	DPR_TV_ACT_WRK_UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
ACTUAL_WORK_UNIT_TEXT	Unit of Measurement Text (Maximum 10 Characters)	MSEHT	CHAR	10			TEXT10
RESPONSIBLE_ORGA_UNIT	Organization Responsible	DPR_TV_RESP_ORGANIZATION	NUMC	8	Assigned to domain		HROBJID	PON	DPR_ORG_UNIT_COLL
RESPONSIBLE_ORGA_UNIT_SHORT	Responsible Organizational Unit	DPR_TV_ORG_UNIT	CHAR	12			CHAR12
RESPONSIBLE_ORGA_UNIT_TEXT	Object Name	DPR_TV_TEXT	CHAR	40			DPR_TEXT
CREATED_BY	Created By	DPR_TV_CREATED_BY	CHAR	12	Assigned to domain		XUBNAME
CREATED_BY_NAME	Name of Person Who Created the Project Element	DPR_TV_CREATED_BY_NAME	CHAR	80			TEXT80
CREATED_ON	Created On	DPR_TV_CREATED_ON_DATE	DATS	8
CHANGED_BY	Last Changed By	DPR_TV_CHANGED_BY	CHAR	12	Assigned to domain		XUBNAME
CHANGED_BY_NAME	Name of Person Who Last Changed the Project Element	DPR_TV_CHANGED_BY_NAME	CHAR	80			TEXT80
CHANGED_ON	Changed On	DPR_TV_CHANGED_ON_DATE	DATS	8
TEMPLATE_ID	Project Template Number	DPR_TV_PRO_TEMPLATE_ID	CHAR	24			CGPL_EXTID		DPR_PROJECT_T
RELEASE_DATE	Release Date	DPR_TV_RELEASE_DATE	DATS	8			DATS
RESCHEDULE	Rescheduling Required	DPR_TV_RESCHEDULE	CHAR	1			DPR_BOOLEAN
LAST_CHANGE_DATE	Date of Last Change	DPR_TV_LAST_CHANGE_DATE	DATS	8
LAST_CHANGE_TIME	Last Changed at	DPR_TV_LAST_CHANGE_TIME	TIMS	6
LAST_CHANGED_BY	User Who Changed Project Data Last	DPR_TV_LAST_CHANGED_BY	CHAR	12			USNAM
LAST_CHANGED_BY_NAME	Name of Person Who Changed Project Data Last	DPR_TV_LAST_CHANGED_BY_NAME	CHAR	80			TEXT80
PRO_CATEGORY	Project Category	DPR_TV_PRO_CATEGORY	CHAR	1	DPR_PRO_CATEG		DPR_PROJECT_CATEGORY
STSMA	Status Profile	J_STSMA	CHAR	8	Assigned to domain		J_STSMA
STATTXT	Concatenated Status Text of an Object	DPR_TV_STATUS_TXT	STRG	0
PROJECT_TEMPLATE_RESPONSIBLE	Name of Person Responsible for Template	DPR_TV_TEMPLATE_ADMIN_NAME	CHAR	80			TEXT80
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
AREA	Area	DPR_TV_AREA	CHAR	4	Assigned to domain		DPR_AREA
AREA_TEXT	Area Text	DPR_TV_AREA_TEXT	CHAR	30			TEXT30
DURATION	Processing Time	DPR_TV_DURATION	QUAN	4
DURATION_UNIT	Time Unit for Execution Duration	CGPL_DURATION_UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
DURATION_UNIT_TEXT	Unit of Measurement Text (Maximum 10 Characters)	MSEHT	CHAR	10			TEXT10
FORECASTED_START	Forecasted Start Date	DPR_TV_FORECASTED_START	DATS	8
FORECASTED_FINISH	Forecasted Finish Date	DPR_TV_FORECASTED_FINISH	DATS	8
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
RESPONSIBLE_ROLE	Project Planning: External Indentifier of an Element	CGPL_EXTID	CHAR	24			CGPL_EXTID
RESPONSIBLE_RESOURCE	Business Partner Number	BU_PARTNER	CHAR	10	Assigned to domain	ALPHA	BU_PARTNER	BPA	BUPA

Key field

Non-key field

< DPR_TS_DX_PHASE - Excel Upload: Phase Data DPR_TS_DX_PROJECT_STRUCTURE - Excel Upload: Project Structure >

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

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

How to access SAP table DPR_TS_DX_PROJECT

Within an ECC or HANA version of SAP you can also view further information about DPR_TS_DX_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).