REPM_ClosePurOrderQ

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 REPM_ClosePurOrderQ.
-- 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: REPM_CLOSEQ
-- Parameters: P_KeyDate : sydate, hidden : true

CREATE VIEW REPM_ClosePurOrderQ AS
SELECT
  REPM_ClosePurOrderC.OverallStatus AS OverallStatus,
  case when REPM_ClosePurOrderC.OverallStatus = 'D' or REPM_ClosePurOrderC.OverallStatus = 'I' then REPM_ClosePurOrderC.GrossAmnt else 0 end as CloseGA AS GrossAmntelse0endasCloseGA,
  case when REPM_ClosePurOrderC.OverallStatus = 'P' then REPM_ClosePurOrderC.GrossAmnt else 0 end as OpenGA AS GrossAmntelse0endasOpenGA,
  REPM_ClosePurOrderC.CompanyName AS CompanyName
FROM REPM_ClosePurOrderC
;