SAP DPR_TS_CHECKLIST_ITEM_DAT Checklist Item Data Table data and field list

DPR_TS_CHECKLIST_ITEM_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 "Checklist Item 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_CHECKLIST_ITEM_DAT TYPE DPR_TS_CHECKLIST_ITEM_DAT.

The DPR_TS_CHECKLIST_ITEM_DAT table consists of various fields, each holding specific information or linking keys about Checklist Item Data data available in SAP. These include PRIORITY (Priority), ACTUAL_FINISH (Actual Finish), SORT_NUMBER (Sort Number), GROUPING (Grouping)... 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_CHECKLIST_ITEM_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_CHECKLIST_ITEM_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_CHECKLIST_ITEM_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
PRIORITY	Priority	CGPL_PRIORITY	NUMC	3	CGPL_PRIO		NUMC3
ACTUAL_FINISH	Actual Finish	DPR_TV_ACTUAL_FINISH	DATS	8
SORT_NUMBER	Sort Number	DPR_TV_SORT_NUMBER	NUMC	5
GROUPING	Grouping	DPR_TV_GROUPING	CHAR	40
SEARCH_FIELD	Search Field	DPR_TV_SEARCH_FIELD	CHAR	40
MASTER_LANGUAGE	Language Key	DPR_TV_LANGU	LANG	1	Assigned to domain	ISOLA	SPRAS
CHANGEABILITY	Changeability of Checklist Items	DPR_TV_CHANGEABILITY_ITEM	CHAR	1			DPR_CHANGEABILITY_ITEM
OK	OK	DPR_TV_CHECKLIST_ITEM_OK	CHAR	1			DPR_BOOLEAN
NOK	Not OK	DPR_TV_CHECKLIST_ITEM_NOK	CHAR	1			DPR_BOOLEAN
NOT_RELEVANT	Not Relevant	DPR_TV_NOT_RELEVANT	CHAR	1			DPR_BOOLEAN
OBLIGATORY	Mandatory	DPR_TV_OBLIGATORY	CHAR	1			DPR_BOOLEAN
APP_RELEVANT	Relevant for Approval	DPR_TV_APPROVAL_RELEVANT	CHAR	1			DPR_BOOLEAN
PROCESS	Process	DPR_TV_PROCESS	CHAR	15	DPR_PROCESS		DPR_PROCESS
SEVERITY	Severity	DPR_TV_SEVERITY	DEC	2			DPR_FMEA_RATING
OCCURENCE	Occurrence	DPR_TV_OCCURENCE	DEC	2			DPR_FMEA_RATING
DETECTION	Detection	DPR_TV_DETECTION	DEC	2			DPR_FMEA_RATING
DESCRIPTION	Project Element Name	DPR_TV_NAME	CHAR	40			TEXT40
CONSTR_TYPE_FIN	Constraint on Finish Date	DPR_TV_FINISH_CONSTRAINT	CHAR	1			DPR_FINISH_CONSTRAINT
FINISH_DATE_FIX	Fixed Predefined Finish Date	DPR_TV_FINISH_DATE_FIX	DATS	8
STAT_PROFILE_CLI	Status Profile Template	DPR_TV_STAT_PROFILE_CLI	CHAR	8	TJ21		J_STSMA
FORECASTED_FINISH	Forecasted Finish Date	DPR_TV_FORECASTED_FINISH	DATS	8
EXTENDED_ATTRIBUTES				0
EA_DUMMY	Dummy Data Element for Enhanced Proj. Mgmt Attributes	DPR_TV_EA_DUMMY	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_FINISH	Calculated Finish Date	DPR_TV_SCHEDULED_FINISH	DATS	8
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
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
SCHEDULED_FINISH_LATE	Latest Finish Date	DPR_TV_SCHEDULED_FINISH_LATE	DATS	8
RPN	Risk Priority Number	DPR_TV_RPN	DEC	4			DPR_RPN
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
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
PROCESS_TEXT	Object Name	DPR_TV_TEXT	CHAR	40			DPR_TEXT
THRESHOLD_TEXT	Threshold Value Description	EVE_TV_THRESHOLD_DESCRIPTION	CHAR	40			EVE_DESCRIPTION
SEVERITY_TEXT	Severity of Threshold Value Description	EVE_TV_SEVERITY_DESCRIPTION	CHAR	40			EVE_DESCRIPTION
CL_ITEM_ID	Checklist Item Number	DPR_TV_CHECKLIST_ITEM_ID	CHAR	24
.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
CL_ITEM_IDINT	Checklist Item Number	DPR_TV_CHECKLIST_ITEM_ID	CHAR	24
SORT_NUMBERINT	Sort Number	DPR_TV_SORT_NUMBER	NUMC	5
VERSION_NUMBERINT	Version Number	CGPL_TV_VERSION	CHAR	24			CGPL_VERSION
GROUPINGINT	Grouping	DPR_TV_GROUPING	CHAR	40
SEARCH_FIELDINT	Search Field	DPR_TV_SEARCH_FIELD	CHAR	40
MASTER_LANGUAGEINT	Language Key	DPR_TV_LANGU	LANG	1	Assigned to domain	ISOLA	SPRAS
TEMPLATE_GUIDINT	Application Object GUID (Entity with Conversion Exit)	DPR_TV_ENTITY_GUID	RAW	16	DPR_CHECKLIST_I	DPRCE	DPR_ENTITY_GUID
CHANGEABILITYINT	Changeability of Checklist Items	DPR_TV_CHANGEABILITY_ITEM	CHAR	1			DPR_CHANGEABILITY_ITEM
OKINT	OK	DPR_TV_CHECKLIST_ITEM_OK	CHAR	1			DPR_BOOLEAN
NOKINT	Not OK	DPR_TV_CHECKLIST_ITEM_NOK	CHAR	1			DPR_BOOLEAN
NOT_RELEVANTINT	Not Relevant	DPR_TV_NOT_RELEVANT	CHAR	1			DPR_BOOLEAN
OBLIGATORYINT	Mandatory	DPR_TV_OBLIGATORY	CHAR	1			DPR_BOOLEAN
APP_RELEVANTINT	Relevant for Approval	DPR_TV_APPROVAL_RELEVANT	CHAR	1			DPR_BOOLEAN
PROCESSINT	Process	DPR_TV_PROCESS	CHAR	15	DPR_PROCESS		DPR_PROCESS
SEVERITYINT	Severity	DPR_TV_SEVERITY	DEC	2			DPR_FMEA_RATING
OCCURENCEINT	Occurrence	DPR_TV_OCCURENCE	DEC	2			DPR_FMEA_RATING
DETECTIONINT	Detection	DPR_TV_DETECTION	DEC	2			DPR_FMEA_RATING
RPNINT	Risk Priority Number	DPR_TV_RPN	DEC	4			DPR_RPN
STAT_PROFILE_CLIINT	Status Profile Template	DPR_TV_STAT_PROFILE_CLI	CHAR	8	Assigned to domain		J_STSMA
SCHEDULE_INDINT	Status of Scheduling Data	PPM_SCHEDULE_INDICATOR	CHAR	1			PPM_SCHEDULE_INDICATOR
EA_DUMMYINT	Dummy Data Element for Enhanced Proj. Mgmt Attributes	DPR_TV_EA_DUMMY	CHAR	1			CHAR1
STATUS				0
TEXTS				0
TASKS				0
DOCUMENTS				0
OBJECT_LINKS				0
PARTICIPANT_LINKS				0
COLLABORATIONS				0

Key field

Non-key field

< DPR_TS_CHECKLIST_ITEM_CHG - Modifiable Attributes of Checklist Item DPR_TS_CHECKLIST_ITEM_DIS - Non-Modifiable Attributes of Checklist Item >

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

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

How to access SAP table DPR_TS_CHECKLIST_ITEM_DAT

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