SHSM_V_PRSTW

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 SHSM_V_PRSTW.
-- 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: SHSMVPRSTW

CREATE VIEW SHSM_V_PRSTW AS
SELECT
  I_Standardwbselement.WBSDescription AS post1,
  I_Standardwbselement.WBSElement AS posid,
  I_Standardwbselement.ResponsiblePerson AS vernr,
  I_Standardwbselement.ResponsiblePersonName AS verna,
  prpss.postu AS postu,
  prpss.posid_edit AS posid_edit,
  I_Standardwbselement.WBSElementInternalID AS posnr,
  I_Standardwbselement.WBSElementShortID AS poski,
  I_Standardwbselement.ControllingArea AS ControllingArea,
  I_Standardwbselement.ProfitCenter AS ProfitCenter,
  I_Standardwbselement.ApplicantCode AS ApplicantCode,
  I_Standardwbselement._ProjectApplicant AS _ProjectApplicant,
  I_Standardwbselement.ResponsiblePerson AS ResponsiblePerson,
  I_Standardwbselement._ResponsiblePerson AS _ResponsiblePerson
FROM I_Standardwbselement
INNER JOIN prpss ON /* join condition not captured in parsed metadata */
;