P_Copa_Doc2

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 P_Copa_Doc2.
-- 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: PFICOPADOC2

CREATE VIEW P_Copa_Doc2 AS
SELECT
  kokrs,
  cast( BELNR as co_belnr ) AS BELNR,
  cast( BUZEI as co_buzei ) AS BUZEI,
  cast( PERIO as fins_fiscalperiod ) AS PERIO,
  objnr,
  cast( WRTTP as co_wrttp ) AS WRTTP,
  cast( KSTAR as fis_racct ) AS KSTAR,
  hrkft,
  vrgng,
  cast( PAROB as parob ) AS PAROB,
  cast( parob1 as parob ) AS PAROB1,
  uspob,
  VBUND,
  PARGB,
  cast( BEKNZ as co_belkz ) AS BEKNZ,
  TWAER,
  cast( cast( WTGBTR as abap.curr( 23,2)) as fis_wsl ) AS WTGBTR,
  cast( OWAER as owaer ) AS OWAER,
  cast( WOGBTR as vco_ocur12 ) AS WOGBTR,
  cast( KWAER as kwaer ) AS KWAER,
  cast( WKGBTR as wkgxxx ) AS WKGBTR,
  cast( WKFBTR as wkfxxx ) AS WKFBTR,
  cast( PAGBTR as pagxxx ) AS PAGBTR,
  cast( PAFBTR as fis_pafxxx ) AS PAFBTR,
  cast( MEINH as co_meinh ) AS MEINH,
  cast( cast( MEGBTR as abap.quan(15,3)) as megxxx ) AS MEGBTR,
  cast( MEFBTR as quan1_12_fix) AS MEFBTR,
  cast( MEINB as erfme ) AS MEINB,
  cast( cast( MBGBTR as abap.quan(15,3)) as mbgxxx ) AS MBGBTR,
  cast( cast( MBFBTR as abap.quan(15,3)) as mbfxxx ) AS MBFBTR,
  qunit1,
  quant1,
  qunit2,
  quant2,
  qunit3,
  quant3,
  cast( cast( MVFLG as abap.char(1) ) as fis_co_mvflg ) AS MVFLG,
  cast( sgtxt as farp_sgtxt ) AS sgtxt,
  refbz,
  cast( ZLENR as dzlenr ) AS ZLENR,
  cast( BW_REFBZ as bw_refbz ) AS BW_REFBZ,
  cast( gkont as fis_gkont ) AS gkont,
  cast( gkoar as farp_koart ) AS gkoar,
  werks,
  matnr,
  rbest,
  ebeln,
  ebelp,
  zekkn,
  erlkz,
  pernr,
  cast( BTRKL as co_btrkl ) AS BTRKL,
  paobjnr,
  beltp,
  GSBER,
  cast( FKBER as fm_farea ) AS FKBER,
  scope,
  cast( logsyso as logsystem ) AS logsyso,
  cast( PKSTAR as pkstar ) AS PKSTAR,
  pbukrs,
  PFKBER,
  pscope,
  cast( logsysp as fis_logsysp ) AS logsysp,
  cast( dabrz as farp_dabrbez ) AS DABRZ,
  bwstrat,
  objnr_hk,
  rsrce,
  qmnum,
  GEBER,
  PGEBER,
  GRANT_NBR,
  PGRANT_NBR,
  REFBZ_FI,
  segment,
  psegment,
  cast( POSNR as posnr_acc ) AS POSNR,
  prctr,
  PPRCT,
  BUDGET_PD,
  PBUDGET_PD,
  prodper,
  awtyp,
  cast( AWKEY as fac_awkey ) AS AWKEY,
  cast( awsys as fis_awsys ) AS AWSYS,
  accas,
  cast( KOSTL as fis_kostl ) AS KOSTL,
  cast( LSTAR as lstar ) AS LSTAR,
  cast( AUFNR as fis_aufnr ) AS AUFNR,
  cast( AUTYP as auftyp ) AS AUTYP,
  cast( ps_psp_pnr as ps_posnr ) AS PS_PSP_PNR,
  cast( PSPNR as ps_posid ) AS PSPNR,
  cast( PSPID as ps_pspid ) AS PSPID,
  cast( VBELN as vbeln ) AS VBELN,
  cast( VBPOSNR as posnr_va ) AS VBPOSNR,
  cast( CE4KEY as copa_ce4key ) AS CE4KEY,
  work_item_id,
  erkrs,
  paccas,
  PKOSTL,
  cast( plstar as fis_par_lstar ) AS plstar,
  cast( paufnr as fis_par_aufnr ) AS paufnr,
  cast( pautyp as fis_par_auftyp ) AS pautyp,
  cast( PPSPNR as fis_par_posid ) AS PPSPNR,
  cast( PPSPID as fis_par_pspid ) AS PPSPID,
  cast( PVBELN as fis_par_kdauf ) AS PVBELN,
  cast( PVBPOSNR as fis_par_kdpos ) AS PVBPOSNR,
  cast( PCE4KEY as pcopa_ce4key ) AS PCE4KEY,
  gjahr,
  bldat,
  budat,
  usnam,
  blart,
  cast( LEDNR as lednr ) AS LEDNR,
  BUKRS,
  BELNR_FI,
  docln,
  drcrk,
  cast( koart as farp_koart ) AS koart,
  ktopl,
  KOSTL_ORI,
  ryear,
  rmvct,
  bttype,
  aworg,
  awref,
  bschl,
  timestamp,
  eprctr,
  rhoart,
  rebzg,
  rebzj,
  rebzz,
  rebzt,
  lifnr,
  umskz,
  mwskz,
  hbkid,
  hktid,
  augdt,
  augbl,
  auggj,
  hkgrp,
  ukostl,
  ulstar,
  LSTAR_ORI,
  AUFNR_ORI,
  AUTYP_ORI,
  fkart,
  vkorg,
  vtweg,
  spart,
  anln1,
  anln2,
  bzdat,
  anbwa,
  periv,
  fiscyearper,
  lokkt,
  ktop2,
  movcat,
  anlgr,
  anlgr2,
  ktosl,
  afabe,
  slalittype,
  zuonr,
  xopvw,
  co_belkz,
  kalnr,
  kzbws,
  xobew,
  sobkz,
  mat_kdauf,
  mat_kdpos,
  bwtar,
  bwkey,
  mat_lifnr,
  kdauf,
  kdpos,
  mat_ps_posid,
  ps_posid,
  ps_pspid,
  awitem,
  awitgrp,
  racct_sender,
  accas_sender,
  matkl,
  kdgrp,
  xreversing,
  xreversed,
  xtruerev,
  aworg_rev,
  awref_rev,
  parobsrc,
  ppaobjnr,
  rrcty,
  vorgn,
  ARTNR,
  KNDNR,
  bstat,
  kstrg,
  pkstrg,
  case when HANA_TIMESTAMP > 0 then cast(substring(cast(HANA_TIMESTAMP as abap.char(19)),1,8) as abap.char(8)) else '00000000' end AS cpudt,
  case when HANA_TIMESTAMP > 0 then cast(substring(cast(HANA_TIMESTAMP as abap.char(19)),9,6) as abap.char(6)) else '000000' end AS cputm,
  cast( AKTBO as aktbo ) AS AKTBO,
  cast( PASUBNR as rkesubnr ) AS PASUBNR,
  cast( UNUSED_CE3 as copa_unused_ce3 ) AS UNUSED_CE3,
  cast( CE4_KWSVME_ME as meins ) AS CE4_KWSVME_ME,
  cast( CE4_BRSCH as brsch ) AS BRSCH,
  cast( CE4_BZIRK as bzirk ) AS BZIRK,
  cast( CE4_KMVKBU as vkbur ) AS KMVKBU,
  cast( CE4_KMVTNR as sales_empl ) AS KMVTNR,
  cast( CE4_VKGRP as vkgrp ) AS VKGRP,
  cast( CE4_KMWNHG as rkeskmwnhg ) AS KMWNHG,
  cast( CE4_KNT_FRM_KZ as rke_kntfrm ) AS KNT_FRM_KZ
FROM P_Copa_Doc1
;