C_GRIRAccountReconciliation

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 C_GRIRAccountReconciliation.
-- 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: CFIGRIRMONITOR

CREATE VIEW C_GRIRAccountReconciliation AS
SELECT
  I_GRIRAccountReconciliation.CompanyCode AS CompanyCode,
  I_GRIRAccountReconciliation.PurchasingDocument AS PurchasingDocument,
  I_GRIRAccountReconciliation.PurchasingDocumentItem AS PurchasingDocumentItem,
  cast( _CompanyCode.CompanyCodeName as fis_butxt preserving type ) AS CompanyCodeName,
  I_GRIRAccountReconciliation.PurchasingDocumentItemUniqueID AS PurchasingDocumentItemUniqueID,
  I_GRIRAccountReconciliation.BalAmtInCompanyCodeCrcy AS BalAmtInCompanyCodeCrcy,
  I_GRIRAccountReconciliation.BalanceAbsoluteAmtInCoCodeCrcy AS BalanceAbsoluteAmtInCoCodeCrcy,
  I_GRIRAccountReconciliation.ReferenceQuantityUnit AS ReferenceQuantityUnit,
  I_GRIRAccountReconciliation.BalanceQuantityInRefQtyUnit AS BalanceQuantityInRefQtyUnit,
  I_GRIRAccountReconciliation.BalanceAbsoluteQtyInRefQtyUnit AS BalanceAbsoluteQtyInRefQtyUnit,
  I_GRIRAccountReconciliation.GoodsReceiptQtyInRefQtyUnit AS GoodsReceiptQtyInRefQtyUnit,
  I_GRIRAccountReconciliation.InvoiceReceiptQtyInRefQtyUnit AS InvoiceReceiptQtyInRefQtyUnit,
  I_GRIRAccountReconciliation.PurchasingDocumentOrderQty AS PurchasingDocumentOrderQty,
  I_GRIRAccountReconciliation.NumberOfGoodsReceipts AS NumberOfGoodsReceipts,
  I_GRIRAccountReconciliation.NumberOfInvoiceReceipts AS NumberOfInvoiceReceipts,
  I_GRIRAccountReconciliation.LastChangeDateTime AS LastChangeDateTime,
  I_GRIRAccountReconciliation.LastChangedByUser AS LastChangedByUser,
  I_GRIRAccountReconciliation.ResponsiblePerson AS ResponsiblePerson,
  I_GRIRAccountReconciliation.GRIRClearingProcessStatus AS GRIRClearingProcessStatus,
  I_GRIRAccountReconciliation.GRIRClearingProcessPriority AS GRIRClearingProcessPriority,
  I_GRIRAccountReconciliation.HasNote AS HasNote,
  I_GRIRAccountReconciliation.GRIRClearingProcessRootCause AS GRIRClearingProcessRootCause,
  I_GRIRAccountReconciliation.LastChangeDate AS LastChangeDate,
  I_GRIRAccountReconciliation.LatestPostingIsAfterLastChange AS LatestPostingIsAfterLastChange,
  I_GRIRAccountReconciliation.SystemMessageIdentification AS SystemMessageIdentification,
  I_GRIRAccountReconciliation.SystemMessageType AS SystemMessageType,
  I_GRIRAccountReconciliation.SystemMessageNumber AS SystemMessageNumber,
  I_GRIRAccountReconciliation.SystemMessageVariable1 AS SystemMessageVariable1,
  I_GRIRAccountReconciliation.SystemMessageVariable2 AS SystemMessageVariable2,
  I_GRIRAccountReconciliation.SystemMessageVariable3 AS SystemMessageVariable3,
  I_GRIRAccountReconciliation.SystemMessageVariable4 AS SystemMessageVariable4,
  I_GRIRAccountReconciliation.SystemMessageText AS SystemMessageText,
  I_GRIRAccountReconciliation.PrpsdResponsibleDepartment AS PrpsdResponsibleDepartment,
  I_GRIRAccountReconciliation.ProposedResponsiblePerson AS ProposedResponsiblePerson,
  I_GRIRAccountReconciliation.GRIRClrgProcessPrpsdStatus AS GRIRClrgProcessPrpsdStatus,
  I_GRIRAccountReconciliation.GRIRClrgProcPrpsdPriority AS GRIRClrgProcPrpsdPriority,
  I_GRIRAccountReconciliation.GRIRClrgProcessPrpsdRootCause AS GRIRClrgProcessPrpsdRootCause,
  I_GRIRAccountReconciliation.PrpsdRespDeptMaxClProbability AS PrpsdRespDeptMaxClProbability,
  I_GRIRAccountReconciliation.PrpsdRespPersonMaxClassProblty AS PrpsdRespPersonMaxClassProblty,
  I_GRIRAccountReconciliation.GRIRProposedStatusMaxClProblty AS GRIRProposedStatusMaxClProblty,
  I_GRIRAccountReconciliation.GRIRProposedPrioMaxClProblty AS GRIRProposedPrioMaxClProblty,
  I_GRIRAccountReconciliation.GRIRPrpsdRootCauseMaxClProblty AS GRIRPrpsdRootCauseMaxClProblty,
  I_GRIRAccountReconciliation.GRIRProcPrpslLastChangeDteTime AS GRIRProcPrpslLastChangeDteTime,
  cast(_Plant.PlantName as werks_name preserving type ) AS PlantName,
  I_GRIRAccountReconciliation.PurchasingOrganization AS PurchasingOrganization,
  cast( _PurchasingOrganization.PurchasingOrganizationName as mm_a_purg_org_name preserving type ) AS PurchasingOrganizationName,
  I_GRIRAccountReconciliation.PurchasingGroup AS PurchasingGroup,
  cast(_PurchasingGroup.PurchasingGroupName as mm_a_purg_grp_name preserving type ) AS PurchasingGroupName,
  I_GRIRAccountReconciliation.MaterialGroup AS MaterialGroup,
  I_GRIRAccountReconciliation.Material AS Material,
  I_GRIRAccountReconciliation.RequisitionerName AS RequisitionerName,
  I_GRIRAccountReconciliation.AccountAssignmentCategory AS AccountAssignmentCategory,
  I_GRIRAccountReconciliation.IsFinallyInvoiced AS IsFinallyInvoiced,
  I_GRIRAccountReconciliation.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  I_GRIRAccountReconciliation.Supplier AS Supplier,
  I_GRIRAccountReconciliation.SupplierName AS SupplierName,
  I_GRIRAccountReconciliation.CreatedByUser AS CreatedByUser,
  I_GRIRAccountReconciliation.LastChangeDays AS LastChangeDays,
  I_GRIRAccountReconciliation.LatestOpenItemPostingDate AS LatestOpenItemPostingDate,
  I_GRIRAccountReconciliation.OldestOpenItemPostingDate AS OldestOpenItemPostingDate,
  I_GRIRAccountReconciliation.NumberOfOpenItems AS NumberOfOpenItems,
  I_GRIRAccountReconciliation.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  I_GRIRAccountReconciliation.ValuationArea AS ValuationArea,
  I_GRIRAccountReconciliation.ValuationType AS ValuationType,
  I_GRIRAccountReconciliation.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  I_GRIRAccountReconciliation.NumberOfPurchaseOrderItems AS NumberOfPurchaseOrderItems,
  I_GRIRAccountReconciliation.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_GRIRAccountReconciliation.PurchasingDocumentType AS PurchasingDocumentType,
  I_GRIRAccountReconciliation.InvoicingParty AS InvoicingParty,
  cast( I_GRIRAccountReconciliation.InvoicingPartyName as wlf_lifre_name preserving type ) AS InvoicingPartyName,
  I_GRIRAccountReconciliation.GdsRcptDelivCostAmtInCCCrcy AS GdsRcptDelivCostAmtInCCCrcy,
  I_GRIRAccountReconciliation.InvoiceRcptGoodsAmtInCCCrcy AS InvoiceRcptGoodsAmtInCCCrcy,
  I_GRIRAccountReconciliation.InvcRcptDelivCostAmtInCCCrcy AS InvcRcptDelivCostAmtInCCCrcy,
  I_GRIRAccountReconciliation.GoodsReceiptGdsQtyInRefQtyUnit AS GoodsReceiptGdsQtyInRefQtyUnit,
  I_GRIRAccountReconciliation.GRDelivCostQtyInRefQtyUnit AS GRDelivCostQtyInRefQtyUnit,
  I_GRIRAccountReconciliation.InvoiceRcptGdsQtyInRefQtyUnit AS InvoiceRcptGdsQtyInRefQtyUnit,
  I_GRIRAccountReconciliation.InvcRcptDelivQtyInRefQtyUnit AS InvcRcptDelivQtyInRefQtyUnit,
  I_GRIRAccountReconciliation.GoodsBalanceAmountInCCCrcy AS GoodsBalanceAmountInCCCrcy,
  I_GRIRAccountReconciliation.GdsBalanceQuantityInRefQtyUnit AS GdsBalanceQuantityInRefQtyUnit,
  I_GRIRAccountReconciliation.DeliveryCostBalAmtInCCCrcy AS DeliveryCostBalAmtInCCCrcy,
  I_GRIRAccountReconciliation.DelivCostBalQtyInRefQtyUnit AS DelivCostBalQtyInRefQtyUnit,
  I_GRIRAccountReconciliation.GoodsReceiptAmountInCoCodeCrcy AS GoodsReceiptAmountInCoCodeCrcy
FROM I_GRIRAccountReconciliation
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUser ON CreatedByUser = _CreatedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ResponsiblePerson ON ResponsiblePerson = _ResponsiblePerson.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ProposedResponsiblePerson ON ProposedResponsiblePerson = _ProposedResponsiblePerson.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _RequisitionerUser ON RequisitionerName = _RequisitionerUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN C_GRIROplAccountingDocItem AS _GRIROplAccountingDocItem ON CompanyCode = _GRIROplAccountingDocItem.CompanyCode AND PurchasingDocument = _GRIROplAccountingDocItem.PurchasingDocument AND PurchasingDocumentItem = _GRIROplAccountingDocItem.PurchasingDocumentItem AND _GRIROplAccountingDocItem.IsGRIROpenItem = 'X'  -- association [0..*]
LEFT OUTER JOIN C_GRIRPurchaseOrderHistory AS _GRIRPurchaseOrderHistory ON PurchasingDocument = _GRIRPurchaseOrderHistory.PurchasingDocument AND PurchasingDocumentItem = _GRIRPurchaseOrderHistory.PurchasingDocumentItem  -- association [0..*]
LEFT OUTER JOIN C_GRIRPurchasingDocItem AS _GRIRPurchasingDocItem ON PurchasingDocument = _GRIRPurchasingDocItem.PurchasingDocument AND PurchasingDocumentItem = _GRIRPurchasingDocItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN C_GRIRFollowOnStatus AS _GRIRFollowOnStatus ON GRIRClearingProcessStatus = _GRIRFollowOnStatus.GRIRClearingProcessStatus  -- association [0..*]
LEFT OUTER JOIN C_GRIRProcessHistoryNote AS _GRIRProcessHistoryNote ON CompanyCode = _GRIRProcessHistoryNote.CompanyCode AND PurchasingDocument = _GRIRProcessHistoryNote.PurchasingDocument AND PurchasingDocumentItem = _GRIRProcessHistoryNote.PurchasingDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessHistory AS _GRIRProcessHistory ON CompanyCode = _GRIRProcessHistory.CompanyCode AND PurchasingDocument = _GRIRProcessHistory.PurchasingDocument AND PurchasingDocumentItem = _GRIRProcessHistory.PurchasingDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessStatusText AS _GRIRProcessStatusText ON GRIRClearingProcessStatus = _GRIRProcessStatusText.GRIRClearingProcessStatus  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessStatusText AS _GRIRClrgProcPrpsdStatusText ON GRIRClrgProcessPrpsdStatus = _GRIRClrgProcPrpsdStatusText.GRIRClearingProcessStatus  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessPriorityText AS _GRIRProcessPriorityText ON GRIRClearingProcessPriority = _GRIRProcessPriorityText.GRIRClearingProcessPriority  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessPriorityText AS _GRIRClrgProcPrpsdPriorityText ON GRIRClrgProcPrpsdPriority = _GRIRClrgProcPrpsdPriorityText.GRIRClearingProcessPriority  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessRootCauseText AS _GRIRProcessRootCauseText ON GRIRClearingProcessRootCause = _GRIRProcessRootCauseText.GRIRClearingProcessRootCause  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessRootCauseText AS _GRIRProcessPrpsdRootCauseText ON GRIRClrgProcessPrpsdRootCause = _GRIRProcessPrpsdRootCauseText.GRIRClearingProcessRootCause  -- association [0..*]
LEFT OUTER JOIN I_PurgDocumentItemCategoryText AS _PurgDocumentItemCategoryText ON PurchasingDocumentItemCategory = _PurgDocumentItemCategoryText.PurchasingDocumentItemCategory  -- association [0..*]
LEFT OUTER JOIN I_PurgDocumentCategoryText AS _PurgDocumentCategoryText ON PurchasingDocumentCategory = _PurgDocumentCategoryText.PurchasingDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeText ON PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory AND PurchasingDocumentType = _PurchasingDocumentTypeText.PurchasingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
;