P_StatusObjectStatusWithGUID

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_StatusObjectStatusWithGUID.
-- 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: PSTATUSOBJSTATUS

CREATE VIEW P_StatusObjectStatusWithGUID AS
SELECT
  crm_jest.objnr AS StatusObjectUUID,
  crm_jest.stat AS StatusCode,
  crm_jsto.stsma AS StatusProfile,
  cast('X' as vdm_j_isuserstatus ) AS IsUserStatus,
  cast('' as vdm_j_statusisactive) AS StatusIsActive,
  crm_jest.inact as StatusIsInactive AS objnrasStatusObjectUUID,
  crm_jest.inact AS StatusIsInactive
FROM crm_jest
LEFT OUTER JOIN crm_jsto ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): crm_jest
;