Summerizationterm

DDL: SUMMERIZATIONTERM SQL: FCLMSUMMTERM Type: view Package: FCLM_CP

summerization term with all priority

Summerizationterm is a CDS View that provides data about "summerization term with all priority" in SAP S/4HANA. It reads from 6 data sources and exposes 16 fields. Part of development package FCLM_CP.

Data Sources (6)

SourceAliasJoin Type
Fclm_GlgroupE e left_outer
Fclm_GlgroupE e left_outer
Fclm_GlgroupE e left_outer
Summerizationterm1 sumterm from
Summerizationterm2 sumterm union
Summerizationterm3 sumterm union

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FCLMSUMMTERM view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
EndUserText.label summerization term with all priority view

Fields (16)

KeyFieldSource TableSource FieldDescription
GLAccount Summerizationterm3 GLAccount General Ledger
CompanyCode Summerizationterm3 CompanyCode Receiver Company Code
ChartOfAccount Summerizationterm3 ChartOfAccount Node Class
SUMGroupping Summerizationterm3 SUMGroupping
SUMTerm Summerizationterm3 SUMTerm
GLAccount General Ledger
CompanyCode Summerizationterm3 CompanyCode Receiver Company Code
ChartOfAccount Summerizationterm3 ChartOfAccount Node Class
SUMGroupping Summerizationterm3 SUMGroupping
SUMTerm Summerizationterm3 SUMTerm
GLAccount General Ledger
CompanyCode Summerizationterm3 CompanyCode Receiver Company Code
ChartOfAccount Summerizationterm3 ChartOfAccount Node Class
SUMGroupping Summerizationterm3 SUMGroupping
SUMTerm Summerizationterm3 SUMTerm
priority Summerizationterm3 priority Workflow priority

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 Summerizationterm.
-- 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: FCLMSUMMTERM

CREATE VIEW Summerizationterm AS
SELECT
  sumterm.GLAccount AS GLAccount,
  sumterm.CompanyCode AS CompanyCode,
  sumterm.ChartOfAccount AS ChartOfAccount,
  sumterm.SUMGroupping AS SUMGroupping,
  sumterm.SUMTerm AS SUMTerm,
  sumterm.priority AS priority
FROM Summerizationterm1 AS sumterm
LEFT OUTER JOIN Fclm_GlgroupE AS e ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): Summerizationterm2, Summerizationterm3
;