FINSCDS_F4_MPROSTT

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 FINSCDS_F4_MPROSTT.
-- 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_F4_MPROSTT

CREATE VIEW FINSCDS_F4_MPROSTT AS
SELECT
  finsv_f4_mprojst.mandt AS mandt,
  finsv_f4_mprojst.project_id AS project_id,
  finsv_f4_mprojst.project_type AS project_type,
  finsv_f4_mprojst.description AS description,
  finsv_f4_mprojst.status_code AS status_code,
  cast( _status_name[1:Language=$session.system_language].MassDataProjectStatusName as fins_mproj_project_status_name ) AS status_name,
  cast ( finsv_f4_mprojst.uname as finb_changed_by ) AS uname,
  cast ( finsv_f4_mprojst.cpudt as aendt ) AS cpudt,
  cast ( finsv_f4_mprojst.cputm as u_time ) AS cputm
FROM finsv_f4_mprojst
LEFT OUTER JOIN I_MassDataProjectStatusText AS _status_name ON _status_name.MassDataProjectStatus = status_code  -- association [0..*]
;