I_CustUnldgPtAddrDepdntInfo

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_CustUnldgPtAddrDepdntInfo.
-- 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: ICUSUNLPTADDEP

CREATE VIEW I_CustUnldgPtAddrDepdntInfo AS
SELECT
  kunnr AS Customer,
  adrnr AS AddressID,
  ablad AS UnloadingPointName,
  knfak AS CustomerFactoryCalenderCode,
  wanid AS BPGoodsReceivingHoursCode,
  defab AS IsDfltBPUnloadingPoint,
  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
FROM knva_addr
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1]
LEFT OUTER JOIN I_Address_2 AS _AddressDefaultRepresentation ON AddressID = _AddressDefaultRepresentation.AddressID AND _AddressDefaultRepresentation.AddressRepresentationCode = ' '  -- association [1..1]
;