C_BR_McgnEngyExpryOPg

DDL: C_BR_MCGNENGYEXPRYOPG SQL: CMGEXPENGYOPG Type: view CONSUMPTION
24 Fields 1 Data Sources

Expired Energy Object page

C_BR_McgnEngyExpryOPg is a Consumption CDS View (Cube) that provides data about "Expired Energy Object page" in SAP S/4HANA. It reads from 1 data source (I_BR_McgnEngyExpryCube) and exposes 24 fields with key fields MicrogenBusinessPartner, MicrogenContractAccount, MicrogenContract, MicrogenInstallation, MicrogenBillPeriodValue.

Data Sources (1)

SourceAliasJoin Type
I_BR_McgnEngyExpryCube ExpiryEnergy from

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CMGEXPENGYOPG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
UI.headerInfo.typeName Energy Quantity view
UI.headerInfo.typeNamePlural Energy Quantities view
EndUserText.label Expired Energy Object page view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY MicrogenBusinessPartner MicrogenBusinessPartner Issuing Authority
KEY MicrogenContractAccount MicrogenContractAccount Contract Acct
KEY MicrogenContract MicrogenContract
KEY MicrogenInstallation MicrogenInstallation
KEY MicrogenBillPeriodValue MicrogenBillPeriodValue
KEY MicrogenTOU MicrogenTOU
KEY MicrogenTransactionNumber MicrogenTransactionNumber
KEY MicrogenContractRef MicrogenContractRef
KEY MicrogenAllocationDate MicrogenAllocationDate Credits Allocation Date
MicrogenActivityType MicrogenActivityType
MicrogenEnergyCreditsQuantity
MicrogenEnergyCreditsUnit MicrogenEnergyCreditsUnit
MicrogenExpiryCreditType MicrogenExpiryCreditType
MicrogenExpiryCreditTypeDesc
MicrogenTOUText
MicrogenBusinessPartnerName _BusinessPartner BusinessPartnerName Extracted Customer Name
_UtilitiesInstallation _UtilitiesInstallation
_BusinessPartner _BusinessPartner
_ContractAccountHeader _ContractAccountHeader
_MicrogenGlobalTOU _MicrogenGlobalTOU
_MicrogenActiveGenCon _MicrogenActiveGenCon
_UnitOfMeasure _UnitOfMeasure
_MicrogenActType _MicrogenActType
_MicrogenExpEnergyType _MicrogenExpEnergyType

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_McgnEngyExpryOPg.
-- 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: CMGEXPENGYOPG

CREATE VIEW C_BR_McgnEngyExpryOPg AS
SELECT
  MicrogenBusinessPartner,
  MicrogenContractAccount,
  MicrogenContract,
  MicrogenInstallation,
  MicrogenBillPeriodValue,
  MicrogenTOU,
  MicrogenTransactionNumber,
  MicrogenContractRef,
  MicrogenAllocationDate,
  MicrogenActivityType,
  cast( MicrogenEnergyCreditsQuantity as e_mg_br_energyquanfordsp_vdm ) AS MicrogenEnergyCreditsQuantity,
  MicrogenEnergyCreditsUnit,
  MicrogenExpiryCreditType,
  _MicrogenExpEnergyType._ExpEnergyTypeText[1: Language = $session.system_language].MicrogenExpiryCreditTypeDesc AS MicrogenExpiryCreditTypeDesc,
  _MicrogenGlobalTOU._MicrogenTOUText[1: Language = $session.system_language].MicrogenTOUText AS MicrogenTOUText,
  _BusinessPartner.BusinessPartnerName AS MicrogenBusinessPartnerName
FROM I_BR_McgnEngyExpryCube AS ExpiryEnergy
;

Learn More