I_BR_McgnEngyCnsmpnCube

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_BR_McgnEngyCnsmpnCube.
-- 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: IMGENGYCNSMPN

CREATE VIEW I_BR_McgnEngyCnsmpnCube AS
SELECT
  EnergyAccount.MicrogenBusinessPartner AS MicrogenBusinessPartner,
  EnergyAccount.MicrogenContractAccount AS MicrogenContractAccount,
  EnergyAccount.MicrogenContract AS MicrogenContract,
  EnergyAccount.MicrogenInstallation AS MicrogenInstallation,
  EnergyAccount.MicrogenBillPeriodValue AS MicrogenBillPeriodValue,
  EnergyAccount.MicrogenTOU AS MicrogenTOU,
  EnergyAccount.MicrogenEnergyType AS MicrogenEnergyType,
  EnergyAccount.MicrogenAllocationDate AS MicrogenAllocationDate,
  EnergyAccount. MicrogenEnergyCreditsQuantity AS MicrogenEnergyCreditsQuantity,
  EnergyAccount.MicrogenEnergyCreditsUnit AS MicrogenEnergyCreditsUnit,
  EnergyAccount.MicrogenBillPeriodStartDate AS MicrogenBillPeriodStartDate,
  EnergyAccount.MicrogenBillPeriodEndDate AS MicrogenBillPeriodEndDate,
  EnergyAccount.MicrogenTransactionNumber AS MicrogenTransactionNumber,
  cast(concat(substring(_MonthName.CalendarMonthName, 1, 3), concat('-', substring(EnergyAccount.MicrogenBillPeriodValue, 3, 2))) as e_mg_br_monthyear_vdm) AS MicrogenMonthYearForDspVal,
  cast(replace( EnergyAccount.MicrogenBillPeriodValue, '/', '') as e_mg_br_yearmonthvalue_vdm) AS MicrogenYearMonthValue,
  MicrogenActiveGenCon.MicrogenContractType AS MicrogenContractType,
  EnergyAccount._BusinessPartner AS _BusinessPartner,
  EnergyAccount._ContractAccountHeader AS _ContractAccountHeader,
  EnergyAccount._UtilitiesInstallation AS _UtilitiesInstallation,
  EnergyAccount._MicrogenGlobalTOU AS _MicrogenGlobalTOU,
  EnergyAccount._UtilitiesContract AS _UtilitiesContract,
  EnergyAccount._MicrogenEnergyType AS _MicrogenEnergyType,
  EnergyAccount._UnitOfMeasure AS _UnitOfMeasure,
  EnergyAccount._BillingDocumentPeriod AS _BillingDocumentPeriod,
  MicrogenActiveGenCon._MicrogenContractType AS _MicrogenContractType
FROM I_BR_McgnEngyAccountCube AS EnergyAccount
INNER JOIN I_BR_McgnActvGnrtrCnsmr AS MicrogenActiveGenCon ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarMonthName AS _MonthName ON _MonthName.CalendarMonth = EnergyAccount.MicrogenBillPeriodMonth  -- association [0..1]
;