pph_e_Resb_agg_1

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 pph_e_Resb_agg_1.
-- 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: V_PPH_RESB_AGG_1

CREATE VIEW pph_e_Resb_agg_1 AS
SELECT
  resb.matnr AS MATNR,
  resb.werks AS WERKS,
  resb.bdter AS DAT00,
  case when resb.shkzg = 'S' then '1' else '2' end AS SORT1,
  case when resb.bdart = 'BB' then '08' when resb.bdart = 'SB' then '07' else '04' end as SORT2 AS bdartSBthen07else04endasSORT2,
  resb.bdart AS DELKZ,
  case when resb.shkzg = 'S' then '+' else '-' end AS PLUMI,
  case when resb.shkzg = 'S' then (resb.bdmng - resb.enmng) else - (resb.bdmng - resb.enmng) end as MNG01 AS enmngendasMNG01,
  case when resb.bdart = 'SB' or resb.bdart = 'BB' then resb.bdmng - resb.enmng else 0 end as MNG03 AS enmngelse0endasMNG03,
  case when resb.verti is not null or resb.verti <> '' then resb.sbter else '00000000' end as DAT03 AS sbterelse00000000endasDAT03,
  resb.bdart AS BAART,
  resb.lgort AS LGORT,
  resb.sernr AS SERNR,
  'DUMMY' AS AUFVR,
  resb.verti AS VERTO,
  resb.lifnr AS LIFNR,
  resb.vrpla AS VRPLA,
  resb.dbskz AS DBSKZ,
  resb.shkzg AS RESB_SHKZG,
  resb.dumps AS RESB_DUMPS,
  resb.no_disp AS RESB_NO_DISP,
  resb.schgt AS RESB_SCHGT,
  resb.umsok AS RESB_UMSOK,
  vorab,
  no_disp,
  kzaus,
  nafkz,
  sgt_scat,
  sgt_rcat,
  knttp AS knttp_db,
  kzvbr AS kzvbr_db,
  kzbws AS kzbws_db
FROM resb
;