FAA_ANLP1
Intern: Verdichten auf SLALITTYPE-Ebene
FAA_ANLP1 is a CDS View in S/4HANA. Intern: Verdichten auf SLALITTYPE-Ebene. It contains 7 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| Faa_Anlp2 | view | from | Intern: Parallele Waehrungen auf AfA-Bereiche mappen |
Fields (7)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | afbnr | afbnr | 1 |
| KEY | anln1 | anln1 | 1 |
| KEY | anln2 | anln2 | 1 |
| KEY | bukrs | bukrs | 1 |
| KEY | gjahr | gjahr | 1 |
| KEY | mandt | mandt | 1 |
| KEY | peraf | peraf | 1 |
@AbapCatalog.sqlViewName: 'FAAV_ANLP1'
@EndUserText.label: 'Intern: Verdichten auf SLALITTYPE-Ebene'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
// this view is just to condense the data on slalittype level
--------------------------------------------------------------
define view Faa_Anlp1
as select from Faa_Rep_Ledger as ldnr
inner join acdoca as adoc
on ldnr.bukrs = adoc.rbukrs
and ldnr.rep_ledger = adoc.rldnr
and ldnr.lead_afabe = adoc.afabe
// and ldnr.xstore = 'X' // NOT FOR ANLP !!!!!!!!!
{ key adoc.rclnt as mandt,
key adoc.rbukrs as bukrs,
key adoc.ryear as gjahr,
key adoc.poper as peraf,
key case when adoc.mig_source = 'A' -- note 2346484
then substring( adoc.subta, 5, 2)
else substring( adoc.awref, 9, 2) end as afbnr,
// key substring( adoc.subta, 5,2 ) as afbnr, -- note 2246616
key adoc.anln1 as anln1,
key adoc.anln2 as anln2,
key adoc.afabe as afaber,
'ADOC' as rctyp,
adoc.slalittype,
------------------------------------------------------
// adoc.rcntr as kostl, // note 2196768, 2201824
// adoc.rbusa as gsber,
// adoc.aufnr as caufn,
// adoc.awref as belnr,
// adoc.lstar as lstar,
// adoc.rfund as geber2,
// adoc.rfarea as fkber2,
// adoc.rgrant_nbr as grant_nbr2,
// adoc.fistl as fistl2,
// adoc.rbudget_pd as budget_pd2,
// adoc.segment as segment,
// adoc.prctr as prctr,
------------------------------------------------------
sum ( hsl ) as hsl,
sum ( ksl ) as ksl,
sum ( osl ) as osl,
sum ( vsl ) as vsl,
sum ( bsl ) as bsl,
sum ( csl ) as csl,
sum ( dsl ) as dsl,
sum ( esl ) as esl,
sum ( fsl ) as fsl,
sum ( gsl ) as gsl }
where anln1 <> ''
and ( awtyp = 'AMDP' or awtyp = 'AS91' ) // 2419672
and bstat <> 'C' // only current year values
and ( mig_source = 'A' or mig_source = '' )
and ( slalittype = '07203' or slalittype = '07204' or slalittype = '07205' or
slalittype = '07206' or slalittype = '07207' or slalittype = '07208' or
slalittype = '07209' )
group by rclnt,
rbukrs,
// gjahr,
ryear,
poper,
subta,
anln1,
anln2,
afabe,
slalittype,
mig_source, -- note 2346484
awref -- note 2346484
------------------------------------------------------
// rcntr // note 2196768, 2201824
// rbusa,
// aufnr,
// awref,
// lstar,
// rfund,
// rfarea,
// rgrant_nbr,
// fistl,
// rbudget_pd,
// segment,
// prctr
------------------------------------------------------
union all
// the same for group assets
----------------------------
select from Faa_Rep_Ledger as ldnr
inner join acdoca as adoc
on ldnr.bukrs = adoc.rbukrs
and ldnr.rep_ledger = adoc.rldnr
and ldnr.lead_afabe = adoc.afabe
// and ldnr.xstore = 'X' // NOT FOR ANLP !!!!!!!!!
{ key adoc.rclnt as mandt,
key adoc.rbukrs as bukrs,
key adoc.ryear as gjahr,
key adoc.poper as peraf,
key case when adoc.mig_source = 'A' -- note 2346484
then substring( adoc.subta, 5, 2)
else substring( adoc.awref, 9, 2) end as afbnr,
// key substring( adoc.subta, 5,2 ) as afbnr, -- note 2246616
key adoc.anlgr as anln1,
key adoc.anlgr2 as anln2,
key adoc.afabe as afaber,
'ADOC' as rctyp,
adoc.slalittype,
------------------------------------------------------
// adoc.rcntr as kostl, // note 2196768, 2201824
// adoc.rbusa as gsber,
// adoc.aufnr as caufn,
// adoc.awref as belnr,
// adoc.lstar as lstar,
// adoc.rfund as geber2,
// adoc.rfarea as fkber2,
// adoc.rgrant_nbr as grant_nbr2,
// adoc.fistl as fistl2,
// adoc.rbudget_pd as budget_pd2,
// adoc.segment as segment,
// adoc.prctr as prctr,
------------------------------------------------------
sum ( hsl ) as hsl,
sum ( ksl ) as ksl,
sum ( osl ) as osl,
sum ( vsl ) as vsl,
sum ( bsl ) as bsl,
sum ( csl ) as csl,
sum ( dsl ) as dsl,
sum ( esl ) as esl,
sum ( fsl ) as fsl,
sum ( gsl ) as gsl }
where anlgr <> ''
and bstat <> 'C' // only current year values
and ( mig_source = 'A' or mig_source = '' )
and ( ( anlgr <> anln1 )
or ( anlgr = anln1 and anlgr2 <> anln2 ) )
and ( awtyp = 'AMDP' or awtyp = 'AS91' ) // 2419672
and ( slalittype = '07203' or slalittype = '07204' or slalittype = '07205' or
slalittype = '07206' or slalittype = '07207' or slalittype = '07208' or
slalittype = '07209' )
group by rclnt,
rbukrs,
// gjahr,
ryear,
poper,
subta,
anlgr,
anlgr2,
afabe,
slalittype,
mig_source, -- note 2346484
awref -- note 2346484
------------------------------------------------------
// rcntr // note 2196768, 2201824
// rbusa,
// aufnr,
// awref,
// lstar,
// rfund,
// rfarea,
// rgrant_nbr,
// fistl,
// rbudget_pd,
// segment,
// prctr
------------------------------------------------------
union all
select from faat_plan_values
{ key mandt as mandt,
key bukrs as bukrs,
key gjahr as gjahr,
key '000' as peraf,
key '00' as afbnr, -- note 2246616
key anln1 as anln1,
key anln2 as anln2,
key afabe as afaber,
'PLAN' as rctyp,
slalittype,
--------------------------------------------
// '' as kostl, // note 2196768, 2201824
// '' as gsber,
// '' as caufn,
// '' as belnr,
// '' as lstar,
// '' as geber2,
// '' as fkber2,
// '' as grant_nbr2,
// '' as fistl2,
// '' as budget_pd2,
// '' as segment,
// '' as prctr,
--------------------------------------------
sum ( hsl ) as hsl,
sum ( ksl ) as ksl,
sum ( osl ) as osl,
sum ( vsl ) as vsl,
sum ( bsl ) as bsl,
sum ( csl ) as csl,
sum ( dsl ) as dsl,
sum ( esl ) as esl,
sum ( fsl ) as fsl,
sum ( gsl ) as gsl }
where anln1 <> ''
and ( slalittype = '07203' or slalittype = '07204' or slalittype = '07205' or
slalittype = '07206' or slalittype = '07207' or slalittype = '07208' or
slalittype = '07209' )
group by mandt,
bukrs,
gjahr,
anln1,
anln2,
afabe,
slalittype
union all
// the same for group assets
----------------------------
select from faat_plan_values
{ key mandt as mandt,
key bukrs as bukrs,
key gjahr as gjahr,
key '000' as peraf,
key '00' as afbnr,
key anlgr as anln1,
key anlgr2 as anln2,
key afabe as afaber,
'PLAN' as rctyp,
slalittype,
--------------------------------------------
// '' as kostl, // note 2196768, 2201824
// '' as gsber,
// '' as caufn,
// '' as belnr,
// '' as lstar,
// '' as geber2,
// '' as fkber2,
// '' as grant_nbr2,
// '' as fistl2,
// '' as budget_pd2,
// '' as segment,
// '' as prctr,
--------------------------------------------
sum ( hsl ) as hsl,
sum ( ksl ) as ksl,
sum ( osl ) as osl,
sum ( vsl ) as vsl,
sum ( bsl ) as bsl,
sum ( csl ) as csl,
sum ( dsl ) as dsl,
sum ( esl ) as esl,
sum ( fsl ) as fsl,
sum ( gsl ) as gsl }
where anlgr <> ''
and ( ( anlgr <> anln1 )
or ( anlgr = anln1 and anlgr2 <> anln2 ) )
and ( slalittype = '07203' or slalittype = '07204' or slalittype = '07205' or
slalittype = '07206' or slalittype = '07207' or slalittype = '07208' or
slalittype = '07209' )
group by mandt,
bukrs,
gjahr,
anlgr,
anlgr2,
afabe,
slalittype
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAA_REP_LEDGER",
"ACDOCA",
"FAAT_PLAN_VALUES"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/