Fclm_Glgrouponlyepl

DDL: FCLM_GLGROUPONLYEPL SQL: FCLMGLGROUPEPL Type: view Package: FCLM_CP
15 Fields 1 Data Sources

GL account group only exclude planning level

Fclm_Glgrouponlyepl is a CDS View that provides data about "GL account group only exclude planning level" 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 FCLMGLGROUPEPL 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 only exclude planning level 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_Glgrouponlyepl.
-- 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: FCLMGLGROUPEPL

CREATE VIEW Fclm_Glgrouponlyepl 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