ICA_CONSJOURNALENTRIES_3

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_CONSJOURNALENTRIES_3.
-- 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: ICACONSJES3

CREATE VIEW ICA_CONSJOURNALENTRIES_3 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,
  cast ('0' as ica_clearing_status ) AS CLEARING_STATUS,
  fiscyearper,
  rldnr,
  rdimen,
  ryear,
  ryear AS gjahr,
  docnr AS ref_belnr,
  docln AS ref_docln,
  rrcty,
  fincs_ref_vers_r.version AS rvers,
  rtcur,
  rhcur,
  case when tf200.group_curr = acdocu.rkcur then rkcur else cast('' as gcurr) end AS rkcur,
  runit,
  poper,
  docct,
  rcomp,
  rbunit,
  ritclg,
  ritem,
  coalesce(_assignment.sa_role, '') AS sa_role,
  rbuptr,
  rcongr,
  robukrs,
  sityp,
  subit,
  plevl,
  rtflg,
  docty,
  tsl,
  hsl,
  case when tf200.group_curr = acdocu.rkcur then ksl else cast(0 as vgcur12) end AS ksl,
  msl,
  sgtxt,
  budat,
  timestamp,
  awtyp,
  aworg,
  ktopl,
  racct,
  zuonr,
  rcntr,
  prctr,
  rfarea,
  kokrs,
  segment,
  scntr,
  pprctr,
  sfarea,
  rassc,
  psegment,
  aufnr,
  kunnr,
  lifnr,
  matnr,
  matkl_mm,
  werks,
  rmvct,
  ps_psp_pnr,
  ps_posid,
  ps_pspid,
  fkart,
  vkorg,
  vtweg,
  spart,
  matnr_copa,
  matkl,
  kdgrp,
  land1,
  brsch,
  bzirk,
  kunre,
  kunwe,
  konzs,
  cast('' as awref) AS awref
FROM acdocu
INNER JOIN fincs_ref_vers_r ON /* join condition not captured in parsed metadata */
INNER JOIN tf200 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ica_fs_item AS _assignment ON /* join condition not captured in parsed metadata */
;