I_OIL_BusinessTypeVH

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_BusinessTypeVH.
-- 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_BusinessTypeVH AS
SELECT
  rnbt AS RetailNetworkBusinessType,
  kalvg AS BusinessTypeMarginProcedure,
  appbk AS BizTypeIsBulkBusinessRelated,
  appmc AS BizTypeIsMerchandisingBusReltd,
  appcw AS BusinessTypeIsCarWashRelated,
  appnn AS BusinessTypeIsNotBusinessReltd,
  iconname AS BusinessTypeIconValue,
  rfcdest_rem AS RtlSystRFCDestWithRemoteUsrVal,
  rfcdest AS RetailSystemRFCDestinationVal,
  url AS StoreWorkbenchWebGateURLValue,
  use_hr_retail AS RetailNetworkIsLogon,
  orgstr_check AS OrganizationStructureCheck,
  ext_pric_tool AS ExternalPriceOptimizerIsActive
FROM oirarnbt
LEFT OUTER JOIN I_OIL_BusinessTypeText AS _Text ON _Text.RetailNetworkBusinessType = RetailNetworkBusinessType  -- association [0..*]
LEFT OUTER JOIN I_OIL_BusinessTypeMargProcedVH AS _BusinessTypeMargProced ON _BusinessTypeMargProced.BusinessTypeMarginProcedure = BusinessTypeMarginProcedure  -- association [0..1]
LEFT OUTER JOIN I_MaintMblApplRFCDestinationVH AS _RFCDestinationRemote ON _RFCDestinationRemote.MaintMblApplRFCDestination = RtlSystRFCDestWithRemoteUsrVal  -- association [0..1]
LEFT OUTER JOIN I_MaintMblApplRFCDestinationVH AS _RFCDestination ON _RFCDestination.MaintMblApplRFCDestination = RetailSystemRFCDestinationVal  -- association [0..1]
LEFT OUTER JOIN I_OIL_OrgStructureCheckVH AS _OrgStructureCheckVH ON _OrgStructureCheckVH.OrganizationStructureCheck = OrganizationStructureCheck  -- association [1..1]
;