FGL_GLTT_SRC
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)
| Source | Alias | Join Type |
|---|---|---|
| faglflext_bck | faglflext_bck | from |
| jvglflext | jvglflext | union_all |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
;
Learn More
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA