CUAND_CE_IC_FT_D

Transparent Table Application Table
51 Fields 2 CDS Views

Interaction Contact Facet Data - #GENERATED#

CUAND_CE_IC_FT_D is an SAP database table in S/4HANA. Interaction Contact Facet Data - #GENERATED#. It contains 51 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_IBCContactFacetData view_entity from EXTENSION Contact Facet Data - Extension
I_IBCContactFacetData view_entity from BASIC Contact Facet Data

Fields (51)

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
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
sex BU_SEXID Sex
sex_ft CUAN_GENDER_TXT Gender
marital_status BU_MARST Marital Status
marital_status_ft CUAN_MARITAL_STATUS_TXT Marital Status
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
smtp_addr HPA_EMAIL_ADDR E-Mail Address
telnr_long AD_TELNRLG Telephone no.
telnr_mobile AD_TELNRLG Telephone no.
faxnr_long AD_FXNRLNG Fax Number
date_of_birth BU_BIRTHDT Date of Birth
obsolete CUAN_CE_OBSOLETE Obsolete
web_uri CUAN_HOMEPAGE_WEB_URI Web Site
image_uri CUAN_IMAGE_URI Image URI
latitude HPA_GEO_LATITUDE Latitude
longitude HPA_GEO_LONGITUDE Longitude
srid GSEG_V_SRID Spatial Ref ID
number_of_employees CUAN_NUMBER_OF_EMPLOYEES No. Employees
company_revenue CUAN_COMPANY_REVENUE Co. Revenue
company_revenue_currency HPA_CURRENCY_CODE Currency
_dataaging DATA_TEMPERATURE Data Aging
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 Facet 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_FT_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]
    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]
    SEX,                       -- Sex [BU_SEXID]
    SEX_FT,                    -- Gender [CUAN_GENDER_TXT]
    MARITAL_STATUS,            -- Marital Status [BU_MARST]
    MARITAL_STATUS_FT,         -- Marital Status [CUAN_MARITAL_STATUS_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]
    SMTP_ADDR,                 -- E-Mail Address [HPA_EMAIL_ADDR]
    TELNR_LONG,                -- Telephone no. [AD_TELNRLG]
    TELNR_MOBILE,              -- Telephone no. [AD_TELNRLG]
    FAXNR_LONG,                -- Fax Number [AD_FXNRLNG]
    DATE_OF_BIRTH,             -- Date of Birth [BU_BIRTHDT]
    OBSOLETE,                  -- Obsolete [CUAN_CE_OBSOLETE]
    WEB_URI,                   -- Web Site [CUAN_HOMEPAGE_WEB_URI]
    IMAGE_URI,                 -- Image URI [CUAN_IMAGE_URI]
    LATITUDE,                  -- Latitude [HPA_GEO_LATITUDE]
    LONGITUDE,                 -- Longitude [HPA_GEO_LONGITUDE]
    SRID,                      -- Spatial Ref ID [GSEG_V_SRID]
    NUMBER_OF_EMPLOYEES,       -- No. Employees [CUAN_NUMBER_OF_EMPLOYEES]
    COMPANY_REVENUE,           -- Co. Revenue [CUAN_COMPANY_REVENUE]
    COMPANY_REVENUE_CURRENCY,  -- Currency [HPA_CURRENCY_CODE]
    _DATAAGING,                -- Data Aging [DATA_TEMPERATURE]
    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