I_OIL_LocSiteControlParam

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_OIL_LocSiteControlParam.
-- 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_OIL_LocSiteControlParam AS
SELECT
  pblnr AS BusinessLocationIdentifier,
  rnbt AS RetailNetworkBusinessType,
  parfn AS ProcessBusinessPartnerRole,
  vkfcal AS SiteSalesCalendar,
  vkfsid AS SalesHourSet,
  w11bos AS MondayMorningOpeningTime,
  w11eos AS MondayMorningClosingTime,
  w12bos AS MondayAfternoonOpeningTime,
  w12eos AS MondayAfternoonClosingTime,
  w21bos AS TuesdayMorningOpeningTime,
  w21eos AS TuesdayMorningClosingTime,
  w22bos AS TuesdayAfternoonOpeningTime,
  w22eos AS TuesdayAfternoonClosingTime,
  w31bos AS WednesdayMorningOpeningTime,
  w31eos AS WednesdayMorningClosingTime,
  w32bos AS WednesdayAfternoonOpeningTime,
  w32eos AS WednesdayAfternoonClosingTime,
  w41bos AS ThursdayMorningOpeningTime,
  w41eos AS ThursdayMorningClosingTime,
  w42bos AS ThursdayAfternoonOpeningTime,
  w42eos AS ThursdayAfternoonClosingTime,
  w51bos AS FridayMorningOpeningTime,
  w51eos AS FridayMorningClosingTime,
  w52bos AS FridayAfternoonOpeningTime,
  w52eos AS FridayAfternoonClosingTime,
  w61bos AS SaturdayMorningOpeningTime,
  w61eos AS SaturdayMorningClosingTime,
  w62bos AS SaturdayAfternoonOpeningTime,
  w62eos AS SaturdayAfternoonClosingTime,
  w71bos AS SundayMorningOpeningTime,
  w71eos AS SundayMorningClosingTime,
  w72bos AS SundayAfternoonOpeningTime,
  w72eos AS SundayAfternoonClosingTime,
  w81bos AS HolidayMorningOpeningTime,
  w81eos AS HolidayMorningClosingTime,
  w82bos AS HolidayAfternoonOpeningTime,
  w82eos AS HolidayAfternoonClosingTime,
  erdat AS CreationDate,
  erzeit AS CreationTime,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aezeit AS LastChangeTime,
  aenam AS LastChangedByUser,
  bloind AS EntityIsBlocked,
  delind AS EntityIsMarkedForDeletion,
  blosh AS SalesHoursAreBlocked,
  blolt AS UseOfLeadTimeEntriesIsBlocked,
  soegrp AS SalesOrderEntryDefaultGroup,
  tpiprd AS DefaultPartnerRole,
  conwk AS DeliveryCsgnmtStockRcvgPlant,
  conlg AS DeliveryCsgnmtStockRcvgStorLoc,
  rcblk AS AutomReplenishmentIsBlocked,
  doblk AS DispatchOptimizationIsBlocked
FROM oiiscpbl
LEFT OUTER JOIN I_OIL_BusinessLocationBasic AS _BusinessLocation ON _BusinessLocation.BusinessLocationIdentifier = BusinessLocationIdentifier  -- association [1..1]
LEFT OUTER JOIN I_OIL_BusinessTypeVH AS _BusinessTypeVH ON _BusinessTypeVH.RetailNetworkBusinessType = RetailNetworkBusinessType  -- association [0..1]
LEFT OUTER JOIN I_OIL_BusinessPartnerRoleVH AS _BusinessPartnerRoleVH ON _BusinessPartnerRoleVH.MktgRtlNtwkBusinessPartnerRole = ProcessBusinessPartnerRole  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON _FactoryCalendar.FactoryCalendar = SiteSalesCalendar  -- association [0..1]
LEFT OUTER JOIN I_OIL_SteCtrlParamSlsHrSetVH AS _SteCtrlParamSlsHrSetVH ON _SteCtrlParamSlsHrSetVH.SalesHourSet = SalesHourSet  -- association [0..1]
LEFT OUTER JOIN I_OIL_SlsOrdEntryDfltGroupVH AS _SlsOrdEntryDfltGroupVH ON _SlsOrdEntryDfltGroupVH.SalesOrderEntryDefaultGroup = SalesOrderEntryDefaultGroup  -- association [0..1]
LEFT OUTER JOIN I_OIL_BusinessPartnerRoleVH AS _DefaultPartnerRoleVH ON _DefaultPartnerRoleVH.MktgRtlNtwkBusinessPartnerRole = DefaultPartnerRole  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = DeliveryCsgnmtStockRcvgPlant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON _StorageLocation.Plant = DeliveryCsgnmtStockRcvgPlant AND _StorageLocation.StorageLocation = DeliveryCsgnmtStockRcvgStorLoc  -- association [0..1]
;