FAA_LINEITEMS_SUM

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 FAA_LINEITEMS_SUM.
-- 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: FAAV_LINEITEMS_S

CREATE VIEW FAA_LINEITEMS_SUM AS
SELECT
  mandt,
  racct,
  budat,
  bzdat,
  bwasl,
  poper,
  depr_period,
  anlgr,
  anlgr2,
  anlkl,
  ktogr,
  panl1,
  panl2,
  subta_rev,
  awtyp,
  awref,
  aworg,
  awsys,
  awitgrp,
  awitem,
  recid,
  has_fi_doc,
  afabe_fi_doc,
  mig_source,
  xreversing,
  xreversed,
  xsettling,
  xsettled,
  prec_awtyp,
  prec_aworg,
  prec_awref,
  prec_subta,
  awtyp_rev,
  awref_rev,
  aworg_rev,
  belnr,
  vbund,
  cpudt,
  cputm,
  usnam,
  tcode,
  sgtxt,
  xblnr,
  zuonr,
  ebeln,
  objid,
  augln,
  ldgrpspec_pn,
  afabespec_pn,
  ubzdt_pn,
  xvabg_pn,
  prozs_pn,
  rkcur,
  rocur,
  rvcur,
  rbcur,
  rccur,
  rdcur,
  recur,
  rfcur,
  rgcur,
  sum(ksl) AS KSL,
  sum(osl) AS OSL,
  sum(vsl) AS VSL,
  sum(bsl) AS bsl,
  sum(csl) AS csl,
  sum(dsl) AS dsl,
  sum(esl) AS esl,
  sum(fsl) AS fsl,
  sum(gsl) AS gsl
FROM faav_lineitems
;