C_GRIRClrgProcessedPurgDocItem

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_GRIRClrgProcessedPurgDocItem.
-- 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: CGRIRPROCPDITEM

CREATE VIEW C_GRIRClrgProcessedPurgDocItem AS
SELECT
  P_GRIRClearingProcessChange.CompanyCode AS CompanyCode,
  P_GRIRClearingProcessChange.PurchasingDocument AS PurchasingDocument,
  P_GRIRClearingProcessChange.PurchasingDocumentItem AS PurchasingDocumentItem,
  cast( sum( GRIRClrgProcThroughputSeconds ) as fis_grir_throughput_time) AS GRIRClrgProcThroughputSeconds,
  cast( sum( GRIRClrgProcessNumberOfChanges ) as fis_grir_no_proc_changes) AS GRIRClrgProcessNumberOfChanges,
  cast( count(distinct GRIRClearingProcessStatus) as fis_grir_no_status_values) AS GRIRClrgProcNrOfStatusValues,
  cast( count(distinct GRIRClearingProcessPriority) as fis_grir_no_prio_values) AS GRIRClrgProcessNrOfPrioValues,
  cast( count(distinct GRIRClrgProcessResponsibleUser) as fis_grir_no_resp_user_values) AS GRIRClrgProcNrOfRespUserValues,
  cast( count(distinct ResponsibleDepartment) as fis_grir_no_root_cause_values) AS GRIRClrgProcNrOfRespDeptValues,
  cast( count(distinct GRIRClearingProcessRootCause) as fis_grir_no_root_cause_values) AS GRIRClrgProcNrOfRootCauseVals,
  cast( sum(GRIRClrgProcessNrOfStatusChgs) as fis_grir_no_status_changes) AS GRIRClrgProcessNrOfStatusChgs,
  cast( sum(GRIRClrgProcessNrOfPrioChanges) as fis_grir_no_prio_changes) AS GRIRClrgProcessNrOfPrioChanges,
  cast( sum(GRIRClrgProcNrOfRespUserChgs) as fis_grir_no_resp_user_changes) AS GRIRClrgProcNrOfRespUserChgs,
  cast( sum(GRIRClrgProcNrOfRespDeptChgs) as fis_grir_no_resp_dpmt_changes) AS GRIRClrgProcNrOfRespDeptChgs,
  cast( sum(GRIRClrgProcNrOfRootCauseChgs) as fis_grir_no_root_cause_changes) AS GRIRClrgProcNrOfRootCauseChgs,
  P_GRIRClearingProcessChange.MaterialGroup AS MaterialGroup,
  P_GRIRClearingProcessChange.Plant AS Plant,
  P_GRIRClearingProcessChange.PurchasingGroup AS PurchasingGroup,
  P_GRIRClearingProcessChange.PurchasingOrganization AS PurchasingOrganization,
  P_GRIRClearingProcessChange.Supplier AS Supplier,
  P_GRIRClearingProcessChange._CompanyCode AS _CompanyCode,
  P_GRIRClearingProcessChange._PurchasingDocument AS _PurchasingDocument,
  P_GRIRClearingProcessChange._PurchasingDocumentItem AS _PurchasingDocumentItem
FROM P_GRIRClearingProcessChange
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_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_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
;