P_Glacct_Line_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 P_Glacct_Line_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: PFIGLACCTLIT

CREATE VIEW P_Glacct_Line_Item 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,
  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,
  matnr,
  werks,
  lifnr,
  kunnr,
  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,
  hkgrp,
  uspob,
  co_belkz,
  beltp,
  muvflg,
  gkont,
  gkoar,
  erlkz,
  pernr,
  scope,
  pbukrs,
  pscope,
  aufnr_org,
  ukostl,
  ulstar,
  uprctr,
  accas,
  nplnr,
  nplnr_vorgn,
  prznr,
  kstrg,
  bemot,
  rsrce,
  qmnum,
  erkrs,
  paccas,
  plstar,
  paufnr,
  pautyp,
  pps_posid,
  pps_pspid,
  pkdauf,
  pkdpos,
  pnplnr,
  pnplnr_vorgn,
  pprznr,
  pkstrg,
  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,
  rcntr,
  cast( lstar as lstar preserving type ) AS lstar,
  cast( aufnr as fis_aufnr preserving type ) AS aufnr,
  cast( autyp as auftyp preserving type ) AS autyp,
  ps_psp_pnr,
  ps_posid,
  ps_pspid,
  kdauf,
  kdpos,
  cast( hsl_debit as fis_dr_hsl preserving type ) AS hsl_debit,
  cast( hsl_credit as fis_cr_hsl preserving type ) AS hsl_credit,
  cast( wsl_debit as fis_dr_wsl preserving type ) AS wsl_debit,
  cast( wsl_credit as fis_cr_wsl preserving type ) AS wsl_credit,
  cast( tsl_debit as fis_dr_tsl preserving type ) AS tsl_debit,
  cast( tsl_credit as fis_cr_tsl preserving type ) AS tsl_credit,
  cast( ksl_debit as fis_dr_ksl preserving type ) AS ksl_debit,
  cast( ksl_credit as fis_cr_ksl preserving type ) AS ksl_credit,
  cast( osl_debit as fis_dr_osl preserving type ) AS osl_debit,
  cast( osl_credit as fis_cr_osl preserving type ) AS osl_credit,
  cast( vsl_debit as fis_dr_vsl preserving type ) AS vsl_debit,
  cast( vsl_credit as fis_cr_vsl preserving type ) AS vsl_credit,
  cast( bsl_debit as fis_dr_bsl preserving type ) AS bsl_debit,
  cast( bsl_credit as fis_cr_bsl preserving type ) AS bsl_credit,
  cast( csl_debit as fis_dr_csl preserving type ) AS csl_debit,
  cast( csl_credit as fis_cr_csl preserving type ) AS csl_credit,
  cast( dsl_debit as fis_dr_dsl preserving type ) AS dsl_debit,
  cast( dsl_credit as fis_cr_dsl preserving type ) AS dsl_credit,
  cast( esl_debit as fis_dr_esl preserving type ) AS esl_debit,
  cast( esl_credit as fis_cr_esl preserving type ) AS esl_credit,
  cast( fsl_debit as fis_dr_fsl preserving type ) AS fsl_debit,
  cast( fsl_credit as fis_cr_fsl preserving type ) AS fsl_credit,
  cast( gsl_debit as fis_dr_gsl preserving type ) AS gsl_debit,
  cast( gsl_credit as fis_cr_gsl preserving type ) AS gsl_credit,
  cast( FINS_XAUFNR_STAT as fins_xaufnr_stat preserving type ) AS FINS_XAUFNR_STAT,
  cast( FINS_XKOSTL_STAT as fins_xkostl_stat preserving type ) AS FINS_XKOSTL_STAT,
  cast( FINS_XKDPOS_STAT as fins_xkdpos_stat preserving type ) AS FINS_XKDPOS_STAT,
  cast( FINS_XPS_POSID_STAT as fins_xps_posid_stat preserving type ) AS FINS_XPS_POSID_STAT
FROM P_Acdoca_Cube
;