What is C_GRIRProcessDigest in SAP S/4HANA?

C_GRIRProcessDigest is a consumption CDS view in SAP S/4HANA. GR/IR Reconcilation Monitor Digest It contains 76 fields.

Which tables does C_GRIRProcessDigest read from?

C_GRIRProcessDigest reads data from: P_GRIRProcessDigest.

What VDM layer is C_GRIRProcessDigest?

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

C_GRIRProcessDigest

DDL: C_GRIRPROCESSDIGEST Type: view_entity CONSUMPTION Package: FINS_FIS_FICO_APPS

76 Fields 1 Data Sources 9 Associations 1 OData Services

GR/IR Reconcilation Monitor Digest

C_GRIRProcessDigest is a Consumption CDS View that provides data about "GR/IR Reconcilation Monitor Digest" in SAP S/4HANA. It reads from 1 data source (P_GRIRProcessDigest) and exposes 76 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_GRIRProcessDigest	P_GRIRProcessDigest	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 Reconcilation Monitor Digest	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 (76)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	P_GRIRProcessDigest	CompanyCode	Receiver Company Code
KEY	FiscalYear	P_GRIRProcessDigest	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	P_GRIRProcessDigest	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	P_GRIRProcessDigest	LedgerGLLineItem	Journal Entry Item
	AccountingDocumentItem	P_GRIRProcessDigest	AccountingDocumentItem	Posting View Item
	PurchasingDocument	P_GRIRProcessDigest	PurchasingDocument	Purchasing Document
	PurchasingDocumentItem	P_GRIRProcessDigest	PurchasingDocumentItem	Purchasing Doc. Item
	Plant	P_GRIRProcessDigest	Plant	Valuation Area
	PlantName	P_GRIRProcessDigest	PlantName	Plant Name
	PurchasingOrganization	P_GRIRProcessDigest	PurchasingOrganization	Purchasing Organization
	PurchasingOrganizationName
	PurchasingGroup	P_GRIRProcessDigest	PurchasingGroup	Purchasing Group
	PurchasingGroupName
	MaterialGroup	P_GRIRProcessDigest	MaterialGroup	Product Group
	ControllingArea	P_GRIRProcessDigest	ControllingArea	Controlling Area
	ProfitCenter	P_GRIRProcessDigest	ProfitCenter	Profit Center
	ProfitCenterName
	FiscalPeriod	P_GRIRProcessDigest	FiscalPeriod	Tax period
	DocumentDate	P_GRIRProcessDigest	DocumentDate	Journal Entry Date
	PostingDate	P_GRIRProcessDigest	PostingDate	Posting Date for GR
	GLAccount	P_GRIRProcessDigest	GLAccount	General Ledger
	ChartOfAccounts	P_GRIRProcessDigest	ChartOfAccounts	Node Class
	CompanyCodeName	P_GRIRProcessDigest	CompanyCodeName	Company Name
	PostingKey	P_GRIRProcessDigest	PostingKey	Posting Key
	DebitCreditCode	P_GRIRProcessDigest	DebitCreditCode	Single-Character Flag
	Supplier	P_GRIRProcessDigest	Supplier	Supplier
	SupplierName	P_GRIRProcessDigest	SupplierName	Supplier Name
	ReferenceDocumentType	P_GRIRProcessDigest	ReferenceDocumentType	Reference Document Type
	GRIRClearingProcessStatus	P_GRIRProcessDigest	GRIRClearingProcessStatus	Status
	GRIRClearingProcessPriority	P_GRIRProcessDigest	GRIRClearingProcessPriority	Priority
	GRIRClearingProcessRootCause	P_GRIRProcessDigest	GRIRClearingProcessRootCause	Root Cause
	ResponsibleDepartment	P_GRIRProcessDigest	ResponsibleDepartment	Processing Department
	ResponsiblePerson	P_GRIRProcessDigest	ResponsiblePerson	Processor
	TransactionTypeDetermination	P_GRIRProcessDigest	TransactionTypeDetermination	Transaction Key
	CreatedByUser	P_GRIRProcessDigest	CreatedByUser	User Name
	DueDays	P_GRIRProcessDigest	DueDays	Processing Time
	CalendarYear	P_GRIRProcessDigest	CalendarYear	Year
	YearMonth	P_GRIRProcessDigest	YearMonth	Year Month
	CalendarMonth	P_GRIRProcessDigest	CalendarMonth	Calendar Month
	AccountAssignmentCategory	P_GRIRProcessDigest	AccountAssignmentCategory	Acct Assgmt Cat
	CompanyCodeCurrency	P_GRIRProcessDigest	CompanyCodeCurrency	Local Currency
	AmountInCompanyCodeCurrency	P_GRIRProcessDigest	AmountInCompanyCodeCurrency	Local Crcy Amt
	GlobalCurrency	P_GRIRProcessDigest	GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency	P_GRIRProcessDigest	AmountInGlobalCurrency	Amount in Global Currency
	BalanceAbsoluteAmtInCoCodeCrcy	P_GRIRProcessDigest	BalanceAbsoluteAmtInCoCodeCrcy
	DebitAmountInCoCodeCrcy	P_GRIRProcessDigest	DebitAmountInCoCodeCrcy	Debit Amount in Company Code Currency
	CreditAmountInCoCodeCrcy	P_GRIRProcessDigest	CreditAmountInCoCodeCrcy	Credit Amount in Company Code Currency
	DebitAmountInGlobalCrcy	P_GRIRProcessDigest	DebitAmountInGlobalCrcy
	CreditAmountInGlobalCrcy	P_GRIRProcessDigest	CreditAmountInGlobalCrcy
	NumberOfOpenItems
	_CompanyCode	P_GRIRProcessDigest	_CompanyCode
	_FiscalYear	P_GRIRProcessDigest	_FiscalYear
	_JournalEntry	P_GRIRProcessDigest	_JournalEntry
	_PurchasingDocumentItem	P_GRIRProcessDigest	_PurchasingDocumentItem
	_GLAccountInChartOfAccounts	P_GRIRProcessDigest	_GLAccountInChartOfAccounts
	_GRIRProcess	P_GRIRProcessDigest	_GRIRProcess
	_CalendarMonth	P_GRIRProcessDigest	_CalendarMonth
	_Plant	P_GRIRProcessDigest	_Plant
	_PurchasingOrganization	P_GRIRProcessDigest	_PurchasingOrganization
	_PurchasingGroup	P_GRIRProcessDigest	_PurchasingGroup
	_MaterialGroup	P_GRIRProcessDigest	_MaterialGroup
	_ProfitCenter	P_GRIRProcessDigest	_ProfitCenter
	_ControllingArea	P_GRIRProcessDigest	_ControllingArea
	_Supplier	P_GRIRProcessDigest	_Supplier
	_ChartOfAccounts	P_GRIRProcessDigest	_ChartOfAccounts
	_CompanyCodeCurrency	P_GRIRProcessDigest	_CompanyCodeCurrency
	_GlobalCurrency	P_GRIRProcessDigest	_GlobalCurrency
	_FiscalPeriodForCoCodeText		_FiscalPeriodForCoCodeText
	_GRIRProcessStatusText		_GRIRProcessStatusText
	_GRIRProcessPriorityText		_GRIRProcessPriorityText
	_GRIRProcessRootCauseText		_GRIRProcessRootCauseText
	_CalendarMonthText		_CalendarMonthText
	_MaterialGroupText		_MaterialGroupText
	_GLAccountText		_GLAccountText
	_ChartOfAccountsText		_ChartOfAccountsText
	_ControllingAreaText		_ControllingAreaText

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_GRIRProcessDigest.
-- 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_GRIRProcessDigest AS
SELECT
  P_GRIRProcessDigest.CompanyCode AS CompanyCode,
  P_GRIRProcessDigest.FiscalYear AS FiscalYear,
  P_GRIRProcessDigest.AccountingDocument AS AccountingDocument,
  P_GRIRProcessDigest.LedgerGLLineItem AS LedgerGLLineItem,
  P_GRIRProcessDigest.AccountingDocumentItem AS AccountingDocumentItem,
  P_GRIRProcessDigest.PurchasingDocument AS PurchasingDocument,
  P_GRIRProcessDigest.PurchasingDocumentItem AS PurchasingDocumentItem,
  P_GRIRProcessDigest.Plant AS Plant,
  P_GRIRProcessDigest.PlantName AS PlantName,
  P_GRIRProcessDigest.PurchasingOrganization AS PurchasingOrganization,
  P_GRIRProcessDigest._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  P_GRIRProcessDigest.PurchasingGroup AS PurchasingGroup,
  P_GRIRProcessDigest._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  P_GRIRProcessDigest.MaterialGroup AS MaterialGroup,
  P_GRIRProcessDigest.ControllingArea AS ControllingArea,
  P_GRIRProcessDigest.ProfitCenter AS ProfitCenter,
  P_GRIRProcessDigest._ProfitCenter[1:ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date]._Text[1:Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  P_GRIRProcessDigest.FiscalPeriod AS FiscalPeriod,
  P_GRIRProcessDigest.DocumentDate AS DocumentDate,
  P_GRIRProcessDigest.PostingDate AS PostingDate,
  P_GRIRProcessDigest.GLAccount AS GLAccount,
  P_GRIRProcessDigest.ChartOfAccounts AS ChartOfAccounts,
  P_GRIRProcessDigest.CompanyCodeName AS CompanyCodeName,
  P_GRIRProcessDigest.PostingKey AS PostingKey,
  P_GRIRProcessDigest.DebitCreditCode AS DebitCreditCode,
  P_GRIRProcessDigest.Supplier AS Supplier,
  P_GRIRProcessDigest.SupplierName AS SupplierName,
  P_GRIRProcessDigest.ReferenceDocumentType AS ReferenceDocumentType,
  P_GRIRProcessDigest.GRIRClearingProcessStatus AS GRIRClearingProcessStatus,
  P_GRIRProcessDigest.GRIRClearingProcessPriority AS GRIRClearingProcessPriority,
  P_GRIRProcessDigest.GRIRClearingProcessRootCause AS GRIRClearingProcessRootCause,
  P_GRIRProcessDigest.ResponsibleDepartment AS ResponsibleDepartment,
  P_GRIRProcessDigest.ResponsiblePerson AS ResponsiblePerson,
  P_GRIRProcessDigest.TransactionTypeDetermination AS TransactionTypeDetermination,
  P_GRIRProcessDigest.CreatedByUser AS CreatedByUser,
  P_GRIRProcessDigest.DueDays AS DueDays,
  P_GRIRProcessDigest.CalendarYear AS CalendarYear,
  P_GRIRProcessDigest.YearMonth AS YearMonth,
  P_GRIRProcessDigest.CalendarMonth AS CalendarMonth,
  P_GRIRProcessDigest.AccountAssignmentCategory AS AccountAssignmentCategory,
  P_GRIRProcessDigest.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_GRIRProcessDigest.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  P_GRIRProcessDigest.GlobalCurrency AS GlobalCurrency,
  P_GRIRProcessDigest.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  P_GRIRProcessDigest.BalanceAbsoluteAmtInCoCodeCrcy AS BalanceAbsoluteAmtInCoCodeCrcy,
  P_GRIRProcessDigest.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  P_GRIRProcessDigest.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  P_GRIRProcessDigest.DebitAmountInGlobalCrcy AS DebitAmountInGlobalCrcy,
  P_GRIRProcessDigest.CreditAmountInGlobalCrcy AS CreditAmountInGlobalCrcy,
  cast( 1 as fis_nr_open_item ) AS NumberOfOpenItems,
  P_GRIRProcessDigest._CompanyCode AS _CompanyCode,
  P_GRIRProcessDigest._FiscalYear AS _FiscalYear,
  P_GRIRProcessDigest._JournalEntry AS _JournalEntry,
  P_GRIRProcessDigest._PurchasingDocumentItem AS _PurchasingDocumentItem,
  P_GRIRProcessDigest._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  P_GRIRProcessDigest._GRIRProcess AS _GRIRProcess,
  P_GRIRProcessDigest._CalendarMonth AS _CalendarMonth,
  P_GRIRProcessDigest._Plant AS _Plant,
  P_GRIRProcessDigest._PurchasingOrganization AS _PurchasingOrganization,
  P_GRIRProcessDigest._PurchasingGroup AS _PurchasingGroup,
  P_GRIRProcessDigest._MaterialGroup AS _MaterialGroup,
  P_GRIRProcessDigest._ProfitCenter AS _ProfitCenter,
  P_GRIRProcessDigest._ControllingArea AS _ControllingArea,
  P_GRIRProcessDigest._Supplier AS _Supplier,
  P_GRIRProcessDigest._ChartOfAccounts AS _ChartOfAccounts,
  P_GRIRProcessDigest._CompanyCodeCurrency AS _CompanyCodeCurrency,
  P_GRIRProcessDigest._GlobalCurrency AS _GlobalCurrency
FROM P_GRIRProcessDigest
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_GRIRProcessDigest view_entity

P_GRIRProcessDigest view_entity