I_Mkt_Contact

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 I_Mkt_Contact.
-- 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: IMKT_CONTACT

CREATE VIEW I_Mkt_Contact AS
SELECT
  cast(Persistence.db_key as cuan_intactncntct_ext) AS InteractionContact,
  cast(bintohex(Persistence.db_key) as abap.char(32)) AS PersonUUID,
  Persistence.name_text AS FullName,
  concat_with_space(Persistence.name_first ,Persistence.name_last, 1 ) AS PersonFullName,
  cast(Persistence.name_first as cuan_name_first_ext) AS FirstName,
  cast(Persistence.name_last as cuan_name_last_ext) AS LastName,
  Persistence.abtnr AS Department,
  cast(Persistence.abtnr_ft as cuan_dprtmnt2_ext) AS ContactPersonDepartment,
  Persistence.pafkt AS Function,
  cast(Persistence.pafkt_ft as cuan_fnctn_ext) AS PartnerFunctionName,
  cast(Persistence.marital_status as cuan_marital_status_ext) AS MaritalStatus,
  cast(Persistence.city1 as cuan_city1_ext ) AS CityName,
  cast(Persistence.street as cuan_street_ext) AS StreetName,
  cast(Persistence.house_num1 as cuan_hsnm1_ext ) AS AddressHouseNumber,
  Persistence.language AS LanguageCode,
  Persistence.language_ft AS LanguageFreeText,
  cast(Persistence.smtp_addr as cuan_smtp_addr_ext) AS EmailAddress,
  cast(Persistence.telnr_long as cuan_telnr_ext) AS PhoneNumber,
  cast(Persistence.telnr_mobile as cuan_mobile_ext) AS MobileNumber,
  cast(Persistence.faxnr_long as cuan_faxnr_ext) AS FaxNumber,
  substring( cast( Persistence.last_inbound_ia_timestamp as abap.char(28) ), 1,8 ) AS LastChangeDate,
  substring( cast( Persistence.crea_date_time as abap.char(28) ), 1,8 ) AS CreationDate,
  substring( cast( Persistence.lchg_date_time as abap.char(28) ), 1,8 ) AS LastChangedDate,
  Persistence.crea_date_time AS CreationDateTime,
  Persistence.lchg_date_time AS ChangedOnDateTime,
  cast(Persistence.crea_uname as cuan_uname_ext) AS CreatedByUser,
  cast(Persistence.lchg_uname as cuan_uname_ext) AS LastChangedByUser,
  cast( Persistence.country as cuan_cds_country) AS Country,
  Persistence.country_ft AS CountryFreeText,
  cast(Persistence.region as cuan_region_ext) AS AddressRegion,
  Persistence.region_ft AS RegionFreeText,
  cast( Persistence.sex as cuan_cds_gender ) AS GenderCode,
  Persistence.sex_ft AS GenderFreeText,
  cast(Persistence.date_of_birth as cuan_birthdate_ext) AS BirthDate,
  Persistence.ic_type AS InteractionContactType,
  cast(Persistence.postcode1 as cuan_pstcd1_ext) AS ContactPostalCode,
  cast(Persistence.title as cuan_title_ext) AS FormOfAddress,
  Persistence.company_name AS CompanyName,
  Persistence.is_contact AS IsContactPerson,
  Persistence.is_consumer AS IsConsumer,
  Persistence.web_uri AS WebsiteURL,
  Persistence.image_uri AS ImageURL,
  Persistence.postal_optin AS HasMktgPermissionForDirectMail,
  Persistence.kunnr AS CorporateAccount,
  Persistence.consumer_account_id AS InteractnCntctConsumerAccount,
  Persistence.validation_status AS ValidationStatus,
  Persistence.last_ia_timestamp AS LastChangeDateTime,
  cast(Persistence.latitude as cuan_latitude_ext preserving type) AS Latitude,
  cast(Persistence.longitude as cuan_longitude_ext preserving type) AS Longitude,
  cast(Persistence.srid as cuan_srid_ext preserving type) AS SpatialReferenceSystem,
  Persistence.brsch AS Industry,
  Persistence.brsch_ft AS IndustryKeyText,
  Persistence.anonymized AS IdentityIsRemoved,
  Persistence.is_for_acc_bsd_mkt AS CorpAcctIsRlvtForAcctBasedMktg,
  Persistence.number_of_employees AS NrOfEmployeesOfCorpAccount,
  Persistence.company_revenue AS CorporateAccountRevenue,
  Persistence.company_revenue_currency AS CorporateAccountCurrency
FROM cuand_ce_ic_root AS Persistence
LEFT OUTER JOIN E_MKT_CONTACT AS _Extension ON Persistence.db_key = _Extension.InteractionContact  -- association [1..1]
LEFT OUTER JOIN E_MKT_PERSON AS _ExtensionPerson ON Persistence.db_key = _ExtensionPerson.Person  -- association [1..1]
LEFT OUTER JOIN E_MKT_COMPANY AS _ExtensionCompany ON Persistence.db_key = _ExtensionCompany.Company  -- association [1..1]
LEFT OUTER JOIN I_MKT_Gender AS _MKT_Gender ON GenderCode = _MKT_Gender.GenderCode  -- association [0..1]
LEFT OUTER JOIN I_MKT_Region AS _MKT_Region ON Country = _MKT_Region.Country AND AddressRegion = _MKT_Region.Region  -- association [0..1]
LEFT OUTER JOIN I_MKT_Country AS _MKT_Country ON Country = _MKT_Country.Country  -- association [0..1]
LEFT OUTER JOIN I_MKT_CountryMarket AS _MKT_CountryMarket ON Country = _MKT_CountryMarket.Country  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON LanguageCode = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_MKT_Industry AS _MKT_Industry ON Industry = _MKT_Industry.Industry  -- association [0..1]
LEFT OUTER JOIN I_MKT_Function AS _MKT_Function ON Function = _MKT_Function.Function  -- association [0..1]
LEFT OUTER JOIN I_MKT_Marital AS _MKT_Marital ON MaritalStatus = _MKT_Marital.MaritalStatus  -- association [0..1]
LEFT OUTER JOIN I_MKT_ValidationStatus AS _MKT_ValidationStatus ON ValidationStatus = _MKT_ValidationStatus.ValidationStatus  -- association [0..1]
LEFT OUTER JOIN I_MKT_Department AS _MKT_Department ON Department = _MKT_Department.Department  -- association [0..1]
LEFT OUTER JOIN I_MKT_ContactTitle AS _MKT_ContactTitle ON FormOfAddress = _MKT_ContactTitle.FormOfAddress  -- association [0..1]
LEFT OUTER JOIN I_MKT_IntactnCntctMktgArea AS _MKT_IntactnCntctMktgArea ON InteractionContact = _MKT_IntactnCntctMktgArea.InteractionContactUUID  -- association [0..*]
;