/MERP/PP_PO_STATUS

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 /MERP/PP_PO_STATUS.
-- 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: /MERP/PP_PO_STAT

CREATE VIEW /MERP/PP_PO_STATUS AS
SELECT
  jest.objnr AS ObjectNumber,
  jest.stat AS Status,
  case jest.stat when 'I0001' then 'X' else '' end as IsCreated AS statwhenI0001thenXelseendasIsCreated,
  case jest.stat when 'I0002' then 'X' else '' end as IsReleased AS statwhenI0002thenXelseendasIsReleased,
  case jest.stat when 'I0007' then 'X' else '' end as IsPrinted AS statwhenI0007thenXelseendasIsPrinted,
  case jest.stat when 'I0009' then 'X' else '' end as IsConfirmed AS statwhenI0009thenXelseendasIsConfirmed,
  case jest.stat when 'I0012' then 'X' else '' end as IsDelivered AS statwhenI0012thenXelseendasIsDelivered,
  case jest.stat when 'I0013' then 'X' else '' end as IsDeleted AS statwhenI0013thenXelseendasIsDeleted,
  case jest.stat when 'I0016' then 'X' else '' end as IsPreCosted AS statwhenI0016thenXelseendasIsPreCosted,
  case jest.stat when 'I0043' then 'X' else '' end as IsLocked AS statwhenI0043thenXelseendasIsLocked,
  case jest.stat when 'I0046' then 'X' else '' end as IsClosed AS statwhenI0046thenXelseendasIsClosed,
  case jest.stat when 'I0117' then 'X' else '' end as IsScheduled AS statwhenI0117thenXelseendasIsScheduled
FROM jest
;