ICA_P_CONSJOURNALENTRIES_01

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_P_CONSJOURNALENTRIES_01.
-- 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: ICAPCJES01

CREATE VIEW ICA_P_CONSJOURNALENTRIES_01 AS
SELECT
  rclnt,
  tf200.rldnr_cons AS rldnr,
  cast('Y1' as fc_dimen) AS rdimen,
  finsc_fisc_date.fiscal_year AS ryear,
  gjahr,
  finsc_fisc_date.fiscal_year_period AS fiscyearper,
  belnr AS ref_belnr,
  docln AS ref_docln,
  rrcty,
  bttype,
  drcrk,
  tf200.rvers AS rvers,
  tf200.iatvs AS iatvs,
  rwcur,
  rtcur,
  runit,
  finsc_fisc_date.fiscal_period AS poper,
  cast('A' as docct) AS docct,
  I_CompanyCode.Company AS rcomp,
  fincs_bunit_2.bunit AS rbunit,
  coalesce( I_FSItemMappingAssgmtWithVers.ConsolidationChartOfAccounts, '') AS ritclg,
  coalesce( I_FSItemMappingAssgmtWithVers.FinancialStatementItem, '' ) AS ritem,
  coalesce( fincs_bunit_3.bunit, '') AS rbuptr,
  cast('' as fc_congr) AS rcongr,
  rbukrs AS robukrs,
  fincs_fsitem.itbrkdwn AS itbrkdwn,
  cast('' as fc_plevl) AS plevl,
  cast('0' as fc_rtflg) AS rtflg,
  cast('0F' as fc_docty) AS docty,
  blart,
  wsl,
  tsl,
  msl,
  sgtxt,
  budat,
  timestamp,
  awtyp,
  aworg,
  ktopl,
  racct,
  zuonr,
  rcntr,
  acdoca.prctr AS prctr,
  rfarea,
  kokrs,
  segment,
  scntr,
  pprctr,
  sfarea,
  rassc,
  psegment,
  aufnr,
  kunnr,
  koart,
  umskz,
  acdoca.mwskz AS mwskz,
  acdoca.xopvw AS xopvw,
  augdt,
  augbl,
  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,
  xreversing,
  xreversed,
  awref,
  awref_rev
FROM acdoca
INNER JOIN I_CompanyCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fincs_bunit AS fincs_bunit_2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fincs_bunit_atvd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tf200 ON /* join condition not captured in parsed metadata */
INNER JOIN finsc_ledger_rep ON /* join condition not captured in parsed metadata */
INNER JOIN finsc_fisc_date ON /* join condition not captured in parsed metadata */
INNER JOIN I_FSItemMappingAssgmtWithVers ON /* join condition not captured in parsed metadata */
;