What is FGL_GLTT1 in SAP S/4HANA?

FGL_GLTT1 is a cds CDS view in SAP S/4HANA. G/L totals: create the period block It contains 129 fields.

Which tables does FGL_GLTT1 read from?

FGL_GLTT1 reads data from: FGL_GLTT0.

FGL_GLTT1

DDL: FGL_GLTT1 SQL: FGLV_GLTT1 Type: view

129 Fields 1 Data Sources

G/L totals: create the period block

FGL_GLTT1 is a CDS View that provides data about "G/L totals: create the period block" in SAP S/4HANA. It reads from 1 data source (FGL_GLTT0) and exposes 129 fields.

Data Sources (1)

Source	Alias	Join Type
FGL_GLTT0	FGL_GLTT0	from

Annotations (6)

Name	Value	Level
AbapCatalog.sqlViewName	FGLV_GLTT1	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
EndUserText.label	G/L totals: create the period block	view

Fields (129)

Field	Source Field	Description
rclnt	rclnt	Client
ryear	ryear	Ref. Year1
objnr00	0
objnr01	0
objnr02	0
objnr03	0
objnr04	0
objnr05	0
objnr06	0
objnr07	0
objnr08	0
drcrk	drcrk	Debit/Credit
activ	activ	Transaction
rmvct	rmvct	Transact. Type
rtcur	rtcur	Currency
runit	runit	Unit/Area
awtyp	awtyp	Reference Document Type
rldnr	rldnr	Ledger (Compat.)
rrcty	rrcty	Record Type
rvers	rvers	Version: Tax rt
logsys	logsys	Source system
racct	racct	GL Account From
cost_elem	cost_elem	Cost Element
rbukrs	rbukrs	Company Code
rcntr	rcntr	Cost Center
prctr	prctr	Profit Centers
rfarea	rfarea	R FuncArea
rbusa	rbusa	Business Area
kokrs	kokrs	Org. Value
segment	segment	Segment number
scntr	scntr	Sender Cost Ctr
pprctr	pprctr	Partner PC
sfarea	sfarea	Sender FnArea
sbusa	sbusa	Trdg Part.BA
rassc	rassc	Trading Partner
psegment	psegment	Partner Segment
fikrs	fikrs	FM Area
rfund	rfund	Fund
rgrant_nbr	rgrant_nbr	Grant
rbudget_pd	rbudget_pd	Rec BudPer
sfund	sfund	Partner Fund
sgrant_nbr	sgrant_nbr	Partner Grant
sbudget_pd	sbudget_pd	Sender BudPer
re_bukrs	re_bukrs	Company Code
re_account	re_account	Ex/Rv A/c in CL
vname	vname	Volatility Name
egrup	egrup	Equity group
recid	recid	Statistical Key Figure Item
tslvt
tsl01		Posting periods
tsl02		Posting periods
tsl03		Posting periods
tsl04		Posting periods
tsl05		Posting periods
tsl06		Posting periods
tsl07		Posting periods
tsl08		Posting periods
tsl09		Posting periods
tsl10		Posting periods
tsl11		Posting periods
tsl12		Posting periods
tsl13		Posting periods
tsl14		Posting periods
tsl15		Posting periods
hslvt
hsl01		Posting periods
hsl02		Posting periods
hsl03		Posting periods
hsl04		Posting periods
hsl05		Posting periods
hsl06		Posting periods
hsl07		Posting periods
hsl08		Posting periods
hsl09		Posting periods
hsl10		Posting periods
hsl11		Posting periods
hsl12		Posting periods
hsl13		Posting periods
hsl14		Posting periods
hsl15		Posting periods
kslvt
ksl01		Posting periods
ksl02		Posting periods
ksl03		Posting periods
ksl04		Posting periods
ksl05		Posting periods
ksl06		Posting periods
ksl07		Posting periods
ksl08		Posting periods
ksl09		Posting periods
ksl10		Posting periods
ksl11		Posting periods
ksl12		Posting periods
ksl13		Posting periods
ksl14		Posting periods
ksl15		Posting periods
oslvt
osl01		Posting periods
osl02		Posting periods
osl03		Posting periods
osl04		Posting periods
osl05		Posting periods
osl06		Posting periods
osl07		Posting periods
osl08		Posting periods
osl09		Posting periods
osl10		Posting periods
osl11		Posting periods
osl12		Posting periods
osl13		Posting periods
osl14		Posting periods
osl15		Posting periods
mslvt
msl01		Posting periods
msl02		Posting periods
msl03		Posting periods
msl04		Posting periods
msl05		Posting periods
msl06		Posting periods
msl07		Posting periods
msl08		Posting periods
msl09		Posting periods
msl10		Posting periods
msl11		Posting periods
msl12		Posting periods
msl13		Posting periods
msl14		Posting periods
msl15		Posting periods
timestamp	timestamp	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

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 FGL_GLTT1.
-- 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: FGLV_GLTT1

CREATE VIEW FGL_GLTT1 AS
SELECT
  rclnt,
  ryear,
  0 AS objnr00,
  0 AS objnr01,
  0 AS objnr02,
  0 AS objnr03,
  0 AS objnr04,
  0 AS objnr05,
  0 AS objnr06,
  0 AS objnr07,
  0 AS objnr08,
  drcrk,
  activ,
  rmvct,
  rtcur,
  runit,
  awtyp,
  rldnr,
  rrcty,
  rvers,
  logsys,
  racct,
  cost_elem,
  rbukrs,
  rcntr,
  prctr,
  rfarea,
  rbusa,
  kokrs,
  segment,
  scntr,
  pprctr,
  sfarea,
  sbusa,
  rassc,
  psegment,
  fikrs,
  rfund,
  rgrant_nbr,
  rbudget_pd,
  sfund,
  sgrant_nbr,
  sbudget_pd,
  re_bukrs,
  re_account,
  vname,
  egrup,
  recid,
  case poper when '000' then tsl else 0 end AS tslvt,
  case mod( cast(poper as abap.int4 ), 16) when 1 then tsl else 0 end AS tsl01,
  case mod( cast(poper as abap.int4 ), 16) when 2 then tsl else 0 end AS tsl02,
  case mod( cast(poper as abap.int4 ), 16) when 3 then tsl else 0 end AS tsl03,
  case mod( cast(poper as abap.int4 ), 16) when 4 then tsl else 0 end AS tsl04,
  case mod( cast(poper as abap.int4 ), 16) when 5 then tsl else 0 end AS tsl05,
  case mod( cast(poper as abap.int4 ), 16) when 6 then tsl else 0 end AS tsl06,
  case mod( cast(poper as abap.int4 ), 16) when 7 then tsl else 0 end AS tsl07,
  case mod( cast(poper as abap.int4 ), 16) when 8 then tsl else 0 end AS tsl08,
  case mod( cast(poper as abap.int4 ), 16) when 9 then tsl else 0 end AS tsl09,
  case mod( cast(poper as abap.int4 ), 16) when 10 then tsl else 0 end AS tsl10,
  case mod( cast(poper as abap.int4 ), 16) when 11 then tsl else 0 end AS tsl11,
  case mod( cast(poper as abap.int4 ), 16) when 12 then tsl else 0 end AS tsl12,
  case mod( cast(poper as abap.int4 ), 16) when 13 then tsl else 0 end AS tsl13,
  case mod( cast(poper as abap.int4 ), 16) when 14 then tsl else 0 end AS tsl14,
  case mod( cast(poper as abap.int4 ), 16) when 15 then tsl else 0 end AS tsl15,
  case poper when '000' then hsl else 0 end AS hslvt,
  case mod( cast(poper as abap.int4 ), 16) when 1 then hsl else 0 end AS hsl01,
  case mod( cast(poper as abap.int4 ), 16) when 2 then hsl else 0 end AS hsl02,
  case mod( cast(poper as abap.int4 ), 16) when 3 then hsl else 0 end AS hsl03,
  case mod( cast(poper as abap.int4 ), 16) when 4 then hsl else 0 end AS hsl04,
  case mod( cast(poper as abap.int4 ), 16) when 5 then hsl else 0 end AS hsl05,
  case mod( cast(poper as abap.int4 ), 16) when 6 then hsl else 0 end AS hsl06,
  case mod( cast(poper as abap.int4 ), 16) when 7 then hsl else 0 end AS hsl07,
  case mod( cast(poper as abap.int4 ), 16) when 8 then hsl else 0 end AS hsl08,
  case mod( cast(poper as abap.int4 ), 16) when 9 then hsl else 0 end AS hsl09,
  case mod( cast(poper as abap.int4 ), 16) when 10 then hsl else 0 end AS hsl10,
  case mod( cast(poper as abap.int4 ), 16) when 11 then hsl else 0 end AS hsl11,
  case mod( cast(poper as abap.int4 ), 16) when 12 then hsl else 0 end AS hsl12,
  case mod( cast(poper as abap.int4 ), 16) when 13 then hsl else 0 end AS hsl13,
  case mod( cast(poper as abap.int4 ), 16) when 14 then hsl else 0 end AS hsl14,
  case mod( cast(poper as abap.int4 ), 16) when 15 then hsl else 0 end AS hsl15,
  case poper when '000' then ksl else 0 end AS kslvt,
  case mod( cast(poper as abap.int4 ), 16) when 1 then ksl else 0 end AS ksl01,
  case mod( cast(poper as abap.int4 ), 16) when 2 then ksl else 0 end AS ksl02,
  case mod( cast(poper as abap.int4 ), 16) when 3 then ksl else 0 end AS ksl03,
  case mod( cast(poper as abap.int4 ), 16) when 4 then ksl else 0 end AS ksl04,
  case mod( cast(poper as abap.int4 ), 16) when 5 then ksl else 0 end AS ksl05,
  case mod( cast(poper as abap.int4 ), 16) when 6 then ksl else 0 end AS ksl06,
  case mod( cast(poper as abap.int4 ), 16) when 7 then ksl else 0 end AS ksl07,
  case mod( cast(poper as abap.int4 ), 16) when 8 then ksl else 0 end AS ksl08,
  case mod( cast(poper as abap.int4 ), 16) when 9 then ksl else 0 end AS ksl09,
  case mod( cast(poper as abap.int4 ), 16) when 10 then ksl else 0 end AS ksl10,
  case mod( cast(poper as abap.int4 ), 16) when 11 then ksl else 0 end AS ksl11,
  case mod( cast(poper as abap.int4 ), 16) when 12 then ksl else 0 end AS ksl12,
  case mod( cast(poper as abap.int4 ), 16) when 13 then ksl else 0 end AS ksl13,
  case mod( cast(poper as abap.int4 ), 16) when 14 then ksl else 0 end AS ksl14,
  case mod( cast(poper as abap.int4 ), 16) when 15 then ksl else 0 end AS ksl15,
  case poper when '000' then osl else 0 end AS oslvt,
  case mod( cast(poper as abap.int4 ), 16) when 1 then osl else 0 end AS osl01,
  case mod( cast(poper as abap.int4 ), 16) when 2 then osl else 0 end AS osl02,
  case mod( cast(poper as abap.int4 ), 16) when 3 then osl else 0 end AS osl03,
  case mod( cast(poper as abap.int4 ), 16) when 4 then osl else 0 end AS osl04,
  case mod( cast(poper as abap.int4 ), 16) when 5 then osl else 0 end AS osl05,
  case mod( cast(poper as abap.int4 ), 16) when 6 then osl else 0 end AS osl06,
  case mod( cast(poper as abap.int4 ), 16) when 7 then osl else 0 end AS osl07,
  case mod( cast(poper as abap.int4 ), 16) when 8 then osl else 0 end AS osl08,
  case mod( cast(poper as abap.int4 ), 16) when 9 then osl else 0 end AS osl09,
  case mod( cast(poper as abap.int4 ), 16) when 10 then osl else 0 end AS osl10,
  case mod( cast(poper as abap.int4 ), 16) when 11 then osl else 0 end AS osl11,
  case mod( cast(poper as abap.int4 ), 16) when 12 then osl else 0 end AS osl12,
  case mod( cast(poper as abap.int4 ), 16) when 13 then osl else 0 end AS osl13,
  case mod( cast(poper as abap.int4 ), 16) when 14 then osl else 0 end AS osl14,
  case mod( cast(poper as abap.int4 ), 16) when 15 then osl else 0 end AS osl15,
  case poper when '000' then msl else 0 end AS mslvt,
  case mod( cast(poper as abap.int4 ), 16) when 1 then msl else 0 end AS msl01,
  case mod( cast(poper as abap.int4 ), 16) when 2 then msl else 0 end AS msl02,
  case mod( cast(poper as abap.int4 ), 16) when 3 then msl else 0 end AS msl03,
  case mod( cast(poper as abap.int4 ), 16) when 4 then msl else 0 end AS msl04,
  case mod( cast(poper as abap.int4 ), 16) when 5 then msl else 0 end AS msl05,
  case mod( cast(poper as abap.int4 ), 16) when 6 then msl else 0 end AS msl06,
  case mod( cast(poper as abap.int4 ), 16) when 7 then msl else 0 end AS msl07,
  case mod( cast(poper as abap.int4 ), 16) when 8 then msl else 0 end AS msl08,
  case mod( cast(poper as abap.int4 ), 16) when 9 then msl else 0 end AS msl09,
  case mod( cast(poper as abap.int4 ), 16) when 10 then msl else 0 end AS msl10,
  case mod( cast(poper as abap.int4 ), 16) when 11 then msl else 0 end AS msl11,
  case mod( cast(poper as abap.int4 ), 16) when 12 then msl else 0 end AS msl12,
  case mod( cast(poper as abap.int4 ), 16) when 13 then msl else 0 end AS msl13,
  case mod( cast(poper as abap.int4 ), 16) when 14 then msl else 0 end AS msl14,
  case mod( cast(poper as abap.int4 ), 16) when 15 then msl else 0 end AS msl15,
  timestamp
FROM FGL_GLTT0
;

Depth:

FGL_GLTT1 view

FGL_GLTT0 view

FGL_GLTT2 view