ICA_GENJOURNALENTRIES

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.
-- 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: ICAGENJES

CREATE VIEW ICA_GENJOURNALENTRIES 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,
  a.periv AS periv,
  gjahr,
  poper,
  cast (fiscyearper as fis_jahrper_conv preserving type) AS fiscyearper,
  ryear,
  budat,
  bldat,
  a.ktopl AS ktopl,
  racct,
  kokrs,
  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,
  buzei
FROM acdoca AS a
INNER JOIN t001 AS b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN skb1 ON /* join condition not captured in parsed metadata */
;