gle_adb_kfc_accdoc_item

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 gle_adb_kfc_accdoc_item.
-- 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: GLE_ADB_KFC_ITEM

CREATE VIEW gle_adb_kfc_accdoc_item AS
SELECT
  ada.rclnt AS mandt,
  repled.rldnr AS rldnr,
  rbukrs,
  gjahr,
  belnr,
  docln,
  ryear,
  docnr_ld,
  rrcty,
  rmvct,
  vorgn,
  vrgng,
  bttype,
  awtyp,
  awsys,
  aworg,
  awref,
  awitem,
  awitgrp,
  subta,
  xreversing,
  xreversed,
  xtruerev,
  awtyp_rev,
  aworg_rev,
  awref_rev,
  subta_rev,
  xsettling,
  xsettled,
  prec_awtyp,
  prec_awsys,
  prec_aworg,
  prec_awref,
  prec_awitem,
  prec_subta,
  xsecondary,
  src_awtyp,
  src_awsys,
  src_aworg,
  src_awref,
  src_awitem,
  src_awsubit,
  xcommitment,
  obs_reason,
  rtcur,
  rhcur,
  rkcur,
  rfccur,
  rocur,
  rvcur,
  rbcur,
  rccur,
  rdcur,
  recur,
  rfcur,
  rgcur,
  rco_ocur,
  runit,
  rvunit,
  racct,
  rcntr,
  prctr,
  rfarea,
  rbusa,
  kokrs,
  segment,
  scntr,
  pprctr,
  sfarea,
  sbusa,
  rassc,
  psegment,
  tsl,
  hsl,
  ksl,
  fcsl,
  osl,
  vsl,
  bsl,
  csl,
  dsl,
  esl,
  fsl,
  gsl,
  hvkwrt,
  psl,
  pfsl,
  msl,
  vmsl,
  drcrk,
  poper,
  periv,
  fiscyearper,
  bldat,
  blart,
  buzei,
  zuonr,
  bschl,
  bstat,
  linetype,
  ktosl,
  slalittype,
  xsplitmod,
  usnam,
  timestamp,
  eprctr,
  rhoart,
  ktopl,
  lokkt,
  ktop2,
  rebzg,
  rebzj,
  rebzz,
  rebzt,
  rbest,
  ebeln,
  ebelp,
  zekkn,
  sgtxt,
  kdauf,
  kdpos,
  matnr,
  werks,
  lifnr,
  kunnr,
  fbuda,
  coco_num,
  koart,
  umskz,
  mwskz,
  hbkid,
  hktid,
  xopvw,
  augdt,
  augbl,
  auggj,
  afabe,
  anln1,
  anln2,
  bzdat,
  anbwa,
  movcat,
  depr_period,
  anlgr,
  anlgr2,
  anlkl,
  ktogr,
  panl1,
  panl2,
  ubzdt_pn,
  xvabg_pn,
  prozs_pn,
  kalnr,
  vprsv,
  mlast,
  kzbws,
  xobew,
  sobkz,
  vtstamp,
  mat_kdauf,
  mat_kdpos,
  mat_pspnr,
  mat_ps_posid,
  mat_lifnr,
  bwtar,
  bwkey,
  hpeinh,
  kpeinh,
  opeinh,
  vpeinh,
  mlptyp,
  mlcateg,
  qsbvalt,
  qsprocess,
  perart,
  mlposnr,
  bukrs_sender,
  racct_sender,
  accas_sender,
  objnr,
  hrkft,
  hkgrp,
  parob1,
  parobsrc,
  uspob,
  co_belkz,
  co_beknz,
  beltp,
  muvflg,
  gkont,
  gkoar,
  erlkz,
  pernr,
  paobjnr,
  scope,
  logsyso,
  pbukrs,
  pscope,
  logsysp,
  bwstrat,
  objnr_hk,
  aufnr_org,
  ukostl,
  ulstar,
  uprznr,
  uprctr,
  accas,
  lstar,
  aufnr,
  autyp,
  ps_psp_pnr,
  ps_posid,
  ps_prj_pnr,
  ps_pspid,
  nplnr,
  nplnr_vorgn,
  prznr,
  kstrg,
  bemot,
  rsrce,
  qmnum,
  erkrs,
  paccas,
  plstar,
  paufnr,
  pautyp,
  pps_posid,
  pps_pspid,
  pkdauf,
  pkdpos,
  ppaobjnr,
  pnplnr,
  pnplnr_vorgn,
  pprznr,
  pkstrg,
  co_zlenr,
  co_belnr,
  co_buzei,
  co_buzei1,
  co_buzei2,
  co_buzei5,
  co_buzei6,
  co_buzei7,
  co_refbz,
  co_refbz1,
  co_refbz2,
  co_refbz5,
  co_refbz6,
  co_refbz7,
  work_item_id,
  arbid,
  vornr,
  aufps,
  uvorn,
  equnr,
  tplnr,
  istru,
  ilart,
  plknz,
  artpr,
  priok,
  maufnr,
  matkl_mm,
  fkart,
  vkorg,
  vtweg,
  spart,
  matnr_copa,
  matkl,
  kdgrp,
  land1,
  brsch,
  bzirk,
  kunre,
  kunwe,
  konzs,
  re_bukrs,
  re_account,
  fikrs,
  fistl,
  measure,
  rfund,
  rgrant_nbr,
  rbudget_pd,
  sfund,
  sgrant_nbr,
  sbudget_pd,
  vname,
  egrup,
  recid,
  vptnr,
  btype,
  etype,
  prodper,
  billm,
  pom,
  cbrunid,
  jvactivity,
  pvname,
  pegrup,
  s_recind,
  cbracct,
  cbobjnr,
  swenr,
  sgenr,
  sgrnr,
  smenr,
  recnnr,
  snksl,
  sempsl,
  dabrz,
  pswenr,
  psgenr,
  psgrnr,
  psmenr,
  precnnr,
  psnksl,
  psempsl,
  pdabrz,
  acrobjtype,
  acrobj_id,
  acrsobj_id,
  acritmtype,
  fup_action,
  mig_source,
  mig_docln,
  rbunit,
  rbuptr,
  rcomp,
  ritclg,
  ritem,
  sityp,
  subit
FROM acdoca AS ada
LEFT OUTER JOIN finsc_period AS fip ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN finsc_period AS fip0 ON /* join condition not captured in parsed metadata */
;