What is I_GRIRProcessHistory in SAP S/4HANA?

I_GRIRProcessHistory is a basic CDS view in SAP S/4HANA. GRIR Process History It contains 76 fields.

Which tables does I_GRIRProcessHistory read from?

I_GRIRProcessHistory reads data from: P_GRIRProcessHistory.

What VDM layer is I_GRIRProcessHistory?

I_GRIRProcessHistory is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_GRIRProcessHistory

DDL: I_GRIRPROCESSHISTORY Type: view_entity BASIC Package: FINS_FIS_FICO

76 Fields 1 Data Sources 11 Associations 3 OData Services 1 Fiori Apps

GRIR Process History

I_GRIRProcessHistory (Basic)

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

Accounting and Financial Close

I_GRIRProcessHistory is a Basic CDS View that provides data about "GRIR Process History" in SAP S/4HANA. It reads from 1 data source (P_GRIRProcessHistory) and exposes 76 fields with key fields CompanyCode, PurchasingDocument, PurchasingDocumentItem, LastChangeDateTime. It has 11 associations to related views. It is exposed through 3 OData services (ASQL_F3302, ASQL_F5796, UI_GRIR_BPI). It is used in 1 Fiori application: GR/IR Process Insights. Part of development package FINS_FIS_FICO.

SAP Help Documentation

Category	CDS Views for Transaction Data
Status	Status

Purpose
This CDS view allows you to access historical GR/IR process information for business process evaluations to gain operational insights. This CDS view provides access to all processing data of the GR/IR (Goods Receipt/Invoice Receipt) account reconciliation process which is performed using the Reconcile GR/IR Accounts app. In the GR/IR processing history table the following is recorded: root cause, status, processor and more for purchasing document items, such as purchase orders, where amounts and/or quantities between goods receipts and invoice receipts do not match. This CDS view allows you to retrospectively review all activities on a purchasing document item level in relation to a business situation at a point in time. This CDS view provides the data to answer the following business questions: Which business situation (amount deviations) did cause a write-off? Which department/processor did perform the clarification of a purchasing document item? What was the root cause of the issue that occurred? Which business situation has led to which process decision?

Prerequisites
Authorizations The following business catalogs needs to be assigned to a user to be able to use this CDS view: SAP_FIN_BC_ACC_RECON_PC

Structure
Fields used for filtering The main filters are as follows: Company code Plant Purchasing goup Purchasing organization Supplier Last changed by user Further important fields Important fields in this view include the following: Field Name Description CompanyCode Company Code PurchasingDocument Purchasing Document PurchasingDocumentItem Purchasing Document Item LastChangeDateTime Last changed on LastChangedbyUser Last changed by ResponsibleDepartment Processing Department ResponsiblePerson Processor GRIRClearingProcessStatus Status GRIRClearingProcessPriority Priority BalAmtInCompanyCodeCrcy Balance Amount BalanceQuantity Balance Quantity Plant Plant Purchasing Group Purchasing Group Purchasing Organization Purchsing Organization Supplier Supplier

View on SAP Help Portal →

SAP API Hub

Category	Basic
State	C1
Line of Business	Accounting and Financial Close
Application Component	FI-GL-IS-2CL
Capabilities	Data Source for Defining CDS Entities
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Accounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view allows you to access historical GR/IR process information for business process evaluations to gain operational insights.</p> <p>This CDS view provides access to all processing data of the GR/IR (Goods Receipt/Invoice Receipt) account reconciliation process which is performed using the Reconcile GR/IR Accounts app. In the GR/IR processing history table the following is recorded: root cause, status, processor and more for purchasing document items, such as purchase orders, where amounts and/or quantities between goods receipts and invoice receipts do not match. </p> <p>This CDS view allows you to retrospectively review all activities on a purchasing document item level in relation to a business situation at a point in time.</p> This CDS view provides the data to answer the following business questions:<ul> <li> <p>Which business situation (amount deviations) did cause a write-off?</p> </li> <li> <p>Which department/processor did perform the clarification of a purchasing document item?</p> </li> <li> <p>What was the root cause of the issue that occurred?</p> </li> <li> <p>Which business situation has led to which process decision?</p> </li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
P_GRIRProcessHistory	P_GRIRProcessHistory	from

Associations (11)

Cardinality	Target	Alias	Condition
[0..1]	I_UserContactCard	_LastChangedByUser	`$projection.LastChangedByUser = _LastChangedByUser.ContactCardID`
[0..1]	I_UserContactCard	_ResponsiblePerson	`$projection.ResponsiblePerson = _ResponsiblePerson.ContactCardID`
[0..*]	I_GRIRProcessStatusText	_GRIRProcessStatusText	`$projection.GRIRClearingProcessStatus = _GRIRProcessStatusText.GRIRClearingProcessStatus`
[0..*]	I_GRIRProcessStatusText	_GRIRClrgProcPrpsdStatusText	`$projection.GRIRClrgProcessPrpsdStatus = _GRIRClrgProcPrpsdStatusText.GRIRClearingProcessStatus`
[0..*]	I_GRIRProcessPriorityText	_GRIRProcessPriorityText	`$projection.GRIRClearingProcessPriority = _GRIRProcessPriorityText.GRIRClearingProcessPriority`
[0..*]	I_GRIRProcessPriorityText	_GRIRClrgProcPrpsdPriorityText	`$projection.GRIRClrgProcPrpsdPriority = _GRIRClrgProcPrpsdPriorityText.GRIRClearingProcessPriority`
[0..*]	I_GRIRProcessRootCauseText	_GRIRProcessRootCauseText	`$projection.GRIRClearingProcessRootCause = _GRIRProcessRootCauseText.GRIRClearingProcessRootCause`
[0..*]	I_GRIRProcessRootCauseText	_GRIRProcessPrpsdRootCauseText	`$projection.GRIRClrgProcessPrpsdRootCause = _GRIRProcessPrpsdRootCauseText.GRIRClearingProcessRootCause`
[0..1]	I_UnitOfMeasure	_PurgDocOrderQuantityUnit	`$projection.PurgDocOrderQuantityUnit = _PurgDocOrderQuantityUnit.UnitOfMeasure`
[1..1]	I_Currency	_CompanyCodeCurrency	`$projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency`
[0..1]	I_Supplier	_Supplier	`$projection.Supplier = _Supplier.Supplier`

Annotations (10)

Name	Value	Level
AbapCatalog.entityBuffer.definitionAllowed	false	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	GRIR Process History	view
VDM.viewType	#BASIC	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#B	view
UI.textArrangement	#TEXT_LAST	view

OData Services (3)

Service	Binding	Version	Contract	Release
ASQL_F3302	ASQL_F3302		C2	NOT_RELEASED
ASQL_F5796	ASQL_F5796		C2	NOT_RELEASED
UI_GRIR_BPI	UI_GRIR_BPI	V2	C1	NOT_RELEASED

Fiori Apps (1)

App ID	App Name	Type	Description
F5796	GR/IR Process Insights	Analytical	With this app, you can gain insights into the GR/IR (goods receipt/invoice receipt) account reconciliation process which is performed using the Reconcile GR/IR Accounts app.

GR/IR Process Insights

Business Role: General Ledger Accountant

With this app, you can gain insights into the GR/IR (goods receipt/invoice receipt) account reconciliation process which is performed using the app. You can visualize the activities of the reconciliation process and thereby identify opportunities for process improvements, such as, by discovering bottlenecks, duplicate work or root causes for delays. You can also retrospectively review all activities on the level of a purchasing document item together with all relevant documents from the purchasing document history. Thus, this app enables you, as a process owner, to analyze the process efficiency of the GR/IR account reconciliation process and to define improvement activities.

Fields (76)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	P_GRIRProcessHistory	CompanyCode	Receiver Company Code
KEY	PurchasingDocument	P_GRIRProcessHistory	PurchasingDocument	Purchasing Document
KEY	PurchasingDocumentItem	P_GRIRProcessHistory	PurchasingDocumentItem	Purchasing Document Item
KEY	LastChangeDateTime	P_GRIRProcessHistory	LastChangeDateTime	GR/IR Clearing Process Last Change Date Time
	LastChangedByUser	P_GRIRProcessHistory	LastChangedByUser	User of Last Change in GR/IR Clearing Process
	ResponsibleDepartment	P_GRIRProcessHistory	ResponsibleDepartment	Processing Department of GR/IR Clearing Process
	ResponsiblePerson	P_GRIRProcessHistory	ResponsiblePerson	Processor of GR/IR Clearing Process
	GRIRClearingProcessStatus	P_GRIRProcessHistory	GRIRClearingProcessStatus	GR/IR Clearing Process Status
	GRIRClearingProcessPriority	P_GRIRProcessHistory	GRIRClearingProcessPriority	Priority of GR/IR Clearing Process
	HasNote	P_GRIRProcessHistory	HasNote	Notes Included in GR/IR Clearing Process
	Note	P_GRIRProcessHistory	Note	TradeRequest Comment
	SystemMessageIdentification	P_GRIRProcessHistory	SystemMessageIdentification	Message identification
	SystemMessageType	P_GRIRProcessHistory	SystemMessageType	Message type
	SystemMessageNumber	P_GRIRProcessHistory	SystemMessageNumber	Message Number
	AccountAssignmentCategory	P_GRIRProcessHistory	AccountAssignmentCategory	Account Assignment Category
	BalAmtInCompanyCodeCrcy	P_GRIRProcessHistory	BalAmtInCompanyCodeCrcy	Total Balance Amount in Company Code Currency
	BalanceQuantity	P_GRIRProcessHistory	BalanceQuantity	Balance Quantity in Reference Quantity Unit
	IsFinallyInvoiced	P_GRIRProcessHistory	IsFinallyInvoiced	Final Invoice Indicator
	LatestOpenItemPostingDate	P_GRIRProcessHistory	LatestOpenItemPostingDate	Posting Date of Latest Open Item
	MaterialGroup	P_GRIRProcessHistory	MaterialGroup	Material Group
	NumberOfGoodsReceipts	P_GRIRProcessHistory	NumberOfGoodsReceipts	Number of Goods Receipts
	NumberOfInvoiceReceipts	P_GRIRProcessHistory	NumberOfInvoiceReceipts	Number of Invoice Receipts
	OldestOpenItemPostingDate	P_GRIRProcessHistory	OldestOpenItemPostingDate	Posting Date of Oldest Open Item
	Plant	P_GRIRProcessHistory	Plant	Valuation Area
	PurchasingGroup	P_GRIRProcessHistory	PurchasingGroup	Purchasing Group
	PurchasingOrganization	P_GRIRProcessHistory	PurchasingOrganization	Purchasing Organization
	Supplier	P_GRIRProcessHistory	Supplier	Account Number of Supplier
	SystemMessageVariable1	P_GRIRProcessHistory	SystemMessageVariable1	Message Variable 1
	SystemMessageVariable2	P_GRIRProcessHistory	SystemMessageVariable2	Message Variable 2
	SystemMessageVariable3	P_GRIRProcessHistory	SystemMessageVariable3	Message Variable 3
	SystemMessageVariable4	P_GRIRProcessHistory	SystemMessageVariable4	Message Variable 4
	SystemMessageText	P_GRIRProcessHistory	SystemMessageText	Message Text
	DueDays	P_GRIRProcessHistory	DueDays	Processing Time
	CompanyCodeCurrency	P_GRIRProcessHistory	CompanyCodeCurrency	Company Code Currency
	PurgDocOrderQuantityUnit	P_GRIRProcessHistory	PurgDocOrderQuantityUnit	Purchasing Document Order Quantity Unit
	PrpsdResponsibleDepartment	P_GRIRProcessHistory	PrpsdResponsibleDepartment	Proposed Processing Department of GR/IR Clearing Process
	ProposedResponsiblePerson	P_GRIRProcessHistory	ProposedResponsiblePerson	Proposed Processor of GR/IR Clearing Process
	GRIRClrgProcessPrpsdStatus	P_GRIRProcessHistory	GRIRClrgProcessPrpsdStatus	Proposed Status of GR/IR Clearing Process
	GRIRClrgProcPrpsdPriority	P_GRIRProcessHistory	GRIRClrgProcPrpsdPriority	Proposed Priority of GR/IR Clearing Process
	GRIRClearingProcessRootCause	P_GRIRProcessHistory	GRIRClearingProcessRootCause	Root Cause for GR/IR Clearing Process
	GRIRClrgProcessPrpsdRootCause	P_GRIRProcessHistory	GRIRClrgProcessPrpsdRootCause	Proposed Root Cause of GR/IR Clearing Process
	PrpsdRespDeptMaxClProbability	P_GRIRProcessHistory	PrpsdRespDeptMaxClProbability	Processing Department Proposal Confidence
	PrpsdRespPersonMaxClassProblty	P_GRIRProcessHistory	PrpsdRespPersonMaxClassProblty	Processor Proposal Confidence
	GRIRProposedStatusMaxClProblty	P_GRIRProcessHistory	GRIRProposedStatusMaxClProblty	Status Proposal Confidence
	GRIRProposedPrioMaxClProblty	P_GRIRProcessHistory	GRIRProposedPrioMaxClProblty	Priority Proposal Confidence
	GRIRPrpsdRootCauseMaxClProblty	P_GRIRProcessHistory	GRIRPrpsdRootCauseMaxClProblty	Root Cause Proposal Confidence
	GoodsReceiptGoodsAmtInCCCrcy	P_GRIRProcessHistory	GoodsReceiptGoodsAmtInCCCrcy	Goods Receipt Amount in Company Code Currency (Goods)
	InvoiceRcptGoodsAmtInCCCrcy	P_GRIRProcessHistory	InvoiceRcptGoodsAmtInCCCrcy	Invoice Receipt Amount in Company Code Currency (Goods)
	GdsRcptDelivCostAmtInCCCrcy	P_GRIRProcessHistory	GdsRcptDelivCostAmtInCCCrcy	Goods Receipt Amount in Company Code Currency (Delivery Cost
	InvcRcptDelivCostAmtInCCCrcy	P_GRIRProcessHistory	InvcRcptDelivCostAmtInCCCrcy	Invoice Receipt Amount in Company Code Crcy (Delivery Costs)
	GoodsReceiptGoodsQuantity	P_GRIRProcessHistory	GoodsReceiptGoodsQuantity	Goods Receipt Quantity (Goods) in Reference Quantity Unit
	InvoiceReceiptGoodsQuantity	P_GRIRProcessHistory	InvoiceReceiptGoodsQuantity	Invoice Receipt Quantity (Goods) in Reference Quantity Unit
	GoodsReceiptDeliveryCostQty	P_GRIRProcessHistory	GoodsReceiptDeliveryCostQty	Goods Receipt Quantity (Delivery Costs) in Reference Quantit
	InvoiceRcptDeliveryCostQty	P_GRIRProcessHistory	InvoiceRcptDeliveryCostQty	Invoice Quantity (Delivery Costs) in Reference Quantity Unit
	GoodsBalanceAmountInCCCrcy	P_GRIRProcessHistory	GoodsBalanceAmountInCCCrcy
	GoodsBalanceQuantity	P_GRIRProcessHistory	GoodsBalanceQuantity
	DeliveryCostBalAmtInCCCrcy	P_GRIRProcessHistory	DeliveryCostBalAmtInCCCrcy
	DeliveryCostBalanceQuantity	P_GRIRProcessHistory	DeliveryCostBalanceQuantity
	GoodsReceiptAmountInCoCodeCrcy	P_GRIRProcessHistory	GoodsReceiptAmountInCoCodeCrcy
	GoodsReceiptQty	P_GRIRProcessHistory	GoodsReceiptQty	Quantity
	InvoiceRcptAmtInCoCodeCrcy	P_GRIRProcessHistory	InvoiceRcptAmtInCoCodeCrcy
	InvoiceReceiptQty	P_GRIRProcessHistory	InvoiceReceiptQty
	_CompanyCode	P_GRIRProcessHistory	_CompanyCode
	_PurchasingDocument	P_GRIRProcessHistory	_PurchasingDocument
	_PurchasingDocumentItem	P_GRIRProcessHistory	_PurchasingDocumentItem
	_LastChangedByUser		_LastChangedByUser
	_ResponsiblePerson		_ResponsiblePerson
	_GRIRProcessStatusText		_GRIRProcessStatusText
	_GRIRProcessPriorityText		_GRIRProcessPriorityText
	_GRIRProcessRootCauseText		_GRIRProcessRootCauseText
	_GRIRClrgProcPrpsdStatusText		_GRIRClrgProcPrpsdStatusText
	_GRIRClrgProcPrpsdPriorityText		_GRIRClrgProcPrpsdPriorityText
	_GRIRProcessPrpsdRootCauseText		_GRIRProcessPrpsdRootCauseText
	_CompanyCodeCurrency		_CompanyCodeCurrency
	_PurgDocOrderQuantityUnit		_PurgDocOrderQuantityUnit
	_Supplier		_Supplier

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_GRIRProcessHistory.
-- 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 I_GRIRProcessHistory AS
SELECT
  P_GRIRProcessHistory.CompanyCode AS CompanyCode,
  P_GRIRProcessHistory.PurchasingDocument AS PurchasingDocument,
  P_GRIRProcessHistory.PurchasingDocumentItem AS PurchasingDocumentItem,
  P_GRIRProcessHistory.LastChangeDateTime AS LastChangeDateTime,
  P_GRIRProcessHistory.LastChangedByUser AS LastChangedByUser,
  P_GRIRProcessHistory.ResponsibleDepartment AS ResponsibleDepartment,
  P_GRIRProcessHistory.ResponsiblePerson AS ResponsiblePerson,
  P_GRIRProcessHistory.GRIRClearingProcessStatus AS GRIRClearingProcessStatus,
  P_GRIRProcessHistory.GRIRClearingProcessPriority AS GRIRClearingProcessPriority,
  P_GRIRProcessHistory.HasNote AS HasNote,
  P_GRIRProcessHistory.Note AS Note,
  P_GRIRProcessHistory.SystemMessageIdentification AS SystemMessageIdentification,
  P_GRIRProcessHistory.SystemMessageType AS SystemMessageType,
  P_GRIRProcessHistory.SystemMessageNumber AS SystemMessageNumber,
  P_GRIRProcessHistory.AccountAssignmentCategory AS AccountAssignmentCategory,
  P_GRIRProcessHistory.BalAmtInCompanyCodeCrcy AS BalAmtInCompanyCodeCrcy,
  P_GRIRProcessHistory.BalanceQuantity AS BalanceQuantity,
  P_GRIRProcessHistory.IsFinallyInvoiced AS IsFinallyInvoiced,
  P_GRIRProcessHistory.LatestOpenItemPostingDate AS LatestOpenItemPostingDate,
  P_GRIRProcessHistory.MaterialGroup AS MaterialGroup,
  P_GRIRProcessHistory.NumberOfGoodsReceipts AS NumberOfGoodsReceipts,
  P_GRIRProcessHistory.NumberOfInvoiceReceipts AS NumberOfInvoiceReceipts,
  P_GRIRProcessHistory.OldestOpenItemPostingDate AS OldestOpenItemPostingDate,
  P_GRIRProcessHistory.Plant AS Plant,
  P_GRIRProcessHistory.PurchasingGroup AS PurchasingGroup,
  P_GRIRProcessHistory.PurchasingOrganization AS PurchasingOrganization,
  P_GRIRProcessHistory.Supplier AS Supplier,
  P_GRIRProcessHistory.SystemMessageVariable1 AS SystemMessageVariable1,
  P_GRIRProcessHistory.SystemMessageVariable2 AS SystemMessageVariable2,
  P_GRIRProcessHistory.SystemMessageVariable3 AS SystemMessageVariable3,
  P_GRIRProcessHistory.SystemMessageVariable4 AS SystemMessageVariable4,
  P_GRIRProcessHistory.SystemMessageText AS SystemMessageText,
  P_GRIRProcessHistory.DueDays AS DueDays,
  P_GRIRProcessHistory.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_GRIRProcessHistory.PurgDocOrderQuantityUnit AS PurgDocOrderQuantityUnit,
  P_GRIRProcessHistory.PrpsdResponsibleDepartment AS PrpsdResponsibleDepartment,
  P_GRIRProcessHistory.ProposedResponsiblePerson AS ProposedResponsiblePerson,
  P_GRIRProcessHistory.GRIRClrgProcessPrpsdStatus AS GRIRClrgProcessPrpsdStatus,
  P_GRIRProcessHistory.GRIRClrgProcPrpsdPriority AS GRIRClrgProcPrpsdPriority,
  P_GRIRProcessHistory.GRIRClearingProcessRootCause AS GRIRClearingProcessRootCause,
  P_GRIRProcessHistory.GRIRClrgProcessPrpsdRootCause AS GRIRClrgProcessPrpsdRootCause,
  P_GRIRProcessHistory.PrpsdRespDeptMaxClProbability AS PrpsdRespDeptMaxClProbability,
  P_GRIRProcessHistory.PrpsdRespPersonMaxClassProblty AS PrpsdRespPersonMaxClassProblty,
  P_GRIRProcessHistory.GRIRProposedStatusMaxClProblty AS GRIRProposedStatusMaxClProblty,
  P_GRIRProcessHistory.GRIRProposedPrioMaxClProblty AS GRIRProposedPrioMaxClProblty,
  P_GRIRProcessHistory.GRIRPrpsdRootCauseMaxClProblty AS GRIRPrpsdRootCauseMaxClProblty,
  P_GRIRProcessHistory.GoodsReceiptGoodsAmtInCCCrcy AS GoodsReceiptGoodsAmtInCCCrcy,
  P_GRIRProcessHistory.InvoiceRcptGoodsAmtInCCCrcy AS InvoiceRcptGoodsAmtInCCCrcy,
  P_GRIRProcessHistory.GdsRcptDelivCostAmtInCCCrcy AS GdsRcptDelivCostAmtInCCCrcy,
  P_GRIRProcessHistory.InvcRcptDelivCostAmtInCCCrcy AS InvcRcptDelivCostAmtInCCCrcy,
  P_GRIRProcessHistory.GoodsReceiptGoodsQuantity AS GoodsReceiptGoodsQuantity,
  P_GRIRProcessHistory.InvoiceReceiptGoodsQuantity AS InvoiceReceiptGoodsQuantity,
  P_GRIRProcessHistory.GoodsReceiptDeliveryCostQty AS GoodsReceiptDeliveryCostQty,
  P_GRIRProcessHistory.InvoiceRcptDeliveryCostQty AS InvoiceRcptDeliveryCostQty,
  P_GRIRProcessHistory.GoodsBalanceAmountInCCCrcy AS GoodsBalanceAmountInCCCrcy,
  P_GRIRProcessHistory.GoodsBalanceQuantity AS GoodsBalanceQuantity,
  P_GRIRProcessHistory.DeliveryCostBalAmtInCCCrcy AS DeliveryCostBalAmtInCCCrcy,
  P_GRIRProcessHistory.DeliveryCostBalanceQuantity AS DeliveryCostBalanceQuantity,
  P_GRIRProcessHistory.GoodsReceiptAmountInCoCodeCrcy AS GoodsReceiptAmountInCoCodeCrcy,
  P_GRIRProcessHistory.GoodsReceiptQty AS GoodsReceiptQty,
  P_GRIRProcessHistory.InvoiceRcptAmtInCoCodeCrcy AS InvoiceRcptAmtInCoCodeCrcy,
  P_GRIRProcessHistory.InvoiceReceiptQty AS InvoiceReceiptQty,
  P_GRIRProcessHistory._CompanyCode AS _CompanyCode,
  P_GRIRProcessHistory._PurchasingDocument AS _PurchasingDocument,
  P_GRIRProcessHistory._PurchasingDocumentItem AS _PurchasingDocumentItem
FROM P_GRIRProcessHistory
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ResponsiblePerson ON ResponsiblePerson = _ResponsiblePerson.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_GRIRProcessStatusText AS _GRIRProcessStatusText ON GRIRClearingProcessStatus = _GRIRProcessStatusText.GRIRClearingProcessStatus  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessStatusText AS _GRIRClrgProcPrpsdStatusText ON GRIRClrgProcessPrpsdStatus = _GRIRClrgProcPrpsdStatusText.GRIRClearingProcessStatus  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessPriorityText AS _GRIRProcessPriorityText ON GRIRClearingProcessPriority = _GRIRProcessPriorityText.GRIRClearingProcessPriority  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessPriorityText AS _GRIRClrgProcPrpsdPriorityText ON GRIRClrgProcPrpsdPriority = _GRIRClrgProcPrpsdPriorityText.GRIRClearingProcessPriority  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessRootCauseText AS _GRIRProcessRootCauseText ON GRIRClearingProcessRootCause = _GRIRProcessRootCauseText.GRIRClearingProcessRootCause  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessRootCauseText AS _GRIRProcessPrpsdRootCauseText ON GRIRClrgProcessPrpsdRootCause = _GRIRProcessPrpsdRootCauseText.GRIRClearingProcessRootCause  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _PurgDocOrderQuantityUnit ON PurgDocOrderQuantityUnit = _PurgDocOrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
;

Depth:

I_GRIRProcessHistory view_entity

P_GRIRProcessHistory view_entity