C_GRIRClearingProcessChange

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_GRIRClearingProcessChange.
-- 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: CGRIRHISTCHG

CREATE VIEW C_GRIRClearingProcessChange AS
SELECT
  P_GRIRClearingProcessChange.CompanyCode AS CompanyCode,
  P_GRIRClearingProcessChange.PurchasingDocument AS PurchasingDocument,
  P_GRIRClearingProcessChange.PurchasingDocumentItem AS PurchasingDocumentItem,
  P_GRIRClearingProcessChange.LastChangeDateTime AS LastChangeDateTime,
  cast( P_GRIRClearingProcessChange.GRIRClrgProcThroughputSeconds as fis_grir_throughput_time ) AS GRIRClrgProcThroughputSeconds,
  P_GRIRClearingProcessChange.GRIRClrgProcessNumberOfChanges AS GRIRClrgProcessNumberOfChanges,
  P_GRIRClearingProcessChange.GRIRClearingProcessStatus AS GRIRClearingProcessStatus,
  P_GRIRClearingProcessChange.GRIRClearingProcessPriority AS GRIRClearingProcessPriority,
  P_GRIRClearingProcessChange.GRIRClrgProcessResponsibleUser AS GRIRClrgProcessResponsibleUser,
  P_GRIRClearingProcessChange.ResponsibleDepartment AS ResponsibleDepartment,
  P_GRIRClearingProcessChange.GRIRClearingProcessRootCause AS GRIRClearingProcessRootCause,
  cast( P_GRIRClearingProcessChange.PrevGRIRClearingProcessStatus as fis_grir_pv_clearing_status) AS PrevGRIRClearingProcessStatus,
  cast( P_GRIRClearingProcessChange.PrevGRIRClrgProcPriority as fis_grir_pv_priority) AS PrevGRIRClrgProcPriority,
  cast( P_GRIRClearingProcessChange.GRIRClrgProcPrevResponsibleUsr as fis_grir_pv_responsible_user) AS GRIRClrgProcPrevResponsibleUsr,
  cast( P_GRIRClearingProcessChange.PrevResponsibleDepartment as fis_grir_pv_responsible_dpmnt) AS PrevResponsibleDepartment,
  cast( P_GRIRClearingProcessChange.GRIRClearingProcPrevRootCause as fis_grir_pv_clrg_root_cause) AS GRIRClearingProcPrevRootCause,
  cast( P_GRIRClearingProcessChange.GRIRClrgProcessNrOfStatusChgs as fis_grir_no_status_changes) AS GRIRClrgProcessNrOfStatusChgs,
  cast( P_GRIRClearingProcessChange.GRIRClrgProcessNrOfPrioChanges as fis_grir_no_prio_changes) AS GRIRClrgProcessNrOfPrioChanges,
  cast( P_GRIRClearingProcessChange.GRIRClrgProcNrOfRespUserChgs as fis_grir_no_resp_user_changes) AS GRIRClrgProcNrOfRespUserChgs,
  cast( P_GRIRClearingProcessChange.GRIRClrgProcNrOfRespDeptChgs as fis_grir_no_resp_dpmt_changes) AS GRIRClrgProcNrOfRespDeptChgs,
  cast( P_GRIRClearingProcessChange.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._PurchasingDocument._Supplier.SupplierName AS SupplierName,
  P_GRIRClearingProcessChange._CompanyCode AS _CompanyCode,
  P_GRIRClearingProcessChange._PurchasingDocument AS _PurchasingDocument,
  P_GRIRClearingProcessChange._PurchasingDocumentItem AS _PurchasingDocumentItem
FROM P_GRIRClearingProcessChange
LEFT OUTER JOIN I_UserContactCard AS _GRIRClrgProcessResponsibleUsr ON GRIRClrgProcessResponsibleUser = _GRIRClrgProcessResponsibleUsr.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _GRIRClrgProcPrevRespUser ON GRIRClrgProcPrevResponsibleUsr = _GRIRClrgProcPrevRespUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_GRIRProcessStatusText AS _GRIRProcessStatusText ON GRIRClearingProcessStatus = _GRIRProcessStatusText.GRIRClearingProcessStatus  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessStatusText AS _PrevGRIRClrgProcessStatusText ON PrevGRIRClearingProcessStatus = _PrevGRIRClrgProcessStatusText.GRIRClearingProcessStatus  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessPriorityText AS _GRIRProcessPriorityText ON GRIRClearingProcessPriority = _GRIRProcessPriorityText.GRIRClearingProcessPriority  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessPriorityText AS _PrevGRIRClrgProcPriorityText ON PrevGRIRClrgProcPriority = _PrevGRIRClrgProcPriorityText.GRIRClearingProcessPriority  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessRootCauseText AS _GRIRProcessRootCauseText ON GRIRClearingProcessRootCause = _GRIRProcessRootCauseText.GRIRClearingProcessRootCause  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessRootCauseText AS _GRIRProcessPrevRootCauseText ON GRIRClearingProcPrevRootCause = _GRIRProcessPrevRootCauseText.GRIRClearingProcessRootCause  -- association [0..*]
LEFT OUTER JOIN C_GRIRClrgProcessedPurgDocItem AS _GRIRProcessedItem ON CompanyCode = _GRIRProcessedItem.CompanyCode AND PurchasingDocument = _GRIRProcessedItem.PurchasingDocument AND PurchasingDocumentItem = _GRIRProcessedItem.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
;