I_BPCustomerUnloadingPointProc

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_BPCustomerUnloadingPointProc.
-- 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_BPCustomerUnloadingPointProc AS
SELECT
  process_id AS MasterDataChangeProcess,
  process_step_no AS MDChgProcessStep,
  source_system AS MDChgProcessSrceSystem,
  source_id AS MDChgProcessSrceObject,
  ablad AS UnloadingPointName,
  assignment_id AS BPAssignmentID,
  knfak AS CustomerFactoryCalenderCode,
  wanid AS BPGoodsReceivingHoursCode,
  defab AS IsDfltBPUnloadingPoint,
  kunnr AS Customer,
  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,
  source_recency AS MDChgProcSrceLastChgdDateTime,
  source_modified AS MDChgProcessSourceModified,
  source_modification_blip AS MDChgProcessSourceModifBinary
FROM knva_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]
;