P_GRIRAcctRecnclnSituation

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_GRIRAcctRecnclnSituation.
-- 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: PFIRECNCLNSITN

CREATE VIEW P_GRIRAcctRecnclnSituation AS
SELECT
  current.CompanyCode AS CompanyCode,
  current.PurchasingDocument AS PurchasingDocument,
  current.PurchasingDocumentItem AS PurchasingDocumentItem,
  current.LastChangeDateTime AS LastChangeDateTime,
  current.CompanyCodeCurrency AS CompanyCodeCurrency,
  abs(last.PrevBalAmtInCompanyCodeCrcy - current.BalAmtInCompanyCodeCrcy) AS BalAmtInCoCodeCrcyIsChanged,
  abs(last.BalanceQuantity - current.BalanceQuantityInRefQtyUnit) AS BalanceQuantityIsChanged,
  abs(last.PrevGoodsReceiptQty - current.GoodsReceiptQtyInRefQtyUnit) AS GoodsReceiptQtyIsChanged,
  abs(last.PrevInvoiceReceiptQty - current.InvoiceReceiptQtyInRefQtyUnit) AS InvoiceReceiptQtyIsChanged,
  abs(last.PrevNumberOfGoodsReceipts - current.NumberOfGoodsReceipts) AS NumberOfGoodsRcptsIsChanged,
  last.PrevNumberOfInvoiceReceipts AS PrevNumberOfInvoiceReceipts,
  current.PurgDocOrderQuantityUnit AS PurgDocOrderQuantityUnit,
  current.BalanceAbsoluteAmtInCoCodeCrcy AS BalanceAbsoluteAmtInCoCodeCrcy,
  current.BalAmtInCompanyCodeCrcy AS BalAmtInCompanyCodeCrcy,
  PurchasingDocumentOrderQty,
  current.NumberOfInvoiceReceipts AS NumberOfInvoiceReceipts,
  current.LastChangedByUser AS LastChangedByUser,
  current.ResponsibleDepartment AS ResponsibleDepartment,
  current.ResponsiblePerson AS ResponsiblePerson,
  current.GRIRClearingProcessStatus AS GRIRClearingProcessStatus,
  current.GRIRClearingProcessPriority AS GRIRClearingProcessPriority,
  current.HasNote AS HasNote,
  current.GRIRClearingProcessRootCause AS GRIRClearingProcessRootCause,
  current.LastChangeDate AS LastChangeDate,
  current.SystemMessageIdentification AS SystemMessageIdentification,
  current.SystemMessageType AS SystemMessageType,
  current.SystemMessageNumber AS SystemMessageNumber,
  current.SystemMessageVariable1 AS SystemMessageVariable1,
  current.SystemMessageVariable2 AS SystemMessageVariable2,
  current.SystemMessageVariable3 AS SystemMessageVariable3,
  current.SystemMessageVariable4 AS SystemMessageVariable4,
  current.SystemMessageText AS SystemMessageText,
  current.PrpsdResponsibleDepartment AS PrpsdResponsibleDepartment,
  current.ProposedResponsiblePerson AS ProposedResponsiblePerson,
  current.GRIRClrgProcessPrpsdStatus AS GRIRClrgProcessPrpsdStatus,
  current.GRIRClrgProcPrpsdPriority AS GRIRClrgProcPrpsdPriority,
  current.GRIRClrgProcessPrpsdRootCause AS GRIRClrgProcessPrpsdRootCause,
  current.PrpsdRespDeptMaxClProbability AS PrpsdRespDeptMaxClProbability,
  current.PrpsdRespPersonMaxClassProblty AS PrpsdRespPersonMaxClassProblty,
  current.GRIRProposedStatusMaxClProblty AS GRIRProposedStatusMaxClProblty,
  current.GRIRProposedPrioMaxClProblty AS GRIRProposedPrioMaxClProblty,
  current.GRIRPrpsdRootCauseMaxClProblty AS GRIRPrpsdRootCauseMaxClProblty,
  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.AccountAssignmentCategory AS AccountAssignmentCategory,
  current.IsFinallyInvoiced AS IsFinallyInvoiced,
  current.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  current.Supplier AS Supplier,
  current.SupplierName AS SupplierName,
  current.CreatedByUser AS CreatedByUser,
  current.LastChangeDays AS LastChangeDays,
  current.LatestOpenItemPostingDate AS LatestOpenItemPostingDate,
  current.OldestOpenItemPostingDate AS OldestOpenItemPostingDate,
  current.NumberOfOpenItems AS NumberOfOpenItems,
  current.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  current.ValuationArea AS ValuationArea,
  current.ValuationType AS ValuationType,
  current.NumberOfPurchaseOrderItems AS NumberOfPurchaseOrderItems,
  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,
  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._CompanyCode AS _CompanyCode,
  current._CompanyCodeCurrency AS _CompanyCodeCurrency,
  current._GRIRProcess AS _GRIRProcess,
  current._Material AS _Material,
  current._MaterialGroup AS _MaterialGroup,
  current._Plant AS _Plant,
  current._PurchasingDocument AS _PurchasingDocument,
  current._PurchasingDocumentItem AS _PurchasingDocumentItem,
  current._Supplier AS _Supplier
FROM I_GRIRAccountReconciliation AS current
;