COLLCCTDRA

Transparent Table Application Table
25 Fields 1 CDS Views

Draft table for entity R_CUSTOMERCONTACTATTRIBUTETP

COLLCCTDRA is an SAP database table in S/4HANA. Draft table for entity R_CUSTOMERCONTACTATTRIBUTETP. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CustomerContactAttributeDrft view from BASIC Customer Contact Draft

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY customercontactuuid bdm_cct_guid Customer Contact Key
KEY draftuuid sdraft_uuid Draft Document ID
businesspartner bu_partner Busn. Partner
collectionsegment udm_coll_segment Segment
collectioncustomercontact bdm_cct_id Contact ID
collectionspecialist coll_cct_collection_specialist Collection Specialist
contactperson bdm_contact_key Contact Person Key
contactpersonname udm_contact_name Contact Person
contactpersonemailaddress udm_contact_email Email
contactpersonphonenumber udm_contact_phone Telephone No.
contactpersonfaxnumber udm_contact_fax Fax Number
contactpersonfaxcountry udm_contact_faxc C/R of Fax No.
customercontactdirection coll_cct_direction Contact Direction
customercontacttype udm_contacttype Contact Type
customercontactresult coll_cct_result Result of Contact
customerisreached bdm_xreached Reached
customercontactdatetime coll_cct_datetime Customer Contact Time
custcontactdurationinminutes bdm_cct_duration Duration
createdbyuser udm_created_by Created By
creationdatetime coll_pr_creation_date_time Created At
changedby udm_changed_by Last Changed By
changedondatetime coll_pr_changed_at Last Changed At
collectionworklistitemuuid udm_worklist_item_guid Technical Key
bopfuuid sdraft_uuid Draft Document ID

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.

-- Draft table for entity R_CUSTOMERCONTACTATTRIBUTETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE COLLCCTDRA (
    MANDT,                         -- Client [mandt]
    CUSTOMERCONTACTUUID,           -- Customer Contact Key [bdm_cct_guid]
    DRAFTUUID,                     -- Draft Document ID [sdraft_uuid]
    BUSINESSPARTNER,               -- Busn. Partner [bu_partner]
    COLLECTIONSEGMENT,             -- Segment [udm_coll_segment]
    COLLECTIONCUSTOMERCONTACT,     -- Contact ID [bdm_cct_id]
    COLLECTIONSPECIALIST,          -- Collection Specialist [coll_cct_collection_specialist]
    CONTACTPERSON,                 -- Contact Person Key [bdm_contact_key]
    CONTACTPERSONNAME,             -- Contact Person [udm_contact_name]
    CONTACTPERSONEMAILADDRESS,     -- Email [udm_contact_email]
    CONTACTPERSONPHONENUMBER,      -- Telephone No. [udm_contact_phone]
    CONTACTPERSONFAXNUMBER,        -- Fax Number [udm_contact_fax]
    CONTACTPERSONFAXCOUNTRY,       -- C/R of Fax No. [udm_contact_faxc]
    CUSTOMERCONTACTDIRECTION,      -- Contact Direction [coll_cct_direction]
    CUSTOMERCONTACTTYPE,           -- Contact Type [udm_contacttype]
    CUSTOMERCONTACTRESULT,         -- Result of Contact [coll_cct_result]
    CUSTOMERISREACHED,             -- Reached [bdm_xreached]
    CUSTOMERCONTACTDATETIME,       -- Customer Contact Time [coll_cct_datetime]
    CUSTCONTACTDURATIONINMINUTES,  -- Duration [bdm_cct_duration]
    CREATEDBYUSER,                 -- Created By [udm_created_by]
    CREATIONDATETIME,              -- Created At [coll_pr_creation_date_time]
    CHANGEDBY,                     -- Last Changed By [udm_changed_by]
    CHANGEDONDATETIME,             -- Last Changed At [coll_pr_changed_at]
    COLLECTIONWORKLISTITEMUUID,    -- Technical Key [udm_worklist_item_guid]
    BOPFUUID,                      -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, CUSTOMERCONTACTUUID, DRAFTUUID)
);

Learn More