P_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 P_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: PGRIRHISTCHG

CREATE VIEW P_GRIRClearingProcessChange AS
SELECT
  I_GRIRProcessHistory.CompanyCode AS CompanyCode,
  I_GRIRProcessHistory.PurchasingDocument AS PurchasingDocument,
  I_GRIRProcessHistory.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_GRIRProcessHistory.LastChangeDateTime AS LastChangeDateTime,
  prev.LastChangeDateTime AS PrevChangeDateTime,
  cast( 1 as fis_grir_no_proc_changes ) AS GRIRClrgProcessNumberOfChanges,
  cast( I_GRIRProcessHistory.GRIRClearingProcessStatus as fis_grir_n_clearing_status) AS GRIRClearingProcessStatus,
  cast( I_GRIRProcessHistory.GRIRClearingProcessPriority as fis_grir_n_priority) AS GRIRClearingProcessPriority,
  cast( I_GRIRProcessHistory.ResponsiblePerson as fis_grir_n_responsible_user) AS GRIRClrgProcessResponsibleUser,
  cast( I_GRIRProcessHistory.ResponsibleDepartment as fis_grir_n_responsible_dpmnt) AS ResponsibleDepartment,
  cast( I_GRIRProcessHistory.GRIRClearingProcessRootCause as fis_grir_n_clrg_root_cause) AS GRIRClearingProcessRootCause,
  I_GRIRProcessHistory.MaterialGroup AS MaterialGroup,
  I_GRIRProcessHistory.Plant AS Plant,
  I_GRIRProcessHistory.PurchasingGroup AS PurchasingGroup,
  I_GRIRProcessHistory.PurchasingOrganization AS PurchasingOrganization,
  I_GRIRProcessHistory.Supplier AS Supplier,
  I_GRIRProcessHistory._CompanyCode AS _CompanyCode,
  I_GRIRProcessHistory._PurchasingDocument AS _PurchasingDocument,
  I_GRIRProcessHistory._PurchasingDocumentItem AS _PurchasingDocumentItem
FROM I_GRIRProcessHistory
LEFT OUTER JOIN P_GRIRProcHistSuccssrTimestamp AS prev ON CompanyCode=prev.CompanyCode AND PurchasingDocument=prev.PurchasingDocument AND PurchasingDocumentItem=prev.PurchasingDocumentItem AND LastChangeDateTime=prev.ImmediateNextChangeDateTime  -- association [0..1]
;