P_ObjectStatus

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_ObjectStatus.
-- 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: POBJECTSTATUS

CREATE VIEW P_ObjectStatus AS
SELECT
  cast ( prps.pspnr as ps_posnr ) AS WBSElementInternalID,
  prps.objnr AS ObjectNumber,
  proj.stspr AS WBSStatusProfile,
  jest.stat AS Status,
  case when jest.stat like 'E%' then 'X' else ' ' end as IsUserStatus AS statlikeEthenXelseendasIsUserStatus,
  _UserStatus._UserStatusText[ 1: Language = $session.system_language ].UserStatusShortName AS UserStatusShortName,
  _SystemStatus._SystemStatusText[ 1: Language = $session.system_language ].SystemStatusShortName AS SystemStatusShortName,
  case when jest.stat like 'E%' then _UserStatus._UserStatusText[1: Language = $session.system_language].UserStatusName else _SystemStatus._SystemStatusText[1: Language = $session.system_language].SystemStatusName end as StatusName AS SystemStatusNameendasStatusName
FROM prps
LEFT OUTER JOIN prte ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN jest ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN proj ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UserStatus AS _UserStatus ON Status = _UserStatus.UserStatus AND WBSStatusProfile = _UserStatus.StatusProfile  -- association [0..1]
LEFT OUTER JOIN I_SystemStatus AS _SystemStatus ON Status = _SystemStatus.SystemStatus  -- association [0..1]
;