fiscds_evpad_01

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 fiscds_evpad_01.
-- 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: FISV_EVPAD_01

CREATE VIEW fiscds_evpad_01 AS
SELECT
  vbsegs.bukrs AS bukrs,
  vbsegs.belnr AS belnr,
  vbsegs.gjahr AS gjahr,
  buzei,
  cast( saknr as abap.char(20)) AS hkont_txt20,
  cast( CONCAT ( CONCAT ( t001.ktopl , 'QWERTZUIOPASDFGHJKLYXCVBNM' ) , saknr ) as abap.char(50)) AS hkont_txt50,
  cast( prctr as abap.char(40)) AS prctr_name,
  cast( segment as abap.char(50)) AS segment_name,
  cast( fkber as abap.char(25)) AS fkber_name,
  cast( gsber as abap.char(30)) AS gsber_name,
  cast( vbkpf.blart as abap.char(20)) AS blart_name,
  cast( '' as abap.char(40)) AS matnr_ext,
  t001.butxt AS RBUKRS_name,
  tka01.bezei AS kokrs_name,
  cast( ' ' as abap.char(35)) AS KUNNR_NAME,
  cast( ' ' as abap.char(35)) AS LIFNR_NAME,
  budat,
  buzid,
  cast( '00000000' as abap.dats( 8)) AS AUGDT,
  cast( ' ' as abap.char(10)) AS AUGBL,
  bschl,
  koart,
  cast( ' ' as abap.char(1)) AS umskz,
  cast( ' ' as abap.char(1)) AS umsks,
  gsber,
  vbsegs.pargb AS pargb,
  mwskz,
  mwart,
  valut,
  zuonr,
  sgtxt,
  vbsegs.vbund AS vbund,
  rmvct AS bewar,
  kostl,
  aufnr,
  cast( ' ' as abap.char(10)) AS vbeln,
  cast( ' ' as abap.char(10)) AS vbel2,
  cast( '000000' as abap.numc(6)) AS posn2,
  prctr,
  pprctr AS pprct,
  segment,
  psegment,
  cast( '0000' as abap.numc(4)) AS ETEN2,
  anln1,
  anln2,
  cast( ' ' as abap.char(1)) AS XKRES,
  cast( ' ' as abap.char(1)) AS XOPVW,
  cast( ' ' as abap.char(1)) AS XZAHL,
  cast( ' ' as abap.char(3)) AS KTOSL,
  t001.ktopl AS ktopl,
  saknr,
  saknr AS hkont,
  cast( ' ' as abap.char(10)) AS kunnr,
  cast( ' ' as abap.char(10)) AS lifnr,
  cast( ' ' as abap.char(10)) AS FILKD,
  zfbdt,
  cast( ' ' as abap.char(4)) AS ZTERM,
  cast( '000' as abap.dec(3,0)) AS zbd1t,
  cast( '000' as abap.dec(3,0)) AS zbd2t,
  cast( '000' as abap.dec(3,0)) AS zbd3t,
  cast( '0' as abap.dec(5,3)) AS zbd1p,
  cast( '0' as abap.dec(5,3)) AS zbd2p,
  cast( ' ' as abap.char(1)) AS zlsch,
  cast( ' ' as abap.char(1)) AS zlspr,
  cast( ' ' as abap.char(1)) AS zbfix,
  cast( ' ' as abap.char(10)) AS REBZG,
  cast( '0000' as abap.numc(4)) AS REBZJ,
  cast( '000' as abap.numc(3)) AS REBZZ,
  cast( ' ' as abap.char(1)) AS REBZT,
  cast( '00000000' as abap.numc(8)) AS samnr,
  cast( ' ' as abap.char(1)) AS wverw,
  cast( ' ' as abap.char(1)) AS mschl,
  cast( ' ' as abap.char(1)) AS mansp,
  cast( '00000000' as abap.dats( 8)) AS madat,
  cast( '0' as abap.numc(1)) AS manst,
  cast( ' ' as abap.char(2)) AS maber,
  matnr,
  werks,
  ebeln,
  ebelp,
  rstgr,
  vertt,
  vertn,
  vbewa,
  imkey,
  dabrz,
  cast( '00000000' as abap.numc(8)) AS projk,
  cast( ' ' as abap.char(1)) AS xragl,
  uzawe,
  cast( ' ' as abap.char(10)) AS lokkt,
  geber,
  xref1,
  xref2,
  fkber,
  cast( ' ' as abap.char(1)) AS xnegp,
  cast( '000' as abap.numc(3)) AS rfzei,
  ccbtc,
  kkber,
  xref3,
  cast( '00' as abap.numc(2)) AS dtws1,
  cast( '00' as abap.numc(2)) AS dtws2,
  cast( '00' as abap.numc(2)) AS dtws3,
  cast( '00' as abap.numc(2)) AS dtws4,
  cast( ' ' as abap.char(1)) AS xpypr,
  cast( ' ' as abap.char(30)) AS kidno,
  cast( '0' as abap.dec(5,0)) AS agzei,
  bupla,
  cast( ' ' as abap.char(4)) AS secco,
  cast( ' ' as abap.char(2)) AS cession_kz,
  grant_nbr,
  cast( ' ' as abap.char(16)) AS fkber_long,
  cast( '0000' as abap.numc(4)) AS auggj,
  cast( ' ' as abap.char(16)) AS pfkber,
  cast( ' ' as abap.char(10)) AS kstar,
  egrup,
  tka01.kokrs AS kokrs,
  cast( ' ' as abap.char(6)) AS vname,
  recid,
  xumsw,
  hzuon,
  bwtar,
  awtyp,
  awkey,
  awsys,
  cast( '0000000000' as abap.numc(10)) AS posnr,
  cast( ' ' as abap.char(1)) AS XAUGP,
  cast( '00000000' as abap.dats( 8)) AS augcp,
  kstrg,
  nplnr,
  aufpl,
  cast( ' ' as abap.char(15)) AS txjcd,
  vbkpf.blart AS blart,
  bldat,
  monat,
  cpudt,
  usnam,
  xblnr,
  cast( ' ' as abap.char(10)) AS stblg,
  cast( '0000' as abap.numc(4)) AS stjah,
  kursf,
  bstat,
  cast( ' ' as abap.char(4)) AS glvor,
  cast( ' ' as abap.char(4)) AS fikrs,
  ldgrp,
  cast( ' ' as abap.char(2)) AS rldnr,
  cast( ' ' as abap.char(12)) AS grpid,
  cast( ' ' as abap.char(10)) AS dbblg,
  bvorg,
  tcode,
  aedat,
  cast( ' ' as abap.char(20)) AS xref1_hd,
  cast( ' ' as abap.char(20)) AS xref2_hd,
  cast( ' ' as abap.char(26)) AS xblnr_alt,
  wwert,
  bktxt,
  vatdate,
  cast( ' ' as abap.char(10)) AS gkont,
  cast( ' ' as abap.char(1)) AS gkart,
  vbsegs.shkzg AS shkzg,
  vbkpf.waers AS waers,
  vbkpf.hwaer AS hwaer,
  vbkpf.hwae2 AS hwae2,
  vbkpf.hwae3 AS hwae3,
  cast( ' ' as abap.cuky(5)) AS pswsl,
  cast( '0' as abap.curr( 23,2)) AS pswbt_shl,
  cast( '0' as abap.curr( 23,2)) AS BDIFF_shl,
  cast( '0' as abap.curr( 23,2)) AS BDIF2_shl,
  cast( '0' as abap.curr( 23,2)) AS BDIF3_shl,
  cast( '0' as abap.curr( 23,2)) AS QBSHB_shl,
  cast( '0' as abap.curr( 23,2)) AS QSFBT_shl,
  cast( '0' as abap.curr( 23,2)) AS SKFBT_shl,
  cast( '0' as abap.curr( 23,2)) AS WSKTO_shl,
  cast( '0' as abap.curr( 23,2)) AS SKNTO_shl,
  cast( '0' as abap.curr( 23,2)) AS QSSHB_shl,
  cast( ' ' as abap.cuky(5)) AS pycur,
  cast( '0' as abap.curr( 23,2)) AS PYAMT_shl,
  cast( ' ' as abap.cuky(5)) AS t014_waers,
  cast( '0' as abap.curr( 23,2)) AS ABSBT_shl,
  vbsegs.meins AS meins,
  vbsegs.menge AS menge,
  cast(1 as abap.dec( 12, 0 )) AS nbritm
INNER JOIN vbkpf ON /* join condition not captured in parsed metadata */
INNER JOIN t001 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tka01 ON /* join condition not captured in parsed metadata */
;