SAP DPR_TS_CONSTRAINT_DATA Data for Date Constraints (Check) Table data and field list

DPR_TS_CONSTRAINT_DATA 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 "Data for Date Constraints (Check)" 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_CONSTRAINT_DATA TYPE DPR_TS_CONSTRAINT_DATA.

The DPR_TS_CONSTRAINT_DATA table consists of various fields, each holding specific information or linking keys about Data for Date Constraints (Check) data available in SAP. These include PLANSTART (Planned start date), PLANFINISH (Planned Finish Date), CONSTR_TIME_START_CHG (Fixed Start Date), CONSTR_TIME_FINISH_CHG (Fixed Predefined 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_CONSTRAINT_DATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP DPR_TS_CONSTRAINT_DATA 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_CONSTRAINT_DATA 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
CALENDAR_ID	Factory Calendar	WFCID	CHAR	2	Assigned to domain		WFCID	FCI
PLANSTART	Planned start date	CGPL_PLANSTART	DEC	15		TSTPS	BCOS_TSTMP
PLANFINISH	Planned Finish Date	CGPL_PLANFINISH	DEC	15		TSTPS	BCOS_TSTMP
CONSTR_TIME_START_CHG	Fixed Start Date	DPR_TV_START_DATE_FIX	DATS	8
CONSTR_TIME_FINISH_CHG	Fixed Predefined Finish Date	DPR_TV_FINISH_DATE_FIX	DATS	8
CONSTR_TYPE_START_ACTUAL	Type of Scheduling Constraint	CGPL_CONSTRAINT	CHAR	1			CGPL_CONSTRAINT
CONSTR_TIME_START_ACTUAL_INT	Constraint Date	CGPL_CONSTRAINT_TIME	DEC	15		TSTPS	BCOS_TSTMP
CONSTR_TIME_START_ACTUAL_EXT	Fixed Start Date	DPR_TV_START_DATE_FIX	DATS	8
CONSTR_TYPE_FINISH_ACTUAL	Type of Scheduling Constraint	CGPL_CONSTRAINT	CHAR	1			CGPL_CONSTRAINT
CONSTR_TIME_FINISH_ACTUAL_INT	Constraint Date	CGPL_CONSTRAINT_TIME	DEC	15		TSTPS	BCOS_TSTMP
CONSTR_TIME_FINISH_ACTUAL_EXT	Fixed Predefined Finish Date	DPR_TV_FINISH_DATE_FIX	DATS	8
CALENDAR_ID_ACTUAL	Factory Calendar	WFCID	CHAR	2	Assigned to domain		WFCID	FCI
DURATION_ACTUAL	Duration of Execution	CGPL_DURATION	DEC	8(2)			CGPL_DURATION
ID_ZERO_DURATION	Checkbox	XFELD	CHAR	1			XFELD
DURATION_UNIT_ACTUAL	Time Unit for Execution Duration	CGPL_DURATION_UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS

Key field

Non-key field

< DPR_TS_CONF_TRANSF_LOG - Project Management Confirmation: Log Structure DPR_TS_COPY_LINK - Connection Between New and Old Object >

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

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

How to access SAP table DPR_TS_CONSTRAINT_DATA

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

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