FGL_GLTT_SRC

DDL: FGL_GLTT_SRC SQL: FGLV_GLTT_SRC Type: view

View across G/L TT-tables. Generated on 21.08.2015

FGL_GLTT_SRC is a CDS View that provides data about "View across G/L TT-tables. Generated on 21.08.2015" in SAP S/4HANA. It reads from 2 data sources (faglflext_bck, jvglflext) and exposes 268 fields.

Data Sources (2)

SourceAliasJoin Type
faglflext_bck faglflext_bck from
jvglflext jvglflext union_all

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FGLV_GLTT_SRC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label View across G/L TT-tables. Generated on 21.08.2015 view

Fields (268)

KeyFieldSource TableSource FieldDescription
rclnt rclnt Client
ryear ryear Ref. Year1
objnr00 objnr00 Object number
objnr01 objnr01 Object number
objnr02 objnr02 Object number
objnr03 objnr03 Object number
objnr04 objnr04 Object number
objnr05 objnr05 Object number
objnr06 objnr06 Object number
objnr07 objnr07 Object number
objnr08 objnr08 Object number
drcrk drcrk Debit/Credit
rpmax rpmax Period
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
rfund
rgrant_nbr
rbudget_pd
sfund
sgrant_nbr
sbudget_pd
re_bukrs
re_account
vname Volatility Name
egrup Equity group
recid Statistical Key Figure Item
tslvt tslvt Transactn curr.
tsl01 tsl01 Transactn curr.
tsl02 tsl02 Transactn curr.
tsl03 tsl03 Transactn curr.
tsl04 tsl04 Transactn curr.
tsl05 tsl05 Transactn curr.
tsl06 tsl06 Transactn curr.
tsl07 tsl07 Transactn curr.
tsl08 tsl08 Transactn curr.
tsl09 tsl09 Transactn curr.
tsl10 tsl10 Transactn curr.
tsl11 tsl11 Transactn curr.
tsl12 tsl12 Transactn curr.
tsl13 tsl13 Transactn curr.
tsl14 tsl14 Transactn curr.
tsl15 tsl15 Transactn curr.
tsl16 tsl16 Transactn curr.
hslvt hslvt Local Currency
hsl01 hsl01 Total transactions in the period in local currency (curr 2)
hsl02 hsl02 Total transactions in the period in local currency (curr 2)
hsl03 hsl03 Total transactions in the period in local currency (curr 2)
hsl04 hsl04 Total transactions in the period in local currency (curr 2)
hsl05 hsl05 Total transactions in the period in local currency (curr 2)
hsl06 hsl06 Total transactions in the period in local currency (curr 2)
hsl07 hsl07 Total transactions in the period in local currency (curr 2)
hsl08 hsl08 Total transactions in the period in local currency (curr 2)
hsl09 hsl09 Total transactions in the period in local currency (curr 2)
hsl10 hsl10 Total transactions in the period in local currency (curr 2)
hsl11 hsl11 Total transactions in the period in local currency (curr 2)
hsl12 hsl12 Total transactions in the period in local currency (curr 2)
hsl13 hsl13 Total transactions in the period in local currency (curr 2)
hsl14 hsl14 Total transactions in the period in local currency (curr 2)
hsl15 hsl15 Total transactions in the period in local currency (curr 2)
hsl16 hsl16 Total transactions in the period in local currency (curr 2)
kslvt kslvt Total GC
ksl01 ksl01 Total GC
ksl02 ksl02 Total GC
ksl03 ksl03 Total GC
ksl04 ksl04 Total GC
ksl05 ksl05 Total GC
ksl06 ksl06 Total GC
ksl07 ksl07 Total GC
ksl08 ksl08 Total GC
ksl09 ksl09 Total GC
ksl10 ksl10 Total GC
ksl11 ksl11 Total GC
ksl12 ksl12 Total GC
ksl13 ksl13 Total GC
ksl14 ksl14 Total GC
ksl15 ksl15 Total GC
ksl16 ksl16 Total GC
oslvt oslvt Bal.Carried Fwd
osl01 osl01 Total
osl02 osl02 Total
osl03 osl03 Total
osl04 osl04 Total
osl05 osl05 Total
osl06 osl06 Total
osl07 osl07 Total
osl08 osl08 Total
osl09 osl09 Total
osl10 osl10 Total
osl11 osl11 Total
osl12 osl12 Total
osl13 osl13 Total
osl14 osl14 Total
osl15 osl15 Total
osl16 osl16 Total
mslvt mslvt Qty c/f balance
msl01 msl01 Total Quants
msl02 msl02 Total Quants
msl03 msl03 Total Quants
msl04 msl04 Total Quants
msl05 msl05 Total Quants
msl06 msl06 Total Quants
msl07 msl07 Total Quants
msl08 msl08 Total Quants
msl09 msl09 Total Quants
msl10 msl10 Total Quants
msl11 msl11 Total Quants
msl12 msl12 Total Quants
msl13 msl13 Total Quants
msl14 msl14 Total Quants
msl15 msl15 Total Quants
msl16 msl16 Total Quants
ryear ryear Ref. Year1
objnr00 objnr00 Object number
objnr01 objnr01 Object number
objnr02 objnr02 Object number
objnr03 objnr03 Object number
objnr04 objnr04 Object number
objnr05 objnr05 Object number
objnr06 objnr06 Object number
objnr07 objnr07 Object number
objnr08 objnr08 Object number
drcrk drcrk Debit/Credit
rpmax rpmax Period
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
rfund
rgrant_nbr
rbudget_pd
sfund
sgrant_nbr
sbudget_pd
re_bukrs
re_account
vname vname Volatility Name
egrup egrup Equity group
recid recid Statistical Key Figure Item
tslvt tslvt Transactn curr.
tsl01 tsl01 Transactn curr.
tsl02 tsl02 Transactn curr.
tsl03 tsl03 Transactn curr.
tsl04 tsl04 Transactn curr.
tsl05 tsl05 Transactn curr.
tsl06 tsl06 Transactn curr.
tsl07 tsl07 Transactn curr.
tsl08 tsl08 Transactn curr.
tsl09 tsl09 Transactn curr.
tsl10 tsl10 Transactn curr.
tsl11 tsl11 Transactn curr.
tsl12 tsl12 Transactn curr.
tsl13 tsl13 Transactn curr.
tsl14 tsl14 Transactn curr.
tsl15 tsl15 Transactn curr.
tsl16 tsl16 Transactn curr.
hslvt hslvt Local Currency
hsl01 hsl01 Total transactions in the period in local currency (curr 2)
hsl02 hsl02 Total transactions in the period in local currency (curr 2)
hsl03 hsl03 Total transactions in the period in local currency (curr 2)
hsl04 hsl04 Total transactions in the period in local currency (curr 2)
hsl05 hsl05 Total transactions in the period in local currency (curr 2)
hsl06 hsl06 Total transactions in the period in local currency (curr 2)
hsl07 hsl07 Total transactions in the period in local currency (curr 2)
hsl08 hsl08 Total transactions in the period in local currency (curr 2)
hsl09 hsl09 Total transactions in the period in local currency (curr 2)
hsl10 hsl10 Total transactions in the period in local currency (curr 2)
hsl11 hsl11 Total transactions in the period in local currency (curr 2)
hsl12 hsl12 Total transactions in the period in local currency (curr 2)
hsl13 hsl13 Total transactions in the period in local currency (curr 2)
hsl14 hsl14 Total transactions in the period in local currency (curr 2)
hsl15 hsl15 Total transactions in the period in local currency (curr 2)
hsl16 hsl16 Total transactions in the period in local currency (curr 2)
kslvt kslvt Total GC
ksl01 ksl01 Total GC
ksl02 ksl02 Total GC
ksl03 ksl03 Total GC
ksl04 ksl04 Total GC
ksl05 ksl05 Total GC
ksl06 ksl06 Total GC
ksl07 ksl07 Total GC
ksl08 ksl08 Total GC
ksl09 ksl09 Total GC
ksl10 ksl10 Total GC
ksl11 ksl11 Total GC
ksl12 ksl12 Total GC
ksl13 ksl13 Total GC
ksl14 ksl14 Total GC
ksl15 ksl15 Total GC
ksl16 ksl16 Total GC
oslvt oslvt Bal.Carried Fwd
osl01 osl01 Total
osl02 osl02 Total
osl03 osl03 Total
osl04 osl04 Total
osl05 osl05 Total
osl06 osl06 Total
osl07 osl07 Total
osl08 osl08 Total
osl09 osl09 Total
osl10 osl10 Total
osl11 osl11 Total
osl12 osl12 Total
osl13 osl13 Total
osl14 osl14 Total
osl15 osl15 Total
osl16 osl16 Total
mslvt mslvt Qty c/f balance
msl01 msl01 Total Quants
msl02 msl02 Total Quants
msl03 msl03 Total Quants
msl04 msl04 Total Quants
msl05 msl05 Total Quants
msl06 msl06 Total Quants
msl07 msl07 Total Quants
msl08 msl08 Total Quants
msl09 msl09 Total Quants
msl10 msl10 Total Quants
msl11 msl11 Total Quants
msl12 msl12 Total Quants
msl13 msl13 Total Quants
msl14 msl14 Total Quants
msl15 msl15 Total Quants
msl16 msl16 Total Quants
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_GLTT_SRC.
-- 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_GLTT_SRC

CREATE VIEW FGL_GLTT_SRC AS
SELECT
  rclnt,
  ryear,
  objnr00,
  objnr01,
  objnr02,
  objnr03,
  objnr04,
  objnr05,
  objnr06,
  objnr07,
  objnr08,
  drcrk,
  rpmax,
  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,
  cast('' as abap.char(4)) AS fikrs,
  cast('' as abap.char(10)) AS rfund,
  cast('' as abap.char(20)) AS rgrant_nbr,
  cast('' as abap.char(10)) AS rbudget_pd,
  cast('' as abap.char(10)) AS sfund,
  cast('' as abap.char(20)) AS sgrant_nbr,
  cast('' as abap.char(10)) AS sbudget_pd,
  cast('' as abap.char(4)) AS re_bukrs,
  cast('' as abap.char(10)) AS re_account,
  cast('' as abap.char(6)) AS vname,
  cast('' as abap.char(3)) AS egrup,
  cast('' as abap.char(2)) AS recid,
  tslvt,
  tsl01,
  tsl02,
  tsl03,
  tsl04,
  tsl05,
  tsl06,
  tsl07,
  tsl08,
  tsl09,
  tsl10,
  tsl11,
  tsl12,
  tsl13,
  tsl14,
  tsl15,
  tsl16,
  hslvt,
  hsl01,
  hsl02,
  hsl03,
  hsl04,
  hsl05,
  hsl06,
  hsl07,
  hsl08,
  hsl09,
  hsl10,
  hsl11,
  hsl12,
  hsl13,
  hsl14,
  hsl15,
  hsl16,
  kslvt,
  ksl01,
  ksl02,
  ksl03,
  ksl04,
  ksl05,
  ksl06,
  ksl07,
  ksl08,
  ksl09,
  ksl10,
  ksl11,
  ksl12,
  ksl13,
  ksl14,
  ksl15,
  ksl16,
  oslvt,
  osl01,
  osl02,
  osl03,
  osl04,
  osl05,
  osl06,
  osl07,
  osl08,
  osl09,
  osl10,
  osl11,
  osl12,
  osl13,
  osl14,
  osl15,
  osl16,
  mslvt,
  msl01,
  msl02,
  msl03,
  msl04,
  msl05,
  msl06,
  msl07,
  msl08,
  msl09,
  msl10,
  msl11,
  msl12,
  msl13,
  msl14,
  msl15,
  msl16,
  timestamp
FROM faglflext_bck
-- UNION ALL with additional select branch(es): jvglflext
;