I_BPCustAddrDepdntUnldgPtsProc

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_BPCustAddrDepdntUnldgPtsProc.
-- 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 I_BPCustAddrDepdntUnldgPtsProc AS
SELECT
  process_id AS MasterDataChangeProcess,
  process_step_no AS MDChgProcessStep,
  source_system AS MDChgProcessSrceSystem,
  source_id AS MDChgProcessSrceObject,
  source_addrnumber AS AddressNumber,
  '000000000002' AS BPAssignmentID,
  ablad AS UnloadingPointName,
  kunnr AS Customer,
  knfak AS CustomerFactoryCalenderCode,
  wanid AS BPGoodsReceivingHoursCode,
  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,
  defab AS IsDfltBPUnloadingPoint,
  source_modified AS MDChgProcessSourceModified,
  source_modification_blip AS MDChgProcessSourceModifBinary,
  source_recency AS MDChgProcSrceLastChgdDateTime
FROM knva_addr_prc
LEFT OUTER JOIN I_BPCustomerProcess AS _Customer ON MasterDataChangeProcess = _Customer.MasterDataChangeProcess AND MDChgProcessStep = _Customer.MDChgProcessStep AND MDChgProcessSrceSystem = _Customer.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Customer.MDChgProcessSrceObject AND BPAssignmentID = _Customer.BPAssignmentID  -- association [0..1]
LEFT OUTER JOIN I_BPProtectedAddress AS _BPProtectedAddress ON MDChgProcessSrceObject = _BPProtectedAddress.BusinessPartner AND AddressNumber = _BPProtectedAddress.AddressID  -- association [0..1]
;