P_GRIRSituationTrigger

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_GRIRSituationTrigger.
-- 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: PFIGRIRSITNTRGGR

CREATE VIEW P_GRIRSituationTrigger AS
SELECT
  current.CompanyCode AS CompanyCode,
  current.PurchasingDocument AS PurchasingDocument,
  current.PurchasingDocumentItem AS PurchasingDocumentItem,
  current.LastChangeDateTime AS LastChangeDateTime,
  cast( concat( current.PurchasingDocument, current.PurchasingDocumentItem ) as purchasingdocumentitemuniqueid ) AS PurchasingDocumentItemUniqueID,
  current.Plant AS Plant,
  current.PurchasingOrganization AS PurchasingOrganization,
  current.PurchasingGroup AS PurchasingGroup,
  current.MaterialGroup AS MaterialGroup,
  current.Material AS Material,
  current.RequisitionerName AS RequisitionerName,
  current.Supplier AS Supplier,
  current.SupplierName AS SupplierName,
  current.NumberOfOpenItems AS NumberOfOpenItems,
  current.HasNoGoodsReceiptPosted AS HasNoGoodsReceiptPosted,
  current.HasNoInvoiceReceiptPosted AS HasNoInvoiceReceiptPosted,
  current.IsGoodsRcptGoodsAmtSurplus AS IsGoodsRcptGoodsAmtSurplus,
  current.IsInvoiceGoodsAmountSurplus AS IsInvoiceGoodsAmountSurplus,
  current.IsGdsRcptDelivCostAmtSurplus AS IsGdsRcptDelivCostAmtSurplus,
  current.IsInvoiceDelivCostAmtSurplus AS IsInvoiceDelivCostAmtSurplus,
  current.IsGoodsRcptGoodsQtySurplus AS IsGoodsRcptGoodsQtySurplus,
  current.IsInvoiceGoodsQtySurplus AS IsInvoiceGoodsQtySurplus,
  current.IsGdsRcptDelivCostQtySurplus AS IsGdsRcptDelivCostQtySurplus,
  current.IsInvoiceDelivCostQtySurplus AS IsInvoiceDelivCostQtySurplus,
  current.PrpsdResponsibleDepartment AS PrpsdResponsibleDepartment,
  current.ProposedResponsiblePerson AS ProposedResponsiblePerson,
  current.GRIRClrgProcessPrpsdStatus AS GRIRClrgProcessPrpsdStatus,
  current.GRIRClrgProcPrpsdPriority AS GRIRClrgProcPrpsdPriority,
  current.GRIRClrgProcessPrpsdRootCause AS GRIRClrgProcessPrpsdRootCause,
  history.GRIRClearingProcessStatus AS GRIRClearingProcessStatus,
  history.PrevGRIRClearingProcessStatus AS PrevGRIRClearingProcessStatus,
  cast( history.GRIRClrgProcStatusIsChanged as fis_grir_status_chg ) AS GRIRClrgProcStatusIsChanged,
  history.GRIRClearingProcessPriority AS GRIRClearingProcessPriority,
  history.PrevGRIRClrgProcPriority AS PrevGRIRClrgProcPriority,
  cast( history.GRIRClrgProcPriorityIsChanged as fis_grir_prio_chg ) AS GRIRClrgProcPriorityIsChanged,
  history.ResponsiblePerson AS ResponsiblePerson,
  history.PrevResponsiblePerson AS PrevResponsiblePerson,
  cast( history.ResponsiblePersonIsChanged as fis_grir_resp_chg ) AS ResponsiblePersonIsChanged,
  history.ResponsibleDepartment AS ResponsibleDepartment,
  history.PrevResponsibleDepartment AS PrevResponsibleDepartment,
  cast( history.ResponsibleDeptIsChanged as fis_grir_dep_chg ) AS ResponsibleDeptIsChanged,
  cast( history.LastChangeDays as fis_grir_processing_days ) AS LastChangeDays,
  cast( dats_days_between( current.LatestOpenItemPostingDate, cast ( $session.system_date as abap.dats ) ) as fis_grir_days_since_last_post ) AS NumberOfDaysSinceLastPosting,
  current.GoodsReceiptGoodsAmtInCCCrcy AS GoodsReceiptGoodsAmtInCCCrcy,
  current.GdsRcptDelivCostAmtInCCCrcy AS GdsRcptDelivCostAmtInCCCrcy,
  current.InvoiceRcptGoodsAmtInCCCrcy AS InvoiceRcptGoodsAmtInCCCrcy,
  current.InvcRcptDelivCostAmtInCCCrcy AS InvcRcptDelivCostAmtInCCCrcy,
  current.GoodsReceiptGdsQtyInRefQtyUnit AS GoodsReceiptGdsQtyInRefQtyUnit,
  current.GRDelivCostQtyInRefQtyUnit AS GRDelivCostQtyInRefQtyUnit,
  current.InvoiceRcptGdsQtyInRefQtyUnit AS InvoiceRcptGdsQtyInRefQtyUnit,
  current.InvcRcptDelivQtyInRefQtyUnit AS InvcRcptDelivQtyInRefQtyUnit,
  current.GoodsBalanceAmountInCCCrcy AS GoodsBalanceAmountInCCCrcy,
  current.GdsBalanceQuantityInRefQtyUnit AS GdsBalanceQuantityInRefQtyUnit,
  current.DeliveryCostBalAmtInCCCrcy AS DeliveryCostBalAmtInCCCrcy,
  current.DelivCostBalQtyInRefQtyUnit AS DelivCostBalQtyInRefQtyUnit,
  current.GoodsReceiptAmountInCoCodeCrcy AS GoodsReceiptAmountInCoCodeCrcy,
  current.InvoiceRcptAmtInCoCodeCrcy AS InvoiceRcptAmtInCoCodeCrcy,
  BalAmtInCoCodeCrcyIsChanged,
  BalanceQuantityIsChanged,
  GoodsReceiptQtyIsChanged,
  InvoiceReceiptQtyIsChanged,
  NumberOfGoodsRcptsIsChanged,
  PrevNumberOfInvoiceReceipts,
  current.BalanceAbsoluteAmtInCoCodeCrcy AS BalanceAbsoluteAmtInCoCodeCrcy,
  current.BalAmtInCompanyCodeCrcy AS BalAmtInCompanyCodeCrcy,
  current.CompanyCodeCurrency AS CompanyCodeCurrency,
  current.LastChangedByUser AS LastChangedByUser,
  current.HasNote AS HasNote,
  current.GRIRClearingProcessRootCause AS GRIRClearingProcessRootCause,
  current.PrpsdRespDeptMaxClProbability AS PrpsdRespDeptMaxClProbability,
  current.PrpsdRespPersonMaxClassProblty AS PrpsdRespPersonMaxClassProblty,
  current.GRIRProposedStatusMaxClProblty AS GRIRProposedStatusMaxClProblty,
  current.GRIRProposedPrioMaxClProblty AS GRIRProposedPrioMaxClProblty,
  current.GRIRPrpsdRootCauseMaxClProblty AS GRIRPrpsdRootCauseMaxClProblty,
  PurchasingDocumentItemText,
  ValuationArea,
  ValuationType,
  NumberOfPurchaseOrderItems,
  current.LatestOpenItemPostingDate AS LatestOpenItemPostingDate,
  current.OldestOpenItemPostingDate AS OldestOpenItemPostingDate,
  current.AccountAssignmentCategory AS AccountAssignmentCategory,
  current.IsFinallyInvoiced AS IsFinallyInvoiced,
  PurchasingDocumentDeletionCode,
  current._PurchasingDocumentItem AS _PurchasingDocumentItem
FROM P_GRIRAcctRecnclnSituation AS current
;