I_IBCContactRelationData

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_IBCContactRelationData.
-- 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.

CREATE VIEW I_IBCContactRelationData AS
SELECT
  cast(cuand_ce_ic_rl_d.db_key as cuan_key_ext preserving type ) AS ContactRelationDataUUID,
  cast(cuand_ce_ic_rl_d.root_key as cuan_key_ext preserving type ) AS InteractionContactUUID,
  cast(cuand_ce_ic_rl_d.parent_key as cuan_key_ext preserving type ) AS InteractionContactFacetUUID,
  cast( cuand_ce_ic_rl_d.id_origin as cuan_ce_origin preserving type ) 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 InteractionContactDepartment,
  cuand_ce_ic_rl_d.abtnr_ft AS IntactnCntctDepartmentName,
  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,
  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,
  cast('DEG' as msehiunit) AS GeoCoordinatesUnit,
  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_IBCContactRelationData AS _ContactRelationDataExtension ON cuand_ce_ic_rl_d.db_key = _ContactRelationDataExtension.ContactRelationDataUUID  -- association [1..1]
LEFT OUTER JOIN I_IBCContactFacetData AS _MKT_ContactFacetData ON ContactOrigin = _MKT_ContactFacetData.InteractionContactOrigin AND ContactID = _MKT_ContactFacetData.InteractionContactId  -- association [1..*]
LEFT OUTER JOIN I_Region AS _MKT_Region ON Country = _MKT_Region.Country AND AddressRegion = _MKT_Region.Region  -- association [0..1]
LEFT OUTER JOIN I_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.InteractionContactFunction  -- 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 InteractionContactDepartment = _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_IBCContactCommunicationArea AS _IBCContactCommArea ON InteractionContactUUID = _IBCContactCommArea.IntactnCntctCommAreaUUID AND ContactOrigin = _IBCContactCommArea.InteractionContactOrigin AND ContactID = _IBCContactCommArea.InteractionContactId  -- association [0..*]
LEFT OUTER JOIN I_IBCContact AS _MKT_Contact ON InteractionContactUUID = _MKT_Contact.InteractionContactUUID  -- 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]
;