Fclm_GlgroupE

DDL: FCLM_GLGROUPEXCLUDE SQL: FCLMGLGROUPE Type: view Package: FCLM_CP
15 Fields 1 Data Sources

GL account group exclude

Fclm_GlgroupE is a CDS View that provides data about "GL account group exclude" in SAP S/4HANA. It reads from 1 data source (Fclm_Glgroup) and exposes 15 fields. Part of development package FCLM_CP.

Data Sources (1)

SourceAliasJoin Type
Fclm_Glgroup glgroup from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FCLMGLGROUPE 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 GL account group exclude view

Fields (15)

KeyFieldSource TableSource FieldDescription
mandt Fclm_Glgroup mandt Editing Client
SUMGroupping Fclm_Glgroup SUMGroupping Grouping
Linetype Fclm_Glgroup Linetype Type of line
Selection Fclm_Glgroup Selection Selection Proc.
GLFrom Fclm_Glgroup GLFrom
GLTo Fclm_Glgroup GLTo
PlanningLevel Fclm_Glgroup PlanningLevel Planning Level
PLFrom Fclm_Glgroup PLFrom
PLTo Fclm_Glgroup PLTo
bukrs Fclm_Glgroup bukrs Value
ktopl Fclm_Glgroup ktopl G/L Chart of Accounts
exclude Fclm_Glgroup exclude Exclusive
SUMTerm Fclm_Glgroup SUMTerm Sum. Term
ckont Fclm_Glgroup ckont Sum. Acct.
cbukr Fclm_Glgroup cbukr Summariz. CoCd

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 Fclm_GlgroupE.
-- 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: FCLMGLGROUPE

CREATE VIEW Fclm_GlgroupE AS
SELECT
  glgroup.mandt AS mandt,
  glgroup.SUMGroupping AS SUMGroupping,
  glgroup.Linetype AS Linetype,
  glgroup.Selection AS Selection,
  glgroup.GLFrom AS GLFrom,
  glgroup.GLTo AS GLTo,
  glgroup.PlanningLevel AS PlanningLevel,
  glgroup.PLFrom AS PLFrom,
  glgroup.PLTo AS PLTo,
  glgroup.bukrs AS bukrs,
  glgroup.ktopl AS ktopl,
  glgroup.exclude AS exclude,
  glgroup.SUMTerm AS SUMTerm,
  glgroup.ckont AS ckont,
  glgroup.cbukr AS cbukr
FROM Fclm_Glgroup AS glgroup
;

Learn More