I_EAMObjectOverallStatusLg

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 I_EAMObjectOverallStatusLg.
-- 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: IEAMOBJOVRLSTSL

CREATE VIEW I_EAMObjectOverallStatusLg AS
SELECT
  status_object AS StatusObject,
  overall_status_profile AS EAMOverallObjectStatusProfile,
  overall_status AS EAMOverallObjectStatus,
  counter AS EAMOverallObjectStatusLgEntry,
  processor_set AS EAMOvrlObjStatusSetByUser,
  processor_unset AS EAMOvrlObjStatusResetByUser,
  timestamp_set AS EAMOvrlObjStsOriglSetDateTime,
  timestamp_unset AS EAMOvrlObjStsOriglRsetDateTime
FROM eam_ostobjsts_cd
LEFT OUTER JOIN I_EAMOverallStatusEvent AS _InProcessUsage ON _InProcessUsage.EAMOverallStatusProfile = EAMOverallObjectStatusProfile AND _InProcessUsage.EAMOverallStatus = EAMOverallObjectStatus AND _InProcessUsage.EAMOverallStatusEvent = 'F2023' AND _InProcessUsage.EAMOvrlStsEventConfiguration = 'INPROC'  -- association [0..1]
;