C_IBCContactProjection

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 C_IBCContactProjection.
-- 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 C_IBCContactProjection AS
SELECT
  InteractionCntctProjectionUUID,
  InteractionContactUUID,
  FullName,
  FirstName,
  LastName,
  FormattedPostalAddressText,
  cast(Country as land preserving type) AS Country,
  _MKT_Country._Text.CountryName as CountryName : localized AS CountryNameasCountryNamelocalized,
  AddressRegion,
  _MKT_Region._RegionText.RegionName as RegionName : localized AS RegionNameasRegionNamelocalized,
  CityName,
  ContactPostalCode,
  StreetName,
  AddressHouseNumber,
  FormOfAddress,
  EmailAddress,
  PhoneNumber,
  MobileNumber,
  InteractionContactDepartment,
  _MKT_Department._Text.DepartmentName as DepartmentName : localized AS DepartmentNameasDepartmentNamelocalized,
  InteractionContactFunction,
  Industry,
  _MKT_Industry._Text.IndustryName as IndustryName : localized AS IndustryNameasIndustryNamelocalized,
  WebsiteURL,
  MaritalStatus,
  cast(LanguageCode as cuan_cds_language preserving type ) AS LanguageCode,
  _Language._Text.LanguageName as LanguageName : localized AS LanguageNameasLanguageNamelocalized,
  cast(GenderCode as cuan_cds_gender preserving type) AS GenderCode,
  _MKT_Gender._Text.GenderCodeName as GenderCodeName : localized AS GenderCodeNameasGenderCodeNamelocalized,
  BirthDate,
  InteractionCntctProjectionType,
  PartnerFunctionType,
  BusinessPartner,
  ToBusinessPartner,
  Customer,
  ToCustomer,
  Supplier,
  ToSupplier,
  ContactPerson,
  CorporateAccountUUID,
  cast(CommunicationArea as hpa_comm_area_id_ext preserving type ) AS CommunicationArea,
  CommunicationAreaName,
  ReferencedOrgStructure
FROM I_IBCContactProjection
LEFT OUTER JOIN C_IBCCommunicationAreaVH AS _CommunicationAreaText ON CommunicationArea = _CommunicationAreaText.CommunicationArea AND ReferencedOrgStructure = _CommunicationAreaText.ReferencedOrgStructure  -- association [0..1]
LEFT OUTER JOIN C_IBCIntactnDetInteraction AS _Interactions ON InteractionContactUUID = _Interactions.InteractionContactUUID AND CommunicationArea = _Interactions.CommunicationArea AND ReferencedOrgStructure = _Interactions.ReferencedOrgStructure  -- association [0..*]
LEFT OUTER JOIN C_IBCContactPermission AS _Permissions ON InteractionContactUUID = _Permissions.InteractionContactUUID AND CommunicationArea = _Permissions.CommunicationArea AND ReferencedOrgStructure = _Permissions.ReferencedOrgStructure AND 'EMAIL' = _Permissions.InteractionContactOrigin  -- association [0..*]
LEFT OUTER JOIN C_IBCRelationshipProjection AS _RelationProjections ON InteractionContactUUID = _RelationProjections.InteractionContactUUID  -- association [0..*]
LEFT OUTER JOIN I_CommAreaSalesOrganization AS _SalesOrg ON CommunicationArea = _SalesOrg.CommunicationArea  -- association [1..1]
LEFT OUTER JOIN I_CommAreaPurchasingOrg AS _PurchasingOrg ON CommunicationArea = _PurchasingOrg.CommunicationArea  -- association [1..1]
;