ICA_GENJOURNALENTRIES_C2

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 ICA_GENJOURNALENTRIES_C2.
-- 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: ICAGENJESC2

CREATE VIEW ICA_GENJOURNALENTRIES_C2 AS
SELECT
  rclnt,
  cast ('' as ica_method_id) AS method_id,
  cast ('0000000000' as ica_docnr) AS DOCNR,
  cast (0 as ica_docln) AS DOCLN,
  cast ('000000000000' as ica_grref) AS GRREF,
  cast ('00' as ica_pstat) AS PSTAT,
  cast ('' as ica_cstat) AS CSTAT,
  cast ('00000000' as ica_due_date) AS DUE_DATE,
  augdt,
  augbl,
  auggj,
  rldnr,
  rbukrs,
  b.rcomp AS rcomp,
  blart,
  belnr AS ref_belnr,
  docln AS ref_docln,
  docnr_ld,
  rrcty,
  xreversing,
  xreversed,
  xtruerev,
  aworg_rev,
  awref_rev,
  aworg,
  awref,
  c.fiscal_year_variant AS periv,
  gjahr,
  c.fiscal_period AS poper,
  cast (c.fiscal_year_period as fis_jahrper_conv preserving type) AS fiscyearper,
  c.fiscal_year AS ryear,
  budat,
  bldat,
  a.ktopl AS ktopl,
  racct,
  rcntr,
  prctr,
  segment,
  scntr,
  pprctr,
  rassc,
  psegment,
  rwcur,
  rhcur,
  rkcur,
  runit,
  wsl,
  hsl,
  ksl,
  msl,
  drcrk,
  bschl,
  rmvct,
  bttype,
  zuonr,
  bstat,
  linetype,
  ktosl,
  slalittype,
  usnam,
  timestamp,
  eprctr,
  rebzg,
  rebzj,
  rebzz,
  cast (rbest as abap.numc( 3 )) AS rbest,
  ebeln,
  ebelp,
  sgtxt,
  kdauf,
  kdpos,
  matnr,
  werks,
  lifnr,
  kunnr,
  koart,
  umskz,
  a.mwskz AS mwskz,
  a.xopvw AS xopvw,
  afabe,
  anln1,
  anln2,
  anbwa,
  anlkl,
  panl1,
  panl2,
  fkart,
  vkorg,
  vtweg,
  spart,
  matnr_copa,
  matkl,
  kdgrp,
  a.land1 AS land1,
  brsch,
  bzirk,
  kunre,
  kunwe,
  konzs,
  gkont,
  gkoar,
  rfccur,
  fcsl,
  rtcur,
  tsl AS mandtrclnt,
  tsl
FROM acdoca AS a
INNER JOIN t001 AS b ON /* join condition not captured in parsed metadata */
INNER JOIN finsc_fisc_date AS c ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t009 AS c ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): acdoca
;