Fco_Mig_Check_Coep11_L3

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 Fco_Mig_Check_Coep11_L3.
-- 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: FCOV_CHECK4_L3

CREATE VIEW Fco_Mig_Check_Coep11_L3 AS
SELECT
  mandt,
  kokrs,
  belnr,
  buzei,
  PERIO,
  cast( WTGBTR as wtgxxx ) AS wtgbtr,
  cast( WOGBTR as wogxxx ) AS wogbtr,
  cast( WKGBTR as wkgxxx ) AS wkgbtr,
  cast( WKFBTR as wkfxxx ) AS wkfbtr,
  cast( PAGBTR as pagxxx ) AS pagbtr,
  cast( PAFBTR as pafxxx ) AS pafbtr,
  cast( MEGBTR as abap.dec(15,3) ) AS megbtr,
  cast( MEFBTR as abap.dec(15,3) ) AS mefbtr,
  cast( MBGBTR as abap.dec(15,3) ) AS mbgbtr,
  cast( MBFBTR as abap.dec(15,3) ) AS mbfbtr,
  LEDNR,
  GJAHR,
  WRTTP,
  VERSN,
  KSTAR,
  hrkft,
  vrgng,
  PAROB,
  parob1,
  uspob,
  VBUND,
  PARGB,
  beknz,
  TWAER,
  OWAER,
  MEINH,
  MEINB,
  muvflg,
  sgtxt,
  REFBZ,
  zlenr,
  BW_REFBZ,
  gkont,
  gkoar,
  werks,
  matnr,
  rbest,
  ebeln,
  ebelp,
  zekkn,
  erlkz,
  pernr,
  BTRKL,
  beltp,
  bukrs,
  gsber,
  FKBER,
  scope,
  pkstar,
  pbukrs,
  PFKBER,
  pscope,
  logsysp,
  dabrz,
  bwstrat,
  objnr_hk,
  qmnum,
  GEBER,
  PGEBER,
  GRANT_NBR,
  PGRANT_NBR,
  REFBZ_FI,
  segment,
  psegment,
  posnr,
  prctr,
  PPRCT,
  BUDGET_PD,
  PBUDGET_PD,
  prodper,
  awtyp,
  AWKEY,
  awsys,
  KWAER,
  KOSTL,
  lstar,
  aufnr,
  autyp,
  pspnr,
  pspid,
  vbeln,
  vbposnr,
  ce4key,
  erkrs,
  paccas,
  PKOSTL,
  plstar,
  paufnr,
  pautyp,
  ppspnr,
  ppspid,
  pvbeln,
  pvbposnr,
  pce4key,
  zuonr,
  quant1,
  quant2,
  quant3,
  qunit1,
  qunit2,
  qunit3
FROM Fco_Mig_Check_Coep11_L2 AS c
INNER JOIN fins_dummy4 AS d ON /* join condition not captured in parsed metadata */
;