FGL_GLSI_SRC

DDL: FGL_GLSI_SRC SQL: FGLV_GLSI_SRC Type: view

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

FGL_GLSI_SRC is a CDS View that provides data about "View across G/L SI-tables. Generated on 21.08.2015" in SAP S/4HANA. It reads from 2 data sources (faglflexa, jvglflexa) and exposes 118 fields.

Data Sources (2)

SourceAliasJoin Type
faglflexa faglflexa from
jvglflexa jvglflexa union_all

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FGLV_GLSI_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 SI-tables. Generated on 21.08.2015 view

Fields (118)

KeyFieldSource TableSource FieldDescription
rclnt rclnt Client
ryear ryear Ref. Year1
docnr docnr Well doc.no.
rldnr rldnr Ledger (Compat.)
rbukrs rbukrs Company Code
docln docln Matching Document Line Item
activ activ Transaction
rmvct rmvct Transact. Type
rtcur rtcur Currency
runit runit Unit/Area
awtyp awtyp Reference Document Type
rrcty rrcty Record Type
rvers rvers Version: Tax rt
logsys logsys Source system
racct racct GL Account From
cost_elem cost_elem Cost Element
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
tsl tsl Trans. Currency
hsl hsl Local Crcy Amt
ksl ksl GrpCurr
osl osl Other Crcy Amnt
msl msl Stat. KeyFig. Qty
wsl wsl OrigTrnsCrcyAmt
drcrk drcrk Debit/Credit
poper poper Posting periods
rwcur rwcur Transaction Currency
gjahr gjahr Settlement Year
budat budat Posting Date
belnr belnr SD Document
buzei buzei Posting View Item
bschl bschl Posting Key
bstat bstat Document Status
linetype linetype Type of line
xsplitmod xsplitmod Changed
usnam usnam User Name
timestamp timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
_dataaging _dataaging Data Aging
fikrs
rfund
rgrant_nbr
rbudget_pd
sfund
sgrant_nbr
sbudget_pd
re_bukrs
re_account
vname Volatility Name
egrup Equity group
ryear ryear Ref. Year1
docnr docnr Well doc.no.
rldnr rldnr Ledger (Compat.)
rbukrs rbukrs Company Code
docln docln Matching Document Line Item
activ activ Transaction
rmvct rmvct Transact. Type
rtcur rtcur Currency
runit runit Unit/Area
awtyp awtyp Reference Document Type
rrcty rrcty Record Type
rvers rvers Version: Tax rt
logsys logsys Source system
racct racct GL Account From
cost_elem cost_elem Cost Element
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
tsl tsl Trans. Currency
hsl hsl Local Crcy Amt
ksl ksl GrpCurr
osl osl Other Crcy Amnt
msl msl Stat. KeyFig. Qty
wsl wsl OrigTrnsCrcyAmt
drcrk drcrk Debit/Credit
poper poper Posting periods
rwcur rwcur Transaction Currency
gjahr gjahr Settlement Year
budat budat Posting Date
belnr belnr SD Document
buzei buzei Posting View Item
bschl bschl Posting Key
bstat bstat Document Status
linetype linetype Type of line
xsplitmod xsplitmod Changed
usnam usnam User Name
timestamp timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
_dataaging _dataaging Data Aging
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

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_GLSI_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_GLSI_SRC

CREATE VIEW FGL_GLSI_SRC AS
SELECT
  rclnt,
  ryear,
  docnr,
  rldnr,
  rbukrs,
  docln,
  activ,
  rmvct,
  rtcur,
  runit,
  awtyp,
  rrcty,
  rvers,
  logsys,
  racct,
  cost_elem,
  rcntr,
  prctr,
  rfarea,
  rbusa,
  kokrs,
  segment,
  scntr,
  pprctr,
  sfarea,
  sbusa,
  rassc,
  psegment,
  tsl,
  hsl,
  ksl,
  osl,
  msl,
  wsl,
  drcrk,
  poper,
  rwcur,
  gjahr,
  budat,
  belnr,
  buzei,
  bschl,
  bstat,
  linetype,
  xsplitmod,
  usnam,
  timestamp,
  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,
  recid
FROM faglflexa
-- UNION ALL with additional select branch(es): jvglflexa
;