I_MKT_ContactRelationData

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_ContactRelationData.
-- 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_CNTCTRELTN

CREATE VIEW I_MKT_ContactRelationData AS
SELECT
  cast(cuand_ce_ic_rl_d.db_key as cuan_key_ext) AS ContactRelationDataUUID,
  cast(cuand_ce_ic_rl_d.root_key as cuan_key_ext) AS InteractionContact,
  cast(cuand_ce_ic_rl_d.parent_key as cuan_key_ext ) AS InteractionContactFacetUUID,
  cuand_ce_ic_rl_d.id_origin AS ContactOrigin,
  cuand_ce_ic_rl_d.id AS ContactID,
  cuand_ce_ic_rl_d.rel_type AS RelationshipCategory,
  cuand_ce_ic_rl_d.rel_origin_to AS ReltdIntactnContactOrigin,
  cuand_ce_ic_rl_d.rel_id_to AS ReltdIntactnContactID,
  cuand_ce_ic_rl_d.name_text AS FullName,
  cuand_ce_ic_rl_d.name_first AS FirstName,
  cuand_ce_ic_rl_d.name_last AS LastName,
  cuand_ce_ic_rl_d.abtnr AS Department,
  cuand_ce_ic_rl_d.abtnr_ft AS DepartmentName,
  cuand_ce_ic_rl_d.pafkt AS InteractionContactFunction,
  cuand_ce_ic_rl_d.pafkt_ft AS IntactnCntctFunctionFreeText,
  cuand_ce_ic_rl_d.city1 AS CityName,
  cuand_ce_ic_rl_d.street AS StreetName,
  cuand_ce_ic_rl_d.house_num1 AS AddressHouseNumber,
  cuand_ce_ic_rl_d.language AS LanguageCode,
  cuand_ce_ic_rl_d.language_ft AS LanguageFreeText,
  cuand_ce_ic_rl_d.country AS Country,
  cuand_ce_ic_rl_d.country_ft AS CountryFreeText,
  cuand_ce_ic_rl_d.region AS AddressRegion,
  cuand_ce_ic_rl_d.region_ft AS RegionFreeText,
  _MKT_ContactFacetData.ValidationStatus AS ValidationStatus,
  cuand_ce_ic_rl_d.postcode1 AS ContactPostalCode,
  cuand_ce_ic_rl_d.title AS FormOfAddress,
  cuand_ce_ic_rl_d.brsch AS Industry,
  cuand_ce_ic_rl_d.brsch_ft AS IndustryKeyText,
  cuand_ce_ic_rl_d.latitude AS Latitude,
  cuand_ce_ic_rl_d.longitude AS Longitude,
  cuand_ce_ic_rl_d.srid AS SpatialReferenceSystem,
  cuand_ce_ic_rl_d.lchg_date_time AS LastChangeDateTime,
  cuand_ce_ic_rl_d.lchg_uname AS LastChangedByUser,
  cuand_ce_ic_rl_d.crea_date_time AS CreationDateTime,
  cuand_ce_ic_rl_d.crea_uname AS CreatedByUser,
  cuand_ce_ic_rl_d.is_main AS IsMainContact,
  cuand_ce_ic_rl_d.contact_key_to AS RelatedInteractionContactUUID,
  cuand_ce_ic_rl_d.timestamp AS RelationDataLastChgUTCDateTime
FROM cuand_ce_ic_rl_d
INNER JOIN cuand_ce_ic_fcet ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_MKT_PERSON AS _Extension ON cuand_ce_ic_rl_d.root_key = _Extension.Person  -- association [1..1]
LEFT OUTER JOIN E_MKT_CONTACT AS _InteractionContactExtension ON cuand_ce_ic_rl_d.root_key = _InteractionContactExtension.InteractionContact  -- association [1..1]
LEFT OUTER JOIN E_MKT_ContactRelationData AS _ContactRelationDataExtension ON cuand_ce_ic_rl_d.db_key = _ContactRelationDataExtension.ContactRelationDataUUID  -- association [1..1]
LEFT OUTER JOIN E_MKT_PersonRelationData AS _PersonRelationDataExtension ON cuand_ce_ic_rl_d.db_key = _PersonRelationDataExtension.PersonRelationDataUUID  -- association [1..1]
LEFT OUTER JOIN I_MKT_ContactFacetData_2 AS _MKT_ContactFacetData ON ContactOrigin = _MKT_ContactFacetData.InteractionContactOrigin AND ContactID = _MKT_ContactFacetData.InteractionContactId  -- association [1..*]
LEFT OUTER JOIN I_MKT_ValidationStatus AS _MKT_ValidationStatus ON ValidationStatus = _MKT_ValidationStatus.ValidationStatus  -- 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_RelationshipCategory AS _MKT_RelationshipCategory ON RelationshipCategory = _MKT_RelationshipCategory.RelationshipCategory  -- 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 InteractionContactFunction = _MKT_Function.Function  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON LanguageCode = _Language.Language  -- 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 AND ContactOrigin = _MKT_IntactnCntctMktgArea.InteractionContactOrigin  -- association [0..*]
LEFT OUTER JOIN I_Mkt_Contact AS _MKT_Contact ON InteractionContact = _MKT_Contact.InteractionContact  -- association [1..1]
LEFT OUTER JOIN I_MKT_Contactorigin AS _MKT_ContactOrigin ON ContactOrigin = _MKT_ContactOrigin.InteractionContactOrigin  -- association [0..1]
LEFT OUTER JOIN I_MKT_Contactorigin AS _MKT_RelatedContactOrigin ON ReltdIntactnContactOrigin = _MKT_RelatedContactOrigin.InteractionContactOrigin  -- association [0..1]
;