SAP DPR_TS_DOCUMENT_EXT Document in External Display Table data and field list

DPR_TS_DOCUMENT_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 "Document in 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_DOCUMENT_EXT TYPE DPR_TS_DOCUMENT_EXT.

The DPR_TS_DOCUMENT_EXT table consists of various fields, each holding specific information or linking keys about Document in External Display data available in SAP. These include GUID (Application Object GUID), OBJECT_TYPE (Object Type (According to CL_DPR_COLL_CO=>SC_TYPE...)), LEVEL (Document Level/Folders in the Hierarchy), DOCUMENT_DATA ()... 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_DOCUMENT_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_DOCUMENT_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_DOCUMENT_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
GUID	Application Object GUID	DPR_TV_GUID	RAW	16			DPR_GUID
OBJECT_TYPE	Object Type (According to CL_DPR_COLL_CO=>SC_TYPE...)			0
LEVEL	Document Level/Folders in the Hierarchy			0
DOCUMENT_DATA				0
DOCID	EDMS: Document ID	EDMS_DOCID	CHAR	32			SDOK_DOCID
DOC_TYPE	EDMS: Document Category	EDMS_DOC_TYPE	CHAR	10			EDMS_DOC_TYPE
DOC_NUMBER	EDMS: External Document Number	EDMS_DOC_NUMBER	CHAR	64			EDMS_DOC_NUMBER
DOC_PART	EDMS: Document Part	EDMS_DOC_PART	CHAR	10			EDMS_DOC_PART
DOC_VERSION	EDMS: Document Version	EDMS_DOC_VERSION	CHAR	10			EDMS_DOC_VERSION
DOC_INDEX	EDMS: Document Index	EDMS_DOC_INDEX	CHAR	10			EDMS_DOC_INDEX
DOCNAME	EDMS: Document Name	EDMS_DOC_NAME	CHAR	255			SDOK_FILNM
DESCRIPTION	EDMS: Document Description	EDMS_DESCRIPTION	CHAR	255			SDOK_FILNM
CREATED_AT	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS	DEC	15			TZNTSTMPS
CREATED_BY	User Name	UNAME	CHAR	12			UNAME
CHANGED_AT	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS	DEC	15			TZNTSTMPS
CHANGED_BY	User Name	UNAME	CHAR	12			UNAME
STATUS_ID	Status ID	CFS_STATUS_ID	CHAR	32			SYSUUID_C
PARENT_ID	EDMS: Document ID	EDMS_DOCID	CHAR	32			SDOK_DOCID
IS_FOLDER	Checkbox	XFELD	CHAR	1			XFELD
ENCRYPTION	List of File Formats	EDMS_T_DOC_FILE_FORMATS	CHAR	80			EDMS_T_DOC_FILE_FORMATS
IS_THUMBNAIL	Checkbox	XFELD	CHAR	1			XFELD
EA_DUMMY	Dummy			0
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
CREATED_ON_DATE	Created On	DPR_TV_CREATED_ON_DATE	DATS	8
CREATED_AT_TIME	Time Created	DPR_TV_CREATED_AT_TIME	TIMS	6
CHANGED_ON_DATE	Changed On	DPR_TV_CHANGED_ON_DATE	DATS	8
CHANGED_AT_TIME	Changed At	DPR_TV_CHANGED_AT_TIME	TIMS	6
STATUS_DATA				0
ID	Status ID	CFS_STATUS_ID	CHAR	32			SYSUUID_C
NAME	Status name	CFS_STATUS_NAME	SSTR	64
DESCRIPTION	Status Description	CFS_STATUS_DESCR	STRG	0
ALT_KEY	Status: Alternative, External Key	CFS_STATUS_ALT_KEY	CHAR	5	Assigned to domain		J_ESTAT
CREATED_BY	Created By	CFS_CREATED_BY	CHAR	12			USNAM
CREATED_ON	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS	DEC	15			TZNTSTMPS
CHANGED_BY	Changed by	CFS_CHANGED_BY	CHAR	12			USNAM
CHANGED_ON	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS	DEC	15			TZNTSTMPS
TEXTS				0
PROFILE_ID	Status Profile ID	CFS_STATUS_PROFILE_ID	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
CREATED_ON_DATE	Created On	DPR_TV_CREATED_ON_DATE	DATS	8
CREATED_AT_TIME	Time Created	DPR_TV_CREATED_AT_TIME	TIMS	6
CHANGED_ON_DATE	Changed On	DPR_TV_CHANGED_ON_DATE	DATS	8
CHANGED_AT_TIME	Changed At	DPR_TV_CHANGED_AT_TIME	TIMS	6
FILE_DATA				0
FILE_ID	EDMS: File ID	EDMS_FILE_ID	CHAR	32			SDOK_DOCID
DESCRIPTION	EDMS: File Description	EDMS_FILE_DESCRIPTION	CHAR	64			SDOK_PROPV
CREATED_AT	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS	DEC	15			TZNTSTMPS
CREATED_BY	User Name	UNAME	CHAR	12			UNAME
CHANGED_AT	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS	DEC	15			TZNTSTMPS
CHANGED_BY	User Name	UNAME	CHAR	12			UNAME
FILENAME	EDMS: URL	EDMS_URL	CHAR	4096			SADC4096
MIMETYPE	HTML content type	W3CONTTYPE	CHAR	128			W3_CONTTYP
FILESIZE	EDMS: File Size	EDMS_FILE_SIZE	INT4	10
STORAGE_CAT	EDMS: Storage Category	EDMS_STORAGE_CAT	CHAR	10	Assigned to domain		SDOK_STCAT
CHECKED_OUT	EDMS: Checked Out	EDMS_CHECKED_OUT	CHAR	1			XFELD
CHECKOUT_USER	EDMS: Checked Out By	EDMS_CHECKEDOUT_USER	CHAR	12			UNAME
CHECKED_OUT_DIR	EDMS: Directory	EDMS_DIRECTORY	CHAR	255			TEXT255
CHECKED_OUT_FILENAME	EDMS: File Name	EDMS_FILENAME	CHAR	255			TEXT255
CHECKED_OUT_HOSTNAME	EDMS: Host Name	EDMS_HOSTNAME	CHAR	15			RFCIPADDR
IS_UNPROTECTED	Checkbox	XFELD	CHAR	1			XFELD
ACTUAL_VERSION	Checkbox	XFELD	CHAR	1			XFELD
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
CREATED_ON_DATE	Created On	DPR_TV_CREATED_ON_DATE	DATS	8
CREATED_AT_TIME	Time Created	DPR_TV_CREATED_AT_TIME	TIMS	6
CHANGED_ON_DATE	Changed On	DPR_TV_CHANGED_ON_DATE	DATS	8
CHANGED_AT_TIME	Changed At	DPR_TV_CHANGED_AT_TIME	TIMS	6

Key field

Non-key field

< DPR_TS_DOCUMENT_DIS - Non-Modifiable Document Attributes DPR_TS_DOCUMENT_INT - Document Attributes (Internal) >

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

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

How to access SAP table DPR_TS_DOCUMENT_EXT

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