FGL_GLSI_C

DDL: FGL_GLSI_C SQL: FGLV_GLSI_C Type: view Package: FAGL_DB_PERSISTENCY
48 Fields 1 Data Sources

Compat. view for cust.-spec. G/L line items (template)

FGL_GLSI_C is a CDS View that provides data about "Compat. view for cust.-spec. G/L line items (template)" in SAP S/4HANA. It reads from 1 data source (FGL_GLSI) and exposes 48 fields. Part of development package FAGL_DB_PERSISTENCY.

Data Sources (1)

SourceAliasJoin Type
FGL_GLSI FGL_GLSI from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FGLV_GLSI_C view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Compat. view for cust.-spec. G/L line items (template) view

Fields (48)

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

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

CREATE VIEW FGL_GLSI_C 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
FROM FGL_GLSI
;

Learn More