FGL_MIG_ACD

DDL: FGL_MIG_ACD SQL: FGLV_MIG_ACD Type: view
53 Fields 2 Data Sources

View of G/L-entities on ACDOCA - generated.

FGL_MIG_ACD is a CDS View that provides data about "View of G/L-entities on ACDOCA - generated." in SAP S/4HANA. It reads from 2 data sources (acdoca, finsc_ledger) and exposes 53 fields.

Data Sources (2)

SourceAliasJoin Type
acdoca a from
finsc_ledger lr inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FGLV_MIG_ACD 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 of G/L-entities on ACDOCA - generated. view

Fields (53)

KeyFieldSource TableSource FieldDescription
rclnt acdoca rclnt Client
ryear acdoca ryear Ref. Year1
drcrk acdoca drcrk Debit/Credit
poper acdoca poper Posting periods
bttype acdoca bttype Business Transaction Type
rmvct acdoca rmvct Transact. Type
rtcur acdoca rtcur Currency
runit acdoca runit Unit/Area
awtyp acdoca awtyp Reference Document Type
rldnr acdoca rldnr Ledger (Compat.)
rrcty acdoca rrcty Record Type
awsys acdoca awsys Logical System
racct acdoca racct GL Account From
rbukrs acdoca rbukrs Company Code
rcntr acdoca rcntr Cost Center
prctr acdoca prctr Profit Centers
rfarea acdoca rfarea R FuncArea
rbusa acdoca rbusa Business Area
kokrs acdoca kokrs Org. Value
segment acdoca segment Segment number
scntr acdoca scntr Sender Cost Ctr
pprctr acdoca pprctr Partner PC
sfarea acdoca sfarea Sender FnArea
sbusa acdoca sbusa Trdg Part.BA
rassc acdoca rassc Trading Partner
psegment acdoca psegment Partner Segment
fikrs acdoca fikrs FM Area
rfund acdoca rfund Fund
rgrant_nbr acdoca rgrant_nbr Grant
rbudget_pd acdoca rbudget_pd Rec BudPer
sfund acdoca sfund Partner Fund
sgrant_nbr acdoca sgrant_nbr Partner Grant
sbudget_pd acdoca sbudget_pd Sender BudPer
re_bukrs acdoca re_bukrs Company Code
re_account acdoca re_account Ex/Rv A/c in CL
vname acdoca vname Volatility Name
egrup acdoca egrup Equity group
recid acdoca recid Statistical Key Figure Item
tsl acdoca tsl Trans. Currency
hsl acdoca hsl Local Crcy Amt
ksl acdoca ksl GrpCurr
osl acdoca osl Other Crcy Amnt
vsl acdoca vsl Amount in Currency 2
bsl acdoca bsl Exchange Key
csl acdoca csl Amount in Currency 4
dsl acdoca dsl Amount in Currency 5
esl acdoca esl Amount in Currency 6
fsl acdoca fsl Amount in Currency 7
gsl acdoca gsl Amount in Currency 8
msl acdoca msl Stat. KeyFig. Qty
wsl acdoca wsl OrigTrnsCrcyAmt
timestamp acdoca timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
mig_source acdoca mig_source Migr. Source

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

CREATE VIEW FGL_MIG_ACD AS
SELECT
  a.rclnt AS rclnt,
  a.ryear AS ryear,
  a.drcrk AS drcrk,
  a.poper AS poper,
  a.bttype AS bttype,
  a.rmvct AS rmvct,
  a.rtcur AS rtcur,
  a.runit AS runit,
  a.awtyp AS awtyp,
  a.rldnr AS rldnr,
  a.rrcty AS rrcty,
  a.awsys AS awsys,
  a.racct AS racct,
  a.rbukrs AS rbukrs,
  a.rcntr AS rcntr,
  a.prctr AS prctr,
  a.rfarea AS rfarea,
  a.rbusa AS rbusa,
  a.kokrs AS kokrs,
  a.segment AS segment,
  a.scntr AS scntr,
  a.pprctr AS pprctr,
  a.sfarea AS sfarea,
  a.sbusa AS sbusa,
  a.rassc AS rassc,
  a.psegment AS psegment,
  a.fikrs AS fikrs,
  a.rfund AS rfund,
  a.rgrant_nbr AS rgrant_nbr,
  a.rbudget_pd AS rbudget_pd,
  a.sfund AS sfund,
  a.sgrant_nbr AS sgrant_nbr,
  a.sbudget_pd AS sbudget_pd,
  a.re_bukrs AS re_bukrs,
  a.re_account AS re_account,
  a.vname AS vname,
  a.egrup AS egrup,
  a.recid AS recid,
  a.tsl AS tsl,
  a.hsl AS hsl,
  a.ksl AS ksl,
  a.osl AS osl,
  a.vsl AS vsl,
  a.bsl AS bsl,
  a.csl AS csl,
  a.dsl AS dsl,
  a.esl AS esl,
  a.fsl AS fsl,
  a.gsl AS gsl,
  a.msl AS msl,
  a.wsl AS wsl,
  a.timestamp AS timestamp,
  a.mig_source AS mig_source
FROM acdoca AS a
INNER JOIN finsc_ledger AS lr ON /* join condition not captured in parsed metadata */
;

Learn More