_ATTACHMENT

29 Fields

_ATTACHMENT is an SAP database table in S/4HANA. It contains 29 fields.

Fields (29)

KeyField CDS FieldsUsed in Views
KEY FileUUID FileUUID 2
KEY PhysicalDocument PhysicalDocument 2
AttachmentAsURL AttachmentAsURL 1
AttachmentAsURLLength AttachmentAsURLLength 1
ChangedDateTime ChangedDateTime 2
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 2
DocumentFormat DocumentFormat 2
DocumentIndex DocumentIndex 1
DocumentInfoRecordFileName DocumentInfoRecordFileName 1
DocumentTitle DocumentTitle 2
FileDescription FileDescription 1
FileName FileName 3
FileSize FileSize 2
InternalComment InternalComment 2
IsOriginalVersionActive IsOriginalVersionActive 1
LastChangedByUser LastChangedByUser 2
LogicalDocument LogicalDocument 2
LogicalDocumentClass LogicalDocumentClass 2
LogicalDocumentIsReference LogicalDocumentIsReference 2
MimeType MimeType 2
OriginalCheckedOutTime OriginalCheckedOutTime 2
OriginalCheckedOutUser OriginalCheckedOutUser 2
OriginalIsProtected OriginalIsProtected 2
OriginalType OriginalType 2
PhysicalDocTechnicalStatus PhysicalDocTechnicalStatus 2
PhysicalDocumentClass PhysicalDocumentClass 2
StorageCategory StorageCategory 2
WorkstationApplication WorkstationApplication 3

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _ATTACHMENT (
    FILEUUID,
    PHYSICALDOCUMENT,
    ATTACHMENTASURL,
    ATTACHMENTASURLLENGTH,
    CHANGEDDATETIME,
    CREATEDBYUSER,
    CREATIONDATETIME,
    DOCUMENTFORMAT,
    DOCUMENTINDEX,
    DOCUMENTINFORECORDFILENAME,
    DOCUMENTTITLE,
    FILEDESCRIPTION,
    FILENAME,
    FILESIZE,
    INTERNALCOMMENT,
    ISORIGINALVERSIONACTIVE,
    LASTCHANGEDBYUSER,
    LOGICALDOCUMENT,
    LOGICALDOCUMENTCLASS,
    LOGICALDOCUMENTISREFERENCE,
    MIMETYPE,
    ORIGINALCHECKEDOUTTIME,
    ORIGINALCHECKEDOUTUSER,
    ORIGINALISPROTECTED,
    ORIGINALTYPE,
    PHYSICALDOCTECHNICALSTATUS,
    PHYSICALDOCUMENTCLASS,
    STORAGECATEGORY,
    WORKSTATIONAPPLICATION,
    PRIMARY KEY (FILEUUID, PHYSICALDOCUMENT)
);

Learn More