SAP DPR_TS_UI_APPR_DATA Approvals Attributes - External Display Table data and field list

DPR_TS_UI_APPR_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 "Approvals Attributes - External Display" 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_UI_APPR_DATA TYPE DPR_TS_UI_APPR_DATA.

The DPR_TS_UI_APPR_DATA table consists of various fields, each holding specific information or linking keys about Approvals Attributes - External Display data available in SAP. These include APPROVAL_GUID (Unique Object Key), PARENT_GUID (Unique Object Key), DESCRIPTION (Language-Dependent Description), EXTERNAL_ID (Approval Number)... 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_UI_APPR_DATA 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_UI_APPR_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_UI_APPR_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
APPROVAL_GUID	Unique Object Key	DPR_TV_OBJECT_GUID_CHAR	CHAR	32			SYSUUID_C
PARENT_GUID	Unique Object Key	DPR_TV_OBJECT_GUID_CHAR	CHAR	32			SYSUUID_C
DESCRIPTION	Language-Dependent Description	CGPL_TEXT1	CHAR	40			TEXT40
EXTERNAL_ID	Approval Number	DPR_TV_APPROVAL_ID	CHAR	24			CGPL_EXTID
VERSION_NUMBER	Version Number	CGPL_TV_VERSION	CHAR	24			CGPL_VERSION
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
VERSION	Approval Version	DPR_TV_APPROVAL_VERSION	CHAR	10			DPR_VERSION
ACTIVE_VERSION	Active Version of Approval	DPR_TV_APPROVAL_ACTIVE_VERSION	CHAR	1
DECISION	Approval/Individual Approval Decision	DPR_TV_APPROVAL_DECISION	CHAR	1			DPR_APPROVAL_DECISION
DECISION_TEXT	Approval/Individual Approval Decision	DPR_TV_APPROVAL_DECISION_TEXT	CHAR	60			DDTEXT
DECIDED_BY	Decision Maker	DPR_TV_DECIDED_BY	CHAR	12	Assigned to domain		XUBNAME
DECIDED_BY_NAME	Name of Person Who Made the Approval Decision	DPR_TV_DECIDED_BY_NAME	CHAR	80			TEXT80
DECIDED_ON_DATE	Date of Approval Decision	DPR_TV_DECIDED_ON_DATE	DATS	8
DECIDED_AT_TIME	Time of Approval Decision	DPR_TV_DECIDED_AT_TIME	TIMS	6
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
DOCUMENT	Approval Document	DPR_TV_APPROVAL_DOCUMENT	RSTR	0			DPR_APPROVAL_DOCUMENT
DOCUMENT_TYPE	Document Category	DPR_TV_APPROVAL_DOCUMENT_TYPE	CHAR	3			DPR_APPROVAL_DOCUMENT_TYPE
DOCUMENT_SIZE	Document Size	DPR_TV_APPROVAL_DOCUMENT_SIZE	INT4	10
FINGER_PRINT	Hash Value (160 Bits)	HASH160X	RAW	20
DOC_SIGN	Approval Document	DPR_TV_APPROVAL_DOCUMENT	RSTR	0			DPR_APPROVAL_DOCUMENT
DOC_TYPE_SIGN	Document Category	DPR_TV_APPROVAL_DOCUMENT_TYPE	CHAR	3			DPR_APPROVAL_DOCUMENT_TYPE
DOC_SIZE_SIGN	Document Size	DPR_TV_APPROVAL_DOCUMENT_SIZE	INT4	10
FNGR_PRNT_SIGN	Hash Value (160 Bits)	HASH160X	RAW	20
SIGNATURE_TYPE	Type of Signature	DPR_TV_SIGNATURE_TYPE	CHAR	1			DPR_SIGNATURE_TYPE
SIGNATURE_METHOD	Signature Method	DPR_TV_SIGNATURE_METHOD	CHAR	1			DPR_SIGNATURE_METHOD
EA_DUMMY	Dummy Data Element for Enhanced Proj. Mgmt Attributes	DPR_TV_EA_DUMMY	CHAR	1			CHAR1
ORIG_LONGTEXT	Object Description (Long Text)	DPR_TV_LONG_TEXT	STRG	0
ORIG_LANGUAGE	Language Key	DPR_TV_LANGU	LANG	1	Assigned to domain	ISOLA	SPRAS
SHORTTEXT	Project Element Name	DPR_TV_NAME	CHAR	40			TEXT40
LONGTEXT	Object Description (Long Text)	DPR_TV_LONG_TEXT	STRG	0
LANGUAGE	Language Key	DPR_TV_LANGU	LANG	1	Assigned to domain	ISOLA	SPRAS

Key field

Non-key field

< DPR_TS_UI_ACTION_CTRL - Action Property DPR_TS_UI_APPR_DATA_T - Approval Data (Template) >

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

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

How to access SAP table DPR_TS_UI_APPR_DATA

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