I_MKT_LocationOriginData

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_LocationOriginData.
-- 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_LOCORIGIN

CREATE VIEW I_MKT_LocationOriginData AS
SELECT
  cuand_loc_facet.loc_id AS MarketingLocationExternalID,
  cuand_loc_facet.loc_origin AS MarketingLocationOrigin,
  cuand_loc_facet.db_key AS MarketingLocOriginDataUUID,
  cast(cuand_loc_facet.parent_key as cuan_cds_location) AS MarketingLocationUUID,
  cuand_loc_facet.type AS MarketingLocationType,
  cuand_loc_facet.company_name AS CompanyName,
  cuand_loc_facet.location_name AS MarketingLocationName,
  cuand_loc_facet.country AS Country,
  cuand_loc_facet.region AS AddressRegion,
  cuand_loc_facet.city AS CityName,
  cuand_loc_facet.postcode AS PostalCode,
  cuand_loc_facet.street AS AddressStreetName,
  cuand_loc_facet.house_num AS AddressHouseNumber,
  cuand_loc_facet.building AS Building,
  cuand_loc_facet.floor AS Floor,
  cuand_loc_facet.room_no AS RoomNumber,
  cuand_loc_facet.telnr_long AS PhoneNumber,
  cuand_loc_facet.faxnr_long AS FaxNumber,
  cuand_loc_facet.smtp_addr AS EmailAddress,
  cuand_loc_facet.web_uri AS WebsiteURL,
  cuand_loc_facet.obsolete AS IsObsolete,
  cuand_loc_facet.latitude AS Latitude,
  cuand_loc_facet.longitude AS Longitude,
  cast('DEG' as msehi) AS LatitudeUnit,
  cast('DEG' as msehi) AS LongitudeUnit,
  cuand_loc_facet.crea_date_time AS CreationUTCDateTime,
  cuand_loc_facet.crea_uname AS CreatedByUser,
  cuand_loc_facet.lchg_date_time AS LastChangeUTCDateTime,
  cuand_loc_facet.lchg_uname AS LastChangeByUser,
  cast( cuand_loc_facet.mkt_area_id as cuan_cds_mkt_area ) AS MarketingArea,
  cuand_loc_facet.valid_from_date AS ValidityStartDate,
  cuand_loc_facet.valid_to_date AS ValidityEndDate,
  cuand_loc_facet.srid AS SpatialReferenceSystem,
  cuand_loc_facet.image_uri AS MarketingLocationImageURL,
  cuand_loc_facet.mall_name AS MarketingLocationMallName,
  cuand_loc_facet.occupancy_type AS MarketingLocationOccupancyType
FROM cuand_loc_facet
LEFT OUTER JOIN I_MKT_MarketingArea AS _MKT_MarketingArea ON MarketingArea = _MKT_MarketingArea.MarketingArea  -- 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_LocationOccupancyType AS _MKT_LocationOccupancyType ON MarketingLocationOccupancyType = _MKT_LocationOccupancyType.MarketingLocationOccupancyType  -- association [0..1]
LEFT OUTER JOIN I_MKT_LocationOrigin AS _MKT_LocationOrigin ON MarketingLocationOrigin = _MKT_LocationOrigin.MarketingLocationOrigin  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _LongitudeUnitOfMeasure ON LongitudeUnit = _LongitudeUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _LatitudeUnitOfMeasure ON LatitudeUnit = _LatitudeUnitOfMeasure.UnitOfMeasure  -- association [0..1]
;