CIC_RetailSiteData

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 CIC_RetailSiteData.
-- 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 CIC_RetailSiteData AS
SELECT
  locnr AS SiteCustomer,
  eroed AS SiteOpeningDate,
  schld AS SiteClosingDate,
  moab1 AS MondayMorningOpeningTime,
  mobi1 AS MondayMorningClosingTime,
  moab2 AS MondayAfternoonOpeningTime,
  mobi2 AS MondayAfternoonClosingTime,
  diab1 AS TuesdayMorningOpeningTime,
  dibi1 AS TuesdayMorningClosingTime,
  diab2 AS TuesdayAfternoonOpeningTime,
  dibi2 AS TuesdayAfternoonClosingTime,
  miab1 AS WednesdayMorningOpeningTime,
  mibi1 AS WednesdayMorningClosingTime,
  miab2 AS WednesdayAfternoonOpeningTime,
  mibi2 AS WednesdayAfternoonClosingTime,
  doab1 AS ThursdayMorningOpeningTime,
  dobi1 AS ThursdayMorningClosingTime,
  doab2 AS ThursdayAfternoonOpeningTime,
  dobi2 AS ThursdayAfternoonClosingTime,
  frab1 AS FridayMorningOpeningTime,
  frbi1 AS FridayMorningClosingTime,
  frab2 AS FridayAfternoonOpeningTime,
  frbi2 AS FridayAfternoonClosingTime,
  saab1 AS SaturdayMorningOpeningTime,
  sabi1 AS SaturdayMorningClosingTime,
  saab2 AS SaturdayAfternoonOpeningTime,
  sabi2 AS SaturdayAfternoonClosingTime,
  soab1 AS SundayMorningOpeningTime,
  sobi1 AS SundayMorningClosingTime,
  soab2 AS SundayAfternoonOpeningTime,
  sobi2 AS SundayAfternoonClosingTime,
  wanid AS SiteGoodsReceivingHoursCode,
  spdab AS SiteBlockingFromDate,
  spdbi AS SiteBlockingToDate,
  betrp AS SiteProfile
FROM wrf1
;