SHSM_CN_LDST_SH_PR

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_CN_LDST_SH_PR.
-- 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: SHSMCNLDSTPR

CREATE VIEW SHSM_CN_LDST_SH_PR AS
SELECT
  I_Project.Project AS pspid,
  I_WBSElement.WBSElement AS posid,
  cnldst_shorttx.language AS LANGUAGE,
  cnldst_shorttx.shorttext AS SHORTTEXT,
  cnldst_shorttx.shorttextu AS SHORTTEXTU,
  I_WBSElement.ControllingArea AS ControllingArea,
  ProjectType,
  ResponsibleCostCenter,
  RespCostCenterControllingArea,
  I_WBSElement.ProfitCenter AS ProfitCenter,
  I_WBSElement.ResponsiblePerson AS ResponsiblePerson,
  I_WBSElement.ResponsiblePersonName AS ResponsiblePersonName,
  I_WBSElement.ProjectInternalID AS ProjectInternalID,
  I_WBSElement.ApplicantCode AS ApplicantCode,
  I_WBSElement._ProjectApplicant AS _ProjectApplicant,
  I_WBSElement._ResponsiblePerson AS _ResponsiblePerson
FROM I_WBSElement
INNER JOIN cnldst_shorttx ON /* join condition not captured in parsed metadata */
INNER JOIN I_Project ON /* join condition not captured in parsed metadata */
INNER JOIN proj ON /* join condition not captured in parsed metadata */
;