COLLCCTDRA

Transparent Table Application Table
32 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 32 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CustomerContactAttributeDrft view from BASIC Customer Contact Draft

Fields (32)

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
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityconsistencystatus abap.char
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes

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]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,   -- abap.char
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, CUSTOMERCONTACTUUID, DRAFTUUID)
);

Learn More