SAP DPR_TS_CTRLPLAN_I_DAT Control Plan Element Data Table data and field list

DPR_TS_CTRLPLAN_I_DAT 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 "Control Plan Element 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_CTRLPLAN_I_DAT TYPE DPR_TS_CTRLPLAN_I_DAT.

The DPR_TS_CTRLPLAN_I_DAT table consists of various fields, each holding specific information or linking keys about Control Plan Element Data data available in SAP. These include GUID (Application Object GUID), LAST_CHANGE_DATE (Date of Last Change), LAST_CHANGE_TIME (Last Changed at), PROJECT_GUID (Project Planning: 16 Character GUID for Projects)... 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_CTRLPLAN_I_DAT 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_CTRLPLAN_I_DAT 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_CTRLPLAN_I_DAT 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
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
PROJECT_GUID	Project Planning: 16 Character GUID for Projects	CGPL_PROJECT_GUID	RAW	16		CGPLP	CGPL_PROJECT_GUID
OBJECT_TYPE	Object Type in Project Planning	CGPL_OBJECT_TYPE	CHAR	3			CHAR3
PRIORITY	Priority	CGPL_PRIORITY	NUMC	3	CGPL_PRIO		NUMC3
ACTUALSTART	Actual Start Date	CGPL_ACTUALSTART	DEC	15		TSTPS	BCOS_TSTMP
ACTUALFINISH	Actual Finish Date	CGPL_ACTUALFINISH	DEC	15		TSTPS	BCOS_TSTMP
PLANSTART	Planned start date	CGPL_PLANSTART	DEC	15		TSTPS	BCOS_TSTMP
PLANFINISH	Planned Finish Date	CGPL_PLANFINISH	DEC	15		TSTPS	BCOS_TSTMP
COMPLETION	Percentage of Completion	CGPL_COMPLETION	NUMC	3			CGPL_COMPLETION
MILESTONE	Milestone indicator	CGPL_MILESTONE	CHAR	1			CHAR1
CONSTRAINT_TYPE	Type of Scheduling Constraint	CGPL_CONSTRAINT	CHAR	1			CGPL_CONSTRAINT
CONSTRAINT_TIME	Constraint Date	CGPL_CONSTRAINT_TIME	DEC	15		TSTPS	BCOS_TSTMP
CREATED_BY	Name of Person Who Created Object	CGPL_CREATED_BY	CHAR	12			USNAM
CREATED_ON	Date When the Object Was Created	CGPL_CREATED_ON	DATS	8			DATUM
CREATED_IN_BW	Transfer Object to BW	CGPL_CREATED_BW	CHAR	1			CHAR1
CHANGED_BY	Name of Person Who Changed Object	CGPL_CHANGED_BY	CHAR	12			USNAM
CHANGED_ON	Date on which object was last changed	CGPL_CHANGED_ON	DATS	8			DATUM
UPDATED_IN_BW	Current Object in BW	CGPL_UPDATED_BW	CHAR	1			CHAR1
BWIDENTIFIER	Project Planning - BW Identification	CGPL_BWIDENTIFIER	NUMC	8			CGPL_BWIDENTIFIER
PLANGROUP	Planning Profile Group	CGPL_SEM_PLGRP	CHAR	4
LATEST_START	Latest start	CGPL_LATEST_START	DEC	15		TSTPS	BCOS_TSTMP
LATEST_FINISH	Latest finish date	CGPL_LATEST_FINISH	DEC	15		TSTPS	BCOS_TSTMP
TOTAL_FLOAT	Total Float	CGPL_TOTAL_FLOAT	DEC	8(2)			CGPL_FLOAT
DURATION	Duration of Execution	CGPL_DURATION	DEC	8(2)			CGPL_DURATION
DURATION_UNIT	Time Unit for Execution Duration	CGPL_DURATION_UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
CALENDAR_ID	Factory Calendar	WFCID	CHAR	2	Assigned to domain		WFCID	FCI
CONSTR_TYPE_FIN	Type of Scheduling Constraint	CGPL_CONSTRAINT	CHAR	1			CGPL_CONSTRAINT
CONSTR_TIME_FIN	Constraint Date	CGPL_CONSTRAINT_TIME	DEC	15		TSTPS	BCOS_TSTMP
APPLICATION	Application in Project Planning	CGPL_APPLICATION_TYPE	CHAR	3	Assigned to domain		CGPL_APPLICATION_TYPE
FORECAST_START	Forecast Start	CGPL_FORECAST_START	DEC	15		TSTPS	BCOS_TSTMP
FORECAST_FINISH	Forecast Finish	CGPL_FORECAST_FINISH	DEC	15		TSTPS	BCOS_TSTMP
GUID_CHAR	Unique Object Key	DPR_TV_OBJECT_GUID_CHAR	CHAR	32			SYSUUID_C
CREATED_BY_NAME	Name of Person Who Created the Project Element	DPR_TV_CREATED_BY_NAME	CHAR	80			TEXT80
CHANGED_BY_NAME	Name of Person Who Last Changed the Project Element	DPR_TV_CHANGED_BY_NAME	CHAR	80			TEXT80
EXTERNAL_ID	Project Planning: External Indentifier of an Element	CGPL_EXTID	CHAR	24			CGPL_EXTID
ITEM_ID	Unique Characteristic ID in the Control Plan	DPR_TV_ITEM_UNIQUE_ID	CHAR	15			DPR_CP_ITEM_ID
VERSION_NUMBER	Version Number	CGPL_TV_VERSION	CHAR	24			CGPL_VERSION
PROCESS_NR	Process Number in Control Plan	DPR_TV_PROC_NR	NUMC	10			DPR_CP_CHA_SEQ_NR
PROCESS_ID	Process ID in Control Plan (Predefined in Customizing)	DPR_TV_PROC_ID	CHAR	15	DPR_CP_PROC		DPR_CP_ITEM_ID
PROCESS_NAME	Object Name	DPR_TV_TEXT	CHAR	40			DPR_TEXT
PROC_IND	Control Plan: Item Category	DPR_TV_CP_IND_PROC_OR_PART	CHAR	1			DPR_CP_ITEM_TYPE
PROC_STAGE	Control Plan Stage/Category	DPR_TV_CP_STAGE	CHAR	15			DPR_STAGE
TOOL_ID	Tools, Machines, and so on in Control Plan	DPR_TV_CP_TOOL_ID	CHAR	15	DPR_CP_TOOL		DPR_CP_ITEM_ID
TOOL_SEQ_NR	Sequence Number of a Tool in the Control Plan	DPR_TV_CP_TOOL_SEQ_NR	NUMC	10			DPR_CP_TOOL_SEQ_NR
TOOL_INFO	Object Name	DPR_TV_TEXT	CHAR	40			DPR_TEXT
CHA_SEQ_NR	Sequence Number of Characteristic in Control Plan	DPR_TV_CP_CHA_SEQ_NR	NUMC	10			DPR_CP_CHA_SEQ_NR
CHA_IND_PROD	Product (1) or Process Characteristic (0) in Control Plan	DPR_TV_CP_CHA_IND_PROD	CHAR	1			DPR_CP_CHA_IND_PROD
CHA_ID	Characteristic ID in Control Plan	DPR_TV_ITEM_ID	CHAR	15	DPR_CP_ITEM		DPR_CP_ITEM_ID
CHA_UNIQUE_ID	System-Wide Unique Characteristic ID in the Control Plan	DPR_TV_CHA_UNIQUE_ID	CHAR	24			CHAR24
CHA_CLASSF	Classification of Special Characterictics in Control Plan	DPR_TV_CP_CHA_CLASSF	CHAR	20			DPR_CP_CHA_CLASSF
CHA_INFO	Object Name	DPR_TV_TEXT	CHAR	40			DPR_TEXT
CHA_PLANTS	Plant of Master Inspection Characteristic	DPR_TV_CP_QM_PLANT	CHAR	4			CHAR4
MTH_PDPC	Control Plan: Product/Process Specification and Tolerance	DPR_TV_CP_MTH_PDPC	CHAR	20			DPR_CP_MTH_PDPC
MTH_H_EV_MSR	Test System in Control Plan	DPR_TV_SYS_ID	CHAR	15	DPR_CP_SYSTEM		DPR_CP_ITEM_ID
MTH_MSR_INFO	Object Name	DPR_TV_TEXT	CHAR	40			DPR_TEXT
MTH_SA_SZ	Sample Size	DPR_TV_CP_MTH_SA_SZ	CHAR	8
MTH_SA_FQ	Sample in Control Plan	DPR_TV_SAMPLE_ID	CHAR	15	DPR_CP_SAMPLE		DPR_CP_ITEM_ID
MTH_CTRL	Control Plan: Control Method for a Process Step	DPR_TV_CP_MTH_CTRL	CHAR	20			DPR_CP_MTH_CTRL
REACT_PLAN	Response Plan in Control Plan	DPR_TV_CP_REACT_PLAN	CHAR	20			DPR_CP_REACT_PLAN
CHA_TARGET_VALUE	Target Value of Characteristic in Control Plan	DPR_TV_CP_CHAR_VALUE	CHAR	20			CHAR20
CHA_UP_VALUE1	Target Value of Characteristic in Control Plan	DPR_TV_CP_CHAR_VALUE	CHAR	20			CHAR20
CHA_DOWN_VALUE1	Target Value of Characteristic in Control Plan	DPR_TV_CP_CHAR_VALUE	CHAR	20			CHAR20
CHA_UP_VALUE2	Target Value of Characteristic in Control Plan	DPR_TV_CP_CHAR_VALUE	CHAR	20			CHAR20
CHA_DOWN_VALUE2	Target Value of Characteristic in Control Plan	DPR_TV_CP_CHAR_VALUE	CHAR	20			CHAR20
CHA_UP_VALUE3	Target Value of Characteristic in Control Plan	DPR_TV_CP_CHAR_VALUE	CHAR	20			CHAR20
CHA_DOWN_VALUE3	Target Value of Characteristic in Control Plan	DPR_TV_CP_CHAR_VALUE	CHAR	20			CHAR20
CHA_PRINT_VALUES	Single-Character Indicator	CHAR1	CHAR	1			CHAR1
CHA_VALUE_UNIT	Unit of Characteristic in Control Plan	DPR_TV_CP_CHAR_UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
EA_DUMMY	Dummy Data Element for Enhanced Proj. Mgmt Attributes	DPR_TV_EA_DUMMY	CHAR	1			CHAR1
CHA_NAME	Characteristic Name	DPR_TV_CP_CHAR_NAME	CHAR	40			DPR_TEXT
INFOFIELD	Characteristic Additional Field in Control Plan	DPR_TV_IT_INFO	STRG	0
DESCRIPTION	Language-Dependent Description	CGPL_TEXT1	CHAR	40			TEXT40
.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
ITEM_IDINT	Unique Characteristic ID in the Control Plan	DPR_TV_ITEM_UNIQUE_ID	CHAR	15			DPR_CP_ITEM_ID
VERSION_NUMBERINT	Version Number	CGPL_TV_VERSION	CHAR	24			CGPL_VERSION
PROCESS_NRINT	Process Number in Control Plan	DPR_TV_PROC_NR	NUMC	10			DPR_CP_CHA_SEQ_NR
PROCESS_IDINT	Process ID in Control Plan (Predefined in Customizing)	DPR_TV_PROC_ID	CHAR	15	DPR_CP_PROC		DPR_CP_ITEM_ID
PROCESS_NAMEINT	Object Name	DPR_TV_TEXT	CHAR	40			DPR_TEXT
PROC_INDINT	Control Plan: Item Category	DPR_TV_CP_IND_PROC_OR_PART	CHAR	1			DPR_CP_ITEM_TYPE
PROC_STAGEINT	Control Plan Stage/Category	DPR_TV_CP_STAGE	CHAR	15			DPR_STAGE
TOOL_IDINT	Tools, Machines, and so on in Control Plan	DPR_TV_CP_TOOL_ID	CHAR	15	DPR_CP_TOOL		DPR_CP_ITEM_ID
TOOL_SEQ_NRINT	Sequence Number of a Tool in the Control Plan	DPR_TV_CP_TOOL_SEQ_NR	NUMC	10			DPR_CP_TOOL_SEQ_NR
TOOL_INFOINT	Object Name	DPR_TV_TEXT	CHAR	40			DPR_TEXT
CHA_SEQ_NRINT	Sequence Number of Characteristic in Control Plan	DPR_TV_CP_CHA_SEQ_NR	NUMC	10			DPR_CP_CHA_SEQ_NR
CHA_IND_PRODINT	Product (1) or Process Characteristic (0) in Control Plan	DPR_TV_CP_CHA_IND_PROD	CHAR	1			DPR_CP_CHA_IND_PROD
CHA_IDINT	Characteristic ID in Control Plan	DPR_TV_ITEM_ID	CHAR	15	DPR_CP_ITEM		DPR_CP_ITEM_ID
CHA_UNIQUE_IDINT	System-Wide Unique Characteristic ID in the Control Plan	DPR_TV_CHA_UNIQUE_ID	CHAR	24			CHAR24
CHA_CLASSFINT	Classification of Special Characterictics in Control Plan	DPR_TV_CP_CHA_CLASSF	CHAR	20			DPR_CP_CHA_CLASSF
CHA_INFOINT	Object Name	DPR_TV_TEXT	CHAR	40			DPR_TEXT
CHA_PLANTSINT	Plant of Master Inspection Characteristic	DPR_TV_CP_QM_PLANT	CHAR	4			CHAR4
MTH_PDPCINT	Control Plan: Product/Process Specification and Tolerance	DPR_TV_CP_MTH_PDPC	CHAR	20			DPR_CP_MTH_PDPC
MTH_H_EV_MSRINT	Test System in Control Plan	DPR_TV_SYS_ID	CHAR	15	DPR_CP_SYSTEM		DPR_CP_ITEM_ID
MTH_MSR_INFOINT	Object Name	DPR_TV_TEXT	CHAR	40			DPR_TEXT
MTH_SA_SZINT	Sample Size	DPR_TV_CP_MTH_SA_SZ	CHAR	8
MTH_SA_FQINT	Sample in Control Plan	DPR_TV_SAMPLE_ID	CHAR	15	DPR_CP_SAMPLE		DPR_CP_ITEM_ID
MTH_CTRLINT	Control Plan: Control Method for a Process Step	DPR_TV_CP_MTH_CTRL	CHAR	20			DPR_CP_MTH_CTRL
REACT_PLANINT	Response Plan in Control Plan	DPR_TV_CP_REACT_PLAN	CHAR	20			DPR_CP_REACT_PLAN
CHA_TARGET_VALUEINT	Target Value of Characteristic in Control Plan	DPR_TV_CP_CHAR_VALUE	CHAR	20			CHAR20
CHA_UP_VALUE1INT	Target Value of Characteristic in Control Plan	DPR_TV_CP_CHAR_VALUE	CHAR	20			CHAR20
CHA_DOWN_VALUE1INT	Target Value of Characteristic in Control Plan	DPR_TV_CP_CHAR_VALUE	CHAR	20			CHAR20
CHA_UP_VALUE2INT	Target Value of Characteristic in Control Plan	DPR_TV_CP_CHAR_VALUE	CHAR	20			CHAR20
CHA_DOWN_VALUE2INT	Target Value of Characteristic in Control Plan	DPR_TV_CP_CHAR_VALUE	CHAR	20			CHAR20
CHA_UP_VALUE3INT	Target Value of Characteristic in Control Plan	DPR_TV_CP_CHAR_VALUE	CHAR	20			CHAR20
CHA_DOWN_VALUE3INT	Target Value of Characteristic in Control Plan	DPR_TV_CP_CHAR_VALUE	CHAR	20			CHAR20
CHA_PRINT_VALUESINT	Single-Character Indicator	CHAR1	CHAR	1			CHAR1
CHA_VALUE_UNITINT	Unit of Characteristic in Control Plan	DPR_TV_CP_CHAR_UNIT	UNIT	3	Assigned to domain	CUNIT	MEINS
EA_DUMMYINT	Dummy Data Element for Enhanced Proj. Mgmt Attributes	DPR_TV_EA_DUMMY	CHAR	1			CHAR1
CHA_NAMEINT	Characteristic Name	DPR_TV_CP_CHAR_NAME	CHAR	40			DPR_TEXT
INFOFIELDINT	Characteristic Additional Field in Control Plan	DPR_TV_IT_INFO	STRG	0
STAGE_TEXT	Object Name	DPR_TV_TEXT	CHAR	40			DPR_TEXT
TOOL_TEXT	Object Name	DPR_TV_TEXT	CHAR	40			DPR_TEXT
PROCESS_TEXT	Object Name	DPR_TV_TEXT	CHAR	40			DPR_TEXT
CHA_PROCESS_TEXT	Object Name	DPR_TV_TEXT	CHAR	40			DPR_TEXT
CHA_PRODUCT_TEXT	Object Name	DPR_TV_TEXT	CHAR	40			DPR_TEXT
EVALUATION_TEXT	Object Name	DPR_TV_TEXT	CHAR	40			DPR_TEXT
FREQUENCE_TEXT	Object Name	DPR_TV_TEXT	CHAR	40			DPR_TEXT
TEXTS				0

Key field

Non-key field

< DPR_TS_CTRLPLAN_I_CHG - Control Plan Characteristic Attributes (Extern. Modifiable) DPR_TS_CTRLPLAN_I_DIS - Attributes for Control Plan Char.(Not Modifiable Externally) >

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

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

How to access SAP table DPR_TS_CTRLPLAN_I_DAT

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

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