I_OwnerAttributeGroup

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_OwnerAttributeGroup.
-- 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_OwnerAttributeGroup AS
SELECT
  oiu_do_oag.oag_id AS OwnerAttributeGroup,
  oiu_do_oag.eff_to_dt AS OwnrAttribGrpEffctvToDte,
  oiu_do_oag.eff_from_dt AS OwnrAttribGrpEffctvFrmDte,
  oiu_do_oag.oag_desc AS OwnerAttributeGroupDesc,
  oiu_do_oag.mfg_is_used AS MarketingFreeGroupIsUsed,
  oiu_do_oag.con_as_oil_fl AS MktgFreeGrpIsOilForCondensate,
  oiu_do_oag.ngl_as_gas_fl AS MktgFreeGrpIsGasForLiquids,
  oiu_do_oag.maint_wtr_sul_inj_fl AS MktgFreeGrpIsOtherUsed,
  oiu_do_oag.mfg_majpd_oil AS MarketingFreeGroupOil,
  oiu_do_oag.mfg_majpd_gas AS MarketingFreeGroupGas,
  oiu_do_oag.mfg_majpd_con AS MarketingFreeGroupCondensate,
  oiu_do_oag.mfg_majpd_ngl AS MktgFreeGrpNaturalGasLiquids,
  oiu_do_oag.mfg_majpd_wtr AS MarketingFreeGroupWater,
  oiu_do_oag.mfg_majpd_sul AS MarketingFreeGroupSulfur,
  oiu_do_oag.mfg_majpd_inj AS MarketingFreeGroupInjection,
  oiu_do_oag.last_user AS PRA_CreationUser,
  oiu_do_oag.last_timestamp AS PRA_CreationDateTime
FROM oiu_do_oag
LEFT OUTER JOIN I_MarketingFreeGroup AS _MarketingFreeGroupOil ON MarketingFreeGroupOil = _MarketingFreeGroupOil.MarketingFreeGroup  -- association [0..1]
LEFT OUTER JOIN I_MarketingFreeGroup AS _MarketingFreeGroupGas ON MarketingFreeGroupGas = _MarketingFreeGroupGas.MarketingFreeGroup  -- association [0..1]
LEFT OUTER JOIN I_MarketingFreeGroup AS _MarketingFreeGroupCondensate ON MarketingFreeGroupCondensate = _MarketingFreeGroupCondensate.MarketingFreeGroup  -- association [0..1]
LEFT OUTER JOIN I_MarketingFreeGroup AS _MktgFreeGrpNaturalGasLiquids ON MktgFreeGrpNaturalGasLiquids = _MktgFreeGrpNaturalGasLiquids.MarketingFreeGroup  -- association [0..1]
LEFT OUTER JOIN I_MarketingFreeGroup AS _MarketingFreeGroupWater ON MarketingFreeGroupWater = _MarketingFreeGroupWater.MarketingFreeGroup  -- association [0..1]
LEFT OUTER JOIN I_MarketingFreeGroup AS _MarketingFreeGroupSulfur ON MarketingFreeGroupSulfur = _MarketingFreeGroupSulfur.MarketingFreeGroup  -- association [0..1]
LEFT OUTER JOIN I_MarketingFreeGroup AS _MarketingFreeGroupInjection ON MarketingFreeGroupInjection = _MarketingFreeGroupInjection.MarketingFreeGroup  -- association [0..1]
;