I_BPCustUnldgPtAddrDepdntInfo

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_BPCustUnldgPtAddrDepdntInfo.
-- 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: IBPCUSTUNLDGADDR

CREATE VIEW I_BPCustUnldgPtAddrDepdntInfo AS
SELECT
  BusinessPartnerCustomer.BusinessPartner AS BusinessPartner,
  cast ( '' as abap.char( 10 ) ) AS AddressID,
  CustomerUnloadingPoint.Customer AS Customer,
  CustomerUnloadingPoint.UnloadingPointName AS UnloadingPointName,
  CustomerUnloadingPoint.CustomerFactoryCalenderCode AS CustomerFactoryCalenderCode,
  CustomerUnloadingPoint.BPGoodsReceivingHoursCode AS BPGoodsReceivingHoursCode,
  CustomerUnloadingPoint.IsDfltBPUnloadingPoint AS IsDfltBPUnloadingPoint,
  CustomerUnloadingPoint.MondayMorningOpeningTime AS MondayMorningOpeningTime,
  CustomerUnloadingPoint.MondayMorningClosingTime AS MondayMorningClosingTime,
  CustomerUnloadingPoint.MondayAfternoonOpeningTime AS MondayAfternoonOpeningTime,
  CustomerUnloadingPoint.MondayAfternoonClosingTime AS MondayAfternoonClosingTime,
  CustomerUnloadingPoint.TuesdayMorningOpeningTime AS TuesdayMorningOpeningTime,
  CustomerUnloadingPoint.TuesdayMorningClosingTime AS TuesdayMorningClosingTime,
  CustomerUnloadingPoint.TuesdayAfternoonOpeningTime AS TuesdayAfternoonOpeningTime,
  CustomerUnloadingPoint.TuesdayAfternoonClosingTime AS TuesdayAfternoonClosingTime,
  CustomerUnloadingPoint.WednesdayMorningOpeningTime AS WednesdayMorningOpeningTime,
  CustomerUnloadingPoint.WednesdayMorningClosingTime AS WednesdayMorningClosingTime,
  CustomerUnloadingPoint.WednesdayAfternoonOpeningTime AS WednesdayAfternoonOpeningTime,
  CustomerUnloadingPoint.WednesdayAfternoonClosingTime AS WednesdayAfternoonClosingTime,
  CustomerUnloadingPoint.ThursdayMorningOpeningTime AS ThursdayMorningOpeningTime,
  CustomerUnloadingPoint.ThursdayMorningClosingTime AS ThursdayMorningClosingTime,
  CustomerUnloadingPoint.ThursdayAfternoonOpeningTime AS ThursdayAfternoonOpeningTime,
  CustomerUnloadingPoint.ThursdayAfternoonClosingTime AS ThursdayAfternoonClosingTime,
  CustomerUnloadingPoint.FridayMorningOpeningTime AS FridayMorningOpeningTime,
  CustomerUnloadingPoint.FridayMorningClosingTime AS FridayMorningClosingTime,
  CustomerUnloadingPoint.FridayAfternoonOpeningTime AS FridayAfternoonOpeningTime,
  CustomerUnloadingPoint.FridayAfternoonClosingTime AS FridayAfternoonClosingTime,
  CustomerUnloadingPoint.SaturdayMorningOpeningTime AS SaturdayMorningOpeningTime,
  CustomerUnloadingPoint.SaturdayMorningClosingTime AS SaturdayMorningClosingTime,
  CustomerUnloadingPoint.SaturdayAfternoonOpeningTime AS SaturdayAfternoonOpeningTime,
  CustomerUnloadingPoint.SaturdayAfternoonClosingTime AS SaturdayAfternoonClosingTime,
  CustomerUnloadingPoint.SundayMorningOpeningTime AS SundayMorningOpeningTime,
  CustomerUnloadingPoint.SundayMorningClosingTime AS SundayMorningClosingTime,
  CustomerUnloadingPoint.SundayAfternoonOpeningTime AS SundayAfternoonOpeningTime,
  CustomerUnloadingPoint.SundayAfternoonClosingTime AS SundayAfternoonClosingTime
INNER JOIN I_BusinessPartnerCustomer AS BusinessPartnerCustomer ON /* join condition not captured in parsed metadata */
INNER JOIN I_CustomerUnloadingPoint AS CustomerUnloadingPoint ON /* join condition not captured in parsed metadata */
INNER JOIN I_CustUnldgPtAddrDepdntInfo AS CustUnldgPtAddrDepdntInfo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BPCurrentDefaultAddress AS _DefaultAddress ON _DefaultAddress.BusinessPartner = BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON _BusinessPartner.BusinessPartner = BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
;