SAP EDMS_TS_MAIN_FILE_DATA EDMS: Main File Data Table data and field list

EDMS_TS_MAIN_FILE_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 "EDMS: Main File 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_EDMS_TS_MAIN_FILE_DATA TYPE EDMS_TS_MAIN_FILE_DATA.

The EDMS_TS_MAIN_FILE_DATA table consists of various fields, each holding specific information or linking keys about EDMS: Main File Data data available in SAP. These include FILE_ID (EDMS: File ID), DESCRIPTION (EDMS: File Description), CREATED_AT (UTC Time Stamp in Short Form (YYYYMMDDhhmmss)), CREATED_BY (User Name)... 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. .

EDMS_TS_MAIN_FILE_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 EDMS_TS_MAIN_FILE_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 EDMS_TS_MAIN_FILE_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
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

Key field

Non-key field

< EDMS_TS_LINKED_OBJECT - EDMS: Linked Object EDMS_TS_MAIN_FILE_ID - EDMS: Main Files Including ID >

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

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

How to access SAP table EDMS_TS_MAIN_FILE_DATA

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