v_Covp_kaep_view

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 v_Covp_kaep_view.
-- 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_COVP_KAEP

CREATE VIEW v_Covp_kaep_view AS
SELECT
  t1.mandt AS mandt,
  t1.kokrs AS kokrs,
  t1.belnr AS belnr,
  t1.buzei AS buzei,
  t1.perio AS perio,
  cast( t1.wtgbtr as wtgxxx ) AS wtgbtr,
  cast( t1.wogbtr as wogxxx ) AS wogbtr,
  cast( t1.wkgbtr as wkgxxx ) AS wkgbtr,
  cast( t1.wkfbtr as wkfxxx ) AS wkfbtr,
  cast( t1.pagbtr as pagxxx ) AS pagbtr,
  cast( t1.pafbtr as pafxxx ) AS pafbtr,
  cast( t1.megbtr as abap.dec(15,3) ) AS megbtr,
  cast( t1.mefbtr as abap.dec(15,3) ) AS mefbtr,
  cast( t1.mbgbtr as abap.dec(15,3) ) AS mbgbtr,
  cast( t1.mbfbtr as abap.dec(15,3) ) AS mbfbtr,
  t1.lednr AS lednr,
  t1.objnr AS objnr,
  t1.gjahr AS gjahr,
  '04' AS WRTTP,
  t1.versn AS versn,
  t1.kstar AS kstar,
  t1.hrkft AS hrkft,
  t1.vrgng AS vrgng,
  t1.parob AS parob,
  t1.parob1 AS parob1,
  t1.uspob AS uspob,
  t1.vbund AS vbund,
  t1.pargb AS pargb,
  t1.beknz AS beknz,
  t1.twaer AS twaer,
  t1.owaer AS owaer,
  t1.meinh AS meinh,
  t1.meinb AS meinb,
  case when t1.muvflg = '0' then 'X' AS muvflg0thenXcompleteelseendasmvflg,
  t1.sgtxt AS sgtxt,
  t1.refbz AS refbz,
  t1.zlenr AS zlenr,
  t1.bw_refbz AS bw_refbz,
  t1.gkont AS gkont,
  t1.gkoar AS gkoar,
  t1.werks AS werks,
  t1.matnr AS matnr,
  t1.rbest AS rbest,
  t1.ebeln AS ebeln,
  t1.ebelp AS ebelp,
  t1.zekkn AS zekkn,
  t1.erlkz AS erlkz,
  t1.pernr AS pernr,
  '00' AS btrkl,
  '' AS objnr_n2,
  '' AS objnr_n3,
  t1.paobjnr AS paobjnr,
  t1.beltp AS beltp,
  t1.bukrs AS bukrs,
  t1.gsber AS gsber,
  t1.fkber AS fkber,
  t1.scope AS scope,
  t1.logsyso AS logsyso,
  t1.pkstar AS pkstar,
  t1.pbukrs AS pbukrs,
  t1.pfkber AS pfkber,
  t1.pscope AS pscope,
  t1.logsysp AS logsysp,
  t1.dabrz AS dabrz,
  t1.bwstrat AS bwstrat,
  t1.objnr_hk AS objnr_hk,
  t2.timestmp AS timestmp,
  t1.geber AS geber,
  t1.pgeber AS pgeber,
  t1.grant_nbr AS grant_nbr,
  t1.pgrant_nbr AS pgrant_nbr,
  t1.refbz_fi AS refbz_fi,
  t1.segment AS segment,
  t1.psegment AS psegment,
  t1.prctr AS prctr,
  t1.pprct AS pprct,
  t1.budget_pd AS budget_pd,
  t1.pbudget_pd AS pbudget_pd,
  t1.prodper AS prodper,
  t2.perab AS perab,
  t2.perbi AS perbi,
  t2.bldat AS bldat,
  t2.budat AS budat,
  t2.cpudt AS cpudt,
  t2.usnam AS usnam,
  t2.bltxt AS bltxt,
  t2.stflg AS stflg,
  t2.stokz AS stokz,
  t2.refbt AS refbt,
  t2.refbn AS refbn,
  t2.refbk AS refbk,
  t2.refgj AS refgj,
  t2.blart AS blart,
  t2.ldgrp AS ldgrp,
  t2.orgvg AS orgvg,
  t2.sumbz AS sumbz,
  t2.delbz AS delbz,
  t2.wsdat AS wsdat,
  t2.kurst AS kurst,
  t2.varnr AS varnr,
  t2.kwaer AS kwaer,
  t2.ctyp1 AS ctyp1,
  t2.ctyp2 AS ctyp2,
  t2.ctyp3 AS ctyp3,
  t2.ctyp4 AS ctyp4,
  t2.awtyp AS awtyp,
  t2.aworg AS aworg,
  t2.logsystem AS logsystem,
  t2.cputm AS cputm,
  t2.alebz AS alebz,
  t2.alebn AS alebn,
  t2.awsys AS awsys,
  t2.awref_rev AS awref_rev,
  t2.aworg_rev AS aworg_rev,
  t2.awkey AS awkey,
  t2.valdt AS valdt,
  t2.kokrs_sender AS kokrs_sender,
  t2.belnr_sender AS belnr_sender,
  t2.gjahr AS k_gjahr,
  t2.versn AS k_versn,
  t2.vrgng AS k_vrgng,
  t2.timestmp AS k_timestmp,
  t1.awtyp AS p_awtyp,
  cast( t1.awkey as abap.char(20) ) AS p_awkey,
  t1.awsys AS p_awsys,
  t1.kwaer AS p_kwaer,
  t1.kostl AS kostl,
  t1.lstar AS lstar,
  t1.aufnr AS aufnr,
  t1.autyp AS autyp,
  t1.pspnr AS pspnr,
  t1.vbeln AS vbeln,
  t1.vbposnr AS vbposnr,
  t1.ce4key AS ce4key,
  t1.erkrs AS erkrs,
  t1.paccas AS paccas,
  t1.pkostl AS pkostl,
  t1.paufnr AS paufnr,
  t1.pautyp AS pautyp,
  t1.ppspnr AS ppspnr,
  t1.pce4key AS pce4key,
  t1.plstar AS plstar,
  t1.pvbeln AS pvbeln,
  t1.pvbposnr AS pvbposnr,
  t1.posnr AS p_posnr,
  t1.pspid AS pspid,
  t1.ppspid AS ppspid,
  cast( t1.quant1 as abap.dec(15,3) ) AS quant1,
  cast( t1.quant2 as abap.dec(15,3) ) AS quant2,
  cast( t1.quant3 as abap.dec(15,3) ) AS quant3,
  t1.qunit1 AS qunit1,
  t1.qunit2 AS qunit2,
  t1.qunit3 AS qunit3
FROM v_coep_acdoca_r AS t1
-- UNION ALL with additional select branch(es): v_coep_acdoca_r
;