What is C_GRIRProcDigestInGlobalCrcy in SAP S/4HANA?

C_GRIRProcDigestInGlobalCrcy is a consumption CDS view in SAP S/4HANA. GR/IR Reconciliation Process Digest in Global Currency It contains 66 fields.

Which tables does C_GRIRProcDigestInGlobalCrcy read from?

C_GRIRProcDigestInGlobalCrcy reads data from: P_GRIRProcDigestInGlobalCrcy.

What VDM layer is C_GRIRProcDigestInGlobalCrcy?

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

C_GRIRProcDigestInGlobalCrcy

DDL: C_GRIRPROCDIGESTINGLOBALCRCY Type: view_entity CONSUMPTION Package: FINS_FIS_FICO_APPS

66 Fields 1 Data Sources 9 Associations 1 OData Services

GR/IR Reconciliation Process Digest in Global Currency

C_GRIRProcDigestInGlobalCrcy is a Consumption CDS View that provides data about "GR/IR Reconciliation Process Digest in Global Currency" in SAP S/4HANA. It reads from 1 data source (P_GRIRProcDigestInGlobalCrcy) and exposes 66 fields with key fields CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 9 associations to related views. It is exposed through 1 OData service (ASQL_F3303). Part of development package FINS_FIS_FICO_APPS.

Data Sources (1)

Source	Alias	Join Type
P_GRIRProcDigestInGlobalCrcy	P_GRIRProcDigestInGlobalCrcy	from

Associations (9)

Cardinality	Target	Alias	Condition
[0..*]	I_ChartOfAccountsText	_ChartOfAccountsText	`$projection.ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts`
[0..1]	I_ControllingArea	_ControllingAreaText	`$projection.ControllingArea = _ControllingAreaText.ControllingArea`
[0..*]	I_FiscalPeriodForCoCodeText	_FiscalPeriodForCoCodeText	`$projection.CompanyCode = _FiscalPeriodForCoCodeText.CompanyCode and $projection.FiscalYear = _FiscalPeriodForCoCodeText.FiscalYear and $projection.FiscalPeriod = _FiscalPeriodForCoCodeText.FiscalPeriod`
[0..*]	I_GRIRProcessStatusText	_GRIRProcessStatusText	`$projection.GRIRClearingProcessStatus = _GRIRProcessStatusText.GRIRClearingProcessStatus`
[0..*]	I_GRIRProcessPriorityText	_GRIRProcessPriorityText	`$projection.GRIRClearingProcessPriority = _GRIRProcessPriorityText.GRIRClearingProcessPriority`
[0..*]	I_GRIRProcessRootCauseText	_GRIRProcessRootCauseText	`$projection.GRIRClearingProcessRootCause = _GRIRProcessRootCauseText.GRIRClearingProcessRootCause`
[0..*]	I_CalendarMonthText	_CalendarMonthText	`$projection.CalendarMonth = _CalendarMonthText.CalendarMonth`
[0..*]	I_MaterialGroupText	_MaterialGroupText	`$projection.MaterialGroup = _MaterialGroupText.MaterialGroup`
[0..*]	I_GLAccountText	_GLAccountText	`$projection.ChartOfAccounts = _GLAccountText.ChartOfAccounts and $projection.GLAccount = _GLAccountText.GLAccount`

Annotations (9)

Name	Value	Level
AbapCatalog.entityBuffer.definitionAllowed	false	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	GR/IR Reconciliation Process Digest in Global Currency	view
VDM.viewType	#CONSUMPTION	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view

OData Services (1)

Service	Binding	Version	Contract	Release
ASQL_F3303	ASQL_F3303		C2	NOT_RELEASED

Fields (66)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	P_GRIRProcDigestInGlobalCrcy	CompanyCode	Receiver Company Code
KEY	FiscalYear	P_GRIRProcDigestInGlobalCrcy	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	P_GRIRProcDigestInGlobalCrcy	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	P_GRIRProcDigestInGlobalCrcy	LedgerGLLineItem	Journal Entry Item
	PurchasingDocument	P_GRIRProcDigestInGlobalCrcy	PurchasingDocument	Purchasing Document
	PurchasingDocumentItem	P_GRIRProcDigestInGlobalCrcy	PurchasingDocumentItem	Purchasing Doc. Item
	Plant	P_GRIRProcDigestInGlobalCrcy	Plant	Valuation Area
	PlantName	P_GRIRProcDigestInGlobalCrcy	PlantName	Plant Name
	PurchasingOrganization	P_GRIRProcDigestInGlobalCrcy	PurchasingOrganization	Purchasing Organization
	PurchasingOrganizationName
	PurchasingGroup	P_GRIRProcDigestInGlobalCrcy	PurchasingGroup	Purchasing Group
	PurchasingGroupName
	MaterialGroup	P_GRIRProcDigestInGlobalCrcy	MaterialGroup	Product Group
	ControllingArea	P_GRIRProcDigestInGlobalCrcy	ControllingArea	Controlling Area
	ProfitCenter	P_GRIRProcDigestInGlobalCrcy	ProfitCenter	Profit Center
	ProfitCenterName
	FiscalPeriod	P_GRIRProcDigestInGlobalCrcy	FiscalPeriod	Tax period
	PostingDate	P_GRIRProcDigestInGlobalCrcy	PostingDate	Posting Date for GR
	GLAccount	P_GRIRProcDigestInGlobalCrcy	GLAccount	General Ledger
	ChartOfAccounts	P_GRIRProcDigestInGlobalCrcy	ChartOfAccounts	Node Class
	CompanyCodeName	P_GRIRProcDigestInGlobalCrcy	CompanyCodeName	Company Name
	CreatedByUser	P_GRIRProcDigestInGlobalCrcy	CreatedByUser	User Name
	Supplier	P_GRIRProcDigestInGlobalCrcy	Supplier	Supplier
	SupplierName	P_GRIRProcDigestInGlobalCrcy	SupplierName	Supplier Name
	GRIRClearingProcessStatus
	GRIRClearingProcessPriority
	GRIRClearingProcessRootCause
	ResponsibleDepartment
	ResponsiblePerson
	AccountAssignmentCategory	P_GRIRProcDigestInGlobalCrcy	AccountAssignmentCategory	Acct Assgmt Cat
	DueDays	P_GRIRProcDigestInGlobalCrcy	DueDays	Processing Time
	CalendarYear	P_GRIRProcDigestInGlobalCrcy	CalendarYear	Year
	YearMonth	P_GRIRProcDigestInGlobalCrcy	YearMonth	Year Month
	CalendarMonth	P_GRIRProcDigestInGlobalCrcy	CalendarMonth	Calendar Month
	GlobalCurrency	P_GRIRProcDigestInGlobalCrcy	GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency	P_GRIRProcDigestInGlobalCrcy	AmountInGlobalCurrency	Amount in Global Currency
	BalanceAbsoluteAmtInGlobalCrcy	P_GRIRProcDigestInGlobalCrcy	BalanceAbsoluteAmtInGlobalCrcy
	DebitAmountInGlobalCrcy	P_GRIRProcDigestInGlobalCrcy	DebitAmountInGlobalCrcy
	CreditAmountInGlobalCrcy	P_GRIRProcDigestInGlobalCrcy	CreditAmountInGlobalCrcy
	_CompanyCode		_CompanyCode
	_FiscalYear		_FiscalYear
	_JournalEntry		_JournalEntry
	_PurchasingDocumentItem		_PurchasingDocumentItem
	_GLAccountInChartOfAccounts		_GLAccountInChartOfAccounts
	_GRIRProcess		_GRIRProcess
	_PurchasingDocument		_PurchasingDocument
	_ChartOfAccounts		_ChartOfAccounts
	_AccountingDocument		_AccountingDocument
	_ControllingArea		_ControllingArea
	_GlobalCurrency		_GlobalCurrency
	_CalendarMonth		_CalendarMonth
	_Plant		_Plant
	_PurchasingOrganization		_PurchasingOrganization
	_PurchasingGroup		_PurchasingGroup
	_MaterialGroup		_MaterialGroup
	_ProfitCenter		_ProfitCenter
	_Supplier		_Supplier
	_ChartOfAccountsText		_ChartOfAccountsText
	_ControllingAreaText		_ControllingAreaText
	_FiscalPeriodForCoCodeText		_FiscalPeriodForCoCodeText
	_GRIRProcessStatusText		_GRIRProcessStatusText
	_GRIRProcessPriorityText		_GRIRProcessPriorityText
	_GRIRProcessRootCauseText		_GRIRProcessRootCauseText
	_CalendarMonthText		_CalendarMonthText
	_MaterialGroupText		_MaterialGroupText
	_GLAccountText		_GLAccountText

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_GRIRProcDigestInGlobalCrcy.
-- 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.

CREATE VIEW C_GRIRProcDigestInGlobalCrcy AS
SELECT
  P_GRIRProcDigestInGlobalCrcy.CompanyCode AS CompanyCode,
  P_GRIRProcDigestInGlobalCrcy.FiscalYear AS FiscalYear,
  P_GRIRProcDigestInGlobalCrcy.AccountingDocument AS AccountingDocument,
  P_GRIRProcDigestInGlobalCrcy.LedgerGLLineItem AS LedgerGLLineItem,
  P_GRIRProcDigestInGlobalCrcy.PurchasingDocument AS PurchasingDocument,
  P_GRIRProcDigestInGlobalCrcy.PurchasingDocumentItem AS PurchasingDocumentItem,
  P_GRIRProcDigestInGlobalCrcy.Plant AS Plant,
  P_GRIRProcDigestInGlobalCrcy.PlantName AS PlantName,
  P_GRIRProcDigestInGlobalCrcy.PurchasingOrganization AS PurchasingOrganization,
  P_GRIRProcDigestInGlobalCrcy._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  P_GRIRProcDigestInGlobalCrcy.PurchasingGroup AS PurchasingGroup,
  P_GRIRProcDigestInGlobalCrcy._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  P_GRIRProcDigestInGlobalCrcy.MaterialGroup AS MaterialGroup,
  P_GRIRProcDigestInGlobalCrcy.ControllingArea AS ControllingArea,
  P_GRIRProcDigestInGlobalCrcy.ProfitCenter AS ProfitCenter,
  P_GRIRProcDigestInGlobalCrcy._ProfitCenter[1:ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date]._Text[1:Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  P_GRIRProcDigestInGlobalCrcy.FiscalPeriod AS FiscalPeriod,
  P_GRIRProcDigestInGlobalCrcy.PostingDate AS PostingDate,
  P_GRIRProcDigestInGlobalCrcy.GLAccount AS GLAccount,
  P_GRIRProcDigestInGlobalCrcy.ChartOfAccounts AS ChartOfAccounts,
  P_GRIRProcDigestInGlobalCrcy.CompanyCodeName AS CompanyCodeName,
  P_GRIRProcDigestInGlobalCrcy.CreatedByUser AS CreatedByUser,
  P_GRIRProcDigestInGlobalCrcy.Supplier AS Supplier,
  P_GRIRProcDigestInGlobalCrcy.SupplierName AS SupplierName,
  cast(coalesce(P_GRIRProcDigestInGlobalCrcy.GRIRClearingProcessStatus, '') as fis_grir_clearing_status ) AS GRIRClearingProcessStatus,
  cast(coalesce(P_GRIRProcDigestInGlobalCrcy.GRIRClearingProcessPriority, '') as fis_grir_priority ) AS GRIRClearingProcessPriority,
  cast(coalesce(P_GRIRProcDigestInGlobalCrcy.GRIRClearingProcessRootCause, '') as fis_grir_clrg_root_cause ) AS GRIRClearingProcessRootCause,
  cast(coalesce(P_GRIRProcDigestInGlobalCrcy.ResponsibleDepartment, '') as fis_grir_responsible_dpmnt ) AS ResponsibleDepartment,
  cast(coalesce(P_GRIRProcDigestInGlobalCrcy.ResponsiblePerson, '') as fis_grir_responsible_user ) AS ResponsiblePerson,
  P_GRIRProcDigestInGlobalCrcy.AccountAssignmentCategory AS AccountAssignmentCategory,
  P_GRIRProcDigestInGlobalCrcy.DueDays AS DueDays,
  P_GRIRProcDigestInGlobalCrcy.CalendarYear AS CalendarYear,
  P_GRIRProcDigestInGlobalCrcy.YearMonth AS YearMonth,
  P_GRIRProcDigestInGlobalCrcy.CalendarMonth AS CalendarMonth,
  P_GRIRProcDigestInGlobalCrcy.GlobalCurrency AS GlobalCurrency,
  P_GRIRProcDigestInGlobalCrcy.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  P_GRIRProcDigestInGlobalCrcy.BalanceAbsoluteAmtInGlobalCrcy AS BalanceAbsoluteAmtInGlobalCrcy,
  P_GRIRProcDigestInGlobalCrcy.DebitAmountInGlobalCrcy AS DebitAmountInGlobalCrcy,
  P_GRIRProcDigestInGlobalCrcy.CreditAmountInGlobalCrcy AS CreditAmountInGlobalCrcy
FROM P_GRIRProcDigestInGlobalCrcy
LEFT OUTER JOIN I_ChartOfAccountsText AS _ChartOfAccountsText ON ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForCoCodeText AS _FiscalPeriodForCoCodeText ON CompanyCode = _FiscalPeriodForCoCodeText.CompanyCode AND FiscalYear = _FiscalPeriodForCoCodeText.FiscalYear AND FiscalPeriod = _FiscalPeriodForCoCodeText.FiscalPeriod  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessStatusText AS _GRIRProcessStatusText ON GRIRClearingProcessStatus = _GRIRProcessStatusText.GRIRClearingProcessStatus  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessPriorityText AS _GRIRProcessPriorityText ON GRIRClearingProcessPriority = _GRIRProcessPriorityText.GRIRClearingProcessPriority  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessRootCauseText AS _GRIRProcessRootCauseText ON GRIRClearingProcessRootCause = _GRIRProcessRootCauseText.GRIRClearingProcessRootCause  -- association [0..*]
LEFT OUTER JOIN I_CalendarMonthText AS _CalendarMonthText ON CalendarMonth = _CalendarMonthText.CalendarMonth  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON ChartOfAccounts = _GLAccountText.ChartOfAccounts AND GLAccount = _GLAccountText.GLAccount  -- association [0..*]
;

Depth:

C_GRIRProcDigestInGlobalCrcy view_entity

P_GRIRProcDigestInGlobalCrcy view_entity