What is C_ARAgingGridGenLedgerQry in SAP S/4HANA?

C_ARAgingGridGenLedgerQry is a consumption CDS view in SAP S/4HANA. G/L Perspective of AR Aging Grid - Query It contains 69 fields.

Which tables does C_ARAgingGridGenLedgerQry read from?

C_ARAgingGridGenLedgerQry reads data from: I_ARAgingGridGenLedgerCube.

What VDM layer is C_ARAgingGridGenLedgerQry?

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

C_ARAgingGridGenLedgerQry

DDL: C_ARAGINGGRIDGENLEDGERQRY Type: view CONSUMPTION

69 Fields 1 Data Sources

G/L Perspective of AR Aging Grid - Query

C_ARAgingGridGenLedgerQry (Consumption)

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

Financial Operations

C_ARAgingGridGenLedgerQry is a Consumption CDS View that provides data about "G/L Perspective of AR Aging Grid - Query" in SAP S/4HANA. It reads from 1 data source (I_ARAgingGridGenLedgerCube) and exposes 69 fields with key fields FiscalYear, AccountingDocument, LedgerGLLineItem.

SAP Help Documentation

Category	CDS Views for Receivables Management
Data Category	Query
Corresponding DataSource	2CCARGRIDGLQUERY

Purpose
This CDS view provides you with an overview of the overdue receivables and receivables that will become due in the future based on the key date you enter. You can use the CDS view for many different reports, such as creating an aggregated view of the receivables per overdue interval and future due interval for an account, or a drill down to individual open receivable items. This CDS view provides the data to answer the following business questions, for example: How high are the overall total receivables? Which customers have total receivables? What are the open receivable items for a customer? Note that this CDS view cannot be accessed directly using SQL or custom CDS views. It receives its data from the G/L Perspective of AR Aging Grid - Cube ( I_ARAgingGridGenLedgerCube ). This CDS view can be used in the Custom Analytical Queries key user app. 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 The authorization check is handled through the CDS View G/L Perspective of AR Aging Grid - Cube ( I_ARAgingGridGenLedgerCube ).

Structure
Parameters The parameters of the CDS view are as follows: P_KeyDate : This parameter is used to enter the key date (as of today or in the past) for which the open receivables and future due receivables are determined. P_OverdueInterval1Days , P_OverdueInterval2Days , P_OverdueInterval3Days , P_OverdueInterval4Days , P_OverdueInterval5Days , P_OverdueInterval6Days : These parameters are used to specify the intervals for which you want to see overdue receivables. P_FutureDueInterval1Days , P_FutureDueInterval2Days , P_FutureDueInterval3Days : These parameters are used to specify the intervals for which you want to see future due receivables. Fields Used for Filtering The main filters are as follows: CompanyCode : This field is mandatory. It is used to specify the company code for which you want to see of overdue receivables and receivables due in the future. Note that you can enter more than one company code, provided that they all have the same local currency. Further Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute Customer Customer Attribute ProfitCenter Profit Center Attribute

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Financial Operations
Application Component	FI-AR-IS
Capabilities	Analytical Query
Package	Financial Operations for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view provides you with an overview of the overdue receivables and receivables that will become due in the future based on the key date you enter. You can use the CDS view for many different reports, such as creating an aggregated view of the receivables per overdue interval and future due interval for an account, or a drill down to individual open receivable items.</p> <p>This CDS view provides the data to answer the following business questions, for example:</p> <ul> <li><p>How high are the overall total receivables?</p></li> <li><p>Which customers have total receivables?</p></li> <li><p>What are the open receivable items for a customer?</p></li> </ul> <p>Note that this CDS view cannot be accessed directly using SQL or custom CDS views. It receives its data from the G/L Perspective of AR Aging Grid - Cube (I_ARAgingGridGenLedgerCube).</p> <p>This CDS view can be used in the Custom Analytical Queries key user app.</p> <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 Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition 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_ARAgingGridGenLedgerCube	I_ARAgingGridGenLedgerCube	from

Parameters (22)

Name	Type	Default
P_KeyDate	vdm_v_key_date
P_OverdueInterval1Days	far_overdue_interval1
P_OverdueInterval2Days	far_overdue_interval2
P_OverdueInterval3Days	far_overdue_interval3
P_OverdueInterval4Days	far_overdue_interval4
P_OverdueInterval5Days	far_overdue_interval5
P_OverdueInterval6Days	far_overdue_interval6
P_FutureDueInterval1Days	far_future_due_interval1
P_FutureDueInterval2Days	far_future_due_interval2
P_FutureDueInterval3Days	far_future_due_interval3
P_LeadingLedger	fins_ledger
P_OverdueInterval1Label	far_araginggrid_interval_label
P_OverdueInterval2Label	far_araginggrid_interval_label
P_OverdueInterval3Label	far_araginggrid_interval_label
P_OverdueInterval4Label	far_araginggrid_interval_label
P_OverdueInterval5Label	far_araginggrid_interval_label
P_OverdueInterval6Label	far_araginggrid_interval_label
P_OverdueInterval7Label	far_araginggrid_interval_label
P_FutureDueInterval1Label	far_araginggrid_interval_label
P_FutureDueInterval2Label	far_araginggrid_interval_label
P_FutureDueInterval3Label	far_araginggrid_interval_label
P_FutureDueInterval4Label	far_araginggrid_interval_label

Annotations (17)

Name	Value	Level
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.modelingPattern	#ANALYTICAL_QUERY	view
EndUserText.label	G/L Perspective of AR Aging Grid - Query	view
Analytics.query	true	view
Analytics.settings.maxProcessingEffort	#HIGH	view
Analytics.variableCheck.implementedBy	ABAP:CL_FAR_AGINGGRID_CCCRCY_CHECK	view
OData.publish	false	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
AbapCatalog.sqlViewName	CARGRIDGLQUERY	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (69)

Key	Field	Source Field	Description
	lookupEntityF_LeadingLedger
	resultElementOverdueIntervalLabel
	resultElementOverdueIntervalLabel
	resultElementOverdueIntervalLabel
	resultElementOverdueIntervalLabel
	resultElementOverdueIntervalLabel
	resultElementOverdueIntervalLabel
	resultElementOverdueIntervalLabel
	resultElementFutureDueIntervalLabel
	resultElementFutureDueIntervalLabel
	resultElementFutureDueIntervalLabel
	resultElementFutureDueIntervalLabel
	P_KeyDate
	P_OverdueInterval1Days
	P_OverdueInterval2Days
	P_OverdueInterval3Days
	P_OverdueInterval4Days
	P_OverdueInterval5Days
	P_OverdueInterval6Days
	P_FutureDueInterval1Days
	P_FutureDueInterval2Days
	P_FutureDueInterval3Days
	P_LeadingLedgerkeyCompanyCode
KEY	FiscalYear	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	LedgerGLLineItem	General Ledger Journal Entry Line Item
	AccountingDocumentItem	AccountingDocumentItem	Journal Entry Posting View Item
	Customer	Customer	Customer Number
	GLAccount	GLAccount	General Ledger
	SpecialGLCode	SpecialGLCode	Special G/L Indicator
	ProfitCenter	ProfitCenter	Profit Center
	FunctionalArea	FunctionalArea	Sendr Fctl Area
	BusinessArea	BusinessArea	Business Area
	Segment	Segment	Segment for Segmental Reporting
	BillingDocument	BillingDocument	Billing Document
	AssignmentReference	AssignmentReference	Assignment Reference
	CustomerCountry	CustomerCountry	Customer Country/Region
	CustomerRegion	CustomerRegion	Region (Customer)
	AccountingClerk	AccountingClerk	Accounting Clerk
	ReconciliationAccount	ReconciliationAccount	Reconciliation Account in General Ledger
	CustomerAccountGroup	CustomerAccountGroup	Customer Account Group
	CustomerClassification	CustomerClassification	Customer Classification
	CustomerCorporateGroup	CustomerCorporateGroup	Customer Corporate Group
	CustomerAccountNote	CustomerAccountNote	Account Memo
	Reference1IDByBusinessPartner	Reference1IDByBusinessPartner	ID of Reference 1 by Business Partner
	Reference2IDByBusinessPartner	Reference2IDByBusinessPartner	ID of Reference 2 by Business Partner
	Reference3IDByBusinessPartner	Reference3IDByBusinessPartner	ID of Reference 3 by Business Partner
	PaymentMethod	PaymentMethod	Payment Method
	CompanyCodeCurrency	CompanyCodeCurrency	Company Code Currency
	FinancialAccountType	FinancialAccountType	Fin. Account Type
	CompanyCodeCountry	CompanyCodeCountry	Company Code Country/Region
	ControllingArea	ControllingArea	Controlling Area
	ChartOfAccounts	ChartOfAccounts	Chart of Accounts
	OverdueIntvl7AmtInCoCodeCrcy	OverdueIntvl7AmtInCoCodeCrcy	Amount in 7th Overdue Period (Company Currency)
	OverdueIntvl6AmtInCoCodeCrcy	OverdueIntvl6AmtInCoCodeCrcy	Amount in 6th Overdue Period (Company Currency)
	OverdueIntvl5AmtInCoCodeCrcy	OverdueIntvl5AmtInCoCodeCrcy	Amount in 5th Overdue Period (Company Currency)
	OverdueIntvl4AmtInCoCodeCrcy	OverdueIntvl4AmtInCoCodeCrcy	Amount in 4th Overdue Period (Company Currency)
	OverdueIntvl3AmtInCoCodeCrcy	OverdueIntvl3AmtInCoCodeCrcy	Amount in 3rd Overdue Period (Company Currency)
	OverdueIntvl2AmtInCoCodeCrcy	OverdueIntvl2AmtInCoCodeCrcy	Amount in 2nd Overdue Period (Company Currency)
	OverdueIntvl1AmtInCoCodeCrcy	OverdueIntvl1AmtInCoCodeCrcy	Amount in 1st Overdue Period (Company Currency)
	DueAtKeyDateAmtInCoCodeCrcy	DueAtKeyDateAmtInCoCodeCrcy	Amount in Company Currency due at Key Date
	FutureDueIntvl1AmtInCoCodeCrcy	FutureDueIntvl1AmtInCoCodeCrcy	Amount in 1st Future Due Period (Company Currency)
	FutureDueIntvl2AmtInCoCodeCrcy	FutureDueIntvl2AmtInCoCodeCrcy	Amount in 2nd Future Due Period (Company Currency)
	FutureDueIntvl3AmtInCoCodeCrcy	FutureDueIntvl3AmtInCoCodeCrcy	Amount in 3rd Future Due Period (Company Currency)
	FutureDueIntvl4AmtInCoCodeCrcy	FutureDueIntvl4AmtInCoCodeCrcy	Amount in 4th Future Due Period (Company Currency)
	OverdueAmtInCoCodeCrcy	OverdueAmtInCoCodeCrcy	Overdue Amount in Company Currency
	NotOverdueAmtInCoCodeCrcy	NotOverdueAmtInCoCodeCrcy	Not Overdue Amount in Company Currency
	FutureDueAmtInCoCodeCrcy	FutureDueAmtInCoCodeCrcy	Future Due Amount in Company Currency
	AmountInCompanyCodeCurrency	AmountInCompanyCodeCurrency	Total Open Receivables Amount in Company Currency

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_ARAgingGridGenLedgerQry.
-- 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_KeyDate : vdm_v_key_date, P_OverdueInterval1Days : far_overdue_interval1, P_OverdueInterval2Days : far_overdue_interval2, P_OverdueInterval3Days : far_overdue_interval3, P_OverdueInterval4Days : far_overdue_interval4, P_OverdueInterval5Days : far_overdue_interval5, P_OverdueInterval6Days : far_overdue_interval6, P_FutureDueInterval1Days : far_future_due_interval1, P_FutureDueInterval2Days : far_future_due_interval2, P_FutureDueInterval3Days : far_future_due_interval3, P_LeadingLedger : fins_ledger, P_OverdueInterval1Label : far_araginggrid_interval_label, P_OverdueInterval2Label : far_araginggrid_interval_label, P_OverdueInterval3Label : far_araginggrid_interval_label, P_OverdueInterval4Label : far_araginggrid_interval_label, P_OverdueInterval5Label : far_araginggrid_interval_label, P_OverdueInterval6Label : far_araginggrid_interval_label, P_OverdueInterval7Label : far_araginggrid_interval_label, P_FutureDueInterval1Label : far_araginggrid_interval_label, P_FutureDueInterval2Label : far_araginggrid_interval_label, P_FutureDueInterval3Label : far_araginggrid_interval_label, P_FutureDueInterval4Label : far_araginggrid_interval_label

CREATE VIEW C_ARAgingGridGenLedgerQry AS
SELECT
  lookupEntity: 'F_LeadingLedger' AS lookupEntityF_LeadingLedger,
  resultElement: 'OverdueIntervalLabel' AS resultElementOverdueIntervalLabel,
  resultElement: 'FutureDueIntervalLabel' AS resultElementFutureDueIntervalLabel,
  binding: [{ targetParameter: 'P_FutureDueInterval3Days', type: #PARAMETER, value: 'P_FutureDueInterval3Days' AS P_KeyDate,
  P_OverdueInterval1Days: $parameters.P_OverdueInterval1Days AS P_OverdueInterval1Days,
  P_OverdueInterval2Days: $parameters.P_OverdueInterval2Days AS P_OverdueInterval2Days,
  P_OverdueInterval3Days: $parameters.P_OverdueInterval3Days AS P_OverdueInterval3Days,
  P_OverdueInterval4Days: $parameters.P_OverdueInterval4Days AS P_OverdueInterval4Days,
  P_OverdueInterval5Days: $parameters.P_OverdueInterval5Days AS P_OverdueInterval5Days,
  P_OverdueInterval6Days: $parameters.P_OverdueInterval6Days AS P_OverdueInterval6Days,
  P_FutureDueInterval1Days: $parameters.P_FutureDueInterval1Days AS P_FutureDueInterval1Days,
  P_FutureDueInterval2Days: $parameters.P_FutureDueInterval2Days AS P_FutureDueInterval2Days,
  P_FutureDueInterval3Days: $parameters.P_FutureDueInterval3Days AS P_FutureDueInterval3Days,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  AccountingDocumentItem,
  Customer,
  GLAccount,
  SpecialGLCode,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  Segment,
  BillingDocument,
  AssignmentReference,
  CustomerCountry,
  CustomerRegion,
  AccountingClerk,
  ReconciliationAccount,
  CustomerAccountGroup,
  CustomerClassification,
  CustomerCorporateGroup,
  CustomerAccountNote,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  PaymentMethod,
  CompanyCodeCurrency,
  FinancialAccountType,
  CompanyCodeCountry,
  ControllingArea,
  ChartOfAccounts,
  OverdueIntvl7AmtInCoCodeCrcy,
  OverdueIntvl6AmtInCoCodeCrcy,
  OverdueIntvl5AmtInCoCodeCrcy,
  OverdueIntvl4AmtInCoCodeCrcy,
  OverdueIntvl3AmtInCoCodeCrcy,
  OverdueIntvl2AmtInCoCodeCrcy,
  OverdueIntvl1AmtInCoCodeCrcy,
  DueAtKeyDateAmtInCoCodeCrcy,
  FutureDueIntvl1AmtInCoCodeCrcy,
  FutureDueIntvl2AmtInCoCodeCrcy,
  FutureDueIntvl3AmtInCoCodeCrcy,
  FutureDueIntvl4AmtInCoCodeCrcy,
  OverdueAmtInCoCodeCrcy,
  NotOverdueAmtInCoCodeCrcy,
  FutureDueAmtInCoCodeCrcy,
  AmountInCompanyCodeCurrency
FROM I_ARAgingGridGenLedgerCube
;

Depth:

C_ARAgingGridGenLedgerQry view

I_ARAgingGridGenLedgerCube view_entity