Fclm_Glgroup

DDL: FCLM_GLGROUP SQL: FCLMGLGROUP Type: view
15 Fields 1 Data Sources

GL account group

Fclm_Glgroup is a CDS View that provides data about "GL account group" in SAP S/4HANA. It reads from 1 data source (t038) and exposes 15 fields.

Data Sources (1)

SourceAliasJoin Type
t038 t038 from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FCLMGLGROUP view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
AbapCatalog.compiler.compareFilter true view
EndUserText.label GL account group view

Fields (15)

KeyFieldSource TableSource FieldDescription
mandt t038 mandt Editing Client
SUMGroupping t038 glied Grouping
Linetype t038 zeilt Line Type
Selection t038 selek Selection
GLFrom
GLTo
PlanningLevel t038 selek Selection
PLFrom
PLTo
bukrs t038 bukrs Value
ktopl t038 ktopl G/L Chart of Accounts
exclude t038 exclude Exclusive
SUMTerm t038 textv Sum. Term
ckont t038 ckont Sum. Acct.
cbukr t038 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_Glgroup.
-- 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: FCLMGLGROUP

CREATE VIEW Fclm_Glgroup AS
SELECT
  t038.mandt AS mandt,
  t038.glied AS SUMGroupping,
  t038.zeilt AS Linetype,
  t038.selek AS Selection,
  replace(t038.selek,'+','0') AS GLFrom,
  replace(t038.selek,'+','9') AS GLTo,
  t038.selek AS PlanningLevel,
  replace(t038.selek,'+','0') AS PLFrom,
  replace(t038.selek,'+','z') AS PLTo,
  t038.bukrs AS bukrs,
  t038.ktopl AS ktopl,
  t038.exclude AS exclude,
  t038.textv AS SUMTerm,
  t038.ckont AS ckont,
  t038.cbukr AS cbukr
FROM t038
;

Learn More