P_GRIRProcessHistoryLastChange

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.

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