Which tables does P_GRIRProcessHistoryLastChange read from?

P_GRIRProcessHistoryLastChange reads data from: I_GRIRProcessHistory, P_GRIRProcHistoryLastChange1.

What VDM layer is P_GRIRProcessHistoryLastChange?

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

P_GRIRProcessHistoryLastChange

Q: What is P_GRIRProcessHistoryLastChange in SAP S/4HANA?

P_GRIRProcessHistoryLastChange is a consumption CDS view in SAP S/4HANA. It contains 80 fields.

DDL: P_GRIRPROCESSHISTORYLASTCHANGE SQL: PFIGRIRHISLCHNG Type: view CONSUMPTION

80 Fields 2 Data Sources

P_GRIRProcessHistoryLastChange is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_GRIRProcessHistory, P_GRIRProcHistoryLastChange1) and exposes 80 fields with key fields CompanyCode, PurchasingDocument, PurchasingDocumentItem, LastChangeDateTime.

Data Sources (2)

Source	Alias	Join Type
I_GRIRProcessHistory	history	from
P_GRIRProcHistoryLastChange1	last	inner

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	PFIGRIRHISLCHNG	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#NOT_ALLOWED	view
VDM.viewType	#CONSUMPTION	view
VDM.private	true	view
ObjectModel.representativeKey	LastChangeDateTime	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#B	view

Fields (80)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	I_GRIRProcessHistory	CompanyCode	Receiver Company Code
KEY	PurchasingDocument	I_GRIRProcessHistory	PurchasingDocument	Purchasing Document
KEY	PurchasingDocumentItem	I_GRIRProcessHistory	PurchasingDocumentItem	Purchasing Doc. Item
KEY	LastChangeDateTime	I_GRIRProcessHistory	LastChangeDateTime	Timestamp
	LastChangedByUser		LastChangedByUser	User Name
	ResponsibleDepartment		ResponsibleDepartment	Processing Department
	ResponsiblePerson		ResponsiblePerson	Processor
	GRIRClearingProcessStatus		GRIRClearingProcessStatus	Status
	GRIRClearingProcessPriority		GRIRClearingProcessPriority	Priority
	HasNote		HasNote	TRUE
	Note		Note	TradeRequest Comment
	SystemMessageIdentification		SystemMessageIdentification	Message ID
	SystemMessageType		SystemMessageType	Message type
	SystemMessageNumber		SystemMessageNumber	Message Number
	AccountAssignmentCategory		AccountAssignmentCategory	Acct Assgmt Cat
	PrevBalAmtInCompanyCodeCrcy		BalAmtInCompanyCodeCrcy	Balance Amount
	BalanceQuantity		BalanceQuantity	Balance Quantity
	IsFinallyInvoiced		IsFinallyInvoiced	Final Invoice
	LatestOpenItemPostingDate		LatestOpenItemPostingDate	Latest Posting Date
	MaterialGroup		MaterialGroup	Product Group
	PrevNumberOfGoodsReceipts		NumberOfGoodsReceipts	Number of Goods Receipts
	PrevNumberOfInvoiceReceipts		NumberOfInvoiceReceipts	Number of Invoice Receipts
	OldestOpenItemPostingDate		OldestOpenItemPostingDate	Oldest Posting Date
	Plant		Plant	Valuation Area
	PurchasingGroup		PurchasingGroup	Purchasing Group
	PurchasingOrganization		PurchasingOrganization	Purchasing Organization
	Supplier		Supplier	Supplier
	SystemMessageVariable1		SystemMessageVariable1	Variable 1
	SystemMessageVariable2		SystemMessageVariable2	Variable 2
	SystemMessageVariable3		SystemMessageVariable3	Variable 3
	SystemMessageVariable4		SystemMessageVariable4	Variable 4
	SystemMessageText		SystemMessageText	Message Text
	DueDays		DueDays	Processing Time
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	PurgDocOrderQuantityUnit		PurgDocOrderQuantityUnit	Purchasing Document Order Qty Unit
	PrpsdResponsibleDepartment		PrpsdResponsibleDepartment	Proposed Processing Department
	ProposedResponsiblePerson		ProposedResponsiblePerson	Proposed Processor
	GRIRClrgProcessPrpsdStatus		GRIRClrgProcessPrpsdStatus	Proposed Status
	GRIRClrgProcPrpsdPriority		GRIRClrgProcPrpsdPriority	Proposed Priority
	GRIRClearingProcessRootCause		GRIRClearingProcessRootCause	Root Cause
	GRIRClrgProcessPrpsdRootCause		GRIRClrgProcessPrpsdRootCause	Proposed Root Cause
	PrpsdRespDeptMaxClProbability		PrpsdRespDeptMaxClProbability	Processing Department Proposal Confidence
	PrpsdRespPersonMaxClassProblty		PrpsdRespPersonMaxClassProblty	Processor Proposal Confidence
	GRIRProposedStatusMaxClProblty		GRIRProposedStatusMaxClProblty	Status Proposal Confidence
	GRIRProposedPrioMaxClProblty		GRIRProposedPrioMaxClProblty	Priority Proposal Confidence
	GRIRPrpsdRootCauseMaxClProblty		GRIRPrpsdRootCauseMaxClProblty	Root Cause Proposal Confidence
	GoodsReceiptGoodsAmtInCCCrcy		GoodsReceiptGoodsAmtInCCCrcy	Goods Receipt Amount (Goods)
	InvoiceRcptGoodsAmtInCCCrcy		InvoiceRcptGoodsAmtInCCCrcy	Invoice Receipt Amount (Goods)
	GdsRcptDelivCostAmtInCCCrcy		GdsRcptDelivCostAmtInCCCrcy	Goods Receipt Amount (Delivery Costs)
	InvcRcptDelivCostAmtInCCCrcy		InvcRcptDelivCostAmtInCCCrcy	Invoice Receipt Amount (Delivery Costs)
	GoodsReceiptGoodsQuantity		GoodsReceiptGoodsQuantity	Goods Receipt Quantity (Goods)
	InvoiceReceiptGoodsQuantity		InvoiceReceiptGoodsQuantity	Invoice Receipt Quantity (Goods)
	GoodsReceiptDeliveryCostQty		GoodsReceiptDeliveryCostQty	Goods Receipt Quantity (Delivery Costs)
	InvoiceRcptDeliveryCostQty		InvoiceRcptDeliveryCostQty	Invoice Receipt Quantity (Deliv. Costs)
	GoodsBalanceAmountInCCCrcy		GoodsBalanceAmountInCCCrcy
	GoodsBalanceQuantity		GoodsBalanceQuantity
	DeliveryCostBalAmtInCCCrcy		DeliveryCostBalAmtInCCCrcy
	DeliveryCostBalanceQuantity		DeliveryCostBalanceQuantity
	GoodsReceiptAmountInCoCodeCrcy		GoodsReceiptAmountInCoCodeCrcy
	PrevGoodsReceiptQty		GoodsReceiptQty	Quantity
	InvoiceRcptAmtInCoCodeCrcy		InvoiceRcptAmtInCoCodeCrcy
	PrevInvoiceReceiptQty		InvoiceReceiptQty
	IsGoodsRcptGoodsAmtSurplus		IsGoodsRcptGoodsAmtSurplus
	IsInvoiceGoodsAmountSurplus		IsInvoiceGoodsAmountSurplus
	IsGdsRcptDelivCostAmtSurplus		IsGdsRcptDelivCostAmtSurplus
	IsInvoiceDelivCostAmtSurplus		IsInvoiceDelivCostAmtSurplus
	IsGoodsRcptGoodsQtySurplus		IsGoodsRcptGoodsQtySurplus
	IsInvoiceGoodsQtySurplus		IsInvoiceGoodsQtySurplus
	IsGdsRcptDelivCostQtySurplus		IsGdsRcptDelivCostQtySurplus
	IsInvoiceDelivCostQtySurplus		IsInvoiceDelivCostQtySurplus
	_CompanyCode		_CompanyCode
	_GRIRClrgProcPrpsdPriorityText		_GRIRClrgProcPrpsdPriorityText
	_GRIRClrgProcPrpsdStatusText		_GRIRClrgProcPrpsdStatusText
	_GRIRProcessPriorityText		_GRIRProcessPriorityText
	_GRIRProcessPrpsdRootCauseText		_GRIRProcessPrpsdRootCauseText
	_GRIRProcessRootCauseText		_GRIRProcessRootCauseText
	_GRIRProcessStatusText		_GRIRProcessStatusText
	_LastChangedByUser		_LastChangedByUser
	_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_GRIRProcessHistoryLastChange.
-- 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: PFIGRIRHISLCHNG

CREATE VIEW P_GRIRProcessHistoryLastChange AS
SELECT
  history.CompanyCode AS CompanyCode,
  history.PurchasingDocument AS PurchasingDocument,
  history.PurchasingDocumentItem AS PurchasingDocumentItem,
  history.LastChangeDateTime AS LastChangeDateTime,
  LastChangedByUser,
  ResponsibleDepartment,
  ResponsiblePerson,
  GRIRClearingProcessStatus,
  GRIRClearingProcessPriority,
  HasNote,
  Note,
  SystemMessageIdentification,
  SystemMessageType,
  SystemMessageNumber,
  AccountAssignmentCategory,
  BalAmtInCompanyCodeCrcy AS PrevBalAmtInCompanyCodeCrcy,
  BalanceQuantity,
  IsFinallyInvoiced,
  LatestOpenItemPostingDate,
  MaterialGroup,
  NumberOfGoodsReceipts AS PrevNumberOfGoodsReceipts,
  NumberOfInvoiceReceipts AS PrevNumberOfInvoiceReceipts,
  OldestOpenItemPostingDate,
  Plant,
  PurchasingGroup,
  PurchasingOrganization,
  Supplier,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  SystemMessageText,
  DueDays,
  CompanyCodeCurrency,
  PurgDocOrderQuantityUnit,
  PrpsdResponsibleDepartment,
  ProposedResponsiblePerson,
  GRIRClrgProcessPrpsdStatus,
  GRIRClrgProcPrpsdPriority,
  GRIRClearingProcessRootCause,
  GRIRClrgProcessPrpsdRootCause,
  PrpsdRespDeptMaxClProbability,
  PrpsdRespPersonMaxClassProblty,
  GRIRProposedStatusMaxClProblty,
  GRIRProposedPrioMaxClProblty,
  GRIRPrpsdRootCauseMaxClProblty,
  GoodsReceiptGoodsAmtInCCCrcy,
  InvoiceRcptGoodsAmtInCCCrcy,
  GdsRcptDelivCostAmtInCCCrcy,
  InvcRcptDelivCostAmtInCCCrcy,
  GoodsReceiptGoodsQuantity,
  InvoiceReceiptGoodsQuantity,
  GoodsReceiptDeliveryCostQty,
  InvoiceRcptDeliveryCostQty,
  GoodsBalanceAmountInCCCrcy,
  GoodsBalanceQuantity,
  DeliveryCostBalAmtInCCCrcy,
  DeliveryCostBalanceQuantity,
  GoodsReceiptAmountInCoCodeCrcy,
  GoodsReceiptQty AS PrevGoodsReceiptQty,
  InvoiceRcptAmtInCoCodeCrcy,
  InvoiceReceiptQty AS PrevInvoiceReceiptQty,
  IsGoodsRcptGoodsAmtSurplus,
  IsInvoiceGoodsAmountSurplus,
  IsGdsRcptDelivCostAmtSurplus,
  IsInvoiceDelivCostAmtSurplus,
  IsGoodsRcptGoodsQtySurplus,
  IsInvoiceGoodsQtySurplus,
  IsGdsRcptDelivCostQtySurplus,
  IsInvoiceDelivCostQtySurplus
FROM I_GRIRProcessHistory AS history
INNER JOIN P_GRIRProcHistoryLastChange1 AS last ON /* join condition not captured in parsed metadata */
;

Depth:

P_GRIRProcessHistoryLastChange view

I_GRIRProcessHistory view
P_GRIRProcHistoryLastChange1 view