FGL_JVGLFLEXA

DDL: FGL_JVGLFLEXA SQL: FGLV_JVGLFLEXA Type: view
51 Fields 1 Data Sources

Compatibility View for JVGLFLEXA

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

Data Sources (1)

SourceAliasJoin Type
FGL_GLSI FGL_GLSI from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FGLV_JVGLFLEXA 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 JVGLFLEXA view

Fields (51)

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
vname vname Volatility Name
egrup egrup Equity group
recid recid Statistical Key Figure Item
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_JVGLFLEXA.
-- 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_JVGLFLEXA

CREATE VIEW FGL_JVGLFLEXA 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,
  vname,
  egrup,
  recid,
  tsl,
  hsl,
  ksl,
  osl,
  msl,
  wsl,
  drcrk,
  poper,
  rwcur,
  gjahr,
  budat,
  belnr,
  buzei,
  bschl,
  bstat,
  linetype,
  xsplitmod,
  usnam,
  timestamp
FROM FGL_GLSI
;

Learn More