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 86 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

86 Fields 1 Data Sources

Year-to-Date Balances

C_GLAccountYTDBalanceQ (Consumption)

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

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 86 fields.

SAP API Hub

State	C1
Line of Business	Accounting and Financial Close
Application Component	FI-FIO-GL
Capabilities	Analytical Query
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
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 (86)

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

Depth:

C_GLAccountYTDBalanceQ view

I_GLAccountYearToDateBalanceC view