FGL_PSGLFLEXA

DDL: FGL_PSGLFLEXA SQL: FGLV_PSGLFLEXA Type: view
51 Fields 1 Data Sources

Compatibility View for PSGLFLEXA

FGL_PSGLFLEXA is a CDS View that provides data about "Compatibility View for PSGLFLEXA" 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_PSGLFLEXA 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 PSGLFLEXA 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
re_bukrs re_bukrs Company Code
re_account re_account Ex/Rv A/c in CL
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
sbudget_pd sbudget_pd Sender BudPer
rfund rfund Fund
rgrant_nbr rgrant_nbr Grant
rfarea rfarea R FuncArea
rbudget_pd rbudget_pd Rec BudPer
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_PSGLFLEXA.
-- 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_PSGLFLEXA

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

Learn More