What is I_GRIRProcInference in SAP S/4HANA?

I_GRIRProcInference is a composite CDS view in SAP S/4HANA. Projection of the ALP view It contains 72 fields.

Which tables does I_GRIRProcInference read from?

I_GRIRProcInference reads data from: I_GRIRAccountReconciliation.

What VDM layer is I_GRIRProcInference?

I_GRIRProcInference is classified as a Composite view that combines data from multiple basic views.

I_GRIRProcInference

DDL: I_GRIRPROCINFERENCE SQL: IGRIRINF Type: view COMPOSITE

72 Fields 1 Data Sources

Projection of the ALP view

I_GRIRProcInference is a Composite CDS View that provides data about "Projection of the ALP view" in SAP S/4HANA. It reads from 1 data source (I_GRIRAccountReconciliation) and exposes 72 fields with key fields CompanyCode, PurchasingDocument, PurchasingDocumentItem.

Data Sources (1)

Source	Alias	Join Type
I_GRIRAccountReconciliation	I_GRIRAccountReconciliation	from

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	IGRIRINF	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	Projection of the ALP view	view
VDM.viewType	#COMPOSITE	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.representativeKey	PurchasingDocumentItem	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view

Fields (72)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	I_GRIRAccountReconciliation	CompanyCode	Receiver Company Code
KEY	PurchasingDocument	I_GRIRAccountReconciliation	PurchasingDocument	Purchasing Document
KEY	PurchasingDocumentItem	I_GRIRAccountReconciliation	PurchasingDocumentItem	Purchasing Doc. Item
	LastChangeDateTime	I_GRIRAccountReconciliation	LastChangeDateTime	Timestamp
	LastChangedByUser	I_GRIRAccountReconciliation	LastChangedByUser	User Name
	GRIRClearingProcessStatus	I_GRIRAccountReconciliation	GRIRClearingProcessStatus	Status
	ResponsibleDepartment	I_GRIRAccountReconciliation	ResponsibleDepartment	Processing Department
	ResponsiblePerson	I_GRIRAccountReconciliation	ResponsiblePerson	Processor
	GRIRClearingProcessPriority	I_GRIRAccountReconciliation	GRIRClearingProcessPriority	Priority
	GRIRClearingProcessRootCause	I_GRIRAccountReconciliation	GRIRClearingProcessRootCause	Root Cause
	PrevResponsibleDepartment	I_GRIRAccountReconciliation	ResponsibleDepartment	Processing Department
	PrevResponsiblePerson	I_GRIRAccountReconciliation	ResponsiblePerson	Processor
	PrevGRIRClearingProcessStatus	I_GRIRAccountReconciliation	GRIRClearingProcessStatus	Status
	PrevGRIRClrgProcPriority	I_GRIRAccountReconciliation	GRIRClearingProcessPriority	Priority
	HasNote	I_GRIRAccountReconciliation	HasNote	TRUE
	SystemMessageIdentification	I_GRIRAccountReconciliation	SystemMessageIdentification	Message ID
	SystemMessageType	I_GRIRAccountReconciliation	SystemMessageType	Message type
	SystemMessageNumber	I_GRIRAccountReconciliation	SystemMessageNumber	Message Number
	AccountAssignmentCategory	I_GRIRAccountReconciliation	AccountAssignmentCategory	Acct Assgmt Cat
	BalAmtInCompanyCodeCrcy	I_GRIRAccountReconciliation	BalAmtInCompanyCodeCrcy	Balance Amount
	BalanceQuantity	I_GRIRAccountReconciliation	BalanceQuantityInRefQtyUnit
	IsFinallyInvoiced	I_GRIRAccountReconciliation	IsFinallyInvoiced	Final Invoice
	LatestOpenItemPostingDate	I_GRIRAccountReconciliation	LatestOpenItemPostingDate	Latest Posting Date
	MaterialGroup	I_GRIRAccountReconciliation	MaterialGroup	Product Group
	NumberOfGoodsReceipts	I_GRIRAccountReconciliation	NumberOfGoodsReceipts	Number of Goods Receipts
	NumberOfInvoiceReceipts	I_GRIRAccountReconciliation	NumberOfInvoiceReceipts	Number of Invoice Receipts
	OldestOpenItemPostingDate	I_GRIRAccountReconciliation	OldestOpenItemPostingDate	Oldest Posting Date
	Plant	I_GRIRAccountReconciliation	Plant	Valuation Area
	PurchasingGroup	I_GRIRAccountReconciliation	PurchasingGroup	Purchasing Group
	PurchasingOrganization	I_GRIRAccountReconciliation	PurchasingOrganization	Purchasing Organization
	Supplier	I_GRIRAccountReconciliation	Supplier	Supplier
	DueDays
	CompanyCodeCurrency	I_GRIRAccountReconciliation	CompanyCodeCurrency	Local Currency
	PurgDocOrderQuantityUnit	I_GRIRAccountReconciliation	PurgDocOrderQuantityUnit	Purchasing Document Order Qty Unit
	PrpsdResponsibleDepartment	I_GRIRAccountReconciliation	PrpsdResponsibleDepartment	Proposed Processing Department
	ProposedResponsiblePerson	I_GRIRAccountReconciliation	ProposedResponsiblePerson	Proposed Processor
	GRIRClrgProcessPrpsdStatus	I_GRIRAccountReconciliation	GRIRClrgProcessPrpsdStatus	Proposed Status
	GRIRClrgProcPrpsdPriority	I_GRIRAccountReconciliation	GRIRClrgProcPrpsdPriority	Proposed Priority
	GRIRClrgProcessPrpsdRootCause	I_GRIRAccountReconciliation	GRIRClrgProcessPrpsdRootCause	Proposed Root Cause
	PrpsdRespDeptMaxClProbability	I_GRIRAccountReconciliation	PrpsdRespDeptMaxClProbability	Processing Department Proposal Confidence
	PrpsdRespPersonMaxClassProblty	I_GRIRAccountReconciliation	PrpsdRespPersonMaxClassProblty	Processor Proposal Confidence
	GRIRProposedStatusMaxClProblty	I_GRIRAccountReconciliation	GRIRProposedStatusMaxClProblty	Status Proposal Confidence
	GRIRProposedPrioMaxClProblty	I_GRIRAccountReconciliation	GRIRProposedPrioMaxClProblty	Priority Proposal Confidence
	GRIRPrpsdRootCauseMaxClProblty	I_GRIRAccountReconciliation	GRIRPrpsdRootCauseMaxClProblty	Root Cause Proposal Confidence
	GRIRProcPrpslLastChangeDteTime	I_GRIRAccountReconciliation	GRIRProcPrpslLastChangeDteTime	Proposals Last Updated On
	GoodsReceiptGoodsAmtInCCCrcy	I_GRIRAccountReconciliation	GoodsReceiptGoodsAmtInCCCrcy	Goods Receipt Amount (Goods)
	InvoiceRcptGoodsAmtInCCCrcy	I_GRIRAccountReconciliation	InvoiceRcptGoodsAmtInCCCrcy	Invoice Receipt Amount (Goods)
	GdsRcptDelivCostAmtInCCCrcy	I_GRIRAccountReconciliation	GdsRcptDelivCostAmtInCCCrcy	Goods Receipt Amount (Delivery Costs)
	InvcRcptDelivCostAmtInCCCrcy	I_GRIRAccountReconciliation	InvcRcptDelivCostAmtInCCCrcy	Invoice Receipt Amount (Delivery Costs)
	GoodsReceiptGoodsQuantity	I_GRIRAccountReconciliation	GoodsReceiptGdsQtyInRefQtyUnit
	InvoiceReceiptGoodsQuantity	I_GRIRAccountReconciliation	InvoiceRcptGdsQtyInRefQtyUnit
	GoodsReceiptDeliveryCostQty	I_GRIRAccountReconciliation	GRDelivCostQtyInRefQtyUnit
	InvoiceRcptDeliveryCostQty	I_GRIRAccountReconciliation	InvcRcptDelivQtyInRefQtyUnit
	GoodsBalanceAmountInCCCrcy	I_GRIRAccountReconciliation	GoodsBalanceAmountInCCCrcy
	GoodsBalanceQuantity	I_GRIRAccountReconciliation	GdsBalanceQuantityInRefQtyUnit
	DeliveryCostBalAmtInCCCrcy	I_GRIRAccountReconciliation	DeliveryCostBalAmtInCCCrcy
	DeliveryCostBalanceQuantity	I_GRIRAccountReconciliation	DelivCostBalQtyInRefQtyUnit
	GoodsReceiptAmountInCoCodeCrcy	I_GRIRAccountReconciliation	GoodsReceiptAmountInCoCodeCrcy
	GoodsReceiptQty	I_GRIRAccountReconciliation	GoodsReceiptQtyInRefQtyUnit
	InvoiceRcptAmtInCoCodeCrcy	I_GRIRAccountReconciliation	InvoiceRcptAmtInCoCodeCrcy
	InvoiceReceiptQty	I_GRIRAccountReconciliation	InvoiceReceiptQtyInRefQtyUnit
	IsGoodsRcptGoodsAmtSurplus	I_GRIRAccountReconciliation	IsGoodsRcptGoodsAmtSurplus
	IsInvoiceGoodsAmountSurplus	I_GRIRAccountReconciliation	IsInvoiceGoodsAmountSurplus
	IsGdsRcptDelivCostAmtSurplus	I_GRIRAccountReconciliation	IsGdsRcptDelivCostAmtSurplus
	IsInvoiceDelivCostAmtSurplus	I_GRIRAccountReconciliation	IsInvoiceDelivCostAmtSurplus
	IsGoodsRcptGoodsQtySurplus	I_GRIRAccountReconciliation	IsGoodsRcptGoodsQtySurplus
	IsInvoiceGoodsQtySurplus	I_GRIRAccountReconciliation	IsInvoiceGoodsQtySurplus
	IsGdsRcptDelivCostQtySurplus	I_GRIRAccountReconciliation	IsGdsRcptDelivCostQtySurplus
	IsInvoiceDelivCostQtySurplus	I_GRIRAccountReconciliation	IsInvoiceDelivCostQtySurplus
	_CompanyCode	I_GRIRAccountReconciliation	_CompanyCode
	_PurchasingDocument	I_GRIRAccountReconciliation	_PurchasingDocument
	_PurchasingDocumentItem	I_GRIRAccountReconciliation	_PurchasingDocumentItem

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 I_GRIRProcInference.
-- 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.
-- SQL view name: IGRIRINF

CREATE VIEW I_GRIRProcInference AS
SELECT
  I_GRIRAccountReconciliation.CompanyCode AS CompanyCode,
  I_GRIRAccountReconciliation.PurchasingDocument AS PurchasingDocument,
  I_GRIRAccountReconciliation.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_GRIRAccountReconciliation.LastChangeDateTime AS LastChangeDateTime,
  I_GRIRAccountReconciliation.LastChangedByUser AS LastChangedByUser,
  I_GRIRAccountReconciliation.GRIRClearingProcessStatus AS GRIRClearingProcessStatus,
  I_GRIRAccountReconciliation.ResponsibleDepartment AS ResponsibleDepartment,
  I_GRIRAccountReconciliation.ResponsiblePerson AS ResponsiblePerson,
  I_GRIRAccountReconciliation.GRIRClearingProcessPriority AS GRIRClearingProcessPriority,
  I_GRIRAccountReconciliation.GRIRClearingProcessRootCause AS GRIRClearingProcessRootCause,
  I_GRIRAccountReconciliation.ResponsibleDepartment AS PrevResponsibleDepartment,
  I_GRIRAccountReconciliation.ResponsiblePerson AS PrevResponsiblePerson,
  I_GRIRAccountReconciliation.GRIRClearingProcessStatus AS PrevGRIRClearingProcessStatus,
  I_GRIRAccountReconciliation.GRIRClearingProcessPriority AS PrevGRIRClrgProcPriority,
  I_GRIRAccountReconciliation.HasNote AS HasNote,
  I_GRIRAccountReconciliation.SystemMessageIdentification AS SystemMessageIdentification,
  I_GRIRAccountReconciliation.SystemMessageType AS SystemMessageType,
  I_GRIRAccountReconciliation.SystemMessageNumber AS SystemMessageNumber,
  I_GRIRAccountReconciliation.AccountAssignmentCategory AS AccountAssignmentCategory,
  I_GRIRAccountReconciliation.BalAmtInCompanyCodeCrcy AS BalAmtInCompanyCodeCrcy,
  I_GRIRAccountReconciliation.BalanceQuantityInRefQtyUnit AS BalanceQuantity,
  I_GRIRAccountReconciliation.IsFinallyInvoiced AS IsFinallyInvoiced,
  I_GRIRAccountReconciliation.LatestOpenItemPostingDate AS LatestOpenItemPostingDate,
  I_GRIRAccountReconciliation.MaterialGroup AS MaterialGroup,
  I_GRIRAccountReconciliation.NumberOfGoodsReceipts AS NumberOfGoodsReceipts,
  I_GRIRAccountReconciliation.NumberOfInvoiceReceipts AS NumberOfInvoiceReceipts,
  I_GRIRAccountReconciliation.OldestOpenItemPostingDate AS OldestOpenItemPostingDate,
  I_GRIRAccountReconciliation.Plant AS Plant,
  I_GRIRAccountReconciliation.PurchasingGroup AS PurchasingGroup,
  I_GRIRAccountReconciliation.PurchasingOrganization AS PurchasingOrganization,
  I_GRIRAccountReconciliation.Supplier AS Supplier,
  cast ( dats_days_between( I_GRIRAccountReconciliation.LatestOpenItemPostingDate, cast ( $session.system_date as abap.dats ) ) as fis_due_days preserving type ) AS DueDays,
  I_GRIRAccountReconciliation.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GRIRAccountReconciliation.PurgDocOrderQuantityUnit AS PurgDocOrderQuantityUnit,
  I_GRIRAccountReconciliation.PrpsdResponsibleDepartment AS PrpsdResponsibleDepartment,
  I_GRIRAccountReconciliation.ProposedResponsiblePerson AS ProposedResponsiblePerson,
  I_GRIRAccountReconciliation.GRIRClrgProcessPrpsdStatus AS GRIRClrgProcessPrpsdStatus,
  I_GRIRAccountReconciliation.GRIRClrgProcPrpsdPriority AS GRIRClrgProcPrpsdPriority,
  I_GRIRAccountReconciliation.GRIRClrgProcessPrpsdRootCause AS GRIRClrgProcessPrpsdRootCause,
  I_GRIRAccountReconciliation.PrpsdRespDeptMaxClProbability AS PrpsdRespDeptMaxClProbability,
  I_GRIRAccountReconciliation.PrpsdRespPersonMaxClassProblty AS PrpsdRespPersonMaxClassProblty,
  I_GRIRAccountReconciliation.GRIRProposedStatusMaxClProblty AS GRIRProposedStatusMaxClProblty,
  I_GRIRAccountReconciliation.GRIRProposedPrioMaxClProblty AS GRIRProposedPrioMaxClProblty,
  I_GRIRAccountReconciliation.GRIRPrpsdRootCauseMaxClProblty AS GRIRPrpsdRootCauseMaxClProblty,
  I_GRIRAccountReconciliation.GRIRProcPrpslLastChangeDteTime AS GRIRProcPrpslLastChangeDteTime,
  I_GRIRAccountReconciliation.GoodsReceiptGoodsAmtInCCCrcy AS GoodsReceiptGoodsAmtInCCCrcy,
  I_GRIRAccountReconciliation.InvoiceRcptGoodsAmtInCCCrcy AS InvoiceRcptGoodsAmtInCCCrcy,
  I_GRIRAccountReconciliation.GdsRcptDelivCostAmtInCCCrcy AS GdsRcptDelivCostAmtInCCCrcy,
  I_GRIRAccountReconciliation.InvcRcptDelivCostAmtInCCCrcy AS InvcRcptDelivCostAmtInCCCrcy,
  I_GRIRAccountReconciliation.GoodsReceiptGdsQtyInRefQtyUnit AS GoodsReceiptGoodsQuantity,
  I_GRIRAccountReconciliation.InvoiceRcptGdsQtyInRefQtyUnit AS InvoiceReceiptGoodsQuantity,
  I_GRIRAccountReconciliation.GRDelivCostQtyInRefQtyUnit AS GoodsReceiptDeliveryCostQty,
  I_GRIRAccountReconciliation.InvcRcptDelivQtyInRefQtyUnit AS InvoiceRcptDeliveryCostQty,
  I_GRIRAccountReconciliation.GoodsBalanceAmountInCCCrcy AS GoodsBalanceAmountInCCCrcy,
  I_GRIRAccountReconciliation.GdsBalanceQuantityInRefQtyUnit AS GoodsBalanceQuantity,
  I_GRIRAccountReconciliation.DeliveryCostBalAmtInCCCrcy AS DeliveryCostBalAmtInCCCrcy,
  I_GRIRAccountReconciliation.DelivCostBalQtyInRefQtyUnit AS DeliveryCostBalanceQuantity,
  I_GRIRAccountReconciliation.GoodsReceiptAmountInCoCodeCrcy AS GoodsReceiptAmountInCoCodeCrcy,
  I_GRIRAccountReconciliation.GoodsReceiptQtyInRefQtyUnit AS GoodsReceiptQty,
  I_GRIRAccountReconciliation.InvoiceRcptAmtInCoCodeCrcy AS InvoiceRcptAmtInCoCodeCrcy,
  I_GRIRAccountReconciliation.InvoiceReceiptQtyInRefQtyUnit AS InvoiceReceiptQty,
  I_GRIRAccountReconciliation.IsGoodsRcptGoodsAmtSurplus AS IsGoodsRcptGoodsAmtSurplus,
  I_GRIRAccountReconciliation.IsInvoiceGoodsAmountSurplus AS IsInvoiceGoodsAmountSurplus,
  I_GRIRAccountReconciliation.IsGdsRcptDelivCostAmtSurplus AS IsGdsRcptDelivCostAmtSurplus,
  I_GRIRAccountReconciliation.IsInvoiceDelivCostAmtSurplus AS IsInvoiceDelivCostAmtSurplus,
  I_GRIRAccountReconciliation.IsGoodsRcptGoodsQtySurplus AS IsGoodsRcptGoodsQtySurplus,
  I_GRIRAccountReconciliation.IsInvoiceGoodsQtySurplus AS IsInvoiceGoodsQtySurplus,
  I_GRIRAccountReconciliation.IsGdsRcptDelivCostQtySurplus AS IsGdsRcptDelivCostQtySurplus,
  I_GRIRAccountReconciliation.IsInvoiceDelivCostQtySurplus AS IsInvoiceDelivCostQtySurplus,
  I_GRIRAccountReconciliation._CompanyCode AS _CompanyCode,
  I_GRIRAccountReconciliation._PurchasingDocument AS _PurchasingDocument,
  I_GRIRAccountReconciliation._PurchasingDocumentItem AS _PurchasingDocumentItem
FROM I_GRIRAccountReconciliation
;

Depth:

I_GRIRProcInference view

I_GRIRAccountReconciliation view