CUAND_CE_IC_RL_D

Transparent Table Application Table
50 Fields 4 CDS Views

Interaction Contact Relation Data - #GENERATED#

CUAND_CE_IC_RL_D is an SAP database table in S/4HANA. Interaction Contact Relation Data - #GENERATED#. It contains 50 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
E_IBCContactRelationData view_entity from EXTENSION Contact Relation Data - Extension
I_IBCCntctRelationAdditionalID view_entity inner BASIC Contact Relationship Additional IDs
I_IBCCntctRelationDataCommArea view_entity inner BASIC Contact Relation Data Communication Area
I_IBCContactRelationData view_entity from BASIC Contact Relation Data

Fields (50)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
root_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
rel_type CUAN_RELTYP Rel
rel_origin_to CUAN_CE_ORIGIN Origin of Contact
rel_id_to CUAN_CE_IDEXT External Contact ID
name_text CUAN_IC_NAME_TEXT Name
name_first AD_NAMEFIR First Name
name_last AD_NAMELAS Last Name
title AD_TITLE Title Key
title_ft CUAN_TITLE_TXT Title
country LAND1 Country/Reg.
country_ft CUAN_COUNTRY_TXT Country/Region
region REGIO Region
region_ft CUAN_REGION_TXT Region
city1 AD_CITY1 City
postcode1 AD_PSTCD1 Postal Code
street AD_STREET Street
house_num1 AD_HSNM1 House Number
language SPRAS Language
language_ft CUAN_LANGUAGE_TXT Language
brsch BRSCH Industry
brsch_ft CUAN_INDUSTRY_TXT Industry Code
abtnr ABTNR_PA Department
abtnr_ft AD_DPRTMNT Department
pafkt BU_PAFKT Function
pafkt_ft AD_FNCTN Function
latitude HPA_GEO_LATITUDE Latitude
longitude HPA_GEO_LONGITUDE Longitude
srid GSEG_V_SRID Spatial Ref ID
timestamp CUAN_CE_IC_RL_D_TSTMP Timestamp
crea_reason CUAN_CE_IC_RELSHIP_CREA_REASON Creation Reason
is_main_ts CUAN_CE_IC_MAIN_FLAG_TIMESTAMP Check for Merge
is_main CUAN_CE_IC_MAIN_FLAG_BOOLE Main Rel.ship
contact_key_to /BOBF/CONF_KEY NodeID
ic_type_to CUAN_CE_IC_TYPE IC Type
obsolete CUAN_CE_OBSOLETE Obsolete
business_partner_id BU_PARTNER Bus. Partner
business_partner_id_to BU_PARTNER Bus. Partner
customer_id_to KUNNR Customer
supplier_id_to LIFNR Supplier
contact_id PARNR Contact Person
crea_date_time TIMESTAMPL Time Stamp
crea_uname UNAME User Name
lchg_date_time TIMESTAMPL Time Stamp
lchg_uname UNAME User Name
cuan_e_ce_ic_rt HPA_DUMMY Dummy Field

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 Relation Data - #GENERATED#
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CUAND_CE_IC_RL_D (
    MANDT,                   -- Client [MANDT]
    DB_KEY,                  -- NodeID [/BOBF/CONF_KEY]
    ROOT_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]
    REL_TYPE,                -- Rel [CUAN_RELTYP]
    REL_ORIGIN_TO,           -- Origin of Contact [CUAN_CE_ORIGIN]
    REL_ID_TO,               -- External Contact ID [CUAN_CE_IDEXT]
    NAME_TEXT,               -- Name [CUAN_IC_NAME_TEXT]
    NAME_FIRST,              -- First Name [AD_NAMEFIR]
    NAME_LAST,               -- Last Name [AD_NAMELAS]
    TITLE,                   -- Title Key [AD_TITLE]
    TITLE_FT,                -- Title [CUAN_TITLE_TXT]
    COUNTRY,                 -- Country/Reg. [LAND1]
    COUNTRY_FT,              -- Country/Region [CUAN_COUNTRY_TXT]
    REGION,                  -- Region [REGIO]
    REGION_FT,               -- Region [CUAN_REGION_TXT]
    CITY1,                   -- City [AD_CITY1]
    POSTCODE1,               -- Postal Code [AD_PSTCD1]
    STREET,                  -- Street [AD_STREET]
    HOUSE_NUM1,              -- House Number [AD_HSNM1]
    LANGUAGE,                -- Language [SPRAS]
    LANGUAGE_FT,             -- Language [CUAN_LANGUAGE_TXT]
    BRSCH,                   -- Industry [BRSCH]
    BRSCH_FT,                -- Industry Code [CUAN_INDUSTRY_TXT]
    ABTNR,                   -- Department [ABTNR_PA]
    ABTNR_FT,                -- Department [AD_DPRTMNT]
    PAFKT,                   -- Function [BU_PAFKT]
    PAFKT_FT,                -- Function [AD_FNCTN]
    LATITUDE,                -- Latitude [HPA_GEO_LATITUDE]
    LONGITUDE,               -- Longitude [HPA_GEO_LONGITUDE]
    SRID,                    -- Spatial Ref ID [GSEG_V_SRID]
    TIMESTAMP,               -- Timestamp [CUAN_CE_IC_RL_D_TSTMP]
    CREA_REASON,             -- Creation Reason [CUAN_CE_IC_RELSHIP_CREA_REASON]
    IS_MAIN_TS,              -- Check for Merge [CUAN_CE_IC_MAIN_FLAG_TIMESTAMP]
    IS_MAIN,                 -- Main Rel.ship [CUAN_CE_IC_MAIN_FLAG_BOOLE]
    CONTACT_KEY_TO,          -- NodeID [/BOBF/CONF_KEY]
    IC_TYPE_TO,              -- IC Type [CUAN_CE_IC_TYPE]
    OBSOLETE,                -- Obsolete [CUAN_CE_OBSOLETE]
    BUSINESS_PARTNER_ID,     -- Bus. Partner [BU_PARTNER]
    BUSINESS_PARTNER_ID_TO,  -- Bus. Partner [BU_PARTNER]
    CUSTOMER_ID_TO,          -- Customer [KUNNR]
    SUPPLIER_ID_TO,          -- Supplier [LIFNR]
    CONTACT_ID,              -- Contact Person [PARNR]
    CREA_DATE_TIME,          -- Time Stamp [TIMESTAMPL]
    CREA_UNAME,              -- User Name [UNAME]
    LCHG_DATE_TIME,          -- Time Stamp [TIMESTAMPL]
    LCHG_UNAME,              -- User Name [UNAME]
    CUAN_E_CE_IC_RT,         -- Dummy Field [HPA_DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More