cuan_ia_read

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view cuan_ia_read.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CUAN_IAREAD

CREATE VIEW cuan_ia_read AS
SELECT
  Interaction.db_key AS db_key,
  Interaction.id_origin AS id_origin,
  Interaction.id AS id,
  Interaction.comm_medium AS comm_medium,
  Interaction.ia_type AS ia_type,
  Interaction.timestamp AS timestamp,
  Interaction.mkt_area_id AS mkt_area_id,
  Interaction.campaign_id AS campaign_id,
  Interaction.ini_version AS ini_version,
  Interaction.loc_origin AS loc_origin,
  Interaction.loc_id AS loc_id,
  Interaction.digacc_id AS digacc_id,
  Interaction.digacc_type AS digacc_type,
  Interaction.comm_cat_id AS comm_cat_id,
  Interaction.quantifier AS quantifier,
  Interaction.valuation AS valuation,
  Interaction.ia_status AS ia_status,
  Interaction.ia_reason AS ia_reason,
  Interaction.ia_language AS ia_language,
  Interaction.is_anonymous AS is_anonymous,
  Interaction.amount AS amount,
  Interaction.currency AS currency,
  Interaction.latitude AS latitude,
  Interaction.longitude AS longitude,
  Interaction.srid AS srid,
  Interaction.unit AS unit,
  Interaction.device_type AS device_type,
  Interaction.device_ft AS device_ft,
  Interaction.sw_client AS sw_client,
  Interaction.os AS os,
  Interaction.priority AS priority,
  Interaction.launch_url AS launch_url,
  Interaction.launch_text AS launch_text,
  Interaction.contact_key AS contact_key,
  Interaction.root_ia_key AS root_ia_key,
  Interaction.ia_date AS ia_date,
  Interaction.node_type AS node_type,
  Interaction.employee_id AS employee_id,
  Interaction.team_id AS team_id,
  Interaction._dataaging AS _dataaging,
  Interaction.crea_uname AS crea_uname,
  Interaction.lchg_uname AS lchg_uname,
  Interaction.content_data AS content_data,
  Interaction.utm_source AS utm_source,
  Interaction.utm_medium AS utm_medium,
  Interaction.utm_campaign AS utm_campaign,
  Interaction.utm_term AS utm_term,
  Interaction.utm_content AS utm_content,
  Interaction.name_text AS name_text,
  Interaction.name_first AS name_first,
  Interaction.name_last AS name_last,
  Interaction.title AS title,
  Interaction.title_ft AS title_ft,
  Interaction.country AS COUNTRY_IA,
  Interaction.country_ft AS country_ft,
  Interaction.region AS region,
  Interaction.region_ft AS region_ft,
  Interaction.city1 AS city1,
  Interaction.postcode1 AS postcode1,
  Interaction.street AS street,
  Interaction.house_num1 AS house_num1,
  Interaction.language AS language,
  Interaction.language_ft AS language_ft,
  Interaction.sex AS sex,
  Interaction.sex_ft AS sex_ft,
  Interaction.kunnr AS kunnr,
  Interaction.company_name AS company_name,
  Interaction.brsch AS brsch,
  Interaction.brsch_ft AS brsch_ft,
  Interaction.abtnr AS abtnr,
  Interaction.abtnr_ft AS abtnr_ft,
  Interaction.pafkt AS pafkt,
  Interaction.pafkt_ft AS pafkt_ft,
  Interaction.smtp_addr AS smtp_addr,
  Interaction.telnr_long AS telnr_long,
  Interaction.telnr_mobile AS telnr_mobile,
  Interaction.faxnr_long AS faxnr_long,
  Interaction.is_contact AS is_contact,
  Interaction.is_consumer AS is_consumer,
  Interaction.obsolete AS obsolete,
  Interaction.web_uri AS web_uri,
  Interaction.email_optin AS email_optin,
  Interaction.phone_optin AS phone_optin,
  Interaction.mobile_optin AS mobile_optin,
  Interaction.fax_optin AS fax_optin,
  Interaction.postal_optin AS postal_optin,
  Interaction.image_uri AS image_uri,
  Interaction.boolean1 AS boolean1,
  Interaction.boolean2 AS boolean2,
  Interaction.boolean3 AS boolean3,
  Interaction.boolean4 AS boolean4,
  Interaction.time1 AS time1,
  Interaction.date1 AS date1,
  Interaction.date2 AS date2,
  Interaction.date3 AS date3,
  Interaction.number1 AS number1,
  Interaction.number2 AS number2,
  Interaction.number3 AS number3,
  Interaction.text20_1 AS text20_1,
  Interaction.text20_2 AS text20_2,
  Interaction.timestamp1 AS timestamp1,
  Interaction.timestamp2 AS timestamp2,
  Interaction.decimal1 AS decimal1,
  Interaction.decimal2 AS decimal2,
  Interaction.decimal3 AS decimal3,
  Interaction.text40_1 AS text40_1,
  Interaction.text40_2 AS text40_2,
  Interaction.text80_1 AS text80_1,
  Interaction.text80_2 AS text80_2,
  Interaction.text120_1 AS text120_1,
  Interaction.text120_2 AS text120_2,
  Interaction.text255_1 AS text255_1,
  Interaction.text255_2 AS text255_2,
  _MKT_IC.country AS COUNTRY,
  _MKT_CPG.name AS INI_NAME,
  _MKT_IC.end_of_purpose AS END_OF_PURPOSE,
  cast(Interaction.valuation as domvalue_l) AS VALUATION_CHAR
FROM cuand_ce_ia_rt AS Interaction
LEFT OUTER JOIN cuand_ce_ic_root AS _MKT_IC ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cuan_d_ini_root AS _MKT_CPG ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cuan_d_comcat_rt AS _MKT_CCAT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_MKT_INTERACTION AS _InteractionExtension ON db_key = _InteractionExtension.Interaction  -- association [1..1]
;