What is C_AvgDailyTrialBalance in SAP S/4HANA?

C_AvgDailyTrialBalance is a consumption CDS view in SAP S/4HANA. ADB Key Figures - Query It contains 166 fields.

Which tables does C_AvgDailyTrialBalance read from?

C_AvgDailyTrialBalance reads data from: I_AvgDailyBalKeyFigCube.

What VDM layer is C_AvgDailyTrialBalance?

C_AvgDailyTrialBalance is classified as a Consumption view optimized for specific business scenarios and reporting.

C_AvgDailyTrialBalance

DDL: C_AVGDAILYTRIALBALANCE Type: view CONSUMPTION Package: GADB_AL_KFC

166 Fields 1 Data Sources

ADB Key Figures - Query

C_AvgDailyTrialBalance (Consumption)

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

Accounting and Financial Close

C_AvgDailyTrialBalance is a Consumption CDS View that provides data about "ADB Key Figures - Query" in SAP S/4HANA. It reads from 1 data source (I_AvgDailyBalKeyFigCube) and exposes 166 fields. Part of development package GADB_AL_KFC.

SAP Help Documentation

Category	CDS Views for Average Daily Balances
Data Category	Query

Purpose
This CDS view serves as an Analytical Query view built on top of a Cube view, which defines user-facing semantics such as measures, dimensions, filters, labels, and value helps. It is directly consumed by analytical applications including Multi-Dimensional Analysis and SAP Analytics Cloud. This CDS view provides the data to answer the following business questions: What are the month‑to‑date (MTD), quarter‑to‑date (QTD), and year‑to‑date (YTD) balances of my account for a specific period? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have access to the authorization objects mentioned in the Authorizations section of ADB Key Figures - Cube .

Structure
Parameters The parameters of the CDS view are as follows: P_ReportingDate : This parameter is used to specify the report execution date P_CreationDate : This parameter is used to specify the cut-off date for journal entry selection P_KeyDate : This parameter is used to specify the key date date for key figure calculation P_CreationTime : This parameter is used to specify the cut-off time for journal entry selection Fields Used for Filtering The main filters are as follows: Ledger : This field is used to filter based on the source ledger CompanyCode : This field is used to filter based on the company code Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute Ledger Ledger Attribute CompanyCode Company Code Attribute CompanyCodeName Company Name Attribute GLAccount G/L Account Attribute GLAccountName G/L Account Name Attribute PostingDate Posting Date Attribute FiscalYear Fiscal Year Attribute LedgerFiscalYear Fiscal Year of Ledger Attribute ProfitCenter Profit Center Attribute ProfitCenterName Profit Center Name Attribute ControllingArea Controlling Area Attribute ControllingAreaName Controlling Area Name Attribute Segment Segment Attribute SegmentName Segment Name Attribute CostCenter Cost Center Attribute CostCenterName Cost Center Name Attribute PartnerProfitCenter Partner Profit Center Attribute PartnerProfitCenterName Profit Center Name Attribute PartnerFunctionalArea Partner Func. Area Attribute PartnerFunctionalAreaName Functional Area Name Attribute PartnerCompany Trading Partner Attribute PartnerSegment Partner Segment Attribute FiscalYearVariant Fiscal Year Variant Attribute ChartOfAccounts Chart of Accounts Attribute FinancialServicesProductGroup Product Group (FS) Attribute FinancialServicesBranch Branch (FS) Attribute FinancialDataSource Data Source Attribute CustomerGroup Customer Group Attribute CustomerSupplierCountry Customer or Supplier Country/Region Attribute CustomerSupplierIndustry Customer Supplier Industry Attribute BalanceTransactionCurrency Balance Transaction Currency Attribute AmountInBalanceTransacCrcy Amount in Balance Transaction Currency Measure PriorDayBalInBalTransCrcy Prior Day Balance in Balance Transaction Currency Measure CurDayActyAmtInBalTransCrcy Current Day Activity Amount in Balance Transaction Currency Measure PriorMonthBalInBalTransCrcy Prior Month Balance in Balance Transaction Currency Measure CurMonthActyAmtInBalTransCrcy Current Month Activity Amount in Balance Transaction Currency Measure YTDBalInBalTransCrcy Year-to-Date Balance in Balance Transaction Currency Measure MTDAvgDailyBalInBalTransCrcy Month-to-Date Average Daily Balance in Balance Transaction Currency Measure QTDAvgDailyBalInBalTransCrcy Quarter-to-Date Average Daily Balance in Balance Transaction Currency Measure YTDAvgDailyBalInBalTransCrcy

View on SAP Help Portal →

SAP API Hub

Category	Consumption
State	Deprecated
Line of Business	Accounting and Financial Close
Application Component	FI-GL-GL-ADB-2CL
Capabilities	Analytical Query
Extensible (Key User)	Yes
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Not Released
Package	Accounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view serves as an Analytical Query view built on top of a Cube view, which defines user-facing semantics such as measures, dimensions, filters, labels, and value helps. It is directly consumed by analytical applications including Multi-Dimensional Analysis and SAP Analytics Cloud.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the month‑to‑date (MTD), quarter‑to‑date (QTD), and year‑to‑date (YTD) balances of my account for a specific period?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

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

Data Sources (1)

Source	Alias	Join Type
I_AvgDailyBalKeyFigCube	I_AvgDailyBalKeyFigCube	from

Parameters (5)

Name	Type	Default
P_ReportingDate	gle_dte_adb_keydate
P_CreationDate	gle_dte_adb_creation_date
P_CreationTime	gle_dte_adb_creation_time
P_Language	sylangu
P_KeyDate	sydate

Annotations (16)

Name	Value	Level
AbapCatalog.sqlViewName	CADBTRIALBAL	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
Analytics.query	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	ADB Key Figures - Query	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
ObjectModel.modelingPattern	#ANALYTICAL_QUERY	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
OData.publish	true	view
VDM.viewType	#CONSUMPTION	view

Fields (166)

Field	Source Table	Source Field	Description
lookupEntityI_MySessionContext
resultElementUserLocalDate
P_CreationTime
CompanyCode		CompanyCode	Receiver Company Code
CompanyCodeName	_CompanyCode	CompanyCodeName	Name of Company Code or Company
GLAccount		GLAccount	General Ledger
GLAccountName			G/L Account Name
PostingDate		PostingDate	Posting Date for GR
SourceLedger		SourceLedger	Source Ledger
FiscalYear		FiscalYear	G/L Fiscal Year
LedgerFiscalYear		LedgerFiscalYear	Fiscal Year of Ledger
FlowOfFundsLedgerFiscalYear		FlowOfFundsLedgerFiscalYear	Funds of Flow Ledger Fiscal Year
ProfitCenter		ProfitCenter	Profit Center
ProfitCenterName			Description of Profit Center
FunctionalArea		FunctionalArea	Sendr Fctl Area
FunctionalAreaName			Name of the Functional Area
ControllingArea		ControllingArea	Controlling Area
Segment		Segment	Segment for Segmental Reporting
SegmentName			Segment Name
CostCenter		CostCenter	Cost Center
CostCenterName			Cost Center Name
PartnerProfitCenter		PartnerProfitCenter	Partner Profit Center
PartnerFunctionalArea		PartnerFunctionalArea	Partner Functional Area
PartnerFunctionalAreaName			Name of the Functional Area
PartnerCompany		PartnerCompany	Company ID of Trading Partner
PartnerSegment		PartnerSegment	Partner Segment for Segmental Reporting
FiscalYearVariant		FiscalYearVariant	Fiscal Year Variant
ChartOfAccounts		ChartOfAccounts	Chart of Accounts
FinancialServicesProductGroup		FinancialServicesProductGroup	Financial Services Product Group
FinancialServicesBranch		FinancialServicesBranch	Financial Services Branch
FinancialDataSource		FinancialDataSource	Financial Data Source
CustomerGroup		CustomerGroup	Customer Group
CustomerSupplierCountry		CustomerSupplierCountry	Customer or Supplier Country/Region
CustomerSupplierIndustry		CustomerSupplierIndustry	Customer Supplier Industry
BalanceTransactionCurrency			Balance Transaction Currency
AmountInBalanceTransacCrcy		AmountInBalanceTransacCrcy	Amount in Balance Transaction Currency
PriorDayBalInBalTransCrcy		PriorDayBalInBalTransCrcy	Prior Day Balance In Balance Transaction Currency
CurDayActyAmtInBalTransCrcy		CurDayActyAmtInBalTransCrcy	Current Day Activity In Balance Transaction Currency
PriorMonthBalInBalTransCrcy		PriorMonthBalInBalTransCrcy	Prior Month Balance In Balance Transaction Currency
CurMonthActyAmtInBalTransCrcy		CurMonthActyAmtInBalTransCrcy	Current Month Activity In Balance Transaction Currency
YTDBalInBalTransCrcy		YTDBalInBalTransCrcy	Year-to-Date Balance In Balance Transaction Currency
MTDAvgDailyBalInBalTransCrcy		MTDAvgDailyBalInBalTransCrcy	Month-to-Date ADB In Balance Transaction Currency
QTDAvgDailyBalInBalTransCrcy		QTDAvgDailyBalInBalTransCrcy	Quarter-to-Date ADB In Balance Transaction Currency
YTDAvgDailyBalInBalTransCrcy		YTDAvgDailyBalInBalTransCrcy	Year-to-Date ADB In Balance Transaction Currency
MTDAvgActyAmtInBalTransCrcy		MTDAvgActyAmtInBalTransCrcy	Month-to-Date Avg Activity In Balance Transaction Currency
QTDActyAmtInBalTransCrcy		QTDActyAmtInBalTransCrcy	Quarter-to-Date Acty In Balance Transaction Currency
CompanyCodeCurrency		CompanyCodeCurrency	Company Code Currency
AmountInCompanyCodeCurrency		AmountInCompanyCodeCurrency	Amount in Company Code Currency
PriorDayBalInCCCrcy		PriorDayBalInCCCrcy	Prior Day Balance In Company Code Currency
CurDayActyAmtInCCCrcy		CurDayActyAmtInCCCrcy	Current Day Activity In Company Code Currency
PriorMonthBalInCCCrcy		PriorMonthBalInCCCrcy	Prior Month Balance In Company Code Currency
CurMonthActyAmtInCCCrcy		CurMonthActyAmtInCCCrcy	Current Month Activity In Company Code Currency
YTDBalInCCCrcy		YTDBalInCCCrcy	Year-to-Date Balance In Company Code Currency
MTDAvgDailyBalInCCCrcy		MTDAvgDailyBalInCCCrcy	Month-to-date ADB In Company Code Currency
QTDAvgDailyBalInCCCrcy		QTDAvgDailyBalInCCCrcy	Quarter-to-Date ADB In Company Code Currency
YTDAvgDailyBalInCCCrcy		YTDAvgDailyBalInCCCrcy	Year-to-Date ADB In Company Code Currency
MTDAvgActyAmtInCCCrcy		MTDAvgActyAmtInCCCrcy	Month-to-Date Average Activity In Company Code Currency
QTDActyAmtInCCCrcy		QTDActyAmtInCCCrcy	Quarter-to-Date Activity In Company Code Currency
GlobalCurrency		GlobalCurrency	GM Billing Element: Global Currency
AmountInGlobalCurrency		AmountInGlobalCurrency	Amount in Global Currency
PriorDayBalInGlobCrcy		PriorDayBalInGlobCrcy	Prior Day Balance In Global Currency
CurDayActyAmtInGlobCrcy		CurDayActyAmtInGlobCrcy	Current Day Activity In Global Currency
PriorMonthBalInGlobCrcy		PriorMonthBalInGlobCrcy	Prior Month Balance In Global Currency
CurMonthActyAmtInGlobCrcy		CurMonthActyAmtInGlobCrcy	Current Month Activity In Global Currency
YTDBalInGlobCrcy		YTDBalInGlobCrcy	Year-to-Date Balance In Global Currency
MTDAvgDailyBalInGlobCrcy		MTDAvgDailyBalInGlobCrcy	Month-to-Date Average Daily Balances In Global Currency
QTDAvgDailyBalInGlobCrcy		QTDAvgDailyBalInGlobCrcy	Quarter-to-Date ADB In Global Currency
YTDAvgDailyBalInGlobCrcy		YTDAvgDailyBalInGlobCrcy	Year-to-Date ADB In Global Currency
MTDAvgActyAmtInGlobCrcy		MTDAvgActyAmtInGlobCrcy	Month-to-Date Average Activity In Balance Global Currency
QTDActyAmtInGlobCrcy		QTDActyAmtInGlobCrcy	Quarter-to-Date Activity In Balance GLobal Currency
FreeDefinedCurrency1		FreeDefinedCurrency1	Freely Defined Currency 1
AmountInFreeDefinedCurrency1		AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
PriorDayBalInFDCrcy1		PriorDayBalInFDCrcy1	Prior Day Balance In Free-Defined Currency 1
CurDayActyAmtInFDCrcy1		CurDayActyAmtInFDCrcy1	Current Day Activity In Free-Defined Currency 1
PriorMonthBalInFDCrcy1		PriorMonthBalInFDCrcy1	Prior Month Balance In Free-Defined Currency 1
CurMonthActyAmtInFDCrcy1		CurMonthActyAmtInFDCrcy1	Current Month Activity In Free-Defined Currency 1
YTDBalInFDCrcy1		YTDBalInFDCrcy1	Year-to-Date Balance In Free-Defined Currency 1
MTDAvgDailyBalInFDCrcy1		MTDAvgDailyBalInFDCrcy1	Month-to-Date ADB In Free-Defined Currency 1
QTDAvgDailyBalInFDCrcy1		QTDAvgDailyBalInFDCrcy1	Quarter-to-Date ADB In Free-Defined Currency 1
YTDAvgDailyBalInFDCrcy1		YTDAvgDailyBalInFDCrcy1	Year-to-Date ADB In Free-Defined Currency 1
MTDAvgActyAmtInFDCrcy1		MTDAvgActyAmtInFDCrcy1	Month-to-Date Avg Activity In Free-Defined Currency 1
QTDActyAmtInFDCrcy1		QTDActyAmtInFDCrcy1	Quarter-to-Date Activity In Free-Defined Currency 1
FreeDefinedCurrency2		FreeDefinedCurrency2	Freely Defined Currency 2
AmountInFreeDefinedCurrency2		AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
PriorDayBalInFDCrcy2		PriorDayBalInFDCrcy2	Prior Day Balance In Free-Defined Currency 2
CurDayActyAmtInFDCrcy2		CurDayActyAmtInFDCrcy2	Current Day Activity In Free-Defined Currency 2
PriorMonthBalInFDCrcy2		PriorMonthBalInFDCrcy2	Prior Month Balance In Free-Defined Currency 2
CurMonthActyAmtInFDCrcy2		CurMonthActyAmtInFDCrcy2	Current Month Activity In Free-Defined Currency 2
YTDBalInFDCrcy2		YTDBalInFDCrcy2	Year-to-Date Balance In Free-Defined Currency 2
MTDAvgDailyBalInFDCrcy2		MTDAvgDailyBalInFDCrcy2	Month-to-Date ADB In Free-Defined Currency 2
QTDAvgDailyBalInFDCrcy2		QTDAvgDailyBalInFDCrcy2	Quarter-to-Date ADB In Free-Defined Currency 2
YTDAvgDailyBalInFDCrcy2		YTDAvgDailyBalInFDCrcy2	Year-to-Date ADB In Free-Defined Currency 2
MTDAvgActyAmtInFDCrcy2		MTDAvgActyAmtInFDCrcy2	Month-to-Date Avg Activity In Free-Defined Currency 2
QTDActyAmtInFDCrcy2		QTDActyAmtInFDCrcy2	Quarter-to-Date Avg Activity In Free-Defined Currency 2
FreeDefinedCurrency3		FreeDefinedCurrency3	Freely Defined Currency 3
AmountInFreeDefinedCurrency3		AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
PriorDayBalInFDCrcy3		PriorDayBalInFDCrcy3	Prior Day Balance In Free-Defined Currency 3
CurDayActyAmtInFDCrcy3		CurDayActyAmtInFDCrcy3	Current Day Activity In Free-Defined Currency 3
PriorMonthBalInFDCrcy3		PriorMonthBalInFDCrcy3	Prior Month Balance In Free-Defined Currency 3
CurMonthActyAmtInFDCrcy3		CurMonthActyAmtInFDCrcy3	Current Month Activity In Free-Defined Currency 3
YTDBalInFDCrcy3		YTDBalInFDCrcy3	Year-to-Date Balance In Free-Defined Currency 3
MTDAvgDailyBalInFDCrcy3		MTDAvgDailyBalInFDCrcy3	Month-to-Date ADB In Free-Defined Currency 3
QTDAvgDailyBalInFDCrcy3		QTDAvgDailyBalInFDCrcy3	Quarter-to-Date ADB In Free-Defined Currency 3
YTDAvgDailyBalInFDCrcy3		YTDAvgDailyBalInFDCrcy3	Year-to-Date ADB In Free-Defined Currency 3
MTDAvgActyAmtInFDCrcy3		MTDAvgActyAmtInFDCrcy3	Month-to-Date Avg Activity In Free-Defined Currency 3
QTDActyAmtInFDCrcy3		QTDActyAmtInFDCrcy3	Quarter-to-Date Avg Activity In Free-Defined Currency 3
FreeDefinedCurrency4		FreeDefinedCurrency4	Freely Defined Currency 4
AmountInFreeDefinedCurrency4		AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
PriorDayBalInFDCrcy4		PriorDayBalInFDCrcy4	Prior Day Balance In Free-Defined Currency 4
CurDayActyAmtInFDCrcy4		CurDayActyAmtInFDCrcy4	Current Day Activity In Free-Defined Currency 4
PriorMonthBalInFDCrcy4		PriorMonthBalInFDCrcy4	Prior Month Balance In Free-Defined Currency 4
CurMonthActyAmtInFDCrcy4		CurMonthActyAmtInFDCrcy4	Current Month Activity In Free-Defined Currency 4
YTDBalInFDCrcy4		YTDBalInFDCrcy4	Year-to-Date Balance In Free-Defined Currency 4
MTDAvgDailyBalInFDCrcy4		MTDAvgDailyBalInFDCrcy4	Month-to-Date ADB In Free-Defined Currency 4
QTDAvgDailyBalInFDCrcy4		QTDAvgDailyBalInFDCrcy4	Quarter-to-Date ADB In Free-Defined Currency 4
YTDAvgDailyBalInFDCrcy4		YTDAvgDailyBalInFDCrcy4	Year-to-Date ADB In Free-Defined Currency 4
MTDAvgActyAmtInFDCrcy4		MTDAvgActyAmtInFDCrcy4	Month-to-Date Avg Activity In Free-Defined Currency 4
QTDActyAmtInFDCrcy4		QTDActyAmtInFDCrcy4	Quarter-to-Date Activity In Free-Defined Currency 4
FreeDefinedCurrency5		FreeDefinedCurrency5	Freely Defined Currency 5
AmountInFreeDefinedCurrency5		AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
PriorDayBalInFDCrcy5		PriorDayBalInFDCrcy5	Prior Day Balance In Free-Defined Currency 5
CurDayActyAmtInFDCrcy5		CurDayActyAmtInFDCrcy5	Current Day Activity In Free-Defined Currency 5
PriorMonthBalInFDCrcy5		PriorMonthBalInFDCrcy5	Prior Month Balance In Free-Defined Currency 5
CurMonthActyAmtInFDCrcy5		CurMonthActyAmtInFDCrcy5	Current Month Activity In Free-Defined Currency 5
YTDBalInFDCrcy5		YTDBalInFDCrcy5	Year-to-Date Balance In Free-Defined Currency 5
MTDAvgDailyBalInFDCrcy5		MTDAvgDailyBalInFDCrcy5	Month-to-Date ADB In Free-Defined Currency 5
QTDAvgDailyBalInFDCrcy5		QTDAvgDailyBalInFDCrcy5	Quarter-to-Date ADB In Free-Defined Currency 5
YTDAvgDailyBalInFDCrcy5		YTDAvgDailyBalInFDCrcy5	Year-to-Date ADB In Free-Defined Currency 5
MTDAvgActyAmtInFDCrcy5		MTDAvgActyAmtInFDCrcy5	Month-to-Date Avg Activity In Free-Defined Currency 5
QTDActyAmtInFDCrcy5		QTDActyAmtInFDCrcy5	Quarter-to-Date Activity In Free-Defined Currency 5
FreeDefinedCurrency6		FreeDefinedCurrency6	Freely Defined Currency 6
AmountInFreeDefinedCurrency6		AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
PriorDayBalInFDCrcy6		PriorDayBalInFDCrcy6	Prior Day Balance In Free-Defined Currency 6
CurDayActyAmtInFDCrcy6		CurDayActyAmtInFDCrcy6	Current Day Activity In Free-Defined Currency 6
PriorMonthBalInFDCrcy6		PriorMonthBalInFDCrcy6	Prior Month Balance In Free-Defined Currency 6
CurMonthActyAmtInFDCrcy6		CurMonthActyAmtInFDCrcy6	Current Month Activity In Free-Defined Currency 6
YTDBalInFDCrcy6		YTDBalInFDCrcy6	Year-to-Date Balance In Free-Defined Currency 6
MTDAvgDailyBalInFDCrcy6		MTDAvgDailyBalInFDCrcy6	Month-to-Date ADB In Free-Defined Currency 6
QTDAvgDailyBalInFDCrcy6		QTDAvgDailyBalInFDCrcy6	Quarter-to-Date ADB In Free-Defined Currency 6
YTDAvgDailyBalInFDCrcy6		YTDAvgDailyBalInFDCrcy6	Year-to-Date ADB In Free-Defined Currency 6
MTDAvgActyAmtInFDCrcy6		MTDAvgActyAmtInFDCrcy6	Month-to-Date Avg Activity In Free-Defined Currency 6
QTDActyAmtInFDCrcy6		QTDActyAmtInFDCrcy6	Quarter-to-Date Activity In Free-Defined Currency 6
FreeDefinedCurrency7		FreeDefinedCurrency7	Freely Defined Currency 7
AmountInFreeDefinedCurrency7		AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
PriorDayBalInFDCrcy7		PriorDayBalInFDCrcy7	Prior Day Balance In Free-Defined Currency 7
CurDayActyAmtInFDCrcy7		CurDayActyAmtInFDCrcy7	Current Day Activity In Free-Defined Currency 7
PriorMonthBalInFDCrcy7		PriorMonthBalInFDCrcy7	Prior Month Balance In Free-Defined Currency 7
CurMonthActyAmtInFDCrcy7		CurMonthActyAmtInFDCrcy7	Current Month Activity In Free-Defined Currency 7
YTDBalInFDCrcy7		YTDBalInFDCrcy7	Year-to-Date Balance In Free-Defined Currency 7
MTDAvgDailyBalInFDCrcy7		MTDAvgDailyBalInFDCrcy7	Month-to-Date ADB In Free-Defined Currency 7
QTDAvgDailyBalInFDCrcy7		QTDAvgDailyBalInFDCrcy7	Quarter-to-Date ADB In Free-Defined Currency 7
YTDAvgDailyBalInFDCrcy7		YTDAvgDailyBalInFDCrcy7	Year-to-Date ADB In Free-Defined Currency 7
MTDAvgActyAmtInFDCrcy7		MTDAvgActyAmtInFDCrcy7	Month-to-Date Avg Activity In Free-Defined Currency 7
QTDActyAmtInFDCrcy7		QTDActyAmtInFDCrcy7	Quarter-to-Date Activity In Free-Defined Currency 7
FreeDefinedCurrency8		FreeDefinedCurrency8	Freely Defined Currency 8
AmountInFreeDefinedCurrency8		AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
PriorDayBalInFDCrcy8		PriorDayBalInFDCrcy8	Prior Day Balance In Free-Defined Currency 8
CurDayActyAmtInFDCrcy8		CurDayActyAmtInFDCrcy8	Current Day Activity In Free-Defined Currency 8
PriorMonthBalInFDCrcy8		PriorMonthBalInFDCrcy8	Prior Month Balance In Free-Defined Currency 8
CurMonthActyAmtInFDCrcy8		CurMonthActyAmtInFDCrcy8	Current Month Activity In Free-Defined Currency 8
YTDBalInFDCrcy8		YTDBalInFDCrcy8	Year-to-Date Balance In Free-Defined Currency 8
MTDAvgDailyBalInFDCrcy8		MTDAvgDailyBalInFDCrcy8	Month-to-Date ADB In Free-Defined Currency 8
QTDAvgDailyBalInFDCrcy8		QTDAvgDailyBalInFDCrcy8	Quarter-to-Date ADB In Free-Defined Currency 8
YTDAvgDailyBalInFDCrcy8		YTDAvgDailyBalInFDCrcy8	Year-to-Date ADB In Free-Defined Currency 8
MTDAvgActyAmtInFDCrcy8		MTDAvgActyAmtInFDCrcy8	Month-to-Date Avg Activity In Free-Defined Currency 8
QTDActyAmtInFDCrcy8		QTDActyAmtInFDCrcy8	Quarter-to-Date Activity In Free-Defined Currency 8

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_AvgDailyTrialBalance.
-- 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.
-- Parameters: P_ReportingDate : gle_dte_adb_keydate, P_CreationDate : gle_dte_adb_creation_date, P_CreationTime : gle_dte_adb_creation_time, P_Language : sylangu, P_KeyDate : sydate

CREATE VIEW C_AvgDailyTrialBalance AS
SELECT
  lookupEntity: 'I_MySessionContext' AS lookupEntityI_MySessionContext,
  resultElement: 'UserLocalDate' AS resultElementUserLocalDate,
  P_CreationTime: $parameters.P_CreationTime AS P_CreationTime,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  GLAccount,
  _GLAccountInChartOfAccounts._Text[1: Language = $parameters.P_Language].GLAccountName AS GLAccountName,
  PostingDate,
  SourceLedger,
  FiscalYear,
  LedgerFiscalYear,
  FlowOfFundsLedgerFiscalYear,
  ProfitCenter,
  _ProfitCenter[1:ValidityEndDate >= $parameters.P_KeyDate and ValidityStartDate <= $parameters.P_KeyDate]._Text[1:Language = $parameters.P_Language].ProfitCenterName AS ProfitCenterName,
  FunctionalArea,
  _FunctionalArea._Text[1:Language = $parameters.P_Language].FunctionalAreaName AS FunctionalAreaName,
  ControllingArea,
  Segment,
  _Segment._Text[1:Language = $parameters.P_Language].SegmentName AS SegmentName,
  CostCenter,
  _CostCenter[1:ValidityEndDate >= $parameters.P_KeyDate and ValidityStartDate <= $parameters.P_KeyDate]._Text[1:Language = $parameters.P_Language].CostCenterName AS CostCenterName,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  _PartnerFunctionalArea._Text[1:Language = $parameters.P_Language].FunctionalAreaName AS PartnerFunctionalAreaName,
  PartnerCompany,
  PartnerSegment,
  FiscalYearVariant,
  ChartOfAccounts,
  FinancialServicesProductGroup,
  FinancialServicesBranch,
  FinancialDataSource,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  AmountInBalanceTransacCrcy,
  PriorDayBalInBalTransCrcy,
  CurDayActyAmtInBalTransCrcy,
  PriorMonthBalInBalTransCrcy,
  CurMonthActyAmtInBalTransCrcy,
  YTDBalInBalTransCrcy,
  MTDAvgDailyBalInBalTransCrcy,
  QTDAvgDailyBalInBalTransCrcy,
  YTDAvgDailyBalInBalTransCrcy,
  MTDAvgActyAmtInBalTransCrcy,
  QTDActyAmtInBalTransCrcy,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  PriorDayBalInCCCrcy,
  CurDayActyAmtInCCCrcy,
  PriorMonthBalInCCCrcy,
  CurMonthActyAmtInCCCrcy,
  YTDBalInCCCrcy,
  MTDAvgDailyBalInCCCrcy,
  QTDAvgDailyBalInCCCrcy,
  YTDAvgDailyBalInCCCrcy,
  MTDAvgActyAmtInCCCrcy,
  QTDActyAmtInCCCrcy,
  GlobalCurrency,
  AmountInGlobalCurrency,
  PriorDayBalInGlobCrcy,
  CurDayActyAmtInGlobCrcy,
  PriorMonthBalInGlobCrcy,
  CurMonthActyAmtInGlobCrcy,
  YTDBalInGlobCrcy,
  MTDAvgDailyBalInGlobCrcy,
  QTDAvgDailyBalInGlobCrcy,
  YTDAvgDailyBalInGlobCrcy,
  MTDAvgActyAmtInGlobCrcy,
  QTDActyAmtInGlobCrcy,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  PriorDayBalInFDCrcy1,
  CurDayActyAmtInFDCrcy1,
  PriorMonthBalInFDCrcy1,
  CurMonthActyAmtInFDCrcy1,
  YTDBalInFDCrcy1,
  MTDAvgDailyBalInFDCrcy1,
  QTDAvgDailyBalInFDCrcy1,
  YTDAvgDailyBalInFDCrcy1,
  MTDAvgActyAmtInFDCrcy1,
  QTDActyAmtInFDCrcy1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  PriorDayBalInFDCrcy2,
  CurDayActyAmtInFDCrcy2,
  PriorMonthBalInFDCrcy2,
  CurMonthActyAmtInFDCrcy2,
  YTDBalInFDCrcy2,
  MTDAvgDailyBalInFDCrcy2,
  QTDAvgDailyBalInFDCrcy2,
  YTDAvgDailyBalInFDCrcy2,
  MTDAvgActyAmtInFDCrcy2,
  QTDActyAmtInFDCrcy2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  PriorDayBalInFDCrcy3,
  CurDayActyAmtInFDCrcy3,
  PriorMonthBalInFDCrcy3,
  CurMonthActyAmtInFDCrcy3,
  YTDBalInFDCrcy3,
  MTDAvgDailyBalInFDCrcy3,
  QTDAvgDailyBalInFDCrcy3,
  YTDAvgDailyBalInFDCrcy3,
  MTDAvgActyAmtInFDCrcy3,
  QTDActyAmtInFDCrcy3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  PriorDayBalInFDCrcy4,
  CurDayActyAmtInFDCrcy4,
  PriorMonthBalInFDCrcy4,
  CurMonthActyAmtInFDCrcy4,
  YTDBalInFDCrcy4,
  MTDAvgDailyBalInFDCrcy4,
  QTDAvgDailyBalInFDCrcy4,
  YTDAvgDailyBalInFDCrcy4,
  MTDAvgActyAmtInFDCrcy4,
  QTDActyAmtInFDCrcy4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  PriorDayBalInFDCrcy5,
  CurDayActyAmtInFDCrcy5,
  PriorMonthBalInFDCrcy5,
  CurMonthActyAmtInFDCrcy5,
  YTDBalInFDCrcy5,
  MTDAvgDailyBalInFDCrcy5,
  QTDAvgDailyBalInFDCrcy5,
  YTDAvgDailyBalInFDCrcy5,
  MTDAvgActyAmtInFDCrcy5,
  QTDActyAmtInFDCrcy5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  PriorDayBalInFDCrcy6,
  CurDayActyAmtInFDCrcy6,
  PriorMonthBalInFDCrcy6,
  CurMonthActyAmtInFDCrcy6,
  YTDBalInFDCrcy6,
  MTDAvgDailyBalInFDCrcy6,
  QTDAvgDailyBalInFDCrcy6,
  YTDAvgDailyBalInFDCrcy6,
  MTDAvgActyAmtInFDCrcy6,
  QTDActyAmtInFDCrcy6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  PriorDayBalInFDCrcy7,
  CurDayActyAmtInFDCrcy7,
  PriorMonthBalInFDCrcy7,
  CurMonthActyAmtInFDCrcy7,
  YTDBalInFDCrcy7,
  MTDAvgDailyBalInFDCrcy7,
  QTDAvgDailyBalInFDCrcy7,
  YTDAvgDailyBalInFDCrcy7,
  MTDAvgActyAmtInFDCrcy7,
  QTDActyAmtInFDCrcy7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  PriorDayBalInFDCrcy8,
  CurDayActyAmtInFDCrcy8,
  PriorMonthBalInFDCrcy8,
  CurMonthActyAmtInFDCrcy8,
  YTDBalInFDCrcy8,
  MTDAvgDailyBalInFDCrcy8,
  QTDAvgDailyBalInFDCrcy8,
  YTDAvgDailyBalInFDCrcy8,
  MTDAvgActyAmtInFDCrcy8,
  QTDActyAmtInFDCrcy8
FROM I_AvgDailyBalKeyFigCube
;

Depth:

C_AvgDailyTrialBalance view

I_AvgDailyBalKeyFigCube view