FINS_MP_PROJ_STAT

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 FINS_MP_PROJ_STAT.
-- 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: FINSV_MP_PROJ_ST

CREATE VIEW FINS_MP_PROJ_STAT AS
SELECT
  p.project_id AS project_id,
  p.project_type AS project_type,
  s.status_start AS status_start,
  s.status_end AS status_end,
  s.time_release AS time_release,
  s.time_start AS time_start,
  s.time_end AS time_end,
  s.time_finish AS time_finish,
  s.uname_start AS uname_start,
  s.uname_end AS uname_end,
  s.uname_finish AS uname_finish
FROM FINS_MP_PROJECT AS p
LEFT OUTER JOIN fins_mproj_stat AS s ON /* join condition not captured in parsed metadata */
;