ICA_CONSJOURNALENTRIES_4

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_4.
-- 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: ICACONSJES4

CREATE VIEW ICA_CONSJOURNALENTRIES_4 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,
  cast('' as fins_bttype) AS BTTYPE,
  cast('' as shkzg) AS drcrk,
  acdocu.rvers AS rvers,
  rtcur,
  rhcur,
  rkcur,
  runit,
  poper,
  docct,
  rcomp,
  rbunit,
  ritclg,
  ritem,
  coalesce(_assignment.sa_role, '') AS sa_role,
  rbuptr,
  rcongr,
  robukrs,
  sityp,
  subit,
  plevl,
  rtflg,
  docty,
  cast('' as blart) AS blart,
  tsl,
  hsl,
  ksl,
  msl,
  sgtxt,
  budat,
  timestamp,
  awtyp,
  aworg,
  ktopl,
  racct,
  zuonr,
  rcntr,
  prctr,
  rfarea,
  kokrs,
  segment,
  scntr,
  pprctr,
  sfarea,
  rassc,
  psegment,
  aufnr,
  kunnr,
  cast('' as koart) AS koart,
  cast('' as umskz) AS umskz,
  cast('' as mwskz) AS mwskz,
  cast('' as xopvw) AS xopvw,
  cast('00000000' as augdt) AS augdt,
  cast('' as augbl) AS augbl,
  cast('' as auggj) AS auggj,
  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,
  case when orndocnr <> '' then cast(orndocnr as awref_rev) else cast(rvsdocnr as awref_rev) end as AWREF_REV AS fieldnameRUNITrclnt,
  xreversing,
  xreversed,
  awref_rev
FROM acdocu
LEFT OUTER 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 */
LEFT OUTER JOIN fincs_bunit_atvd ON /* join condition not captured in parsed metadata */
INNER JOIN finsc_ledger_rep ON /* join condition not captured in parsed metadata */
INNER JOIN tf200 ON /* join condition not captured in parsed metadata */
INNER JOIN finsc_fisc_date ON /* join condition not captured in parsed metadata */
INNER JOIN fincs_bunit_atd ON /* join condition not captured in parsed metadata */
INNER JOIN fincs_fsitem ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): acdoca
;