P_EngagementProject

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_EngagementProject.
-- 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: PIENGMNTPROJ

CREATE VIEW P_EngagementProject AS
SELECT
  EngagementProject.db_key AS db_key,
  EngagementProject.mp_id AS mp_id,
  EngagementProject.mp_type AS mp_type,
  EngagementProject.mp_stage AS mp_stage,
  EngagementProject.start_date AS start_date,
  EngagementProject.end_date AS end_date,
  EngagementProject.customer AS customer,
  EngagementProject.org_id AS org_id,
  EngagementProject.confidential AS confidential,
  EngagementProject.project_type AS project_type,
  EngagementProject.created_by AS created_by,
  cast( EngagementProject.created_on as /cpd/cpm_createdon ) AS created_on,
  EngagementProject.changed_by AS changed_by,
  cast( EngagementProject.changed_on as /cpd/cpm_changedon ) AS changed_on,
  EngagementProject.cost_center AS cost_center,
  EngagementProjectText.text AS text,
  EngagementProjectText.textu AS textu,
  Project.vkokr AS ControllingArea,
  Project.vbukr AS CompanyCode,
  Project.profl AS ProjectProfileCode
FROM /cpd/d_mp_hdr AS EngagementProject
INNER JOIN /cpd/d_mp_hdr_s AS EngagementProjectText ON /* join condition not captured in parsed metadata */
;