C_BR_McgnOvPg

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 C_BR_McgnOvPg.
-- 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.
-- SQL view name: CMGBROVP

CREATE VIEW C_BR_McgnOvPg AS
SELECT
  MicrogenBusinessPartner,
  MicrogenContractAccount,
  MicrogenContract,
  MicrogenInstallation,
  MicrogenBillPeriodValue,
  MicrogenTOU,
  MicrogenEnergyType,
  MicrogenAllocationDate,
  MicrogenEnergyCreditsQuantity,
  MicrogenEnergyCreditsUnit,
  MicrogenBillPeriodStartDate,
  MicrogenBillPeriodEndDate
FROM I_BR_McgnEngyAccountCube AS MicrogenEnergy
LEFT OUTER JOIN C_BR_McgnEngyAccount AS _McgnEngyAccount ON MicrogenBusinessPartner = _McgnEngyAccount.MicrogenBusinessPartner AND MicrogenContractAccount = _McgnEngyAccount.MicrogenContractAccount AND MicrogenContract = _McgnEngyAccount.MicrogenContract AND MicrogenInstallation = _McgnEngyAccount.MicrogenInstallation AND MicrogenTOU = _McgnEngyAccount.MicrogenTOU AND MicrogenBillPeriodValue = _McgnEngyAccount.MicrogenBillPeriodValue  -- association [0..*]
LEFT OUTER JOIN C_BR_McgnActvGnrtrCnsmr AS _McgnActvGenrtrConsmr ON MicrogenContract = _McgnActvGenrtrConsmr.MicrogenContract AND MicrogenBillPeriodValue = _McgnActvGenrtrConsmr.MicrogenBillPeriodValue  -- association [0..*]
LEFT OUTER JOIN C_BR_McgnEngyExpry AS _McgnEngyExpry ON MicrogenBusinessPartner = _McgnEngyExpry.MicrogenBusinessPartner AND MicrogenContractAccount = _McgnEngyExpry.MicrogenContractAccount AND MicrogenContract = _McgnEngyExpry.MicrogenContract AND MicrogenInstallation = _McgnEngyExpry.MicrogenInstallation AND MicrogenTOU = _McgnEngyExpry.MicrogenTOU  -- association [0..*]
LEFT OUTER JOIN C_BR_McgnMaxGnrtr AS _McgnMaxGnrtr ON MicrogenBusinessPartner = _McgnMaxGnrtr.MicrogenBusinessPartner AND MicrogenContractAccount = _McgnMaxGnrtr.MicrogenContractAccount AND MicrogenContract = _McgnMaxGnrtr.MicrogenContract AND MicrogenInstallation = _McgnMaxGnrtr.MicrogenInstallation AND MicrogenBillPeriodValue = _McgnMaxGnrtr.MicrogenBillPeriodValue  -- association [0..*]
LEFT OUTER JOIN C_BR_McgnEngyCnsmpn AS _McgnEngyCnsmpn ON MicrogenBusinessPartner = _McgnEngyCnsmpn.MicrogenBusinessPartner AND MicrogenContractAccount = _McgnEngyCnsmpn.MicrogenContractAccount AND MicrogenContract = _McgnEngyCnsmpn.MicrogenContract AND MicrogenInstallation = _McgnEngyCnsmpn.MicrogenInstallation AND MicrogenTOU = _McgnEngyCnsmpn .MicrogenTOU  -- association [0..*]
;