CUAND_CE_IC_ROOT

Transparent Table Application Table
52 Fields 5 CDS Views

Interaction Contact ROOT

CUAND_CE_IC_ROOT is an SAP database table in S/4HANA. Interaction Contact ROOT. It contains 52 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
cuan_ia_read view_entity left_outer Read Interaction
cuan_ic_search view_entity from Interaction Contact Search
E_IBCContact view_entity from EXTENSION Interaction Contact - Extension
I_IBCContact view_entity from BASIC Interaction Contact
I_IBCContactSearch view_entity from BASIC Contact Search

Fields (52)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
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
last_ia_timestamp CUAN_CE_LAST_IA_TIMESTAMP Timestamp
last_inbound_ia_timestamp CUAN_CE_LAST_IA_TIMESTAMP Timestamp
_dataaging DATA_TEMPERATURE Data Aging
end_of_purpose CUAN_CE_END_OF_PURPOSE End of Purpose
ic_type CUAN_CE_IC_TYPE IC Type
num_ft_d CUAN_CE_IC_NUM_FT_D No. Origin Data
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 ROOT
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CUAND_CE_IC_ROOT (
    MANDT,                      -- Client [MANDT]
    DB_KEY,                     -- NodeID [/BOBF/CONF_KEY]
    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]
    LAST_IA_TIMESTAMP,          -- Timestamp [CUAN_CE_LAST_IA_TIMESTAMP]
    LAST_INBOUND_IA_TIMESTAMP,  -- Timestamp [CUAN_CE_LAST_IA_TIMESTAMP]
    _DATAAGING,                 -- Data Aging [DATA_TEMPERATURE]
    END_OF_PURPOSE,             -- End of Purpose [CUAN_CE_END_OF_PURPOSE]
    IC_TYPE,                    -- IC Type [CUAN_CE_IC_TYPE]
    NUM_FT_D,                   -- No. Origin Data [CUAN_CE_IC_NUM_FT_D]
    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