I_MKT_Location

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_Location.
-- 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_LOCATION

CREATE VIEW I_MKT_Location AS
SELECT
  cuand_loc_root.db_key AS MarketingLocationUUID,
  cuand_loc_root.type AS MarketingLocationType,
  cuand_loc_root.company_name AS CompanyName,
  cuand_loc_root.location_name AS MarketingLocationName,
  cuand_loc_root.country AS Country,
  cuand_loc_root.region AS AddressRegion,
  cuand_loc_root.city AS CityName,
  cuand_loc_root.postcode AS PostalCode,
  cuand_loc_root.street AS AddressStreetName,
  cuand_loc_root.house_num AS AddressHouseNumber,
  cuand_loc_root.building AS Building,
  cuand_loc_root.floor AS Floor,
  cuand_loc_root.room_no AS RoomNumber,
  cuand_loc_root.telnr_long AS PhoneNumber,
  cuand_loc_root.faxnr_long AS FaxNumber,
  cuand_loc_root.smtp_addr AS EmailAddress,
  cuand_loc_root.web_uri AS WebsiteURL,
  cuand_loc_root.obsolete AS IsObsolete,
  cuand_loc_root.latitude AS Latitude,
  cuand_loc_root.longitude AS Longitude,
  cast('DEG' as msehi) AS LatitudeUnit,
  cast('DEG' as msehi) AS LongitudeUnit,
  cuand_loc_root.crea_date_time AS CreationUTCDateTime,
  cuand_loc_root.crea_uname AS CreatedByUser,
  cuand_loc_root.lchg_date_time AS LastChangeUTCDateTime,
  cuand_loc_root.lchg_uname AS LastChangeByUser,
  cast( cuand_loc_root.mkt_area_id as cuan_cds_mkt_area ) AS MarketingArea,
  cuand_loc_root.valid_from_date AS ValidityStartDate,
  cuand_loc_root.valid_to_date AS ValidityEndDate,
  cuand_loc_root.srid AS SpatialReferenceSystem,
  cuand_loc_root.image_uri AS ImageURL,
  cuand_loc_root.mall_name AS MarketingLocationMallName,
  cuand_loc_root.occupancy_type AS MarketingLocationOccupancyType
FROM cuand_loc_root
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]
;