P_Copa_Doc1

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_Doc1.
-- 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: PFICOPADOC1

CREATE VIEW P_Copa_Doc1 AS
SELECT
  kokrs,
  case when P_Acdoca_As_Coep.co_belnr = '' then P_Acdoca_As_Coep.belnr else P_Acdoca_As_Coep.co_belnr end as BELNR AS co_belnrendasBELNR,
  case when P_Acdoca_As_Coep.co_buzei = '000' then cast(SUBSTRING(docln,4,3) as abap.numc(3)) else P_Acdoca_As_Coep.co_buzei end as BUZEI AS co_buzeiendasBUZEI,
  rldnr,
  rldnr_pers,
  cast( '00' as abap.char(2)) AS LEDNR,
  rbukrs AS BUKRS,
  gjahr,
  belnr AS BELNR_FI,
  docln,
  rbusa AS GSBER,
  werks,
  matnr,
  rfarea AS FKBER,
  drcrk,
  koart,
  blart,
  rhcur,
  ktopl,
  rcntr AS KOSTL_ORI,
  segment,
  prctr,
  racct AS KSTAR,
  ryear,
  rmvct,
  bttype,
  awtyp,
  awsys,
  aworg,
  awref,
  rtcur,
  rkcur AS KWAER,
  rocur,
  runit AS MEINB,
  rwcur AS TWAER,
  rvunit AS MEINH,
  qunit1,
  qunit2,
  qunit3,
  scntr AS PKOSTL,
  pprctr AS PPRCT,
  sfarea AS PFKBER,
  sbusa AS PARGB,
  rassc AS VBUND,
  psegment,
  tsl,
  hsl,
  ksl AS WKGBTR,
  osl,
  msl AS MBGBTR,
  wsl AS WTGBTR,
  vmsl AS MEGBTR,
  kfsl AS WKFBTR,
  psl AS PAGBTR,
  pfsl AS PAFBTR,
  vmfsl AS MEFBTR,
  quant1,
  quant2,
  quant3,
  poper AS PERIO,
  budat,
  buzei AS REFBZ_FI,
  bschl,
  usnam,
  timestamp,
  eprctr,
  rhoart,
  rebzg,
  rebzj,
  rebzz,
  rebzt,
  rbest,
  ebeln,
  ebelp,
  zekkn,
  sgtxt,
  lifnr,
  umskz,
  mwskz,
  hbkid,
  hktid,
  augdt,
  augbl,
  auggj,
  hkgrp,
  beltp,
  gkont,
  gkoar,
  erlkz,
  pernr,
  scope,
  pbukrs,
  pscope,
  ukostl,
  ulstar,
  accas,
  lstar AS LSTAR_ORI,
  aufnr AS AUFNR_ORI,
  autyp AS AUTYP_ORI,
  erkrs,
  paccas,
  plstar,
  paufnr,
  pautyp,
  fkart,
  vkorg,
  vtweg,
  spart,
  anln1,
  anln2,
  bzdat,
  anbwa,
  periv,
  fiscyearper,
  bldat,
  lokkt,
  ktop2,
  movcat,
  anlgr,
  anlgr2,
  ktosl,
  afabe,
  slalittype,
  zuonr,
  xopvw,
  co_belkz,
  co_osl,
  rco_ocur,
  kalnr,
  kzbws,
  xobew,
  sobkz,
  mat_kdauf,
  mat_kdpos,
  bwtar,
  bwkey,
  mat_lifnr,
  mfsl AS MBFBTR,
  kdauf,
  kdpos,
  mat_ps_posid,
  ps_psp_pnr,
  ps_posid,
  ps_pspid,
  pps_posid AS PPSPNR,
  pps_pspid AS PPSPID,
  pkdauf AS PVBELN,
  pkdpos AS PVBPOSNR,
  awitem,
  awitgrp,
  racct_sender,
  accas_sender,
  matkl,
  kdgrp,
  xreversing,
  xreversed,
  xtruerev,
  aworg_rev,
  awref_rev,
  co_belnr,
  co_buzei,
  work_item_id,
  parob1,
  uspob,
  parobsrc,
  paobjnr,
  ppaobjnr,
  objnr,
  objnr_hk,
  rrcty,
  vorgn,
  vrgng,
  hrkft,
  logsyso,
  bwstrat,
  logsysp,
  muvflg AS MVFLG,
  matnr_copa AS ARTNR,
  kunnr AS KNDNR,
  bstat,
  kstrg,
  pkstrg,
  case when (P_Acdoca_As_Coep.accasty = 'KL' or P_Acdoca_As_Coep.accasty = 'KS') then P_Acdoca_As_Coep.rcntr else '' end as KOSTL AS rcntrelseendasKOSTL,
  case when P_Acdoca_As_Coep.accasty = 'KL' then P_Acdoca_As_Coep.lstar else '' end as LSTAR AS lstarelseendasLSTAR,
  case when (P_Acdoca_As_Coep.accasty = 'OP' or P_Acdoca_As_Coep.accasty = 'OR' or P_Acdoca_As_Coep.accasty = 'OV') then P_Acdoca_As_Coep.aufnr else '' end as AUFNR AS aufnrelseendasAUFNR,
  case when (P_Acdoca_As_Coep.accasty = 'OP' or P_Acdoca_As_Coep.accasty = 'OR' or P_Acdoca_As_Coep.accasty = 'OV') then P_Acdoca_As_Coep.autyp else '00' end as AUTYP AS autypelse00endasAUTYP,
  case when P_Acdoca_As_Coep.accasty = 'PR' then P_Acdoca_As_Coep.ps_posid else '' end as PSPNR AS ps_posidelseendasPSPNR,
  case when P_Acdoca_As_Coep.accasty = 'PR' then P_Acdoca_As_Coep.ps_pspid else '' end as PSPID AS ps_pspidelseendasPSPID,
  case when P_Acdoca_As_Coep.accasty = 'VB' then P_Acdoca_As_Coep.kdauf else '' end as VBELN AS kdaufelseendasVBELN,
  case when P_Acdoca_As_Coep.accasty = 'VB' then P_Acdoca_As_Coep.kdpos else '000000' end as VBPOSNR AS kdposelse000000endasVBPOSNR,
  case when P_Acdoca_As_Coep.rco_ocur = ' ' then case when P_Acdoca_As_Coep.rocur = ' ' then P_Acdoca_As_Coep.hsl else P_Acdoca_As_Coep.osl end else P_Acdoca_As_Coep.co_osl end as WOGBTR AS co_oslendasWOGBTR,
  case when P_Acdoca_As_Coep.co_belkz = '' or P_Acdoca_As_Coep.co_belkz is null then P_Acdoca_As_Coep.drcrk else P_Acdoca_As_Coep.co_belkz end as BEKNZ AS co_belkzendasBEKNZ,
  case when P_Acdoca_As_Coep.rco_ocur = ' ' then case when P_Acdoca_As_Coep.rocur = ' ' then P_Acdoca_As_Coep.rhcur else P_Acdoca_As_Coep.rocur end else P_Acdoca_As_Coep.rco_ocur end as OWAER AS rco_ocurendasOWAER,
  awitem AS refbz,
  cast(SUBSTRING(P_Acdoca_As_Coep.awitem,4,3) as abap.numc(3)) AS ZLENR,
  '0000000000' AS POSNR,
  CONCAT( P_Acdoca_As_Coep.awref, P_Acdoca_As_Coep.aworg ) as AWKEY AS aworgasAWKEY,
  case when P_Acdoca_As_Coep.accasty = 'EO' then cast(SUBSTRING(P_Acdoca_As_Coep.objnr,7,10) as abap.numc(10)) else '0000000000' end as CE4KEY AS numc10else0000000000endasCE4KEY,
  case when P_Acdoca_As_Coep.paccasty = 'EO' then cast(SUBSTRING(P_Acdoca_As_Coep.objnr,7,10) as abap.numc(10)) else '0000000000' end as PCE4KEY AS numc10else0000000000endasPCE4KEY,
  P_Acdoca_As_Coep.co_buzei AS BW_REFBZ,
  '00' AS BTRKL,
  dabrz,
  rsrce,
  qmnum,
  rfund AS GEBER,
  sfund AS PGEBER,
  rgrant_nbr AS GRANT_NBR,
  sgrant_nbr AS PGRANT_NBR,
  rbudget_pd AS BUDGET_PD,
  sbudget_pd AS PBUDGET_PD,
  prodper,
  P_Acdoca_As_Coep.timestamp AS HANA_TIMESTAMP,
  cast( '04' as abap.char(2)) AS WRTTP,
  cast( ' ' as abap.char(10)) AS PKSTAR,
  'X' AS AKTBO,
  cast( '0000' as abap.numc(4)) AS PASUBNR,
  '' AS UNUSED_CE3,
  cast( ' ' as abap.unit(3)) AS CE4_KWSVME_ME,
  cast( ' ' as abap.char(4)) AS CE4_BRSCH,
  cast( ' ' as abap.char(6)) AS CE4_BZIRK,
  cast( ' ' as abap.char(4)) AS CE4_KMVKBU,
  cast( '00000000' as abap.numc(8)) AS CE4_KMVTNR,
  cast( ' ' as abap.char(3)) AS CE4_VKGRP,
  cast( '00' as abap.numc(2)) AS CE4_KMWNHG,
  cast( '0' as abap.numc(1)) AS CE4_KNT_FRM_KZ
FROM P_Acdoca_As_Coep
;