P_GRIRProcessSituation

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_GRIRProcessSituation.
-- 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_GRIRProcessSituation AS
SELECT
  history.CompanyCode AS CompanyCode,
  history.PurchasingDocument AS PurchasingDocument,
  history.PurchasingDocumentItem AS PurchasingDocumentItem,
  history.LastChangeDateTime AS LastChangeDateTime,
  history.LastChangedByUser AS LastChangedByUser,
  history.GRIRClearingProcessStatus AS GRIRClearingProcessStatus,
  history.PrevGRIRClearingProcessStatus AS PrevGRIRClearingProcessStatus,
  history.GRIRClearingProcessPriority AS GRIRClearingProcessPriority,
  history.PrevGRIRClrgProcPriority AS PrevGRIRClrgProcPriority,
  history.ResponsiblePerson AS ResponsiblePerson,
  history.PrevResponsiblePerson AS PrevResponsiblePerson,
  history.ResponsibleDepartment AS ResponsibleDepartment,
  history.PrevResponsibleDepartment AS PrevResponsibleDepartment,
  history.GRIRClearingProcessRootCause AS GRIRClearingProcessRootCause,
  dats_days_between( tstmp_to_dats(history.LastChangeDateTime, '', $session.client, 'NULL'), cast ( $session.system_date as abap.dats ) ) AS LastChangeDays,
  history.HasNote AS HasNote,
  history.SystemMessageIdentification AS SystemMessageIdentification,
  history.SystemMessageType AS SystemMessageType,
  history.SystemMessageNumber AS SystemMessageNumber,
  history.AccountAssignmentCategory AS AccountAssignmentCategory,
  history.BalAmtInCompanyCodeCrcy AS BalAmtInCompanyCodeCrcy,
  history.BalanceQuantity AS BalanceQuantity,
  history.IsFinallyInvoiced AS IsFinallyInvoiced,
  history.LatestOpenItemPostingDate AS LatestOpenItemPostingDate,
  history.MaterialGroup AS MaterialGroup,
  history.NumberOfGoodsReceipts AS NumberOfGoodsReceipts,
  history.NumberOfInvoiceReceipts AS NumberOfInvoiceReceipts,
  history.OldestOpenItemPostingDate AS OldestOpenItemPostingDate,
  history.Plant AS Plant,
  history.PurchasingGroup AS PurchasingGroup,
  history.PurchasingOrganization AS PurchasingOrganization,
  history.Supplier AS Supplier,
  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.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 GoodsReceiptQty,
  history.InvoiceRcptAmtInCoCodeCrcy AS InvoiceRcptAmtInCoCodeCrcy,
  history.InvoiceReceiptQty AS InvoiceReceiptQty,
  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._PurchasingDocument AS _PurchasingDocument,
  history._PurchasingDocumentItem AS _PurchasingDocumentItem
FROM P_GRIRProcessHistoryLastChange AS last
INNER JOIN P_GRIRProcHistPredecessor AS history ON /* join condition not captured in parsed metadata */
;