@AbapCatalog.sqlViewName: 'FAAV_ANLP_POPER'
@EndUserText.label: 'Intern: Ermittelt Perioden fuer ANLP-Saetze'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
-------------------------------------------------------------------
// ANLP records are crated only for those periods that occur
// in table acdoca
-------------------------------------------------------------------
define view Faa_Anlp_Poper
as select distinct 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 !!!!!!!!!
inner join Faa_Curtyp as crtp
on adoc.rbukrs = crtp.bukrs
and adoc.afabe = crtp.lead_afabe
{ adoc.rclnt as mandt,
adoc.rbukrs as bukrs,
adoc.ryear as gjahr,
adoc.anln1 as anln1,
adoc.anln2 as anln2,
crtp.afabe as afaber,
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
adoc.poper as poper }
// adoc.rcntr as kostl } // note 2201824, 2231195
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' )
union all
// the same for group assets
----------------------------
select distinct 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 !!!!!!!!!
inner join Faa_Curtyp as crtp
on adoc.rbukrs = crtp.bukrs
and adoc.afabe = crtp.lead_afabe
{ adoc.rclnt as mandt,
adoc.rbukrs as bukrs,
adoc.ryear as gjahr,
adoc.anlgr as anln1,
adoc.anlgr2 as anln2,
crtp.afabe as afaber,
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
adoc.poper as poper }
// adoc.rcntr as kostl } // note 2201824, 2231195
where anlgr <> ''
and ( awtyp = 'AMDP' or awtyp = 'AS91' ) // 2419672
and bstat <> 'C' // only current year values
and ( mig_source = 'A' or mig_source = '' )
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' )
// Poper 000 for planvalues - new with note 2535987
-----------------------------------------------------
union all
select distinct from faat_plan_values
{ mandt as mandt,
bukrs as bukrs,
gjahr as gjahr,
anln1 as anln1,
anln2 as anln2,
afabe as afaber,
'00' as afbnr,
'000' as poper }
where anln1 <> ''
and ( slalittype = '07203' or slalittype = '07204' or slalittype = '07205' or
slalittype = '07206' or slalittype = '07207' or slalittype = '07208' or
slalittype = '07209' )
union all
// Poper 000 for planvalues - group assets - new with note 2535987
---------------------------------------------------------------
select distinct from faat_plan_values
{ mandt as mandt,
bukrs as bukrs,
gjahr as gjahr,
anlgr as anln1,
anlgr2 as anln2,
afabe as afaber,
'00' as afbnr,
'000' as poper }
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' )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAA_CURTYP",
"FAA_REP_LEDGER",
"ACDOCA",
"FAAT_PLAN_VALUES"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/