SAP DPR_TS_APPROVAL_EXT Approval Attributes (External) Table data and field list

DPR_TS_APPROVAL_EXT 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 "Approval Attributes (External)" 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_APPROVAL_EXT TYPE DPR_TS_APPROVAL_EXT.

The DPR_TS_APPROVAL_EXT table consists of various fields, each holding specific information or linking keys about Approval Attributes (External) data available in SAP. These include DESCRIPTION (Language-Dependent Description), EXTENDED_ATTRIBUTES (), EA_DUMMY (Dummy Data Element for Enhanced Proj. Mgmt Attributes), DOC_SIGN (Approval Document)... 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_APPROVAL_EXT 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_APPROVAL_EXT 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_APPROVAL_EXT 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
DESCRIPTION	Language-Dependent Description	CGPL_TEXT1	CHAR	40			TEXT40
EXTENDED_ATTRIBUTES				0
EA_DUMMY	Dummy Data Element for Enhanced Proj. Mgmt Attributes	DPR_TV_EA_DUMMY	CHAR	1			CHAR1
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
GUID	Application Object GUID	DPR_TV_GUID	RAW	16			DPR_GUID
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
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
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
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

Key field

Non-key field

< DPR_TS_APPROVAL_DOCUMENT_SIGN - Include for Certifiable Approval Document DPR_TS_APPROVAL_EXTENDED_ATTR - Include for Enhanced Attributes for Approval >

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

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

How to access SAP table DPR_TS_APPROVAL_EXT

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

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