FGL_MIG_ACD

DDL: FGL_MIG_ACD SQL: FGLV_MIG_ACD Type: view Package: FINS_FI_MIG

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. Part of development package FINS_FI_MIG.

2 data source(s) 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
ryear acdoca ryear
drcrk acdoca drcrk
poper acdoca poper
bttype acdoca bttype
rmvct acdoca rmvct
rtcur acdoca rtcur
runit acdoca runit
awtyp acdoca awtyp
rldnr acdoca rldnr
rrcty acdoca rrcty
awsys acdoca awsys
racct acdoca racct
rbukrs acdoca rbukrs
rcntr acdoca rcntr
prctr acdoca prctr
rfarea acdoca rfarea
rbusa acdoca rbusa
kokrs acdoca kokrs
segment acdoca segment
scntr acdoca scntr
pprctr acdoca pprctr
sfarea acdoca sfarea
sbusa acdoca sbusa
rassc acdoca rassc
psegment acdoca psegment
fikrs acdoca fikrs
rfund acdoca rfund
rgrant_nbr acdoca rgrant_nbr
rbudget_pd acdoca rbudget_pd
sfund acdoca sfund
sgrant_nbr acdoca sgrant_nbr
sbudget_pd acdoca sbudget_pd
re_bukrs acdoca re_bukrs
re_account acdoca re_account
vname acdoca vname
egrup acdoca egrup
recid acdoca recid
tsl acdoca tsl
hsl acdoca hsl
ksl acdoca ksl
osl acdoca osl
vsl acdoca vsl
bsl acdoca bsl
csl acdoca csl
dsl acdoca dsl
esl acdoca esl
fsl acdoca fsl
gsl acdoca gsl
msl acdoca msl
wsl acdoca wsl
timestamp acdoca timestamp
mig_source acdoca mig_source 
@AbapCatalog.sqlViewName: 'FGLV_MIG_ACD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@EndUserText.label: 'View of G/L-entities on ACDOCA - generated.'
define view FGL_MIG_ACD
  as select from acdoca       as a
    inner join   finsc_ledger as lr on  lr.mandt       = a.rclnt
                                    and lr.ledger_type = ' '
                                    and lr.rldnr       = a.rldnr
 //<$VJ>

//<$JOINS>

//<$VJ>

{
a.rclnt,
a.ryear,
a.drcrk,
a.poper,
a.bttype,
a.rmvct,
a.rtcur,
a.runit,
a.awtyp,
a.rldnr,
a.rrcty,
a.awsys,
a.racct,
a.rbukrs,
a.rcntr,
a.prctr,
a.rfarea,
a.rbusa,
a.kokrs,
a.segment,
a.scntr,
a.pprctr,
a.sfarea,
a.sbusa,
a.rassc,
a.psegment,
//<$VF>

a.fikrs,
a.rfund,
a.rgrant_nbr,
a.rbudget_pd,
a.sfund,
a.sgrant_nbr,
a.sbudget_pd,
a.re_bukrs,
a.re_account,
a.vname,
a.egrup,
a.recid,
//<$FIELDS>

//<$VF>

a.tsl,
a.hsl,
a.ksl,
a.osl,
a.vsl,
a.bsl,
a.csl,
a.dsl,
a.esl,
a.fsl,
a.gsl,
a.msl,
a.wsl,
a.timestamp,
a.mig_source
}

Learn More