COLLS_EMAIL

Transparent Table Application Table
22 Fields 1 CDS Views

Collections Email

COLLS_EMAIL is an SAP database table in S/4HANA. Collections Email. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CollectionsEmail view from BASIC Collections Email

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY emailuuid SYSUUID_X16 UUID
objecttype SBO_BO_TYPE SAP Object Type
objectkey SWO_TYPEID Key
template_id COLLS_EMAIL_TEMPLATE Email Template
tmpl_language SPRAS Language
subject SMTG_TMPL_SUBJECT Email Subject
body_html SMTG_TMPL_BODY_HTML Body HTML
recipient COLLS_EMAIL_RECIPIENT To
cc_recipient COLLS_EMAIL_CC_RECIPIENT Cc
bcc_recipient COLLS_EMAIL_BCC_RECIPIENT Bcc
sender COLLS_EMAIL_SENDER Sender
email_sent_at COLLS_EMAIL_SENT_AT Sent At
email_sent_by COLLS_EMAIL_SENT_BY Sent By
sending_triggered_by UNAME User Name
email_status COLLS_EMAIL_STATUS Status
application_log_number BALOGNR Log Number
zip_attachments COLLS_EMAIL_ZIP_ATTACHMENTS Zip Attachments
created_at COLL_PR_CREATION_DATE_TIME Created At
created_by UDM_CREATED_BY Created By
last_changed_at COLL_PR_CHANGED_AT Last Changed At
last_changed_by UDM_CHANGED_BY Last Changed By

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.

-- Collections Email
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE COLLS_EMAIL (
    MANDT,                   -- Client [MANDT]
    EMAILUUID,               -- UUID [SYSUUID_X16]
    OBJECTTYPE,              -- SAP Object Type [SBO_BO_TYPE]
    OBJECTKEY,               -- Key [SWO_TYPEID]
    TEMPLATE_ID,             -- Email Template [COLLS_EMAIL_TEMPLATE]
    TMPL_LANGUAGE,           -- Language [SPRAS]
    SUBJECT,                 -- Email Subject [SMTG_TMPL_SUBJECT]
    BODY_HTML,               -- Body HTML [SMTG_TMPL_BODY_HTML]
    RECIPIENT,               -- To [COLLS_EMAIL_RECIPIENT]
    CC_RECIPIENT,            -- Cc [COLLS_EMAIL_CC_RECIPIENT]
    BCC_RECIPIENT,           -- Bcc [COLLS_EMAIL_BCC_RECIPIENT]
    SENDER,                  -- Sender [COLLS_EMAIL_SENDER]
    EMAIL_SENT_AT,           -- Sent At [COLLS_EMAIL_SENT_AT]
    EMAIL_SENT_BY,           -- Sent By [COLLS_EMAIL_SENT_BY]
    SENDING_TRIGGERED_BY,    -- User Name [UNAME]
    EMAIL_STATUS,            -- Status [COLLS_EMAIL_STATUS]
    APPLICATION_LOG_NUMBER,  -- Log Number [BALOGNR]
    ZIP_ATTACHMENTS,         -- Zip Attachments [COLLS_EMAIL_ZIP_ATTACHMENTS]
    CREATED_AT,              -- Created At [COLL_PR_CREATION_DATE_TIME]
    CREATED_BY,              -- Created By [UDM_CREATED_BY]
    LAST_CHANGED_AT,         -- Last Changed At [COLL_PR_CHANGED_AT]
    LAST_CHANGED_BY,         -- Last Changed By [UDM_CHANGED_BY]
    PRIMARY KEY (MANDT, EMAILUUID)
);

Learn More