I_BR_MCGNENGYACCOUNTCUBE
Energy Account of Gntr and Cnsmr
I_BR_MCGNENGYACCOUNTCUBE is a CDS View in S/4HANA. Energy Account of Gntr and Cnsmr. It contains 20 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_BR_McgnEngyAccount | view | from | CONSUMPTION | Energy Account of Gntr and Cnsmr |
| C_BR_McgnEngyAcctOPg | view | from | CONSUMPTION | Energy Account Object page |
| C_BR_McgnOvPg | view | from | CONSUMPTION | Overview page |
| I_BR_McgnEngyCnsmpnCube | view | from | COMPOSITE | Energy Cnsmp for Genrtr n Consmr - Cube |
| I_BR_McgnMaxGnrtrCube | view | from | COMPOSITE | Top Energy Generator |
Fields (20)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | MicrogenBillPeriodValue | MicrogenBillPeriodValue | 1 |
| KEY | MicrogenBusinessPartner | MicrogenBusinessPartner | 1 |
| KEY | MicrogenContract | MicrogenContract | 1 |
| KEY | MicrogenContractAccount | MicrogenContractAccount | 1 |
| KEY | MicrogenEnergyType | MicrogenEnergyType | 1 |
| KEY | MicrogenInstallation | MicrogenInstallation | 1 |
| KEY | MicrogenTOU | MicrogenTOU | 1 |
| _BillingDocumentPeriod | _BillingDocumentPeriod | 1 | |
| _BusinessPartner | _BusinessPartner | 1 | |
| _ContractAccountHeader | _ContractAccountHeader | 1 | |
| _MicrogenEnergyType | _MicrogenEnergyType | 1 | |
| _MicrogenGlobalTOU | _MicrogenGlobalTOU | 1 | |
| _UnitOfMeasure | _UnitOfMeasure | 1 | |
| _UtilitiesContract | _UtilitiesContract | 1 | |
| _UtilitiesInstallation | _UtilitiesInstallation | 1 | |
| MicrogenAllocationDate | MicrogenAllocationDate | 1 | |
| MicrogenBillPeriodEndDate | MicrogenBillPeriodEndDate | 1 | |
| MicrogenBillPeriodStartDate | MicrogenBillPeriodStartDate | 1 | |
| MicrogenEnergyCreditsUnit | MicrogenEnergyCreditsUnit | 1 | |
| MicrogenTransactionNumber | MicrogenTransactionNumber | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Energy Account of Gntr and Cnsmr
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BR_MCGNENGYACCOUNTCUBE (
MICROGENBILLPERIODVALUE,
MICROGENBUSINESSPARTNER,
MICROGENCONTRACT,
MICROGENCONTRACTACCOUNT,
MICROGENENERGYTYPE,
MICROGENINSTALLATION,
MICROGENTOU,
_BILLINGDOCUMENTPERIOD,
_BUSINESSPARTNER,
_CONTRACTACCOUNTHEADER,
_MICROGENENERGYTYPE,
_MICROGENGLOBALTOU,
_UNITOFMEASURE,
_UTILITIESCONTRACT,
_UTILITIESINSTALLATION,
MICROGENALLOCATIONDATE,
MICROGENBILLPERIODENDDATE,
MICROGENBILLPERIODSTARTDATE,
MICROGENENERGYCREDITSUNIT,
MICROGENTRANSACTIONNUMBER,
PRIMARY KEY (MICROGENBILLPERIODVALUE, MICROGENBUSINESSPARTNER, MICROGENCONTRACT, MICROGENCONTRACTACCOUNT, MICROGENENERGYTYPE, MICROGENINSTALLATION, MICROGENTOU)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA