ICA_CONSJOURNALENTRIES_3C

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_3C.
-- 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.

CREATE VIEW ICA_CONSJOURNALENTRIES_3C AS
SELECT
  $session.client AS 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,
  acdocu.fiscyearper AS fiscyearper,
  acdocu.rldnr AS rldnr,
  acdocu.rdimen AS rdimen,
  acdocu.ryear AS ryear,
  acdocu.ryear AS gjahr,
  acdocu.docnr AS ref_belnr,
  acdocu.docln AS ref_docln,
  acdocu.rrcty AS rrcty,
  fincs_ref_vers_r.version AS rvers,
  acdocu.rtcur AS rtcur,
  acdocu.rhcur AS rhcur,
  case when tf200.group_curr = acdocu.rkcur then acdocu.rkcur else cast('' as gcurr) end AS rkcur,
  acdocu.runit AS runit,
  acdocu.poper AS poper,
  acdocu.docct AS docct,
  acdocu.rcomp AS rcomp,
  acdocu.rbunit AS rbunit,
  acdocu.ritclg AS ritclg,
  acdocu.ritem AS ritem,
  coalesce(_assignment.sa_role, '') AS sa_role,
  acdocu.rbuptr AS rbuptr,
  acdocu.rcongr AS rcongr,
  acdocu.robukrs AS robukrs,
  acdocu.sityp AS sityp,
  acdocu.subit AS subit,
  acdocu.plevl AS plevl,
  acdocu.rtflg AS rtflg,
  acdocu.docty AS docty,
  acdocu.tsl AS tsl,
  acdocu.hsl AS hsl,
  case when tf200.group_curr = acdocu.rkcur then acdocu.ksl else cast(0 as vgcur12) end AS ksl,
  acdocu.msl AS msl,
  acdocu.tsl_csign AS tsl_csign,
  acdocu.hsl_csign AS hsl_csign,
  case when tf200.group_curr = acdocu.rkcur then acdocu.ksl_csign else cast(0 as vgcur12) end AS ksl_csign,
  acdocu.msl_csign AS msl_csign,
  acdocu.sgtxt AS sgtxt,
  acdocu.budat AS budat,
  acdocu.timestamp AS timestamp,
  acdocu.awtyp AS awtyp,
  acdocu.aworg AS aworg,
  acdocu.ktopl AS ktopl,
  acdocu.racct AS racct,
  acdocu.zuonr AS zuonr,
  acdocu.rcntr AS rcntr,
  acdocu.prctr AS prctr,
  acdocu.rfarea AS rfarea,
  acdocu.kokrs AS kokrs,
  acdocu.segment AS segment,
  acdocu.scntr AS scntr,
  acdocu.pprctr AS pprctr,
  acdocu.sfarea AS sfarea,
  acdocu.rassc AS rassc,
  acdocu.psegment AS psegment,
  acdocu.aufnr AS aufnr,
  acdocu.kunnr AS kunnr,
  acdocu.lifnr AS lifnr,
  acdocu.matnr AS matnr,
  acdocu.matkl_mm AS matkl_mm,
  acdocu.werks AS werks,
  acdocu.rmvct AS rmvct,
  acdocu.ps_psp_pnr AS ps_psp_pnr,
  acdocu.ps_posid AS ps_posid,
  acdocu.ps_pspid AS ps_pspid,
  acdocu.fkart AS fkart,
  acdocu.vkorg AS vkorg,
  acdocu.vtweg AS vtweg,
  acdocu.spart AS spart,
  acdocu.matnr_copa AS matnr_copa,
  acdocu.matkl AS matkl,
  acdocu.kdgrp AS kdgrp,
  acdocu.land1 AS land1,
  acdocu.brsch AS brsch,
  acdocu.bzirk AS bzirk,
  acdocu.kunre AS kunre,
  acdocu.kunwe AS kunwe,
  acdocu.konzs AS konzs,
  cast('' as awref) AS awref,
  case when acdocu.orndocnr <> '' then cast(acdocu.orndocnr as awref_rev) else cast(acdocu.rvsdocnr as awref_rev) end as AWREF_REV AS rvsdocnrasawref_revendasAWREF_REV
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 */
;