CUAND_CE_IC_FCET

Transparent Table Application Table
13 Fields 5 CDS Views

Interaction Contact Facet

CUAND_CE_IC_FCET is an SAP database table in S/4HANA. Interaction Contact Facet. It contains 13 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_IBCCntctRelationAdditionalID view_entity inner BASIC Contact Relationship Additional IDs
I_IBCCntctRelationDataCommArea view_entity inner BASIC Contact Relation Data Communication Area
I_IBCContactFacet view_entity from BASIC Contact Facet
I_IBCContactRelationData view_entity inner BASIC Contact Relation Data
I_MKT_ContactFacetAll view_entity from BASIC Marketing: Interaction Contact Facet All

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
parent_key /BOBF/CONF_KEY NodeID
id_origin CUAN_CE_ORIGIN Origin of Contact
id CUAN_CE_IDEXT External Contact ID
timestamp CUAN_CE_IC_FCET_TSTMP Timestamp
obsolete CUAN_CE_OBSOLETE Obsolete
end_of_purpose CUAN_CE_END_OF_PURPOSE End of Purpose
_dataaging DATA_TEMPERATURE Data Aging
invalid CUAN_CE_INVALID Invalid
check_for_merge CUAN_CE_IC_CHECK_FOR_MERGE Check for Merge
facet_type CUAN_CE_IC_FACET_TYPE Facet type
invalid_until CUAN_CE_INVALID_UNTIL Invalid Until

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.

-- Interaction Contact Facet
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CUAND_CE_IC_FCET (
    MANDT,            -- Client [MANDT]
    DB_KEY,           -- NodeID [/BOBF/CONF_KEY]
    PARENT_KEY,       -- NodeID [/BOBF/CONF_KEY]
    ID_ORIGIN,        -- Origin of Contact [CUAN_CE_ORIGIN]
    ID,               -- External Contact ID [CUAN_CE_IDEXT]
    TIMESTAMP,        -- Timestamp [CUAN_CE_IC_FCET_TSTMP]
    OBSOLETE,         -- Obsolete [CUAN_CE_OBSOLETE]
    END_OF_PURPOSE,   -- End of Purpose [CUAN_CE_END_OF_PURPOSE]
    _DATAAGING,       -- Data Aging [DATA_TEMPERATURE]
    INVALID,          -- Invalid [CUAN_CE_INVALID]
    CHECK_FOR_MERGE,  -- Check for Merge [CUAN_CE_IC_CHECK_FOR_MERGE]
    FACET_TYPE,       -- Facet type [CUAN_CE_IC_FACET_TYPE]
    INVALID_UNTIL,    -- Invalid Until [CUAN_CE_INVALID_UNTIL]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More