Summerizationterm1

DDL: SUMMERIZATIONTERM1 SQL: FCLMSUMMTERM1 Type: view
9 Fields 2 Data Sources

summerization term with first priority

Summerizationterm1 is a CDS View that provides data about "summerization term with first priority" in SAP S/4HANA. It reads from 2 data sources (I_GLAccount, Fclm_Glgroup) and exposes 9 fields.

Data Sources (2)

SourceAliasJoin Type
I_GLAccount glaccount from
Fclm_Glgroup glgroup inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FCLMSUMMTERM1 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 first priority view

Fields (9)

KeyFieldSource TableSource FieldDescription
GLAccount I_GLAccount GLAccount General Ledger
CompanyCode I_GLAccount CompanyCode Receiver Company Code
ChartOfAccount I_GLAccount ChartOfAccounts Node Class
SUMGroupping Fclm_Glgroup SUMGroupping Grouping
SUMTerm Fclm_Glgroup SUMTerm Sum. Term
Map_CompanyCode Fclm_Glgroup bukrs Value
Map_ChartOfAccount Fclm_Glgroup ktopl G/L Chart of Accounts
exclude Fclm_Glgroup exclude Exclusive
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 Summerizationterm1.
-- 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: FCLMSUMMTERM1

CREATE VIEW Summerizationterm1 AS
SELECT
  glaccount.GLAccount AS GLAccount,
  glaccount.CompanyCode AS CompanyCode,
  glaccount.ChartOfAccounts AS ChartOfAccount,
  glgroup.SUMGroupping AS SUMGroupping,
  glgroup.SUMTerm AS SUMTerm,
  glgroup.bukrs AS Map_CompanyCode,
  glgroup.ktopl AS Map_ChartOfAccount,
  glgroup.exclude AS exclude,
  cast(3 as abap.int4) AS priority
FROM I_GLAccount AS glaccount
INNER JOIN Fclm_Glgroup AS glgroup ON /* join condition not captured in parsed metadata */
;

Learn More