What is P_GRIRProcessHistory in SAP S/4HANA?

P_GRIRProcessHistory is a basic CDS view in SAP S/4HANA. GR/IR Process History It contains 65 fields.

Which tables does P_GRIRProcessHistory read from?

P_GRIRProcessHistory reads data from: fins_grirprochis.

What VDM layer is P_GRIRProcessHistory?

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

P_GRIRProcessHistory

DDL: P_GRIRPROCESSHISTORY Type: view_entity BASIC Package: FINS_FIS_FICO

65 Fields 1 Data Sources

GR/IR Process History

P_GRIRProcessHistory is a Basic CDS View that provides data about "GR/IR Process History" in SAP S/4HANA. It reads from 1 data source (fins_grirprochis) and exposes 65 fields with key fields CompanyCode, PurchasingDocument, PurchasingDocumentItem, LastChangeDateTime. Part of development package FINS_FIS_FICO.

Data Sources (1)

Source	Alias	Join Type
fins_grirprochis	fins_grirprochis	from

Annotations (9)

Name	Value	Level
AbapCatalog.entityBuffer.definitionAllowed	false	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
VDM.viewType	#BASIC	view
VDM.private	true	view
ObjectModel.representativeKey	LastChangeDateTime	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#B	view

Fields (65)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	fins_grirprochis	companycode	Receiver Company Code
KEY	PurchasingDocument	fins_grirprochis	purchasingdocument	Purchasing Document
KEY	PurchasingDocumentItem	fins_grirprochis	purchasingdocumentitem	Purchasing Doc. Item
KEY	LastChangeDateTime	fins_grirprochis	lastchangedatetime	Timestamp
	LastChangedByUser	fins_grirprochis	lastchangedbyuser	User Name
	ResponsibleDepartment	fins_grirprochis	responsibledepartment	Processing Department
	ResponsiblePerson	fins_grirprochis	responsibleperson	Processor
	GRIRClearingProcessStatus	fins_grirprochis	grirclearingprocessstatus	Status
	GRIRClearingProcessPriority	fins_grirprochis	grirclearingprocesspriority	Priority
	HasNote	fins_grirprochis	hasnote	TRUE
	Note	fins_grirprochis	note	TradeRequest Comment
	SystemMessageIdentification	fins_grirprochis	systemmessageidentification	Message ID
	SystemMessageType	fins_grirprochis	systemmessagetype	Message type
	SystemMessageNumber	fins_grirprochis	systemmessagenumber	Message Number
	AccountAssignmentCategory	fins_grirprochis	accountassignmentcategory	Acct Assgmt Cat
	BalAmtInCompanyCodeCrcy	fins_grirprochis	balamtincompanycodecrcy	Balance Amount
	BalanceQuantity	fins_grirprochis	balancequantity	Balance Quantity
	IsFinallyInvoiced	fins_grirprochis	isfinallyinvoiced	Final Invoice
	LatestOpenItemPostingDate	fins_grirprochis	latestopenitempostingdate	Latest Posting Date
	MaterialGroup	fins_grirprochis	materialgroup	Product Group
	NumberOfGoodsReceipts	fins_grirprochis	numberofgoodsreceipts	Number of Goods Receipts
	NumberOfInvoiceReceipts	fins_grirprochis	numberofinvoicereceipts	Number of Invoice Receipts
	OldestOpenItemPostingDate	fins_grirprochis	oldestopenitempostingdate	Oldest Posting Date
	Plant	fins_grirprochis	plant	Valuation Area
	PurchasingGroup	fins_grirprochis	purchasinggroup	Purchasing Group
	PurchasingOrganization	fins_grirprochis	purchasingorganization	Purchasing Organization
	Supplier	fins_grirprochis	supplier	Supplier
	SystemMessageVariable1
	SystemMessageVariable2
	SystemMessageVariable3
	SystemMessageVariable4
	SystemMessageText	fins_grirprochis	systemmessagetext	Message Text
	DueDays	fins_grirprochis	duedays	Processing Time
	CompanyCodeCurrency	fins_grirprochis	companycodecurrency	Local Currency
	PurgDocOrderQuantityUnit	fins_grirprochis	purgdocorderquantityunit	Purchasing Document Order Qty Unit
	PrpsdResponsibleDepartment	fins_grirprochis	prpsdresponsibledepartment	Proposed Processing Department
	ProposedResponsiblePerson	fins_grirprochis	proposedresponsibleperson	Proposed Processor
	GRIRClrgProcessPrpsdStatus	fins_grirprochis	grirclrgprocessprpsdstatus	Proposed Status
	GRIRClrgProcPrpsdPriority	fins_grirprochis	grirclrgprocprpsdpriority	Proposed Priority
	GRIRClearingProcessRootCause	fins_grirprochis	grirclearingprocessrootcause	Root Cause
	GRIRClrgProcessPrpsdRootCause	fins_grirprochis	grirclrgprocessprpsdrootcause	Proposed Root Cause
	PrpsdRespDeptMaxClProbability	fins_grirprochis	prpsdrespdeptmaxclprobability	Processing Department Proposal Confidence
	PrpsdRespPersonMaxClassProblty	fins_grirprochis	prpsdresppersonmaxclassproblty	Processor Proposal Confidence
	GRIRProposedStatusMaxClProblty	fins_grirprochis	grirproposedstatusmaxclproblty	Status Proposal Confidence
	GRIRProposedPrioMaxClProblty	fins_grirprochis	grirproposedpriomaxclproblty	Priority Proposal Confidence
	GRIRPrpsdRootCauseMaxClProblty	fins_grirprochis	grirprpsdrootcausemaxclproblty	Root Cause Proposal Confidence
	GoodsReceiptGoodsAmtInCCCrcy	fins_grirprochis	goodsreceiptgoodsamtincccrcy	Goods Receipt Amount (Goods)
	InvoiceRcptGoodsAmtInCCCrcy	fins_grirprochis	invoicercptgoodsamtincccrcy	Invoice Receipt Amount (Goods)
	GdsRcptDelivCostAmtInCCCrcy	fins_grirprochis	gdsrcptdelivcostamtincccrcy	Goods Receipt Amount (Delivery Costs)
	InvcRcptDelivCostAmtInCCCrcy	fins_grirprochis	invcrcptdelivcostamtincccrcy	Invoice Receipt Amount (Delivery Costs)
	GoodsReceiptGoodsQuantity	fins_grirprochis	goodsreceiptgoodsquantity	Goods Receipt Quantity (Goods)
	InvoiceReceiptGoodsQuantity	fins_grirprochis	invoicereceiptgoodsquantity	Invoice Receipt Quantity (Goods)
	GoodsReceiptDeliveryCostQty	fins_grirprochis	goodsreceiptdeliverycostqty	Goods Receipt Quantity (Delivery Costs)
	InvoiceRcptDeliveryCostQty	fins_grirprochis	invoicercptdeliverycostqty	Invoice Receipt Quantity (Deliv. Costs)
	GoodsBalanceAmountInCCCrcy
	GoodsBalanceQuantity
	DeliveryCostBalAmtInCCCrcy
	DeliveryCostBalanceQuantity
	GoodsReceiptAmountInCoCodeCrcy
	GoodsReceiptQty
	InvoiceRcptAmtInCoCodeCrcy
	InvoiceReceiptQty
	_CompanyCode		_CompanyCode
	_PurchasingDocument		_PurchasingDocument
	_PurchasingDocumentItem		_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 P_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 P_GRIRProcessHistory AS
SELECT
  fins_grirprochis.companycode AS CompanyCode,
  fins_grirprochis.purchasingdocument AS PurchasingDocument,
  fins_grirprochis.purchasingdocumentitem AS PurchasingDocumentItem,
  fins_grirprochis.lastchangedatetime AS LastChangeDateTime,
  fins_grirprochis.lastchangedbyuser AS LastChangedByUser,
  fins_grirprochis.responsibledepartment AS ResponsibleDepartment,
  fins_grirprochis.responsibleperson AS ResponsiblePerson,
  fins_grirprochis.grirclearingprocessstatus AS GRIRClearingProcessStatus,
  fins_grirprochis.grirclearingprocesspriority AS GRIRClearingProcessPriority,
  fins_grirprochis.hasnote AS HasNote,
  fins_grirprochis.note AS Note,
  fins_grirprochis.systemmessageidentification AS SystemMessageIdentification,
  fins_grirprochis.systemmessagetype AS SystemMessageType,
  fins_grirprochis.systemmessagenumber AS SystemMessageNumber,
  fins_grirprochis.accountassignmentcategory AS AccountAssignmentCategory,
  fins_grirprochis.balamtincompanycodecrcy AS BalAmtInCompanyCodeCrcy,
  fins_grirprochis.balancequantity AS BalanceQuantity,
  fins_grirprochis.isfinallyinvoiced AS IsFinallyInvoiced,
  fins_grirprochis.latestopenitempostingdate AS LatestOpenItemPostingDate,
  fins_grirprochis.materialgroup AS MaterialGroup,
  fins_grirprochis.numberofgoodsreceipts AS NumberOfGoodsReceipts,
  fins_grirprochis.numberofinvoicereceipts AS NumberOfInvoiceReceipts,
  fins_grirprochis.oldestopenitempostingdate AS OldestOpenItemPostingDate,
  fins_grirprochis.plant AS Plant,
  fins_grirprochis.purchasinggroup AS PurchasingGroup,
  fins_grirprochis.purchasingorganization AS PurchasingOrganization,
  fins_grirprochis.supplier AS Supplier,
  cast( fins_grirprochis.systemmessagevariable1 as fis_grir_msgv1 preserving type ) AS SystemMessageVariable1,
  cast( fins_grirprochis.systemmessagevariable2 as fis_grir_msgv2 preserving type ) AS SystemMessageVariable2,
  cast( fins_grirprochis.systemmessagevariable3 as fis_grir_msgv3 preserving type ) AS SystemMessageVariable3,
  cast( fins_grirprochis.systemmessagevariable4 as fis_grir_msgv4 preserving type ) AS SystemMessageVariable4,
  fins_grirprochis.systemmessagetext AS SystemMessageText,
  fins_grirprochis.duedays AS DueDays,
  fins_grirprochis.companycodecurrency AS CompanyCodeCurrency,
  fins_grirprochis.purgdocorderquantityunit AS PurgDocOrderQuantityUnit,
  fins_grirprochis.prpsdresponsibledepartment AS PrpsdResponsibleDepartment,
  fins_grirprochis.proposedresponsibleperson AS ProposedResponsiblePerson,
  fins_grirprochis.grirclrgprocessprpsdstatus AS GRIRClrgProcessPrpsdStatus,
  fins_grirprochis.grirclrgprocprpsdpriority AS GRIRClrgProcPrpsdPriority,
  fins_grirprochis.grirclearingprocessrootcause AS GRIRClearingProcessRootCause,
  fins_grirprochis.grirclrgprocessprpsdrootcause AS GRIRClrgProcessPrpsdRootCause,
  fins_grirprochis.prpsdrespdeptmaxclprobability AS PrpsdRespDeptMaxClProbability,
  fins_grirprochis.prpsdresppersonmaxclassproblty AS PrpsdRespPersonMaxClassProblty,
  fins_grirprochis.grirproposedstatusmaxclproblty AS GRIRProposedStatusMaxClProblty,
  fins_grirprochis.grirproposedpriomaxclproblty AS GRIRProposedPrioMaxClProblty,
  fins_grirprochis.grirprpsdrootcausemaxclproblty AS GRIRPrpsdRootCauseMaxClProblty,
  fins_grirprochis.goodsreceiptgoodsamtincccrcy AS GoodsReceiptGoodsAmtInCCCrcy,
  fins_grirprochis.invoicercptgoodsamtincccrcy AS InvoiceRcptGoodsAmtInCCCrcy,
  fins_grirprochis.gdsrcptdelivcostamtincccrcy AS GdsRcptDelivCostAmtInCCCrcy,
  fins_grirprochis.invcrcptdelivcostamtincccrcy AS InvcRcptDelivCostAmtInCCCrcy,
  fins_grirprochis.goodsreceiptgoodsquantity AS GoodsReceiptGoodsQuantity,
  fins_grirprochis.invoicereceiptgoodsquantity AS InvoiceReceiptGoodsQuantity,
  fins_grirprochis.goodsreceiptdeliverycostqty AS GoodsReceiptDeliveryCostQty,
  fins_grirprochis.invoicercptdeliverycostqty AS InvoiceRcptDeliveryCostQty,
  fins_grirprochis.goodsreceiptgoodsamtincccrcy + fins_grirprochis.invoicercptgoodsamtincccrcy AS GoodsBalanceAmountInCCCrcy,
  fins_grirprochis.goodsreceiptgoodsquantity + fins_grirprochis.invoicereceiptgoodsquantity AS GoodsBalanceQuantity,
  fins_grirprochis.gdsrcptdelivcostamtincccrcy + fins_grirprochis.invcrcptdelivcostamtincccrcy AS DeliveryCostBalAmtInCCCrcy,
  fins_grirprochis.goodsreceiptdeliverycostqty + fins_grirprochis.invoicercptdeliverycostqty AS DeliveryCostBalanceQuantity,
  fins_grirprochis.goodsreceiptgoodsamtincccrcy + fins_grirprochis.gdsrcptdelivcostamtincccrcy AS GoodsReceiptAmountInCoCodeCrcy,
  fins_grirprochis.goodsreceiptgoodsquantity + fins_grirprochis.goodsreceiptdeliverycostqty AS GoodsReceiptQty,
  fins_grirprochis.invoicercptgoodsamtincccrcy + fins_grirprochis.invcrcptdelivcostamtincccrcy AS InvoiceRcptAmtInCoCodeCrcy,
  fins_grirprochis.invoicereceiptgoodsquantity + fins_grirprochis.invoicercptdeliverycostqty AS InvoiceReceiptQty
FROM fins_grirprochis
;

Depth:

P_GRIRProcessHistory view_entity

fins_grirprochis

I_GRIRProcessHistory view_entity