SAP CTE_D_DOC_AT Table – Document Attachments

The CTE_D_DOC_AT table in SAP ERP or S/4HANA stores Document Attachments data. There are total 12 fields in CTE_D_DOC_AT table. The Document Attachments table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CTE_D_DOC_AT table. It is in Central Posting Objects (CTE_FND_POST_IMP) ABAP package and is part of the Concur S/4HANA Integration (BNS-CON-SE-S4) module.

SAP CTE_D_DOC_AT Table Fields

Following is the list of fields that are available in SAP CTE_D_DOC_AT table. The primary key fields of the table are CLIENT (Client), SYSTEM_KEY (System Key), DOCUMENT_TYPE (Concur Document Type), DOCUMENT_ID (ID of Concur Document), REVISION_ID (Concur Document Revision Number), ENTRY_ID (Concur Node ID), CONCUR_ATTACHMENT_ID (Concur Node ID).

Field Description Data Element Check Table Data Type
CLIENT Client MANDT * CLNT (3)
SYSTEM_KEY System Key CTE_SYSTEM_KEY_NUMBER INT1 (3)
DOCUMENT_TYPE Concur Document Type CTE_FND_POST_DOC_TYPE CHAR (2)
DOCUMENT_ID ID of Concur Document CTE_FND_POST_DOC_ID CHAR (32)
REVISION_ID Concur Document Revision Number CTE_FND_POST_DOC_REV_ID CHAR (3)
ENTRY_ID Concur Node ID CTE_CONCUR_NODE_ID CHAR (32)
CONCUR_ATTACHMENT_ID Concur Node ID CTE_CONCUR_NODE_ID CHAR (32)
ATTACHMENT_FORMAT Format of Attachment CTE_ATTACHMENT_FORMAT CHAR (3)
ATTACHMENT_LOCATION_TYPE Attachment location type CTE_ATTACHMENT_LOCATION_TYPE CHAR (10)
ATTACHMENT_ARCHIV_ID Content Repository Identification SAEARCHIVI * CHAR (2)
ATTACHMENT_ARCH_DOC_TYPE Document type SAEOBJART * CHAR (10)
ATTA_DOC_ASGN_TYPE Boolean CTE_BOOLEAN CHAR (1)