What is I_AvgDailyBalKeyFigCube in SAP S/4HANA?

I_AvgDailyBalKeyFigCube is a composite CDS view in SAP S/4HANA. ADB KFC - Cube It contains 0 fields.

Which tables does I_AvgDailyBalKeyFigCube read from?

I_AvgDailyBalKeyFigCube reads data from: P_AvgDailyBalKeyFig.

What VDM layer is I_AvgDailyBalKeyFigCube?

I_AvgDailyBalKeyFigCube is classified as a Composite view that combines data from multiple basic views.

I_AvgDailyBalKeyFigCube

DDL: I_AVGDAILYBALKEYFIGCUBE SQL: IADBKFCUBE Type: view COMPOSITE

1 Data Sources 94 Associations

ADB KFC - Cube

I_AvgDailyBalKeyFigCube (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_AvgDailyBalKeyFigCube is a Composite CDS View (Cube) that provides data about "ADB KFC - Cube" in SAP S/4HANA. It reads from 1 data source (P_AvgDailyBalKeyFig). It has 94 associations to related views.

SAP Help Documentation

Category	CDS Views for Accounting Enhancements for Banking
Status	Released

Purpose
This CDS view provides the average daily balances and spot balances of various dimensions of the journal entry including the most important business entities, such as the G/L account, company code, cost center, or profit center. Other attributes and hierarchies can be reached via associations. The names of master data or configuration data are included. This CDS view provides the prerequisites for answering the following business questions: What are the ADB and spot balances for a specific time frame? What are the ADB and spot balances of a cost center for a specific time frame? What are the ADB and spot balances within the G/L account hierarchy? For a list of the authorization objects and fields for which display access is needed, see Authorizations in Analytics for Universal Journal . These authorization objects are edited using transaction PFCG .

Structure
Business Objects This view relates to the Journal Entry business object. Main Parameters and Filters of the CDS View The main parameters are as follows: P_KeyDate used to limit the reporting time frame beginning from the start of the year P_CreationDate used to compare the creation date of the posting P_CreationTime used to compare the creation time of the posting Measures and Attributes Some important measures and attributes are the following key figures: Key Figures Currency MonthToDateAverageDailyBalance The key figure is available in the following currencies: Transaction currency Company code currency Global currency Free-defined currency 1 Free-defined currency 2 Free-defined currency 3 Free-defined currency 4 Free-defined currency 5 Free-defined currency 6 Free-defined currency 7 Free-defined currency 8 QuarterToDateAverageDailyBalance YearToDateAverageDailyBalance PriorDayBalance CurrentDayActivity PriorMonthBalance CurrentMonthActivity YearToDateBalance MonthToDateAverageActivity QuarterToDateAverageActivity

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Accounting and Financial Close
Application Component	FI-GL-GL-ADB
Capabilities	Data Provider for Analytical Queries
Package	Accounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
P_AvgDailyBalKeyFig	P_AvgDailyBalKeyFig	from

Parameters (3)

Name	Type	Default
P_ReportingDate	gle_dte_adb_keydate
P_CreationTime	gle_dte_adb_creation_time
P_CreationDate	gle_dte_adb_creation_date

Associations (94)

Cardinality	Target	Alias	Condition
[1..1]	E_JournalEntryItem	_Extension	`$projection.SourceLedger = _Extension.SourceLedger and $projection.CompanyCode = _Extension.CompanyCode and $projection.FiscalYear = _Extension.FiscalYear and $projection.AccountingDocument = _Extension.AccountingDocument and $projection.LedgerGLLineItem = _Extension.LedgerGLLineItem`
[1..1]	I_JournalEntry	_JournalEntry	`$projection.CompanyCode = _JournalEntry.CompanyCode and $projection.FiscalYear = _JournalEntry.FiscalYear and $projection.AccountingDocument = _JournalEntry.AccountingDocument`
[1..1]	I_CompanyCode	_CompanyCode	`$projection.CompanyCode = _CompanyCode.CompanyCode`
[0..1]	I_CompanyCode	_CompanyCodeText	`$projection.CompanyCode = _CompanyCodeText.CompanyCode`
[1..1]	I_FiscalYearVariant	_FiscalYearVariant	`$projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant`
[0..1]	I_FiscalYearForCompanyCode	_FiscalYear	`$projection.FiscalYear = _FiscalYear.FiscalYear and $projection.CompanyCode = _FiscalYear.CompanyCode`
[0..1]	I_FiscalYearForCompanyCode	_LedgerFiscalYear	`$projection.LedgerFiscalYear = _LedgerFiscalYear.FiscalYear and $projection.CompanyCode = _LedgerFiscalYear.CompanyCode`
[0..1]	I_FiscalYearPeriodForCmpnyCode	_FiscalPeriod	`$projection.LedgerFiscalYear = _FiscalPeriod.FiscalYear and $projection.FiscalPeriod = _FiscalPeriod.FiscalPeriod and $projection.CompanyCode = _FiscalPeriod.CompanyCode`
[0..1]	I_FiscalCalYearPeriodForCoCode	_FiscalYearPeriod	`$projection.FiscalYearPeriod = _FiscalYearPeriod.FiscalYearPeriod and $projection.CompanyCode = _FiscalYearPeriod.CompanyCode`
[0..1]	I_FiscalYearForVariant	_LedgerFiscalYearForVariant	`$projection.LedgerFiscalYear = _LedgerFiscalYearForVariant.FiscalYear and $projection.FiscalYearVariant = _LedgerFiscalYearForVariant.FiscalYearVariant`
[0..1]	I_FiscalPeriodForVariant	_FiscalPeriodForVariant	`$projection.LedgerFiscalYear = _FiscalPeriodForVariant.FiscalYear and $projection.FiscalPeriod = _FiscalPeriodForVariant.FiscalPeriod and $projection.FiscalYearVariant = _FiscalPeriodForVariant.FiscalYearVariant`
[0..1]	I_FiscalYearPeriodForVariant	_FiscalYearPeriodForVariant	`$projection.FiscalYearPeriod = _FiscalYearPeriodForVariant.FiscalYearPeriod and $projection.FiscalYearVariant = _FiscalYearPeriodForVariant.FiscalYearVariant`
[0..1]	I_FiscalCalendarDate	_FiscalCalendarDate	`$projection.PostingDate = _FiscalCalendarDate.CalendarDate and $projection.FiscalYearVariant = _FiscalCalendarDate.FiscalYearVariant`
[0..1]	I_ControllingArea	_ControllingArea	`$projection.ControllingArea = _ControllingArea.ControllingArea`
[0..1]	I_ControllingArea	_ControllingAreaText	`$projection.ControllingArea = _ControllingAreaText.ControllingArea`
[0..1]	I_Currency	_BalanceTransactionCurrency	`$projection.BalanceTransactionCurrency = _BalanceTransactionCurrency.Currency`
[1..1]	I_Currency	_CompanyCodeCurrency	`$projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency`
[0..1]	I_Currency	_GlobalCurrency	`$projection.GlobalCurrency = _GlobalCurrency.Currency`
[0..1]	I_Currency	_FreeDefinedCurrency1	`$projection.FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency`
[0..1]	I_Currency	_FreeDefinedCurrency2	`$projection.FreeDefinedCurrency2 = _FreeDefinedCurrency2.Currency`
[0..1]	I_Currency	_FreeDefinedCurrency3	`$projection.FreeDefinedCurrency3 = _FreeDefinedCurrency3.Currency`
[0..1]	I_Currency	_FreeDefinedCurrency4	`$projection.FreeDefinedCurrency4 = _FreeDefinedCurrency4.Currency`
[0..1]	I_Currency	_FreeDefinedCurrency5	`$projection.FreeDefinedCurrency5 = _FreeDefinedCurrency5.Currency`
[0..1]	I_Currency	_FreeDefinedCurrency6	`$projection.FreeDefinedCurrency6 = _FreeDefinedCurrency6.Currency`
[0..1]	I_Currency	_FreeDefinedCurrency7	`$projection.FreeDefinedCurrency7 = _FreeDefinedCurrency7.Currency`
[0..1]	I_Currency	_FreeDefinedCurrency8	`$projection.FreeDefinedCurrency8 = _FreeDefinedCurrency8.Currency`
[0..1]	I_UnitOfMeasure	_BaseUnit	`$projection.BaseUnit = _BaseUnit.UnitOfMeasure`
[0..1]	I_UnitOfMeasure	_CostSourceUnit	`$projection.CostSourceUnit = _CostSourceUnit.UnitOfMeasure`
[0..1]	I_Segment	_Segment	`$projection.Segment = _Segment.Segment`
[0..*]	I_SegmentText	_SegmentText	`$projection.Segment = _SegmentText.Segment`
[0..*]	I_ProfitCenter	_ProfitCenter	`$projection.ControllingArea = _ProfitCenter.ControllingArea and $projection.ProfitCenter = _ProfitCenter.ProfitCenter`
[0..*]	I_ProfitCenterText	_ProfitCenterText	`$projection.ControllingArea = _ProfitCenterText.ControllingArea and $projection.ProfitCenter = _ProfitCenterText.ProfitCenter`
[0..1]	I_ProfitCenter	_CurrentProfitCenter	`$projection.ControllingArea = _CurrentProfitCenter.ControllingArea and $projection.ProfitCenter = _CurrentProfitCenter.ProfitCenter and _CurrentProfitCenter.ValidityStartDate <= $session.system_date and _CurrentProfitCenter.ValidityEndDate >= $session.system_date`
[0..*]	I_CostCenter	_CostCenter	`$projection.ControllingArea = _CostCenter.ControllingArea and $projection.CostCenter = _CostCenter.CostCenter`
[0..*]	I_CostCenterText	_CostCenterText	`$projection.ControllingArea = _CostCenterText.ControllingArea and $projection.CostCenter = _CostCenterText.CostCenter`
[0..1]	I_CostCenter	_CurrentCostCenter	`$projection.ControllingArea = _CurrentCostCenter.ControllingArea and $projection.CostCenter = _CurrentCostCenter.CostCenter and _CurrentCostCenter.ValidityStartDate <= $session.system_date and _CurrentCostCenter.ValidityEndDate >= $session.system_date`
[0..1]	I_WBSElementBasicData	_WBSElementBasicData	`$projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID`
[0..1]	I_WBSElementBasicData	_WBSElementBasicDataText	`$projection.WBSElementInternalID = _WBSElementBasicDataText.WBSElementInternalID`
[0..1]	I_BusinessArea	_BusinessArea	`$projection.BusinessArea = _BusinessArea.BusinessArea`
[0..*]	I_BusinessAreaText	_BusinessAreaText	`$projection.BusinessArea = _BusinessAreaText.BusinessArea`
[0..1]	I_FunctionalArea	_FunctionalArea	`$projection.FunctionalArea = _FunctionalArea.FunctionalArea`
[0..*]	I_FunctionalAreaText	_FunctionalAreaText	`$projection.FunctionalArea = _FunctionalAreaText.FunctionalArea`
[0..1]	I_GLAccountInChartOfAccounts	_GLAccountInChartOfAccounts	`$projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts and $projection.GLAccount = _GLAccountInChartOfAccounts.GLAccount`
[0..*]	I_GLAccountText	_GLAcctInChartOfAccountsText	`$projection.ChartOfAccounts = _GLAcctInChartOfAccountsText.ChartOfAccounts and $projection.GLAccount = _GLAcctInChartOfAccountsText.GLAccount`
[0..1]	I_GLAccountInCompanyCode	_GLAccountInCompanyCode	`$projection.CompanyCode = _GLAccountInCompanyCode.CompanyCode and $projection.GLAccount = _GLAccountInCompanyCode.GLAccount`
[0..1]	I_ChartOfAccounts	_ChartOfAccounts	`$projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts`
[0..*]	I_ChartOfAccountsText	_ChartOfAccountsText	`$projection.ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts`
[0..1]	I_AccountingDocumentType	_AccountingDocumentType	`$projection.AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType`
[0..*]	I_AccountingDocumentTypeText	_AccountingDocumentTypeText	`$projection.AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType`
[0..1]	I_FinancialAccountType	_FinancialAccountType	`$projection.FinancialAccountType = _FinancialAccountType.FinancialAccountType`
[0..*]	I_FinancialAccountTypeText	_FinancialAccountTypeText	`$projection.FinancialAccountType = _FinancialAccountTypeText.FinancialAccountType`
[0..1]	I_DebitCreditCode	_DebitCreditCode	`$projection.DebitCreditCode = _DebitCreditCode.DebitCreditCode`
[0..*]	I_DebitCreditCodeText	_DebitCreditCodeText	`$projection.DebitCreditCode = _DebitCreditCodeText.DebitCreditCode`
[0..1]	I_Product	_Product	`$projection.Product = _Product.Product`
[0..*]	I_ProductDescription	_ProductText	`$projection.Product = _ProductText.Product`
[0..1]	I_Plant	_Plant	`$projection.Plant = _Plant.Plant`
[1..1]	I_Ledger	_Ledger	`$projection.Ledger = _Ledger.Ledger`
[0..*]	I_LedgerText	_LedgerText	`$projection.Ledger = _LedgerText.Ledger`
[0..1]	I_Ledger	_SourceLedger	`$projection.SourceLedger = _SourceLedger.Ledger`
[0..1]	I_Customer	_Customer	`$projection.Customer = _Customer.Customer`
[0..1]	I_Customer	_CustomerText	`$projection.Customer = _CustomerText.Customer`
[0..1]	I_CustomerGroup	_CustomerGroup	`$projection.CustomerGroup = _CustomerGroup.CustomerGroup`
[0..1]	I_Supplier	_Supplier	`$projection.Supplier = _Supplier.Supplier`
[0..1]	I_Supplier	_SupplierText	`$projection.Supplier = _SupplierText.Supplier`
[0..1]	I_ProductGroup	_SoldProductGroup	`$projection.SoldProductGroup = _SoldProductGroup.MaterialGroup`
[0..1]	I_ProductGroup_2	_SoldProductGroup_2	`$projection.SoldProductGroup = _SoldProductGroup_2.ProductGroup`
[0..1]	I_ProductGroup	_ProductGroup	`$projection.ProductGroup = _ProductGroup.MaterialGroup`
[0..1]	I_ProductGroup_2	_ProductGroup_2	`$projection.ProductGroup = _ProductGroup_2.ProductGroup`
[0..1]	I_SalesDocument	_SalesDocument	`$projection.SalesDocument = _SalesDocument.SalesDocument`
[0..1]	I_SalesDocumentItem	_SalesDocumentItem	`$projection.SalesDocument = _SalesDocumentItem.SalesDocument and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem`
[0..1]	I_InternalOrder	_InternalOrder	`$projection.OrderID = _InternalOrder.InternalOrder`
[0..1]	I_Order	_Order	`$projection.OrderID = _Order.OrderID`
[0..*]	I_CostAnalysisResource	_CostAnalysisResource	`$projection.ControllingArea = _CostAnalysisResource.ControllingArea and $projection.CostAnalysisResource = _CostAnalysisResource.CostAnalysisResource`
[0..*]	I_CostAnalysisResourceText	_CostAnalysisResourceText	`$projection.ControllingArea = _CostAnalysisResourceText.ControllingArea and $projection.CostAnalysisResource = _CostAnalysisResourceText.CostAnalysisResource`
[0..1]	I_Employment	_Employment	`$projection.PersonnelNumber = _Employment.EmploymentInternalID`
[0..1]	I_PersonWorkAgreement_1	_PersonWorkAgreement_1	`$projection.PersonnelNumber = _PersonWorkAgreement_1.PersonWorkAgreement`
[0..1]	I_FinancialTransactionType	_FinancialTransactionType	`$projection.FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType`
[0..1]	I_BusinessTransactionType	_BusinessTransactionType	`$projection.BusinessTransactionType = _BusinessTransactionType.BusinessTransactionType`
[0..*]	I_BusTransactionTypeText	_BusinessTransactionTypeText	`$projection.BusinessTransactionType = _BusinessTransactionTypeText.BusinessTransactionType`
[0..1]	I_ReferenceDocumentType	_PredecessorReferenceDocType	`$projection.PredecessorReferenceDocType = _PredecessorReferenceDocType.ReferenceDocumentType`
[0..*]	I_CostCenter	_PartnerCostCenter	`$projection.ControllingArea = _PartnerCostCenter.ControllingArea and $projection.PartnerCostCenter = _PartnerCostCenter.CostCenter`
[0..*]	I_ProfitCenter	_PartnerProfitCenter	`$projection.ControllingArea = _PartnerProfitCenter.ControllingArea and $projection.PartnerProfitCenter = _PartnerProfitCenter.ProfitCenter`
[0..1]	I_BusinessArea	_PartnerBusinessArea	`$projection.PartnerBusinessArea = _PartnerBusinessArea.BusinessArea`
[0..*]	I_BusinessAreaText	_PartnerBusinessAreaText	`$projection.PartnerBusinessArea = _PartnerBusinessAreaText.BusinessArea`
[0..1]	I_FunctionalArea	_PartnerFunctionalArea	`$projection.PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea`
[0..1]	I_CompanyCode	_PartnerCompanyCode	`$projection.PartnerCompanyCode = _PartnerCompanyCode.CompanyCode`
[0..1]	I_CompanyCode	_PartnerCompanyCodeText	`$projection.PartnerCompanyCode = _PartnerCompanyCodeText.CompanyCode`
[0..1]	I_Segment	_PartnerSegment	`$projection.PartnerSegment = _PartnerSegment.Segment`
[0..*]	I_SegmentText	_PartnerSegmentText	`$projection.PartnerSegment = _PartnerSegmentText.Segment`
[0..1]	I_AccountingDocumentCategory	_AccountingDocumentCategory	`$projection.AccountingDocumentCategory = _AccountingDocumentCategory.AccountingDocumentCategory`
[0..1]	I_PostingKey	_PostingKey	`$projection.PostingKey = _PostingKey.PostingKey`
[0..1]	I_SubLedgerAccLineItemType	_SubLedgerAccLineItemType	`$projection.SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType`
[0..1]	I_User	_User	`$projection.AccountingDocCreatedByUser = _User.UserID`
[0..*]	I_ProfitCenter	_EliminationProfitCenter	`$projection.ControllingArea = _EliminationProfitCenter.ControllingArea and $projection.EliminationProfitCenter = _EliminationProfitCenter.ProfitCenter`

Annotations (18)

Name	Value	Level
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.sqlViewName	IADBKFCUBE	view
EndUserText.label	ADB KFC - Cube	view
Analytics.dataCategory	#CUBE	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
AccessControl.personalData.blocking	#REQUIRED	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view
Analytics.internalName	#LOCAL	view

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_AvgDailyBalKeyFigCube.
-- 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: IADBKFCUBE
-- Parameters: P_ReportingDate : gle_dte_adb_keydate, P_CreationTime : gle_dte_adb_creation_time, P_CreationDate : gle_dte_adb_creation_date

CREATE VIEW I_AvgDailyBalKeyFigCube AS
SELECT *  -- field list not available in parsed metadata
FROM P_AvgDailyBalKeyFig
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON SourceLedger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem  -- association [1..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND AccountingDocument = _JournalEntry.AccountingDocument  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON CompanyCode = _CompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _LedgerFiscalYear ON LedgerFiscalYear = _LedgerFiscalYear.FiscalYear AND CompanyCode = _LedgerFiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForCmpnyCode AS _FiscalPeriod ON LedgerFiscalYear = _FiscalPeriod.FiscalYear AND FiscalPeriod = _FiscalPeriod.FiscalPeriod AND CompanyCode = _FiscalPeriod.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalCalYearPeriodForCoCode AS _FiscalYearPeriod ON FiscalYearPeriod = _FiscalYearPeriod.FiscalYearPeriod AND CompanyCode = _FiscalYearPeriod.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForVariant AS _LedgerFiscalYearForVariant ON LedgerFiscalYear = _LedgerFiscalYearForVariant.FiscalYear AND FiscalYearVariant = _LedgerFiscalYearForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FiscalPeriodForVariant ON LedgerFiscalYear = _FiscalPeriodForVariant.FiscalYear AND FiscalPeriod = _FiscalPeriodForVariant.FiscalPeriod AND FiscalYearVariant = _FiscalPeriodForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant ON FiscalYearPeriod = _FiscalYearPeriodForVariant.FiscalYearPeriod AND FiscalYearVariant = _FiscalYearPeriodForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalCalendarDate AS _FiscalCalendarDate ON PostingDate = _FiscalCalendarDate.CalendarDate AND FiscalYearVariant = _FiscalCalendarDate.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _BalanceTransactionCurrency ON BalanceTransactionCurrency = _BalanceTransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency1 ON FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency2 ON FreeDefinedCurrency2 = _FreeDefinedCurrency2.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency3 ON FreeDefinedCurrency3 = _FreeDefinedCurrency3.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency4 ON FreeDefinedCurrency4 = _FreeDefinedCurrency4.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency5 ON FreeDefinedCurrency5 = _FreeDefinedCurrency5.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency6 ON FreeDefinedCurrency6 = _FreeDefinedCurrency6.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency7 ON FreeDefinedCurrency7 = _FreeDefinedCurrency7.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency8 ON FreeDefinedCurrency8 = _FreeDefinedCurrency8.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CostSourceUnit ON CostSourceUnit = _CostSourceUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _SegmentText ON Segment = _SegmentText.Segment  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _CurrentProfitCenter ON ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter AND _CurrentProfitCenter.ValidityStartDate <= $session.system_date AND _CurrentProfitCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _CurrentCostCenter ON ControllingArea = _CurrentCostCenter.ControllingArea AND CostCenter = _CurrentCostCenter.CostCenter AND _CurrentCostCenter.ValidityStartDate <= $session.system_date AND _CurrentCostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicDataText ON WBSElementInternalID = _WBSElementBasicDataText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAcctInChartOfAccountsText ON ChartOfAccounts = _GLAcctInChartOfAccountsText.ChartOfAccounts AND GLAccount = _GLAcctInChartOfAccountsText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccountsText AS _ChartOfAccountsText ON ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_FinancialAccountType AS _FinancialAccountType ON FinancialAccountType = _FinancialAccountType.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountTypeText AS _FinancialAccountTypeText ON FinancialAccountType = _FinancialAccountTypeText.FinancialAccountType  -- association [0..*]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCodeText AS _DebitCreditCodeText ON DebitCreditCode = _DebitCreditCodeText.DebitCreditCode  -- association [0..*]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductDescription AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_Ledger AS _SourceLedger ON SourceLedger = _SourceLedger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _CustomerText ON Customer = _CustomerText.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SupplierText ON Supplier = _SupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup AS _SoldProductGroup ON SoldProductGroup = _SoldProductGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _SoldProductGroup_2 ON SoldProductGroup = _SoldProductGroup_2.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup AS _ProductGroup ON ProductGroup = _ProductGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup_2 ON ProductGroup = _ProductGroup_2.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesDocument = _SalesDocumentItem.SalesDocument AND SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON OrderID = _InternalOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_CostAnalysisResource AS _CostAnalysisResource ON ControllingArea = _CostAnalysisResource.ControllingArea AND CostAnalysisResource = _CostAnalysisResource.CostAnalysisResource  -- association [0..*]
LEFT OUTER JOIN I_CostAnalysisResourceText AS _CostAnalysisResourceText ON ControllingArea = _CostAnalysisResourceText.ControllingArea AND CostAnalysisResource = _CostAnalysisResourceText.CostAnalysisResource  -- association [0..*]
LEFT OUTER JOIN I_Employment AS _Employment ON PersonnelNumber = _Employment.EmploymentInternalID  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement_1 ON PersonnelNumber = _PersonWorkAgreement_1.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransactionType AS _FinancialTransactionType ON FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType  -- association [0..1]
LEFT OUTER JOIN I_BusinessTransactionType AS _BusinessTransactionType ON BusinessTransactionType = _BusinessTransactionType.BusinessTransactionType  -- association [0..1]
LEFT OUTER JOIN I_BusTransactionTypeText AS _BusinessTransactionTypeText ON BusinessTransactionType = _BusinessTransactionTypeText.BusinessTransactionType  -- association [0..*]
LEFT OUTER JOIN I_ReferenceDocumentType AS _PredecessorReferenceDocType ON PredecessorReferenceDocType = _PredecessorReferenceDocType.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _PartnerCostCenter ON ControllingArea = _PartnerCostCenter.ControllingArea AND PartnerCostCenter = _PartnerCostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _PartnerProfitCenter ON ControllingArea = _PartnerProfitCenter.ControllingArea AND PartnerProfitCenter = _PartnerProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _PartnerBusinessArea ON PartnerBusinessArea = _PartnerBusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _PartnerBusinessAreaText ON PartnerBusinessArea = _PartnerBusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _PartnerFunctionalArea ON PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PartnerCompanyCode ON PartnerCompanyCode = _PartnerCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PartnerCompanyCodeText ON PartnerCompanyCode = _PartnerCompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _PartnerSegment ON PartnerSegment = _PartnerSegment.Segment  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _PartnerSegmentText ON PartnerSegment = _PartnerSegmentText.Segment  -- association [0..*]
LEFT OUTER JOIN I_AccountingDocumentCategory AS _AccountingDocumentCategory ON AccountingDocumentCategory = _AccountingDocumentCategory.AccountingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_PostingKey AS _PostingKey ON PostingKey = _PostingKey.PostingKey  -- association [0..1]
LEFT OUTER JOIN I_SubLedgerAccLineItemType AS _SubLedgerAccLineItemType ON SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON AccountingDocCreatedByUser = _User.UserID  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _EliminationProfitCenter ON ControllingArea = _EliminationProfitCenter.ControllingArea AND EliminationProfitCenter = _EliminationProfitCenter.ProfitCenter  -- association [0..*]
;

Depth:

I_AvgDailyBalKeyFigCube view

P_AvgDailyBalKeyFig view

C_AvgDailyTrialBalance view