SAP EDMS_AT01 EDMS: Documents - GUID Table data and field list

EDMS_AT01 is a standard SAP Table which is used to store EDMS: Documents - GUID data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The EDMS_AT01 table consists of various fields, each holding specific information or linking keys about EDMS: Documents - GUID data available in SAP. These include DOC_TYPE (EDMS: Document Category), DOC_NUMBER (EDMS: External Document Number), DOC_PART (EDMS: Document Part), DOC_VERSION (EDMS: Document Version)... 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_AT01 table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP EDMS_AT01 table 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_AT01 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
DOC_TYPEEDMS: Document Category EDMS_DOC_TYPECHAR10EDMS_DOC_TYPE
DOC_NUMBEREDMS: External Document Number EDMS_DOC_NUMBERCHAR64EDMS_DOC_NUMBER
DOC_PARTEDMS: Document Part EDMS_DOC_PARTCHAR10EDMS_DOC_PART
DOC_VERSIONEDMS: Document Version EDMS_DOC_VERSIONCHAR10EDMS_DOC_VERSION
DOC_INDEXEDMS: Document Index EDMS_DOC_INDEXCHAR10EDMS_DOC_INDEX
DOCIDEDMS: Document ID EDMS_DOCIDCHAR32SDOK_DOCID
ENCRYPTIONList of File Formats EDMS_T_DOC_FILE_FORMATSCHAR80EDMS_T_DOC_FILE_FORMATS
EA_DUMMY Dummy0

Key field Non-key field



How do I retrieve data from SAP table EDMS_AT01 using ABAP code

The following ABAP code Example will allow you to do a basic selection on EDMS_AT01 to SELECT all data from the table
DATA: WA_EDMS_AT01 TYPE EDMS_AT01.

SELECT SINGLE *
FROM EDMS_AT01
INTO CORRESPONDING FIELDS OF WA_EDMS_AT01
WHERE...

How to access SAP table EDMS_AT01

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

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