I_BPCustUnldgPtAddrDepdntTP

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_BPCustUnldgPtAddrDepdntTP.
-- 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: ICUSTADRUPTP

CREATE VIEW I_BPCustUnldgPtAddrDepdntTP AS
SELECT
  AddressID,
  _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  Customer,
  UnloadingPointName,
  Customer AS CustomerForEdit,
  AddressID AS AddressIDForEdit,
  UnloadingPointName AS UnloadingPointNameForEdit,
  _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartnerForEdit,
  _Customer._CustomerToBusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  CustomerFactoryCalenderCode,
  IsDfltBPUnloadingPoint,
  BPGoodsReceivingHoursCode,
  MondayMorningOpeningTime,
  MondayMorningClosingTime,
  MondayAfternoonOpeningTime,
  MondayAfternoonClosingTime,
  TuesdayMorningOpeningTime,
  TuesdayMorningClosingTime,
  TuesdayAfternoonOpeningTime,
  TuesdayAfternoonClosingTime,
  WednesdayMorningOpeningTime,
  WednesdayMorningClosingTime,
  WednesdayAfternoonOpeningTime,
  WednesdayAfternoonClosingTime,
  ThursdayMorningOpeningTime,
  ThursdayMorningClosingTime,
  ThursdayAfternoonOpeningTime,
  ThursdayAfternoonClosingTime,
  FridayMorningOpeningTime,
  FridayMorningClosingTime,
  FridayAfternoonOpeningTime,
  FridayAfternoonClosingTime,
  SaturdayMorningOpeningTime,
  SaturdayMorningClosingTime,
  SaturdayAfternoonOpeningTime,
  SaturdayAfternoonClosingTime,
  SundayMorningOpeningTime,
  SundayMorningClosingTime,
  SundayAfternoonOpeningTime,
  SundayAfternoonClosingTime,
  cast( ' ' as abap.sstring( 260 ) ) AS FormattedAddress
FROM I_CustUnldgPtAddrDepdntInfo
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON businesspartner = _BusinessPartner.BusinessPartner  -- association [1..1]
;