gle_adb_kfc_calculation

DDL: GLE_ADB_KFC_CALCULATION SQL: GLE_ADB_KFC_CALC Type: view

Average Daily Balances - Calculation

gle_adb_kfc_calculation is a CDS View that provides data about "Average Daily Balances - Calculation" in SAP S/4HANA. It reads from 5 data sources (gle_tadb_msub, GLE_ADB_KFC_ARCHIVE, gle_adb_kfc_archive_gen, gle_adb_kfc_avg_sl_gen, gle_adb_kfc_accdoc_item) and exposes 1159 fields.

Data Sources (5)

SourceAliasJoin Type
gle_tadb_msub cust left_outer
GLE_ADB_KFC_ARCHIVE GLE_ADB_KFC_ARCHIVE cross
gle_adb_kfc_archive_gen gle_adb_kfc_archive_gen union_all
gle_adb_kfc_avg_sl_gen gle_adb_kfc_avg_sl_gen union_all
gle_adb_kfc_accdoc_item item from

Parameters (6)

NameTypeDefault
StartOfYear abap.dats
StartOfHalfYear abap.dats
StartOfQuarter abap.dats
StartOfCurrMonth abap.dats
ReportingDate abap.dats
P_ArchiveDataIsIncluded abap_boolean

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName GLE_ADB_KFC_CALC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Average Daily Balances - Calculation view

Fields (1159)

KeyFieldSource TableSource FieldDescription
rldnr rldnr Ledger (Compat.)
rbukrs rbukrs Company Code
gjahr gjahr Settlement Year
belnr belnr SD Document
docln docln Matching Document Line Item
ryear ryear Ref. Year1
docnr_ld docnr_ld Ledger spec. DocNo
rrcty rrcty Record Type
rmvct rmvct Transact. Type
vorgn vorgn Transaction
vrgng vrgng Bus.Transaction
bttype bttype Business Transaction Type
awtyp awtyp Reference Document Type
awsys awsys Logical System
aworg aworg Refer. Org.Unit
awref awref Reference Doc.
awitem awitem Ref. Doc. Line Item
awitgrp awitgrp Ref. Item Group
subta subta Sub Transaction
xreversing xreversing Reversal doc.
xreversed xreversed Reversed
xtruerev xtruerev Is true reversal
awtyp_rev awtyp_rev ReversalRefTran
aworg_rev aworg_rev Reversal Org.
awref_rev awref_rev Reversal Ref.
subta_rev subta_rev Reversal Sub Trans
xsettling xsettling Is Settling
xsettled xsettled Is Settled
prec_awtyp prec_awtyp PrecRefTransact
prec_awsys prec_awsys PrecRefLogSys
prec_aworg prec_aworg PrecRefOrgUnit
prec_awref prec_awref PrecRefDocument
prec_awitem prec_awitem Prec. Ref. Doc. Item
prec_subta prec_subta Sub Transaction
xsecondary xsecondary Secondary entry
src_awtyp src_awtyp Src Doc Type
src_awsys src_awsys Src Doc Sys
src_aworg src_aworg Source Org Unit
src_awref src_awref Source Doc. No.
src_awitem src_awitem Source Doc. LineItem
src_awsubit src_awsubit Source Doc. Subitem
xcommitment xcommitment Commitment
obs_reason obs_reason Obsolete Reason
rco_ocur rco_ocur Object Currency
runit runit Unit/Area
rvunit rvunit Valuation UoM
racct racct GL Account From
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
hvkwrt hvkwrt Value SP LCrcy
psl psl Price Variance
pfsl pfsl Price Var. Fxd
msl msl Stat. KeyFig. Qty
vmsl vmsl Val. quantity
drcrk drcrk Debit/Credit
poper poper Posting periods
periv periv FYear Variant
fiscyearper fiscyearper Period/Year
budat budat Posting Date
bldat bldat Journal Entry Date
blart blart Rep. rec. doc. type
buzei buzei Posting View Item
zuonr zuonr Finance Project
bschl bschl Posting Key
bstat bstat Document Status
linetype linetype Type of line
ktosl ktosl Transaction
slalittype slalittype SLALineItemType
xsplitmod xsplitmod Changed
usnam usnam User Name
timestamp timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
eprctr eprctr Elimination PrCtr
rhoart rhoart Origin object
ktopl ktopl G/L Chart of Accounts
lokkt lokkt Local Acct No.
ktop2 ktop2 Alternative COA
rebzg rebzg Invoice Ref.
rebzj rebzj Fiscal Year
rebzz rebzz Item
rebzt rebzt Follow-On Doc. Type
rbest rbest PO Category
ebeln ebeln Source PurchDoc
ebelp ebelp Item pur. doc.
zekkn zekkn Account Assgmt No.
sgtxt sgtxt Text
kdauf kdauf SD Document
kdpos kdpos Sales Ord. Item
matnr matnr Vehicle Model
werks werks Receiving Plant
lifnr lifnr Vendor no.
kunnr kunnr Stock customer
fbuda fbuda Services Rendered Date
coco_num coco_num Condition Contract
koart koart Account type
umskz umskz Special G/L Ind
mwskz mwskz Tax Code
hbkid hbkid House Bank
hktid hktid House Bank Account
xopvw xopvw OI Management
augdt augdt Clearing
augbl augbl Clrng doc.
auggj auggj Clrg Fiscal Yr
afabe afabe Deprec. Area
anln1 anln1 Asset
anln2 anln2 Sub-number
bzdat bzdat Reference date
anbwa anbwa Trans. type
movcat movcat Trans.Type Cat.
depr_period depr_period Posting Period
anlgr anlgr Group Asset
anlgr2 anlgr2 Subnumber
anlkl anlkl Asset Class
ktogr ktogr Account Determ.
panl1 panl1 Partner Asset
panl2 panl2 Partner Sub-No.
ubzdt_pn ubzdt_pn Orig. Val. Dat
xvabg_pn xvabg_pn Compl.Retiremnt
prozs_pn prozs_pn Percentage Rate
kalnr kalnr ProdCostEst.No.
vprsv vprsv Price control
mlast mlast Price Determ.
kzbws kzbws Valuation
xobew xobew Vendor stk val.
sobkz sobkz Special Stock
vtstamp vtstamp Valu. TimeStamp
mat_kdauf mat_kdauf SD Doc of Inv.
mat_kdpos mat_kdpos SD Item of Inv.
mat_pspnr mat_pspnr WBSElem of Inv.
mat_ps_posid mat_ps_posid WBSElem of Inv.
mat_lifnr mat_lifnr Vendor of Inv.
bwtar bwtar Valuation Type
bwkey bwkey Valuation Area
hpeinh hpeinh Price Unit LC
kpeinh kpeinh Price Unit GC
opeinh opeinh Price Unit AC
vpeinh vpeinh Price Unit 4C
mlptyp mlptyp Orig. proc.cat.
mlcateg mlcateg Category
qsbvalt qsbvalt PrcrmntAlt/proc
qsprocess qsprocess Prod. Proc. No.
perart perart Period Type
mlposnr mlposnr Item
bukrs_sender bukrs_sender Sender CoCode
racct_sender racct_sender Sender GL Account
accas_sender accas_sender Sender Acct Assgmt
objnr objnr Val. Obj. No.
hrkft hrkft Origin group order
hkgrp hkgrp Origin Group
parob1 parob1 Partner Object
parobsrc parobsrc ParObj Source
uspob uspob Source Object
co_belkz co_belkz Dr/Cr ind. CO
co_beknz co_beknz Dr/Cr (Origin)
beltp beltp Debit Type
muvflg muvflg Qty Is Incomplete
gkont gkont Offsetting Acct
gkoar gkoar Offst.Acct Type
erlkz erlkz Status
pernr pernr Personnel no.
paobjnr paobjnr Profit. segment
scope scope Visibility
logsyso logsyso Logical System
pbukrs pbukrs Partner CoCode
pscope pscope PartnerObjClass
logsysp logsysp Logical system
bwstrat bwstrat Val.strategy
objnr_hk objnr_hk Origin object
aufnr_org aufnr_org Origin Order
ukostl ukostl OrigCCtr
ulstar ulstar OrigAct.
uprznr uprznr Sce: BProc.
uprctr uprctr Origin Profit Center
accas accas Account Assignment
lstar lstar Activity Type
aufnr aufnr SettlementOrder
autyp autyp Order category
ps_psp_pnr ps_psp_pnr WBS Element
ps_posid ps_posid WBS Element
ps_prj_pnr ps_prj_pnr Project def.
ps_pspid ps_pspid Project def.
nplnr nplnr Network
nplnr_vorgn nplnr_vorgn Netwk activity
prznr prznr Sender BProc
kstrg kstrg Cost Objects
bemot bemot AcctIndicator
rsrce rsrce Resource
qmnum qmnum Notification
erkrs erkrs Operating concern
paccas paccas Part. Acct Assgmt
plstar plstar ParActvy
paufnr paufnr Partner order
pautyp pautyp Prtnr Ord. Cat.
pps_posid pps_posid Partner WBS Element
pps_pspid pps_pspid Part. Proj. Def
pkdauf pkdauf Partner SalOrd
pkdpos pkdpos Part. SlsOrd Item
ppaobjnr ppaobjnr PartnerPrf.Seg.
pnplnr pnplnr Part. Proj. Network
pnplnr_vorgn pnplnr_vorgn Part.Proj.Ntwk.Acty
pprznr pprznr Part. Bus. Process
pkstrg pkstrg Partner Cost Object
co_zlenr co_zlenr Item
co_belnr co_belnr Document Number
co_buzei co_buzei Posting Row
co_buzei1 co_buzei1 CO PostingRow 1
co_buzei2 co_buzei2 CO PostingRow 2
co_buzei5 co_buzei5 CO PostingRow 5
co_buzei6 co_buzei6 CO PostingRow 6
co_buzei7 co_buzei7 CO PostingRow 7
co_refbz co_refbz Posting Row
co_refbz1 co_refbz1 RefPostRow 1
co_refbz2 co_refbz2 RefPostRow 2
co_refbz5 co_refbz5 RefPostRow 5
co_refbz6 co_refbz6 RefPostRow 6
co_refbz7 co_refbz7 RefPostRow 7
work_item_id work_item_id Work Item ID
arbid arbid WorkCtrGp plan.
vornr vornr Operation
aufps aufps Order item no.
uvorn uvorn Suboperation
equnr equnr Equipment
tplnr tplnr Functional loc.
istru istru Assembly
ilart ilart MaintActivType
plknz plknz OrderPlanInd.
artpr artpr PriorityType
priok priok Priority
maufnr maufnr SuperiorOrder
matkl_mm matkl_mm Material Group
fkart fkart Ship. cost type
vkorg vkorg SD Sales Org.
vtweg vtweg RefDistCh-Cust/Mat.
spart spart Source supplier
matnr_copa matnr_copa Product Sold
matkl matkl Product Sold Group
kdgrp kdgrp Customer group
land1 land1 Trip Ctry/Reg
brsch brsch Industry
bzirk bzirk Sales District
kunre kunre Bill-to Party
kunwe kunwe Ship-to Party
konzs konzs Group
re_bukrs re_bukrs Company Code
re_account re_account Ex/Rv A/c in CL
fikrs fikrs FM Area
fistl fistl Funds Center
measure measure obsolete
rfund rfund Fund
rgrant_nbr rgrant_nbr Grant
rbudget_pd rbudget_pd Rec BudPer
sfund sfund Partner Fund
sgrant_nbr sgrant_nbr Partner Grant
sbudget_pd sbudget_pd Sender BudPer
vname vname Volatility Name
egrup egrup Equity group
recid recid Statistical Key Figure Item
vptnr vptnr Partner
btype btype ProcurementType
etype etype RDS Entity Type
prodper prodper Production Month
billm billm Billing Month
pom pom Proc.Oper.Month
cbrunid cbrunid Cutback Run ID (JVA)
jvactivity jvactivity JVA Activity
pvname pvname Variant
pegrup pegrup Partner EG (JVA)
s_recind s_recind Sender Rec. Ind
cbracct cbracct Cutback Account JVA
cbobjnr cbobjnr Cutback CO (JVA)
swenr swenr Business Entity
sgenr sgenr Building
sgrnr sgrnr Land
smenr smenr Rental Unit
recnnr recnnr Contract No.
snksl snksl Srv. Charge Key
sempsl sempsl Settlement Unit
dabrz dabrz Reference date
pswenr pswenr Ptnr. Bus. Entity
psgenr psgenr Ptnr. Building
psgrnr psgrnr Partner Land
psmenr psmenr Ptnr. Rent. Unit
precnnr precnnr Ptnr. Contract No.
psnksl psnksl Ptnr. Srv. Chrg. Key
psempsl psempsl Ptnr. Sett. Unit
pdabrz pdabrz Ptnr. Reference Date
acrobjtype acrobjtype Accrual Object Type
acrobj_id acrobj_id Accrual Object
acrsobj_id acrsobj_id Accrual Subobject
acritmtype acritmtype Accrual Item Type
fup_action fup_action Follow-up action
mig_source mig_source Migr. Source
mig_docln mig_docln Migr. Line Item ID
_dataaging _dataaging Data Aging
rbunit rbunit Consolidation Unit
rbuptr rbuptr Partner Unit
rcomp rcomp Trading Partner
ritclg ritclg Consolidation COA
ritem ritem Reporting Item
sityp sityp Trip Schedule Type
subit subit Subitem
rtcur rtcur Currency
tsl tsl Trans. Currency
Y2DBal_T tsl Trans. Currency
rhcur rhcur Local Currency
hsl hsl Local Crcy Amt
Y2DBal_H hsl Local Crcy Amt
rkcur rkcur Ledger curr.
ksl ksl GrpCurr
Y2DBal_K ksl GrpCurr
rfccur rfccur Functional Currency
fcsl fcsl Amount in FunctCrcy
Y2DBal_FC fcsl Amount in FunctCrcy
rocur rocur Free Defined Crcy 1
osl osl Other Crcy Amnt
Y2DBal_O osl Other Crcy Amnt
rvcur rvcur Free Defined Crcy 4
vsl vsl Amount in Currency 2
Y2DBal_V vsl Amount in Currency 2
rbcur rbcur Free Defined Crcy 3
bsl bsl Exchange Key
Y2DBal_B bsl Exchange Key
rccur rccur Third Currency
csl csl Amount in Currency 4
Y2DBal_C csl Amount in Currency 4
rdcur rdcur Free Defined Crcy 5
dsl dsl Amount in Currency 5
Y2DBal_D dsl Amount in Currency 5
recur recur Free Defined Crcy 6
esl esl Amount in Currency 6
Y2DBal_E esl Amount in Currency 6
rfcur rfcur Free Defined Crcy 7
fsl fsl Amount in Currency 7
Y2DBal_F fsl Amount in Currency 7
rgcur rgcur Free Defined Crcy 8
gsl gsl Amount in Currency 8
Y2DBal_G gsl Amount in Currency 8
rldnr rldnr Ledger (Compat.)
rbukrs rbukrs Company Code
gjahr gjahr Settlement Year
belnr belnr SD Document
docln docln Matching Document Line Item
ryear ryear Ref. Year1
docnr_ld docnr_ld Ledger spec. DocNo
rrcty rrcty Record Type
rmvct rmvct Transact. Type
vorgn vorgn Transaction
vrgng vrgng Bus.Transaction
bttype bttype Business Transaction Type
awtyp awtyp Reference Document Type
awsys awsys Logical System
aworg aworg Refer. Org.Unit
awref awref Reference Doc.
awitem awitem Ref. Doc. Line Item
awitgrp awitgrp Ref. Item Group
subta subta Sub Transaction
xreversing xreversing Reversal doc.
xreversed xreversed Reversed
xtruerev xtruerev Is true reversal
awtyp_rev awtyp_rev ReversalRefTran
aworg_rev aworg_rev Reversal Org.
awref_rev awref_rev Reversal Ref.
subta_rev subta_rev Reversal Sub Trans
xsettling xsettling Is Settling
xsettled xsettled Is Settled
prec_awtyp prec_awtyp PrecRefTransact
prec_awsys prec_awsys PrecRefLogSys
prec_aworg prec_aworg PrecRefOrgUnit
prec_awref prec_awref PrecRefDocument
prec_awitem prec_awitem Prec. Ref. Doc. Item
prec_subta prec_subta Sub Transaction
xsecondary xsecondary Secondary entry
src_awtyp src_awtyp Src Doc Type
src_awsys src_awsys Src Doc Sys
src_aworg src_aworg Source Org Unit
src_awref src_awref Source Doc. No.
src_awitem src_awitem Source Doc. LineItem
src_awsubit src_awsubit Source Doc. Subitem
xcommitment xcommitment Commitment
obs_reason obs_reason Obsolete Reason
rco_ocur rco_ocur Object Currency
runit runit Unit/Area
rvunit rvunit Valuation UoM
racct racct GL Account From
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
hvkwrt hvkwrt Value SP LCrcy
psl psl Price Variance
pfsl pfsl Price Var. Fxd
msl msl Stat. KeyFig. Qty
vmsl vmsl Val. quantity
drcrk drcrk Debit/Credit
poper poper Posting periods
periv periv FYear Variant
fiscyearper fiscyearper Period/Year
budat budat Posting Date
bldat bldat Journal Entry Date
blart blart Rep. rec. doc. type
buzei buzei Posting View Item
zuonr zuonr Finance Project
bschl bschl Posting Key
bstat bstat Document Status
linetype linetype Type of line
ktosl ktosl Transaction
slalittype slalittype SLALineItemType
xsplitmod xsplitmod Changed
usnam usnam User Name
timestamp timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
eprctr eprctr Elimination PrCtr
rhoart rhoart Origin object
ktopl ktopl G/L Chart of Accounts
lokkt lokkt Local Acct No.
ktop2 ktop2 Alternative COA
rebzg rebzg Invoice Ref.
rebzj rebzj Fiscal Year
rebzz rebzz Item
rebzt rebzt Follow-On Doc. Type
rbest rbest PO Category
ebeln ebeln Source PurchDoc
ebelp ebelp Item pur. doc.
zekkn zekkn Account Assgmt No.
sgtxt sgtxt Text
kdauf kdauf SD Document
kdpos kdpos Sales Ord. Item
matnr matnr Vehicle Model
werks werks Receiving Plant
lifnr lifnr Vendor no.
kunnr kunnr Stock customer
fbuda fbuda Services Rendered Date
coco_num coco_num Condition Contract
koart koart Account type
umskz umskz Special G/L Ind
mwskz mwskz Tax Code
hbkid hbkid House Bank
hktid hktid House Bank Account
xopvw xopvw OI Management
augdt augdt Clearing
augbl augbl Clrng doc.
auggj auggj Clrg Fiscal Yr
afabe afabe Deprec. Area
anln1 anln1 Asset
anln2 anln2 Sub-number
bzdat bzdat Reference date
anbwa anbwa Trans. type
movcat movcat Trans.Type Cat.
depr_period depr_period Posting Period
anlgr anlgr Group Asset
anlgr2 anlgr2 Subnumber
anlkl anlkl Asset Class
ktogr ktogr Account Determ.
panl1 panl1 Partner Asset
panl2 panl2 Partner Sub-No.
ubzdt_pn ubzdt_pn Orig. Val. Dat
xvabg_pn xvabg_pn Compl.Retiremnt
prozs_pn prozs_pn Percentage Rate
kalnr kalnr ProdCostEst.No.
vprsv vprsv Price control
mlast mlast Price Determ.
kzbws kzbws Valuation
xobew xobew Vendor stk val.
sobkz sobkz Special Stock
vtstamp vtstamp Valu. TimeStamp
mat_kdauf mat_kdauf SD Doc of Inv.
mat_kdpos mat_kdpos SD Item of Inv.
mat_pspnr mat_pspnr WBSElem of Inv.
mat_ps_posid mat_ps_posid WBSElem of Inv.
mat_lifnr mat_lifnr Vendor of Inv.
bwtar bwtar Valuation Type
bwkey bwkey Valuation Area
hpeinh hpeinh Price Unit LC
kpeinh kpeinh Price Unit GC
opeinh opeinh Price Unit AC
vpeinh vpeinh Price Unit 4C
mlptyp mlptyp Orig. proc.cat.
mlcateg mlcateg Category
qsbvalt qsbvalt PrcrmntAlt/proc
qsprocess qsprocess Prod. Proc. No.
perart perart Period Type
mlposnr mlposnr Item
bukrs_sender bukrs_sender Sender CoCode
racct_sender racct_sender Sender GL Account
accas_sender accas_sender Sender Acct Assgmt
objnr objnr Val. Obj. No.
hrkft hrkft Origin group order
hkgrp hkgrp Origin Group
parob1 parob1 Partner Object
parobsrc parobsrc ParObj Source
uspob uspob Source Object
co_belkz co_belkz Dr/Cr ind. CO
co_beknz co_beknz Dr/Cr (Origin)
beltp beltp Debit Type
muvflg muvflg Qty Is Incomplete
gkont gkont Offsetting Acct
gkoar gkoar Offst.Acct Type
erlkz erlkz Status
pernr pernr Personnel no.
paobjnr paobjnr Profit. segment
scope scope Visibility
logsyso logsyso Logical System
pbukrs pbukrs Partner CoCode
pscope pscope PartnerObjClass
logsysp logsysp Logical system
bwstrat bwstrat Val.strategy
objnr_hk objnr_hk Origin object
aufnr_org aufnr_org Origin Order
ukostl ukostl OrigCCtr
ulstar ulstar OrigAct.
uprznr uprznr Sce: BProc.
uprctr uprctr Origin Profit Center
accas accas Account Assignment
lstar lstar Activity Type
aufnr aufnr SettlementOrder
autyp autyp Order category
ps_psp_pnr ps_psp_pnr WBS Element
ps_posid ps_posid WBS Element
ps_prj_pnr ps_prj_pnr Project def.
ps_pspid ps_pspid Project def.
nplnr nplnr Network
nplnr_vorgn nplnr_vorgn Netwk activity
prznr prznr Sender BProc
kstrg kstrg Cost Objects
bemot bemot AcctIndicator
rsrce rsrce Resource
qmnum qmnum Notification
erkrs erkrs Operating concern
paccas paccas Part. Acct Assgmt
plstar plstar ParActvy
paufnr paufnr Partner order
pautyp pautyp Prtnr Ord. Cat.
pps_posid pps_posid Partner WBS Element
pps_pspid pps_pspid Part. Proj. Def
pkdauf pkdauf Partner SalOrd
pkdpos pkdpos Part. SlsOrd Item
ppaobjnr ppaobjnr PartnerPrf.Seg.
pnplnr pnplnr Part. Proj. Network
pnplnr_vorgn pnplnr_vorgn Part.Proj.Ntwk.Acty
pprznr pprznr Part. Bus. Process
pkstrg pkstrg Partner Cost Object
co_zlenr co_zlenr Item
co_belnr co_belnr Document Number
co_buzei co_buzei Posting Row
co_buzei1 co_buzei1 CO PostingRow 1
co_buzei2 co_buzei2 CO PostingRow 2
co_buzei5 co_buzei5 CO PostingRow 5
co_buzei6 co_buzei6 CO PostingRow 6
co_buzei7 co_buzei7 CO PostingRow 7
co_refbz co_refbz Posting Row
co_refbz1 co_refbz1 RefPostRow 1
co_refbz2 co_refbz2 RefPostRow 2
co_refbz5 co_refbz5 RefPostRow 5
co_refbz6 co_refbz6 RefPostRow 6
co_refbz7 co_refbz7 RefPostRow 7
work_item_id work_item_id Work Item ID
arbid arbid WorkCtrGp plan.
vornr vornr Operation
aufps aufps Order item no.
uvorn uvorn Suboperation
equnr equnr Equipment
tplnr tplnr Functional loc.
istru istru Assembly
ilart ilart MaintActivType
plknz plknz OrderPlanInd.
artpr artpr PriorityType
priok priok Priority
maufnr maufnr SuperiorOrder
matkl_mm matkl_mm Material Group
fkart fkart Ship. cost type
vkorg vkorg SD Sales Org.
vtweg vtweg RefDistCh-Cust/Mat.
spart spart Source supplier
matnr_copa matnr_copa Product Sold
matkl matkl Product Sold Group
kdgrp kdgrp Customer group
land1 land1 Trip Ctry/Reg
brsch brsch Industry
bzirk bzirk Sales District
kunre kunre Bill-to Party
kunwe kunwe Ship-to Party
konzs konzs Group
re_bukrs re_bukrs Company Code
re_account re_account Ex/Rv A/c in CL
fikrs fikrs FM Area
fistl fistl Funds Center
measure measure obsolete
rfund rfund Fund
rgrant_nbr rgrant_nbr Grant
rbudget_pd rbudget_pd Rec BudPer
sfund sfund Partner Fund
sgrant_nbr sgrant_nbr Partner Grant
sbudget_pd sbudget_pd Sender BudPer
vname vname Volatility Name
egrup egrup Equity group
recid recid Statistical Key Figure Item
vptnr vptnr Partner
btype btype ProcurementType
etype etype RDS Entity Type
prodper prodper Production Month
billm billm Billing Month
pom pom Proc.Oper.Month
cbrunid cbrunid Cutback Run ID (JVA)
jvactivity jvactivity JVA Activity
pvname pvname Variant
pegrup pegrup Partner EG (JVA)
s_recind s_recind Sender Rec. Ind
cbracct cbracct Cutback Account JVA
cbobjnr cbobjnr Cutback CO (JVA)
swenr swenr Business Entity
sgenr sgenr Building
sgrnr sgrnr Land
smenr smenr Rental Unit
recnnr recnnr Contract No.
snksl snksl Srv. Charge Key
sempsl sempsl Settlement Unit
dabrz dabrz Reference date
pswenr pswenr Ptnr. Bus. Entity
psgenr psgenr Ptnr. Building
psgrnr psgrnr Partner Land
psmenr psmenr Ptnr. Rent. Unit
precnnr precnnr Ptnr. Contract No.
psnksl psnksl Ptnr. Srv. Chrg. Key
psempsl psempsl Ptnr. Sett. Unit
pdabrz pdabrz Ptnr. Reference Date
acrobjtype acrobjtype Accrual Object Type
acrobj_id acrobj_id Accrual Object
acrsobj_id acrsobj_id Accrual Subobject
acritmtype acritmtype Accrual Item Type
fup_action fup_action Follow-up action
mig_source mig_source Migr. Source
mig_docln mig_docln Migr. Line Item ID
_dataaging _dataaging Data Aging
rbunit rbunit Consolidation Unit
rbuptr rbuptr Partner Unit
rcomp rcomp Trading Partner
ritclg ritclg Consolidation COA
ritem ritem Reporting Item
sityp sityp Trip Schedule Type
subit subit Subitem
rtcur rtcur Currency
tsl 0 Trans. Currency
PriorDayBal_T 0
CurrDayAct_T 0
PriorMonthBal_T 0
CurrMonthAct_T 0
Y2DBal_T 0 Trans. Currency
M2DAvgBal_T
Q2DAvgBal_T Trans. Currency
HY2DAvgBal_T
Y2DAvgBal_T Trans. Currency
M2DAvgAct_T
Q2DAct_T 0
rhcur rhcur Local Currency
hsl 0 Local Crcy Amt
PriorDayBal_H 0
CurrDayAct_H 0
PriorMonthBal_H 0
CurrMonthAct_H 0
Y2DBal_H 0 Local Crcy Amt
M2DAvgBal_H
Q2DAvgBal_H Local Crcy Amt
HY2DAvgBal_H
Y2DAvgBal_H Local Crcy Amt
M2DAvgAct_H
Q2DAct_H 0
rkcur rkcur Ledger curr.
ksl 0 GrpCurr
PriorDayBal_K 0
CurrDayAct_K 0
PriorMonthBal_K 0
CurrMonthAct_K 0
Y2DBal_K 0 GrpCurr
M2DAvgBal_K
Q2DAvgBal_K GrpCurr
HY2DAvgBal_K
Y2DAvgBal_K GrpCurr
M2DAvgAct_K
Q2DAct_K 0
rfccur rfccur Functional Currency
fcsl 0 Amount in FunctCrcy
PriorDayBal_FC 0
CurrDayAct_FC 0
PriorMonthBal_FC 0
CurrMonthAct_FC 0
Y2DBal_FC 0 Amount in FunctCrcy
M2DAvgBal_FC
Q2DAvgBal_FC Amount in FunctCrcy
HY2DAvgBal_FC
Y2DAvgBal_FC Amount in FunctCrcy
M2DAvgAct_FC
Q2DAct_FC 0
rocur rocur Free Defined Crcy 1
osl 0 Other Crcy Amnt
PriorDayBal_O 0
CurrDayAct_O 0
PriorMonthBal_O 0
CurrMonthAct_O 0
Y2DBal_O 0 Other Crcy Amnt
M2DAvgBal_O
Q2DAvgBal_O Other Crcy Amnt
HY2DAvgBal_O
Y2DAvgBal_O Other Crcy Amnt
M2DAvgAct_O
Q2DAct_O 0
rvcur rvcur Free Defined Crcy 4
vsl 0 Amount in Currency 2
PriorDayBal_V 0
CurrDayAct_V 0
PriorMonthBal_V 0
CurrMonthAct_V 0
Y2DBal_V 0 Amount in Currency 2
M2DAvgBal_V
Q2DAvgBal_V Amount in Currency 2
HY2DAvgBal_V
Y2DAvgBal_V Amount in Currency 2
M2DAvgAct_V
Q2DAct_V 0
rbcur rbcur Free Defined Crcy 3
bsl 0 Exchange Key
PriorDayBal_B 0
CurrDayAct_B 0
PriorMonthBal_B 0
CurrMonthAct_B 0
Y2DBal_B 0 Exchange Key
M2DAvgBal_B
Q2DAvgBal_B Exchange Key
HY2DAvgBal_B
Y2DAvgBal_B Exchange Key
M2DAvgAct_B
Q2DAct_B 0
rccur rccur Third Currency
csl 0 Amount in Currency 4
PriorDayBal_C 0
CurrDayAct_C 0
PriorMonthBal_C 0
CurrMonthAct_C 0
Y2DBal_C 0 Amount in Currency 4
M2DAvgBal_C
Q2DAvgBal_C Amount in Currency 4
HY2DAvgBal_C
Y2DAvgBal_C Amount in Currency 4
M2DAvgAct_C
Q2DAct_C 0
rdcur rdcur Free Defined Crcy 5
dsl 0 Amount in Currency 5
PriorDayBal_D 0
CurrDayAct_D 0
PriorMonthBal_D 0
CurrMonthAct_D 0
Y2DBal_D 0 Amount in Currency 5
M2DAvgBal_D
Q2DAvgBal_D Amount in Currency 5
HY2DAvgBal_D
Y2DAvgBal_D Amount in Currency 5
M2DAvgAct_D
Q2DAct_D 0
recur recur Free Defined Crcy 6
esl 0 Amount in Currency 6
PriorDayBal_E 0
CurrDayAct_E 0
PriorMonthBal_E 0
CurrMonthAct_E 0
Y2DBal_E 0 Amount in Currency 6
M2DAvgBal_E
Q2DAvgBal_E Amount in Currency 6
HY2DAvgBal_E
Y2DAvgBal_E Amount in Currency 6
M2DAvgAct_E
Q2DAct_E 0
rfcur rfcur Free Defined Crcy 7
fsl 0 Amount in Currency 7
PriorDayBal_F 0
CurrDayAct_F 0
PriorMonthBal_F 0
CurrMonthAct_F 0
Y2DBal_F 0 Amount in Currency 7
M2DAvgBal_F
Q2DAvgBal_F Amount in Currency 7
HY2DAvgBal_F
Y2DAvgBal_F Amount in Currency 7
M2DAvgAct_F
Q2DAct_F 0
rgcur rgcur Free Defined Crcy 8
gsl 0 Amount in Currency 8
PriorDayBal_G 0
CurrDayAct_G 0
PriorMonthBal_G 0
CurrMonthAct_G 0
Y2DBal_G 0 Amount in Currency 8
M2DAvgBal_G
Q2DAvgBal_G Amount in Currency 8
HY2DAvgBal_G
Y2DAvgBal_G Amount in Currency 8
M2DAvgAct_G
mandt Editing Client
rldnr rldnr Ledger (Compat.)
rbukrs rbukrs Company Code
gjahr gjahr Settlement Year
belnr belnr SD Document
docln docln Matching Document Line Item
ryear ryear Ref. Year1
docnr_ld docnr_ld Ledger spec. DocNo
rrcty rrcty Record Type
rmvct rmvct Transact. Type
vorgn vorgn Transaction
vrgng vrgng Bus.Transaction
bttype bttype Business Transaction Type
awtyp awtyp Reference Document Type
awsys awsys Logical System
aworg aworg Refer. Org.Unit
awref awref Reference Doc.
awitem awitem Ref. Doc. Line Item
awitgrp awitgrp Ref. Item Group
subta subta Sub Transaction
xreversing xreversing Reversal doc.
xreversed xreversed Reversed
xtruerev xtruerev Is true reversal
awtyp_rev awtyp_rev ReversalRefTran
aworg_rev aworg_rev Reversal Org.
awref_rev awref_rev Reversal Ref.
subta_rev subta_rev Reversal Sub Trans
xsettling xsettling Is Settling
xsettled xsettled Is Settled
prec_awtyp prec_awtyp PrecRefTransact
prec_awsys prec_awsys PrecRefLogSys
prec_aworg prec_aworg PrecRefOrgUnit
prec_awref prec_awref PrecRefDocument
prec_awitem prec_awitem Prec. Ref. Doc. Item
prec_subta prec_subta Sub Transaction
xsecondary xsecondary Secondary entry
src_awtyp src_awtyp Src Doc Type
src_awsys src_awsys Src Doc Sys
src_aworg src_aworg Source Org Unit
src_awref src_awref Source Doc. No.
src_awitem src_awitem Source Doc. LineItem
src_awsubit src_awsubit Source Doc. Subitem
xcommitment xcommitment Commitment
obs_reason obs_reason Obsolete Reason
rco_ocur rco_ocur Object Currency
runit runit Unit/Area
rvunit rvunit Valuation UoM
racct racct GL Account From
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
hvkwrt hvkwrt Value SP LCrcy
psl psl Price Variance
pfsl pfsl Price Var. Fxd
msl msl Stat. KeyFig. Qty
vmsl vmsl Val. quantity
drcrk drcrk Debit/Credit
poper poper Posting periods
periv periv FYear Variant
fiscyearper fiscyearper Period/Year
budat budat Posting Date
bldat bldat Journal Entry Date
blart blart Rep. rec. doc. type
buzei buzei Posting View Item
zuonr zuonr Finance Project
bschl bschl Posting Key
bstat bstat Document Status
linetype linetype Type of line
ktosl ktosl Transaction
slalittype slalittype SLALineItemType
xsplitmod xsplitmod Changed
usnam usnam User Name
timestamp timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
eprctr eprctr Elimination PrCtr
rhoart rhoart Origin object
ktopl ktopl G/L Chart of Accounts
lokkt lokkt Local Acct No.
ktop2 ktop2 Alternative COA
rebzg rebzg Invoice Ref.
rebzj rebzj Fiscal Year
rebzz rebzz Item
rebzt rebzt Follow-On Doc. Type
rbest rbest PO Category
ebeln ebeln Source PurchDoc
ebelp ebelp Item pur. doc.
zekkn zekkn Account Assgmt No.
sgtxt sgtxt Text
kdauf kdauf SD Document
kdpos kdpos Sales Ord. Item
matnr matnr Vehicle Model
werks werks Receiving Plant
lifnr lifnr Vendor no.
kunnr kunnr Stock customer
fbuda fbuda Services Rendered Date
coco_num coco_num Condition Contract
koart koart Account type
umskz umskz Special G/L Ind
mwskz mwskz Tax Code
hbkid hbkid House Bank
hktid hktid House Bank Account
xopvw xopvw OI Management
augdt augdt Clearing
augbl augbl Clrng doc.
auggj auggj Clrg Fiscal Yr
afabe afabe Deprec. Area
anln1 anln1 Asset
anln2 anln2 Sub-number
bzdat bzdat Reference date
anbwa anbwa Trans. type
movcat movcat Trans.Type Cat.
depr_period depr_period Posting Period
anlgr anlgr Group Asset
anlgr2 anlgr2 Subnumber
anlkl anlkl Asset Class
ktogr ktogr Account Determ.
panl1 panl1 Partner Asset
panl2 panl2 Partner Sub-No.
ubzdt_pn ubzdt_pn Orig. Val. Dat
xvabg_pn xvabg_pn Compl.Retiremnt
prozs_pn prozs_pn Percentage Rate
kalnr kalnr ProdCostEst.No.
vprsv vprsv Price control
mlast mlast Price Determ.
kzbws kzbws Valuation
xobew xobew Vendor stk val.
sobkz sobkz Special Stock
vtstamp vtstamp Valu. TimeStamp
mat_kdauf mat_kdauf SD Doc of Inv.
mat_kdpos mat_kdpos SD Item of Inv.
mat_pspnr mat_pspnr WBSElem of Inv.
mat_ps_posid mat_ps_posid WBSElem of Inv.
mat_lifnr mat_lifnr Vendor of Inv.
bwtar bwtar Valuation Type
bwkey bwkey Valuation Area
hpeinh hpeinh Price Unit LC
kpeinh kpeinh Price Unit GC
opeinh opeinh Price Unit AC
vpeinh vpeinh Price Unit 4C
mlptyp mlptyp Orig. proc.cat.
mlcateg mlcateg Category
qsbvalt qsbvalt PrcrmntAlt/proc
qsprocess qsprocess Prod. Proc. No.
perart perart Period Type
mlposnr mlposnr Item
bukrs_sender bukrs_sender Sender CoCode
racct_sender racct_sender Sender GL Account
accas_sender accas_sender Sender Acct Assgmt
objnr objnr Val. Obj. No.
hrkft hrkft Origin group order
hkgrp hkgrp Origin Group
parob1 parob1 Partner Object
parobsrc parobsrc ParObj Source
uspob uspob Source Object
co_belkz co_belkz Dr/Cr ind. CO
co_beknz co_beknz Dr/Cr (Origin)
beltp beltp Debit Type
muvflg muvflg Qty Is Incomplete
gkont gkont Offsetting Acct
gkoar gkoar Offst.Acct Type
erlkz erlkz Status
pernr pernr Personnel no.
paobjnr paobjnr Profit. segment
scope scope Visibility
logsyso logsyso Logical System
pbukrs pbukrs Partner CoCode
pscope pscope PartnerObjClass
logsysp logsysp Logical system
bwstrat bwstrat Val.strategy
objnr_hk objnr_hk Origin object
aufnr_org aufnr_org Origin Order
ukostl ukostl OrigCCtr
ulstar ulstar OrigAct.
uprznr uprznr Sce: BProc.
uprctr uprctr Origin Profit Center
accas accas Account Assignment
lstar lstar Activity Type
aufnr aufnr SettlementOrder
autyp autyp Order category
ps_psp_pnr ps_psp_pnr WBS Element
ps_posid ps_posid WBS Element
ps_prj_pnr ps_prj_pnr Project def.
ps_pspid ps_pspid Project def.
nplnr nplnr Network
nplnr_vorgn nplnr_vorgn Netwk activity
prznr prznr Sender BProc
kstrg kstrg Cost Objects
bemot bemot AcctIndicator
rsrce rsrce Resource
qmnum qmnum Notification
erkrs erkrs Operating concern
paccas paccas Part. Acct Assgmt
plstar plstar ParActvy
paufnr paufnr Partner order
pautyp pautyp Prtnr Ord. Cat.
pps_posid pps_posid Partner WBS Element
pps_pspid pps_pspid Part. Proj. Def
pkdauf pkdauf Partner SalOrd
pkdpos pkdpos Part. SlsOrd Item
ppaobjnr ppaobjnr PartnerPrf.Seg.
pnplnr pnplnr Part. Proj. Network
pnplnr_vorgn pnplnr_vorgn Part.Proj.Ntwk.Acty
pprznr pprznr Part. Bus. Process
pkstrg pkstrg Partner Cost Object
co_zlenr co_zlenr Item
co_belnr co_belnr Document Number
co_buzei co_buzei Posting Row
co_buzei1 co_buzei1 CO PostingRow 1
co_buzei2 co_buzei2 CO PostingRow 2
co_buzei5 co_buzei5 CO PostingRow 5
co_buzei6 co_buzei6 CO PostingRow 6
co_buzei7 co_buzei7 CO PostingRow 7
co_refbz co_refbz Posting Row
co_refbz1 co_refbz1 RefPostRow 1
co_refbz2 co_refbz2 RefPostRow 2
co_refbz5 co_refbz5 RefPostRow 5
co_refbz6 co_refbz6 RefPostRow 6
co_refbz7 co_refbz7 RefPostRow 7
work_item_id work_item_id Work Item ID
arbid arbid WorkCtrGp plan.
vornr vornr Operation
aufps aufps Order item no.
uvorn uvorn Suboperation
equnr equnr Equipment
tplnr tplnr Functional loc.
istru istru Assembly
ilart ilart MaintActivType
plknz plknz OrderPlanInd.
artpr artpr PriorityType
priok priok Priority
maufnr maufnr SuperiorOrder
matkl_mm matkl_mm Material Group
fkart fkart Ship. cost type
vkorg vkorg SD Sales Org.
vtweg vtweg RefDistCh-Cust/Mat.
spart spart Source supplier
matnr_copa matnr_copa Product Sold
matkl matkl Product Sold Group
kdgrp kdgrp Customer group
land1 land1 Trip Ctry/Reg
brsch brsch Industry
bzirk bzirk Sales District
kunre kunre Bill-to Party
kunwe kunwe Ship-to Party
konzs konzs Group
re_bukrs re_bukrs Company Code
re_account re_account Ex/Rv A/c in CL
fikrs fikrs FM Area
fistl fistl Funds Center
measure measure obsolete
rfund rfund Fund
rgrant_nbr rgrant_nbr Grant
rbudget_pd rbudget_pd Rec BudPer
sfund sfund Partner Fund
sgrant_nbr sgrant_nbr Partner Grant
sbudget_pd sbudget_pd Sender BudPer
vname vname Volatility Name
egrup egrup Equity group
recid recid Statistical Key Figure Item
vptnr vptnr Partner
btype btype ProcurementType
etype etype RDS Entity Type
prodper prodper Production Month
billm billm Billing Month
pom pom Proc.Oper.Month
cbrunid cbrunid Cutback Run ID (JVA)
jvactivity jvactivity JVA Activity
pvname pvname Variant
pegrup pegrup Partner EG (JVA)
s_recind s_recind Sender Rec. Ind
cbracct cbracct Cutback Account JVA
cbobjnr cbobjnr Cutback CO (JVA)
swenr swenr Business Entity
sgenr sgenr Building
sgrnr sgrnr Land
smenr smenr Rental Unit
recnnr recnnr Contract No.
snksl snksl Srv. Charge Key
sempsl sempsl Settlement Unit
dabrz dabrz Reference date
pswenr pswenr Ptnr. Bus. Entity
psgenr psgenr Ptnr. Building
psgrnr psgrnr Partner Land
psmenr psmenr Ptnr. Rent. Unit
precnnr precnnr Ptnr. Contract No.
psnksl psnksl Ptnr. Srv. Chrg. Key
psempsl psempsl Ptnr. Sett. Unit
pdabrz pdabrz Ptnr. Reference Date
acrobjtype acrobjtype Accrual Object Type
acrobj_id acrobj_id Accrual Object
acrsobj_id acrsobj_id Accrual Subobject
acritmtype acritmtype Accrual Item Type
fup_action fup_action Follow-up action
mig_source mig_source Migr. Source
mig_docln mig_docln Migr. Line Item ID
_dataaging _dataaging Data Aging
rbunit rbunit Consolidation Unit
rbuptr rbuptr Partner Unit
rcomp rcomp Trading Partner
ritclg ritclg Consolidation COA
ritem ritem Reporting Item
sityp sityp Trip Schedule Type
subit subit Subitem
rtcur rtcur Currency
tsl tsl Trans. Currency
Y2DBal_T tsl Trans. Currency
rhcur rhcur Local Currency
hsl hsl Local Crcy Amt
Y2DBal_H hsl Local Crcy Amt
rkcur rkcur Ledger curr.
ksl ksl GrpCurr
Y2DBal_K ksl GrpCurr
rfccur rfccur Functional Currency
fcsl fcsl Amount in FunctCrcy
Y2DBal_FC fcsl Amount in FunctCrcy
rocur rocur Free Defined Crcy 1
osl osl Other Crcy Amnt
Y2DBal_O osl Other Crcy Amnt
rvcur rvcur Free Defined Crcy 4
vsl vsl Amount in Currency 2
Y2DBal_V vsl Amount in Currency 2
rbcur rbcur Free Defined Crcy 3
bsl bsl Exchange Key
Y2DBal_B bsl Exchange Key
rccur rccur Third Currency
csl csl Amount in Currency 4
Y2DBal_C csl Amount in Currency 4
rdcur rdcur Free Defined Crcy 5
dsl dsl Amount in Currency 5
Y2DBal_D dsl Amount in Currency 5
recur recur Free Defined Crcy 6
esl esl Amount in Currency 6
Y2DBal_E esl Amount in Currency 6
rfcur rfcur Free Defined Crcy 7
fsl fsl Amount in Currency 7
Y2DBal_F fsl Amount in Currency 7
rgcur rgcur Free Defined Crcy 8
gsl gsl Amount in Currency 8
Y2DBal_G gsl Amount in Currency 8
mandt gle_adb_kfc_accdoc_item mandt Editing Client

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 gle_adb_kfc_calculation.
-- 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: GLE_ADB_KFC_CALC
-- Parameters: StartOfYear : abap.dats, StartOfHalfYear : abap.dats, StartOfQuarter : abap.dats, StartOfCurrMonth : abap.dats, ReportingDate : abap.dats, P_ArchiveDataIsIncluded : abap_boolean

CREATE VIEW gle_adb_kfc_calculation AS
SELECT
  rldnr,
  rbukrs,
  gjahr,
  belnr,
  docln,
  ryear,
  docnr_ld,
  rrcty,
  rmvct,
  vorgn,
  vrgng,
  bttype,
  awtyp,
  awsys,
  aworg,
  awref,
  awitem,
  awitgrp,
  subta,
  xreversing,
  xreversed,
  xtruerev,
  awtyp_rev,
  aworg_rev,
  awref_rev,
  subta_rev,
  xsettling,
  xsettled,
  prec_awtyp,
  prec_awsys,
  prec_aworg,
  prec_awref,
  prec_awitem,
  prec_subta,
  xsecondary,
  src_awtyp,
  src_awsys,
  src_aworg,
  src_awref,
  src_awitem,
  src_awsubit,
  xcommitment,
  obs_reason,
  rco_ocur,
  runit,
  rvunit,
  racct,
  rcntr,
  prctr,
  rfarea,
  rbusa,
  kokrs,
  segment,
  scntr,
  pprctr,
  sfarea,
  sbusa,
  rassc,
  psegment,
  hvkwrt,
  psl,
  pfsl,
  msl,
  vmsl,
  drcrk,
  poper,
  periv,
  fiscyearper,
  budat,
  bldat,
  blart,
  buzei,
  zuonr,
  bschl,
  bstat,
  linetype,
  ktosl,
  slalittype,
  xsplitmod,
  usnam,
  timestamp,
  eprctr,
  rhoart,
  ktopl,
  lokkt,
  ktop2,
  rebzg,
  rebzj,
  rebzz,
  rebzt,
  rbest,
  ebeln,
  ebelp,
  zekkn,
  sgtxt,
  kdauf,
  kdpos,
  matnr,
  werks,
  lifnr,
  kunnr,
  fbuda,
  coco_num,
  koart,
  umskz,
  mwskz,
  hbkid,
  hktid,
  xopvw,
  augdt,
  augbl,
  auggj,
  afabe,
  anln1,
  anln2,
  bzdat,
  anbwa,
  movcat,
  depr_period,
  anlgr,
  anlgr2,
  anlkl,
  ktogr,
  panl1,
  panl2,
  ubzdt_pn,
  xvabg_pn,
  prozs_pn,
  kalnr,
  vprsv,
  mlast,
  kzbws,
  xobew,
  sobkz,
  vtstamp,
  mat_kdauf,
  mat_kdpos,
  mat_pspnr,
  mat_ps_posid,
  mat_lifnr,
  bwtar,
  bwkey,
  hpeinh,
  kpeinh,
  opeinh,
  vpeinh,
  mlptyp,
  mlcateg,
  qsbvalt,
  qsprocess,
  perart,
  mlposnr,
  bukrs_sender,
  racct_sender,
  accas_sender,
  objnr,
  hrkft,
  hkgrp,
  parob1,
  parobsrc,
  uspob,
  co_belkz,
  co_beknz,
  beltp,
  muvflg,
  gkont,
  gkoar,
  erlkz,
  pernr,
  paobjnr,
  scope,
  logsyso,
  pbukrs,
  pscope,
  logsysp,
  bwstrat,
  objnr_hk,
  aufnr_org,
  ukostl,
  ulstar,
  uprznr,
  uprctr,
  accas,
  lstar,
  aufnr,
  autyp,
  ps_psp_pnr,
  ps_posid,
  ps_prj_pnr,
  ps_pspid,
  nplnr,
  nplnr_vorgn,
  prznr,
  kstrg,
  bemot,
  rsrce,
  qmnum,
  erkrs,
  paccas,
  plstar,
  paufnr,
  pautyp,
  pps_posid,
  pps_pspid,
  pkdauf,
  pkdpos,
  ppaobjnr,
  pnplnr,
  pnplnr_vorgn,
  pprznr,
  pkstrg,
  co_zlenr,
  co_belnr,
  co_buzei,
  co_buzei1,
  co_buzei2,
  co_buzei5,
  co_buzei6,
  co_buzei7,
  co_refbz,
  co_refbz1,
  co_refbz2,
  co_refbz5,
  co_refbz6,
  co_refbz7,
  work_item_id,
  arbid,
  vornr,
  aufps,
  uvorn,
  equnr,
  tplnr,
  istru,
  ilart,
  plknz,
  artpr,
  priok,
  maufnr,
  matkl_mm,
  fkart,
  vkorg,
  vtweg,
  spart,
  matnr_copa,
  matkl,
  kdgrp,
  land1,
  brsch,
  bzirk,
  kunre,
  kunwe,
  konzs,
  re_bukrs,
  re_account,
  fikrs,
  fistl,
  measure,
  rfund,
  rgrant_nbr,
  rbudget_pd,
  sfund,
  sgrant_nbr,
  sbudget_pd,
  vname,
  egrup,
  recid,
  vptnr,
  btype,
  etype,
  prodper,
  billm,
  pom,
  cbrunid,
  jvactivity,
  pvname,
  pegrup,
  s_recind,
  cbracct,
  cbobjnr,
  swenr,
  sgenr,
  sgrnr,
  smenr,
  recnnr,
  snksl,
  sempsl,
  dabrz,
  pswenr,
  psgenr,
  psgrnr,
  psmenr,
  precnnr,
  psnksl,
  psempsl,
  pdabrz,
  acrobjtype,
  acrobj_id,
  acrsobj_id,
  acritmtype,
  fup_action,
  mig_source,
  mig_docln,
  rbunit,
  rbuptr,
  rcomp,
  ritclg,
  ritem,
  sityp,
  subit,
  rtcur,
  tsl,
  tsl AS Y2DBal_T,
  rhcur,
  hsl,
  hsl AS Y2DBal_H,
  rkcur,
  ksl,
  ksl AS Y2DBal_K,
  rfccur,
  fcsl,
  fcsl AS Y2DBal_FC,
  rocur,
  osl,
  osl AS Y2DBal_O,
  rvcur,
  vsl,
  vsl AS Y2DBal_V,
  rbcur,
  bsl,
  bsl AS Y2DBal_B,
  rccur,
  csl,
  csl AS Y2DBal_C,
  rdcur,
  dsl,
  dsl AS Y2DBal_D,
  recur,
  esl,
  esl AS Y2DBal_E,
  rfcur,
  fsl,
  fsl AS Y2DBal_F,
  rgcur,
  gsl,
  gsl AS Y2DBal_G,
  0 AS PriorDayBal_T,
  0 AS CurrDayAct_T,
  0 AS PriorMonthBal_T,
  0 AS CurrMonthAct_T,
  case when budat >= :StartOfCurrMonth then tsl else 0 end AS M2DAvgBal_T,
  case when budat >= :StartOfQuarter then case when period_end_date < :ReportingDate then division(( cast( tsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) else division(( cast( tsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) end else 0 end AS Q2DAvgBal_T,
  case when budat >= :StartOfHalfYear then tsl else 0 end AS HY2DAvgBal_T,
  case when budat >= :StartOfYear then case when period_end_date < :ReportingDate then division(( cast( tsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) else division(( cast( tsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) end when budat < '00000000' then tsl else 0 end AS Y2DAvgBal_T,
  case when budat >= :StartOfCurrMonth then tsl else 0 end AS M2DAvgAct_T,
  0 AS Q2DAct_T,
  0 AS PriorDayBal_H,
  0 AS CurrDayAct_H,
  0 AS PriorMonthBal_H,
  0 AS CurrMonthAct_H,
  case when budat >= :StartOfCurrMonth then hsl else 0 end AS M2DAvgBal_H,
  case when budat >= :StartOfQuarter then case when period_end_date < :ReportingDate then division(( cast( hsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) else division(( cast( hsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) end else 0 end AS Q2DAvgBal_H,
  case when budat >= :StartOfHalfYear then hsl else 0 end AS HY2DAvgBal_H,
  case when budat >= :StartOfYear then case when period_end_date < :ReportingDate then division(( cast( hsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) else division(( cast( hsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) end when budat < '00000000' then hsl else 0 end AS Y2DAvgBal_H,
  case when budat >= :StartOfCurrMonth then hsl else 0 end AS M2DAvgAct_H,
  0 AS Q2DAct_H,
  0 AS PriorDayBal_K,
  0 AS CurrDayAct_K,
  0 AS PriorMonthBal_K,
  0 AS CurrMonthAct_K,
  case when budat >= :StartOfCurrMonth then ksl else 0 end AS M2DAvgBal_K,
  case when budat >= :StartOfQuarter then case when period_end_date < :ReportingDate then division(( cast( ksl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) else division(( cast( ksl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) end else 0 end AS Q2DAvgBal_K,
  case when budat >= :StartOfHalfYear then ksl else 0 end AS HY2DAvgBal_K,
  case when budat >= :StartOfYear then case when period_end_date < :ReportingDate then division(( cast( ksl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) else division(( cast( ksl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) end when budat < '00000000' then ksl else 0 end AS Y2DAvgBal_K,
  case when budat >= :StartOfCurrMonth then ksl else 0 end AS M2DAvgAct_K,
  0 AS Q2DAct_K,
  0 AS PriorDayBal_FC,
  0 AS CurrDayAct_FC,
  0 AS PriorMonthBal_FC,
  0 AS CurrMonthAct_FC,
  case when budat >= :StartOfCurrMonth then fcsl else 0 end AS M2DAvgBal_FC,
  case when budat >= :StartOfQuarter then case when period_end_date < :ReportingDate then division(( cast( fcsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) else division(( cast( fcsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) end else 0 end AS Q2DAvgBal_FC,
  case when budat >= :StartOfHalfYear then fcsl else 0 end AS HY2DAvgBal_FC,
  case when budat >= :StartOfYear then case when period_end_date < :ReportingDate then division(( cast( fcsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) else division(( cast( fcsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) end when budat < '00000000' then fcsl else 0 end AS Y2DAvgBal_FC,
  case when budat >= :StartOfCurrMonth then fcsl else 0 end AS M2DAvgAct_FC,
  0 AS Q2DAct_FC,
  0 AS PriorDayBal_O,
  0 AS CurrDayAct_O,
  0 AS PriorMonthBal_O,
  0 AS CurrMonthAct_O,
  case when budat >= :StartOfCurrMonth then osl else 0 end AS M2DAvgBal_O,
  case when budat >= :StartOfQuarter then case when period_end_date < :ReportingDate then division(( cast( osl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) else division(( cast( osl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) end else 0 end AS Q2DAvgBal_O,
  case when budat >= :StartOfHalfYear then osl else 0 end AS HY2DAvgBal_O,
  case when budat >= :StartOfYear then case when period_end_date < :ReportingDate then division(( cast( osl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) else division(( cast( osl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) end when budat < '00000000' then osl else 0 end AS Y2DAvgBal_O,
  case when budat >= :StartOfCurrMonth then osl else 0 end AS M2DAvgAct_O,
  0 AS Q2DAct_O,
  0 AS PriorDayBal_V,
  0 AS CurrDayAct_V,
  0 AS PriorMonthBal_V,
  0 AS CurrMonthAct_V,
  case when budat >= :StartOfCurrMonth then vsl else 0 end AS M2DAvgBal_V,
  case when budat >= :StartOfQuarter then case when period_end_date < :ReportingDate then division(( cast( vsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) else division(( cast( vsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) end else 0 end AS Q2DAvgBal_V,
  case when budat >= :StartOfHalfYear then vsl else 0 end AS HY2DAvgBal_V,
  case when budat >= :StartOfYear then case when period_end_date < :ReportingDate then division(( cast( vsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) else division(( cast( vsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) end when budat < '00000000' then vsl else 0 end AS Y2DAvgBal_V,
  case when budat >= :StartOfCurrMonth then vsl else 0 end AS M2DAvgAct_V,
  0 AS Q2DAct_V,
  0 AS PriorDayBal_B,
  0 AS CurrDayAct_B,
  0 AS PriorMonthBal_B,
  0 AS CurrMonthAct_B,
  case when budat >= :StartOfCurrMonth then bsl else 0 end AS M2DAvgBal_B,
  case when budat >= :StartOfQuarter then case when period_end_date < :ReportingDate then division(( cast( bsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) else division(( cast( bsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) end else 0 end AS Q2DAvgBal_B,
  case when budat >= :StartOfHalfYear then bsl else 0 end AS HY2DAvgBal_B,
  case when budat >= :StartOfYear then case when period_end_date < :ReportingDate then division(( cast( bsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) else division(( cast( bsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) end when budat < '00000000' then bsl else 0 end AS Y2DAvgBal_B,
  case when budat >= :StartOfCurrMonth then bsl else 0 end AS M2DAvgAct_B,
  0 AS Q2DAct_B,
  0 AS PriorDayBal_C,
  0 AS CurrDayAct_C,
  0 AS PriorMonthBal_C,
  0 AS CurrMonthAct_C,
  case when budat >= :StartOfCurrMonth then csl else 0 end AS M2DAvgBal_C,
  case when budat >= :StartOfQuarter then case when period_end_date < :ReportingDate then division(( cast( csl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) else division(( cast( csl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) end else 0 end AS Q2DAvgBal_C,
  case when budat >= :StartOfHalfYear then csl else 0 end AS HY2DAvgBal_C,
  case when budat >= :StartOfYear then case when period_end_date < :ReportingDate then division(( cast( csl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) else division(( cast( csl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) end when budat < '00000000' then csl else 0 end AS Y2DAvgBal_C,
  case when budat >= :StartOfCurrMonth then csl else 0 end AS M2DAvgAct_C,
  0 AS Q2DAct_C,
  0 AS PriorDayBal_D,
  0 AS CurrDayAct_D,
  0 AS PriorMonthBal_D,
  0 AS CurrMonthAct_D,
  case when budat >= :StartOfCurrMonth then dsl else 0 end AS M2DAvgBal_D,
  case when budat >= :StartOfQuarter then case when period_end_date < :ReportingDate then division(( cast( dsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) else division(( cast( dsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) end else 0 end AS Q2DAvgBal_D,
  case when budat >= :StartOfHalfYear then dsl else 0 end AS HY2DAvgBal_D,
  case when budat >= :StartOfYear then case when period_end_date < :ReportingDate then division(( cast( dsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) else division(( cast( dsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) end when budat < '00000000' then dsl else 0 end AS Y2DAvgBal_D,
  case when budat >= :StartOfCurrMonth then dsl else 0 end AS M2DAvgAct_D,
  0 AS Q2DAct_D,
  0 AS PriorDayBal_E,
  0 AS CurrDayAct_E,
  0 AS PriorMonthBal_E,
  0 AS CurrMonthAct_E,
  case when budat >= :StartOfCurrMonth then esl else 0 end AS M2DAvgBal_E,
  case when budat >= :StartOfQuarter then case when period_end_date < :ReportingDate then division(( cast( esl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) else division(( cast( esl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) end else 0 end AS Q2DAvgBal_E,
  case when budat >= :StartOfHalfYear then esl else 0 end AS HY2DAvgBal_E,
  case when budat >= :StartOfYear then case when period_end_date < :ReportingDate then division(( cast( esl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) else division(( cast( esl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) end when budat < '00000000' then esl else 0 end AS Y2DAvgBal_E,
  case when budat >= :StartOfCurrMonth then esl else 0 end AS M2DAvgAct_E,
  0 AS Q2DAct_E,
  0 AS PriorDayBal_F,
  0 AS CurrDayAct_F,
  0 AS PriorMonthBal_F,
  0 AS CurrMonthAct_F,
  case when budat >= :StartOfCurrMonth then fsl else 0 end AS M2DAvgBal_F,
  case when budat >= :StartOfQuarter then case when period_end_date < :ReportingDate then division(( cast( fsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) else division(( cast( fsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) end else 0 end AS Q2DAvgBal_F,
  case when budat >= :StartOfHalfYear then fsl else 0 end AS HY2DAvgBal_F,
  case when budat >= :StartOfYear then case when period_end_date < :ReportingDate then division(( cast( fsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) else division(( cast( fsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) end when budat < '00000000' then fsl else 0 end AS Y2DAvgBal_F,
  case when budat >= :StartOfCurrMonth then fsl else 0 end AS M2DAvgAct_F,
  0 AS Q2DAct_F,
  0 AS PriorDayBal_G,
  0 AS CurrDayAct_G,
  0 AS PriorMonthBal_G,
  0 AS CurrMonthAct_G,
  case when budat >= :StartOfCurrMonth then gsl else 0 end AS M2DAvgBal_G,
  case when budat >= :StartOfQuarter then case when period_end_date < :ReportingDate then division(( cast( gsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) else division(( cast( gsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfQuarter, :ReportingDate ) ), 6 ) end else 0 end AS Q2DAvgBal_G,
  case when budat >= :StartOfHalfYear then gsl else 0 end AS HY2DAvgBal_G,
  case when budat >= :StartOfYear then case when period_end_date < :ReportingDate then division(( cast( gsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, period_end_date ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) else division(( cast( gsl as abap.dec( 27, 6 ) ) *( 1 + dats_days_between( budat, :ReportingDate ) ) ),( 1 + dats_days_between( :StartOfYear, :ReportingDate ) ), 6 ) end when budat < '00000000' then gsl else 0 end AS Y2DAvgBal_G,
  case when budat >= :StartOfCurrMonth then gsl else 0 end AS M2DAvgAct_G,
  0 as Q2DAct_G AS mandt
FROM gle_adb_kfc_accdoc_item AS item
LEFT OUTER JOIN gle_tadb_msub AS cust ON /* join condition not captured in parsed metadata */
CROSS JOIN GLE_ADB_KFC_ARCHIVE
-- UNION ALL with additional select branch(es): gle_adb_kfc_avg_sl_gen, gle_adb_kfc_archive_gen
;