P_Journal_Entry

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 P_Journal_Entry.
-- 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: PFIJOURNALENTRY

CREATE VIEW P_Journal_Entry AS
SELECT
  rldnr_pers,
  rbukrs,
  gjahr,
  belnr,
  docln,
  rldnr,
  ryear,
  rrcty,
  rmvct,
  bttype,
  awtyp,
  awsys,
  aworg,
  awref,
  awitem,
  awitgrp,
  subta,
  xreversing,
  xreversed,
  xtruerev,
  awtyp_rev,
  aworg_rev,
  awref_rev,
  subta_rev,
  xsettling,
  xsettled,
  prec_awtyp,
  prec_aworg,
  prec_awref,
  prec_awitem,
  prec_subta,
  src_awtyp,
  src_awsys,
  src_aworg,
  src_awref,
  src_awitem,
  src_awsubit,
  xcommitment,
  racct,
  rcntr,
  prctr,
  rfarea,
  rbusa,
  kokrs,
  segment,
  scntr,
  pprctr,
  sfarea,
  sbusa,
  rassc,
  psegment,
  rtcur,
  tsl,
  rwcur,
  wsl,
  rhcur,
  hsl,
  rkcur,
  ksl,
  rocur,
  osl,
  rvcur,
  vsl,
  rbcur,
  bsl,
  rccur,
  csl,
  rdcur,
  dsl,
  recur,
  esl,
  rfcur,
  fsl,
  rgcur,
  gsl,
  kfsl,
  kfsl2,
  kfsl3,
  psl,
  psl2,
  psl3,
  pfsl,
  pfsl2,
  pfsl3,
  rco_ocur,
  co_osl,
  runit,
  msl,
  mfsl,
  rvunit,
  vmsl,
  vmfsl,
  qunit1,
  quant1,
  qunit2,
  quant2,
  qunit3,
  quant3,
  drcrk,
  poper,
  periv,
  fiscyearper,
  budat,
  bldat,
  blart,
  buzei,
  zuonr,
  bschl,
  bstat,
  ktosl,
  slalittype,
  usnam,
  timestamp,
  eprctr,
  rhoart,
  ktopl,
  lokkt,
  ktop2,
  rebzg,
  rebzj,
  rebzz,
  rebzt,
  rbest,
  ebeln,
  ebelp,
  zekkn,
  sgtxt,
  kdauf,
  kdpos,
  matnr,
  werks,
  lifnr,
  kunnr,
  fbuda,
  koart,
  umskz,
  mwskz,
  hbkid,
  hktid,
  xopvw,
  augdt,
  augbl,
  auggj,
  XAUGP,
  afabe,
  anln1,
  anln2,
  bzdat,
  anbwa,
  movcat,
  depr_period,
  anlgr,
  anlgr2,
  kalnr,
  kzbws,
  xobew,
  sobkz,
  mat_kdauf,
  mat_kdpos,
  mat_pspnr,
  mat_ps_posid,
  mat_lifnr,
  bwtar,
  bwkey,
  racct_sender,
  accas_sender,
  objnr,
  hkgrp,
  uspob,
  co_belkz,
  beltp,
  muvflg,
  gkont,
  gkoar,
  erlkz,
  pernr,
  scope,
  pbukrs,
  pscope,
  aufnr_org,
  ukostl,
  ulstar,
  uprctr,
  accas,
  lstar,
  aufnr,
  autyp,
  ps_psp_pnr,
  ps_posid,
  ps_pspid,
  nplnr,
  nplnr_vorgn,
  prznr,
  kstrg,
  bemot,
  rsrce,
  qmnum,
  erkrs,
  paccas,
  plstar,
  paufnr,
  pautyp,
  pps_posid,
  pps_pspid,
  pkdauf,
  pkdpos,
  pnplnr,
  pnplnr_vorgn,
  pprznr,
  pkstrg,
  work_item_id,
  fkart,
  vkorg,
  vtweg,
  spart,
  matnr_copa,
  matkl,
  kdgrp,
  land1,
  brsch,
  bzirk,
  kunre,
  kunwe,
  konzs,
  re_bukrs,
  re_account,
  fikrs,
  rfund,
  rgrant_nbr,
  rbudget_pd,
  sfund,
  sgrant_nbr,
  sbudget_pd,
  fistl,
  measure,
  vname,
  egrup,
  recid,
  vptnr,
  btype,
  etype,
  prodper,
  swenr,
  sgenr,
  sgrnr,
  smenr,
  recnnr,
  snksl,
  sempsl,
  dabrz,
  pswenr,
  psgenr,
  psgrnr,
  psmenr,
  precnnr,
  psnksl,
  psempsl,
  pdabrz,
  arbid,
  vornr,
  aufps,
  hsl_debit,
  hsl_credit,
  wsl_debit,
  wsl_credit,
  tsl_debit,
  tsl_credit,
  ksl_debit,
  ksl_credit,
  osl_debit,
  osl_credit,
  vsl_debit,
  vsl_credit,
  bsl_debit,
  bsl_credit,
  csl_debit,
  csl_credit,
  dsl_debit,
  dsl_credit,
  esl_debit,
  esl_credit,
  fsl_debit,
  fsl_credit,
  gsl_debit,
  gsl_credit,
  cast( FINS_XAUFNR_STAT as fins_xaufnr_stat ) AS FINS_XAUFNR_STAT,
  cast( FINS_XKOSTL_STAT as fins_xkostl_stat ) AS FINS_XKOSTL_STAT,
  cast( FINS_XKDPOS_STAT as fins_xkdpos_stat ) AS FINS_XKDPOS_STAT,
  cast( FINS_XPS_POSID_STAT as fins_xps_posid_stat ) AS FINS_XPS_POSID_STAT,
  nbritm
FROM P_Acdoca_Cube
;