FGL_FMGLFLEXA

DDL: FGL_FMGLFLEXA SQL: FGLV_FMGLFLEXA Type: view
47 Fields 1 Data Sources

Compatibility View for FMGLFLEXA

FGL_FMGLFLEXA is a CDS View that provides data about "Compatibility View for FMGLFLEXA" in SAP S/4HANA. It reads from 1 data source (FGL_GLSI) and exposes 47 fields.

Data Sources (1)

SourceAliasJoin Type
FGL_GLSI FGL_GLSI from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FGLV_FMGLFLEXA view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Compatibility View for FMGLFLEXA view

Fields (47)

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
rbusa rbusa Business Area
kokrs kokrs Org. Value
fikrs fikrs FM Area
sfarea sfarea Sender FnArea
sbusa sbusa Trdg Part.BA
rassc rassc Trading Partner
sfund sfund Partner Fund
sgrant_nbr sgrant_nbr Partner Grant
rfund rfund Fund
rgrant_nbr rgrant_nbr Grant
rfarea rfarea R FuncArea
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

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_FMGLFLEXA.
-- 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_FMGLFLEXA

CREATE VIEW FGL_FMGLFLEXA AS
SELECT
  rclnt,
  ryear,
  docnr,
  rldnr,
  rbukrs,
  docln,
  activ,
  rmvct,
  rtcur,
  runit,
  awtyp,
  rrcty,
  rvers,
  logsys,
  racct,
  cost_elem,
  rbusa,
  kokrs,
  fikrs,
  sfarea,
  sbusa,
  rassc,
  sfund,
  sgrant_nbr,
  rfund,
  rgrant_nbr,
  rfarea,
  tsl,
  hsl,
  ksl,
  osl,
  msl,
  wsl,
  drcrk,
  poper,
  rwcur,
  gjahr,
  budat,
  belnr,
  buzei,
  bschl,
  bstat,
  linetype,
  xsplitmod,
  usnam,
  timestamp
FROM FGL_GLSI
;

Learn More