What is C_GLAccountYTDBalanceQ in SAP S/4HANA?

C_GLAccountYTDBalanceQ is a consumption CDS view in SAP S/4HANA. Year-to-Date Balances It contains 89 fields.

Which tables does C_GLAccountYTDBalanceQ read from?

C_GLAccountYTDBalanceQ reads data from: I_GLAccountYearToDateBalanceC.

What VDM layer is C_GLAccountYTDBalanceQ?

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

C_GLAccountYTDBalanceQ

DDL: C_GLACCOUNTYTDBALANCEQ Type: view CONSUMPTION Package: FINS_FIS_FICO_APPS

89 Fields 1 Data Sources

Year-to-Date Balances

C_GLAccountYTDBalanceQ (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_GLAccountYTDBalanceQ is a Consumption CDS View that provides data about "Year-to-Date Balances" in SAP S/4HANA. It reads from 1 data source (I_GLAccountYearToDateBalanceC) and exposes 89 fields. Part of development package FINS_FIS_FICO_APPS.

SAP API Hub

Category	Consumption
State	C1
Line of Business	Accounting and Financial Close
Application Component	FI-FIO-GL-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

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_GLAccountYearToDateBalanceC	I_GLAccountYearToDateBalanceC	from

Parameters (4)

Name	Type	Default
P_BusinessUser	syuname
P_ControllingArea	fis_kokrs
P_FiscalYearVariant	fins_periv
P_KeyDate	vdm_v_key_date

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	CFIGLACCTYTDBALQ	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
AbapCatalog.compiler.compareFilter	true	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.modelingPattern	#ANALYTICAL_QUERY	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Year-to-Date Balances	view
Analytics.query	true	view
Analytics.settings.maxProcessingEffort	#HIGH	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
VDM.viewType	#CONSUMPTION	view

Fields (89)

Field	Source Table	Source Field	Description
resultElementControllingArea
resultElementFiscalYearVariant
resultElementUserLocalDate
Ledger			Ledger in General Ledger Accounting
CompanyCode	I_GLAccountYearToDateBalanceC	CompanyCode	Receiver Company Code
LedgerFiscalYear	I_GLAccountYearToDateBalanceC	LedgerFiscalYear	Fiscal Year of Ledger
FiscalYearPeriod	I_GLAccountYearToDateBalanceC	FiscalYearPeriod	Fiscal Year Period
FiscalPeriod	I_GLAccountYearToDateBalanceC	FiscalPeriod	Fiscal Period
FiscalYearVariant	I_GLAccountYearToDateBalanceC	FiscalYearVariant	Fiscal Year Variant
CostCenter	I_GLAccountYearToDateBalanceC	CostCenter	Cost Center
ProfitCenter	I_GLAccountYearToDateBalanceC	ProfitCenter	Profit Center
ControllingArea	I_GLAccountYearToDateBalanceC	ControllingArea	Controlling Area
WBSElementExternalID	I_GLAccountYearToDateBalanceC	WBSElementExternalID	WBS Element External ID
ProjectExternalID	I_GLAccountYearToDateBalanceC	ProjectExternalID	Project External ID
OrderID	I_GLAccountYearToDateBalanceC	OrderID	Order ID
OrderCategory	I_GLAccountYearToDateBalanceC	OrderCategory	Order Category
CostCtrActivityType	I_GLAccountYearToDateBalanceC	CostCtrActivityType	Activity Type
ProjectNetwork	I_GLAccountYearToDateBalanceC	ProjectNetwork	Network Number for Account Assignment
BusinessArea	I_GLAccountYearToDateBalanceC	BusinessArea	Business Area
FunctionalArea	I_GLAccountYearToDateBalanceC	FunctionalArea	Sendr Fctl Area
AccountAssignmentNumber	I_GLAccountYearToDateBalanceC	AccountAssignmentNumber	Account Assignment Number
GLAccountType	I_GLAccountYearToDateBalanceC	GLAccountType	Type of a General Ledger Account
Segment	I_GLAccountYearToDateBalanceC	Segment	Segment for Segmental Reporting
ChartOfAccounts	I_GLAccountYearToDateBalanceC	ChartOfAccounts	Chart of Accounts
GLAccount	I_GLAccountYearToDateBalanceC	GLAccount	General Ledger
SalesOrganization	I_GLAccountYearToDateBalanceC	SalesOrganization	Sales Organization
BusinessTransactionType	I_GLAccountYearToDateBalanceC	BusinessTransactionType	Business Transaction Type
Plant	I_GLAccountYearToDateBalanceC	Plant	Valuation Area
Customer	I_GLAccountYearToDateBalanceC	Customer	Customer Number
Supplier	I_GLAccountYearToDateBalanceC	Supplier	Supplier
CustomerGroup	I_GLAccountYearToDateBalanceC	CustomerGroup	Customer Group
OrganizationDivision	I_GLAccountYearToDateBalanceC	OrganizationDivision	Org. Division
PostingDate	I_GLAccountYearToDateBalanceC	PostingDate	Posting Date for GR
FiscalQuarter	I_GLAccountYearToDateBalanceC	FiscalQuarter	Fiscal Quarter
PostingKey	I_GLAccountYearToDateBalanceC	PostingKey	Posting Key
CompanyCodeCurrency	I_GLAccountYearToDateBalanceC	CompanyCodeCurrency	Company Code Currency
DebitAmountInCoCodeCrcy	I_GLAccountYearToDateBalanceC	DebitAmountInCoCodeCrcy	Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy	I_GLAccountYearToDateBalanceC	CreditAmountInCoCodeCrcy	Credit Amount in Company Code Currency
AmountInCompanyCodeCurrency	I_GLAccountYearToDateBalanceC	AmountInCompanyCodeCurrency	Amount in Company Code Currency
DebitAmountInGlobalCrcy	I_GLAccountYearToDateBalanceC	DebitAmountInGlobalCrcy	Debit Amount in Global Currency
CreditAmountInGlobalCrcy	I_GLAccountYearToDateBalanceC	CreditAmountInGlobalCrcy	Credit Amount in Global Currency
AmountInGlobalCurrency	I_GLAccountYearToDateBalanceC	AmountInGlobalCurrency	Amount in Global Currency
GlobalCurrency	I_GLAccountYearToDateBalanceC	GlobalCurrency	GM Billing Element: Global Currency
DebitAmountInFunctionalCrcy	I_GLAccountYearToDateBalanceC	DebitAmountInFunctionalCrcy	Debit Amount in Functional Currency
CreditAmountInFunctionalCrcy	I_GLAccountYearToDateBalanceC	CreditAmountInFunctionalCrcy	Credit Amount in Functional Currency
AmountInFunctionalCurrency	I_GLAccountYearToDateBalanceC	AmountInFunctionalCurrency	Amount in Functional Currency
FunctionalCurrency	I_GLAccountYearToDateBalanceC	FunctionalCurrency	Functional Currency
BalanceTransactionCurrency	I_GLAccountYearToDateBalanceC	BalanceTransactionCurrency	Balance Transaction Currency
DebitAmountInBalanceTransCrcy	I_GLAccountYearToDateBalanceC	DebitAmountInBalanceTransCrcy	Debit Amount in Balance Transaction Currency
CreditAmountInBalanceTransCrcy	I_GLAccountYearToDateBalanceC	CreditAmountInBalanceTransCrcy	Credit Amount in Balance Transaction Currency
AmountInBalanceTransacCrcy	I_GLAccountYearToDateBalanceC	AmountInBalanceTransacCrcy	Amount in Balance Transaction Currency
TransactionCurrency	I_GLAccountYearToDateBalanceC	TransactionCurrency	Transaction Currency
DebitAmountInTransCrcy	I_GLAccountYearToDateBalanceC	DebitAmountInTransCrcy	Debit Amount in Transaction Currency
CreditAmountInTransCrcy	I_GLAccountYearToDateBalanceC	CreditAmountInTransCrcy	Credit Amount in Transaction Currency
AmountInTransactionCurrency	I_GLAccountYearToDateBalanceC	AmountInTransactionCurrency	Amount in Transaction Currency
FreeDefinedCurrency1	I_GLAccountYearToDateBalanceC	FreeDefinedCurrency1	Freely Defined Currency 1
DebitAmountInFreeDfndCrcy1	I_GLAccountYearToDateBalanceC	DebitAmountInFreeDfndCrcy1	Debit Amount in Free Defined Currency 1
CreditAmountInFreeDfndCrcy1	I_GLAccountYearToDateBalanceC	CreditAmountInFreeDfndCrcy1	Credit Amount in Free Defined Currency 1
AmountInFreeDefinedCurrency1	I_GLAccountYearToDateBalanceC	AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
FreeDefinedCurrency2	I_GLAccountYearToDateBalanceC	FreeDefinedCurrency2	Freely Defined Currency 2
DebitAmountInFreeDfndCrcy2	I_GLAccountYearToDateBalanceC	DebitAmountInFreeDfndCrcy2	Debit Amount in Free Defined Currency 2
CreditAmountInFreeDfndCrcy2	I_GLAccountYearToDateBalanceC	CreditAmountInFreeDfndCrcy2	Credit Amount in Free Defined Currency 2
AmountInFreeDefinedCurrency2	I_GLAccountYearToDateBalanceC	AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
FreeDefinedCurrency3	I_GLAccountYearToDateBalanceC	FreeDefinedCurrency3	Freely Defined Currency 3
DebitAmountInFreeDfndCrcy3	I_GLAccountYearToDateBalanceC	DebitAmountInFreeDfndCrcy3	Debit Amount in Free Defined Currency 3
CreditAmountInFreeDfndCrcy3	I_GLAccountYearToDateBalanceC	CreditAmountInFreeDfndCrcy3	Credit Amount in Free Defined Currency 3
AmountInFreeDefinedCurrency3	I_GLAccountYearToDateBalanceC	AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
FreeDefinedCurrency4	I_GLAccountYearToDateBalanceC	FreeDefinedCurrency4	Freely Defined Currency 4
DebitAmountInFreeDfndCrcy4	I_GLAccountYearToDateBalanceC	DebitAmountInFreeDfndCrcy4	Debit Amount in Free Defined Currency 4
CreditAmountInFreeDfndCrcy4	I_GLAccountYearToDateBalanceC	CreditAmountInFreeDfndCrcy4	Credit Amount in Free Defined Currency 4
AmountInFreeDefinedCurrency4	I_GLAccountYearToDateBalanceC	AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
FreeDefinedCurrency5	I_GLAccountYearToDateBalanceC	FreeDefinedCurrency5	Freely Defined Currency 5
DebitAmountInFreeDfndCrcy5	I_GLAccountYearToDateBalanceC	DebitAmountInFreeDfndCrcy5	Debit Amount in Free Defined Currency 5
CreditAmountInFreeDfndCrcy5	I_GLAccountYearToDateBalanceC	CreditAmountInFreeDfndCrcy5	Credit Amount in Free Defined Currency 5
AmountInFreeDefinedCurrency5	I_GLAccountYearToDateBalanceC	AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
FreeDefinedCurrency6	I_GLAccountYearToDateBalanceC	FreeDefinedCurrency6	Freely Defined Currency 6
DebitAmountInFreeDfndCrcy6	I_GLAccountYearToDateBalanceC	DebitAmountInFreeDfndCrcy6	Debit Amount in Free Defined Currency 6
CreditAmountInFreeDfndCrcy6	I_GLAccountYearToDateBalanceC	CreditAmountInFreeDfndCrcy6	Credit Amount in Free Defined Currency 6
AmountInFreeDefinedCurrency6	I_GLAccountYearToDateBalanceC	AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
FreeDefinedCurrency7	I_GLAccountYearToDateBalanceC	FreeDefinedCurrency7	Freely Defined Currency 7
DebitAmountInFreeDfndCrcy7	I_GLAccountYearToDateBalanceC	DebitAmountInFreeDfndCrcy7	Debit Amount in Free Defined Currency 7
CreditAmountInFreeDfndCrcy7	I_GLAccountYearToDateBalanceC	CreditAmountInFreeDfndCrcy7	Credit Amount in Free Defined Currency 7
AmountInFreeDefinedCurrency7	I_GLAccountYearToDateBalanceC	AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
FreeDefinedCurrency8	I_GLAccountYearToDateBalanceC	FreeDefinedCurrency8	Freely Defined Currency 8
DebitAmountInFreeDfndCrcy8	I_GLAccountYearToDateBalanceC	DebitAmountInFreeDfndCrcy8	Debit Amount in Free Defined Currency 8
CreditAmountInFreeDfndCrcy8	I_GLAccountYearToDateBalanceC	CreditAmountInFreeDfndCrcy8	Credit Amount in Free Defined Currency 8
AmountInFreeDefinedCurrency8	I_GLAccountYearToDateBalanceC	AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
CustomerSupplierCountry	I_GLAccountYearToDateBalanceC	CustomerSupplierCountry	Customer or Supplier Country/Region
CustomerSupplierIndustry	I_GLAccountYearToDateBalanceC	CustomerSupplierIndustry	Customer Supplier Industry

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_GLAccountYTDBalanceQ.
-- 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_BusinessUser : syuname, P_ControllingArea : fis_kokrs, P_FiscalYearVariant : fins_periv, P_KeyDate : vdm_v_key_date

CREATE VIEW C_GLAccountYTDBalanceQ AS
SELECT
  resultElement: 'ControllingArea' AS resultElementControllingArea,
  resultElement: 'FiscalYearVariant' AS resultElementFiscalYearVariant,
  resultElement: 'UserLocalDate' AS resultElementUserLocalDate,
  binding: [ { targetElement : 'UserID' , type : #PARAMETER, value : 'P_BusinessUser' AS Ledger,
  I_GLAccountYearToDateBalanceC.CompanyCode AS CompanyCode,
  I_GLAccountYearToDateBalanceC.LedgerFiscalYear AS LedgerFiscalYear,
  I_GLAccountYearToDateBalanceC.FiscalYearPeriod AS FiscalYearPeriod,
  I_GLAccountYearToDateBalanceC.FiscalPeriod AS FiscalPeriod,
  I_GLAccountYearToDateBalanceC.FiscalYearVariant AS FiscalYearVariant,
  I_GLAccountYearToDateBalanceC.CostCenter AS CostCenter,
  I_GLAccountYearToDateBalanceC.ProfitCenter AS ProfitCenter,
  I_GLAccountYearToDateBalanceC.ControllingArea AS ControllingArea,
  I_GLAccountYearToDateBalanceC.WBSElementExternalID AS WBSElementExternalID,
  I_GLAccountYearToDateBalanceC.ProjectExternalID AS ProjectExternalID,
  I_GLAccountYearToDateBalanceC.OrderID AS OrderID,
  I_GLAccountYearToDateBalanceC.OrderCategory AS OrderCategory,
  I_GLAccountYearToDateBalanceC.CostCtrActivityType AS CostCtrActivityType,
  I_GLAccountYearToDateBalanceC.ProjectNetwork AS ProjectNetwork,
  I_GLAccountYearToDateBalanceC.BusinessArea AS BusinessArea,
  I_GLAccountYearToDateBalanceC.FunctionalArea AS FunctionalArea,
  I_GLAccountYearToDateBalanceC.AccountAssignmentNumber AS AccountAssignmentNumber,
  I_GLAccountYearToDateBalanceC.GLAccountType AS GLAccountType,
  I_GLAccountYearToDateBalanceC.Segment AS Segment,
  I_GLAccountYearToDateBalanceC.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccountYearToDateBalanceC.GLAccount AS GLAccount,
  I_GLAccountYearToDateBalanceC.SalesOrganization AS SalesOrganization,
  I_GLAccountYearToDateBalanceC.BusinessTransactionType AS BusinessTransactionType,
  I_GLAccountYearToDateBalanceC.Plant AS Plant,
  I_GLAccountYearToDateBalanceC.Customer AS Customer,
  I_GLAccountYearToDateBalanceC.Supplier AS Supplier,
  I_GLAccountYearToDateBalanceC.CustomerGroup AS CustomerGroup,
  I_GLAccountYearToDateBalanceC.OrganizationDivision AS OrganizationDivision,
  I_GLAccountYearToDateBalanceC.PostingDate AS PostingDate,
  I_GLAccountYearToDateBalanceC.FiscalQuarter AS FiscalQuarter,
  I_GLAccountYearToDateBalanceC.PostingKey AS PostingKey,
  I_GLAccountYearToDateBalanceC.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GLAccountYearToDateBalanceC.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  I_GLAccountYearToDateBalanceC.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  I_GLAccountYearToDateBalanceC.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_GLAccountYearToDateBalanceC.DebitAmountInGlobalCrcy AS DebitAmountInGlobalCrcy,
  I_GLAccountYearToDateBalanceC.CreditAmountInGlobalCrcy AS CreditAmountInGlobalCrcy,
  I_GLAccountYearToDateBalanceC.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  I_GLAccountYearToDateBalanceC.GlobalCurrency AS GlobalCurrency,
  I_GLAccountYearToDateBalanceC.DebitAmountInFunctionalCrcy AS DebitAmountInFunctionalCrcy,
  I_GLAccountYearToDateBalanceC.CreditAmountInFunctionalCrcy AS CreditAmountInFunctionalCrcy,
  I_GLAccountYearToDateBalanceC.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  I_GLAccountYearToDateBalanceC.FunctionalCurrency AS FunctionalCurrency,
  I_GLAccountYearToDateBalanceC.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  I_GLAccountYearToDateBalanceC.DebitAmountInBalanceTransCrcy AS DebitAmountInBalanceTransCrcy,
  I_GLAccountYearToDateBalanceC.CreditAmountInBalanceTransCrcy AS CreditAmountInBalanceTransCrcy,
  I_GLAccountYearToDateBalanceC.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  I_GLAccountYearToDateBalanceC.TransactionCurrency AS TransactionCurrency,
  I_GLAccountYearToDateBalanceC.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
  I_GLAccountYearToDateBalanceC.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
  I_GLAccountYearToDateBalanceC.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  I_GLAccountYearToDateBalanceC.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  I_GLAccountYearToDateBalanceC.DebitAmountInFreeDfndCrcy1 AS DebitAmountInFreeDfndCrcy1,
  I_GLAccountYearToDateBalanceC.CreditAmountInFreeDfndCrcy1 AS CreditAmountInFreeDfndCrcy1,
  I_GLAccountYearToDateBalanceC.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  I_GLAccountYearToDateBalanceC.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  I_GLAccountYearToDateBalanceC.DebitAmountInFreeDfndCrcy2 AS DebitAmountInFreeDfndCrcy2,
  I_GLAccountYearToDateBalanceC.CreditAmountInFreeDfndCrcy2 AS CreditAmountInFreeDfndCrcy2,
  I_GLAccountYearToDateBalanceC.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  I_GLAccountYearToDateBalanceC.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  I_GLAccountYearToDateBalanceC.DebitAmountInFreeDfndCrcy3 AS DebitAmountInFreeDfndCrcy3,
  I_GLAccountYearToDateBalanceC.CreditAmountInFreeDfndCrcy3 AS CreditAmountInFreeDfndCrcy3,
  I_GLAccountYearToDateBalanceC.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  I_GLAccountYearToDateBalanceC.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  I_GLAccountYearToDateBalanceC.DebitAmountInFreeDfndCrcy4 AS DebitAmountInFreeDfndCrcy4,
  I_GLAccountYearToDateBalanceC.CreditAmountInFreeDfndCrcy4 AS CreditAmountInFreeDfndCrcy4,
  I_GLAccountYearToDateBalanceC.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  I_GLAccountYearToDateBalanceC.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  I_GLAccountYearToDateBalanceC.DebitAmountInFreeDfndCrcy5 AS DebitAmountInFreeDfndCrcy5,
  I_GLAccountYearToDateBalanceC.CreditAmountInFreeDfndCrcy5 AS CreditAmountInFreeDfndCrcy5,
  I_GLAccountYearToDateBalanceC.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  I_GLAccountYearToDateBalanceC.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  I_GLAccountYearToDateBalanceC.DebitAmountInFreeDfndCrcy6 AS DebitAmountInFreeDfndCrcy6,
  I_GLAccountYearToDateBalanceC.CreditAmountInFreeDfndCrcy6 AS CreditAmountInFreeDfndCrcy6,
  I_GLAccountYearToDateBalanceC.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  I_GLAccountYearToDateBalanceC.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  I_GLAccountYearToDateBalanceC.DebitAmountInFreeDfndCrcy7 AS DebitAmountInFreeDfndCrcy7,
  I_GLAccountYearToDateBalanceC.CreditAmountInFreeDfndCrcy7 AS CreditAmountInFreeDfndCrcy7,
  I_GLAccountYearToDateBalanceC.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  I_GLAccountYearToDateBalanceC.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  I_GLAccountYearToDateBalanceC.DebitAmountInFreeDfndCrcy8 AS DebitAmountInFreeDfndCrcy8,
  I_GLAccountYearToDateBalanceC.CreditAmountInFreeDfndCrcy8 AS CreditAmountInFreeDfndCrcy8,
  I_GLAccountYearToDateBalanceC.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  I_GLAccountYearToDateBalanceC.CustomerSupplierCountry AS CustomerSupplierCountry,
  I_GLAccountYearToDateBalanceC.CustomerSupplierIndustry AS CustomerSupplierIndustry
FROM I_GLAccountYearToDateBalanceC
;

Depth:

C_GLAccountYTDBalanceQ view

I_GLAccountYearToDateBalanceC view_entity