P_ProjectVersion01

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_ProjectVersion01.
-- 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: PPROJVERSION01

CREATE VIEW P_ProjectVersion01 AS
SELECT
  case when vsproj_cn.pspid is not null or vsproj_cn.pspid <> '' then vsproj_cn.pspid when vsprps_cn.posid is not null or vsprps_cn.posid <> '' then vsprps_cn.posid when vsaufk_cn.aufnr is not null or vsaufk_cn.aufnr <> '' then vsaufk_cn.aufnr when vsafvc_cn.vornr is not null or vsafvc_cn.vornr <> '' then vsafvc_cn.vornr when vsresb_cn.rsnum is not null or vsresb_cn.rsnum <> '' then vsresb_cn.rsnum else '' end as ProjectObjectExternalID AS rsnumelseendasProjectObjectExternalID,
  case when vsproj_cn.pspid is not null or vsproj_cn.pspid <> '' then 'PD' when vsprps_cn.posid is not null or vsprps_cn.posid <> '' then 'PR' when vsaufk_cn.aufnr is not null or vsaufk_cn.aufnr <> '' then 'NP' when vsafvc_cn.vornr is not null or vsafvc_cn.vornr <> '' then 'NV' when vsresb_cn.rsnum is not null or vsresb_cn.rsnum <> '' then 'OK' else '' end as ObjectType AS rsnumthenOKelseendasObjectType,
  vssteu.vsnmr AS Version,
  vssteu.vsgruppe AS ProjectVersionGroupName,
  vskopf.vszhl AS MCount,
  vskopf.vstext AS ProjectVersionDescription,
  case length( vskopf.vstext ) when 0 then 1 else 0 end AS BlankCount,
  vskopf.vstext AS DistinctDescCount
FROM vskopf
LEFT OUTER JOIN vssteu ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vsproj_cn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vsprps_cn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vsaufk_cn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vsafvc_cn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vsresb_cn ON /* join condition not captured in parsed metadata */
;