Faa_Anlp_Poper

@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' )