FAA_ANLC1_P_STAT

CDS View

Periodisches Verdichten auf SLALITTYPE

FAA_ANLC1_P_STAT is a CDS View in S/4HANA. Periodisches Verdichten auf SLALITTYPE. It contains 5 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 5 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
Faa_Anlc2_P_Stat view from Per. parallele Waehrung Bereiche mappen

Fields (5)

KeyField CDS FieldsUsed in Views
anln1 anln1 1
anln2 anln2 1
bukrs bukrs 1
gjahr gjahr 1
mandt mandt 1 
@AbapCatalog.sqlViewName: 'FAAV_ANLC1_PSTAT'
@EndUserText.label: 'Periodisches Verdichten auf SLALITTYPE'

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P

// this view is to condense the data on slalittype level

-------------------------------------------------------------
define view Faa_Anlc1_P_Stat

as select from faat_doc_it

{     mandt,
      bukrs,
      anln1,
      anln2,
      gjahr,
      afabe,
      slalittype,
      movcat,
      faat_doc_it.poper as poperx,
      faat_doc_it.poper as poperg,                                      

      case when (     ( bwasl  <> '999'                                                                            )   
                  and ( movcat <> '00' and movcat <> 'C7' and movcat <> '77' and movcat <> '87' and movcat <> '97' ) ) 
           then '999'                    // current year

           else '000' end as poper,      // balance carried forward


  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 = '07000' or
          slalittype = '07001' or slalittype = '07002' or slalittype = '07003' or slalittype = '07004' or
          slalittype = '07005' or slalittype = '07006' or slalittype = '07007' or slalittype = '07008' or
          slalittype = '07009' or
          slalittype = '07010' or
                                  slalittype = '07022' or slalittype = '07023' or slalittype = '07024' or
          slalittype = '07025' or slalittype = '07026' or slalittype = '07027' or slalittype = '07028' or
          slalittype = '07040' or
          slalittype = '07041' or slalittype = '07042' or slalittype = '07043' or slalittype = '07044' or
          slalittype = '07045' or slalittype = '07046' or slalittype = '07047' or slalittype = '07048' or
          slalittype = '07050' or
          slalittype = '07203' or slalittype = '07204' or slalittype = '07205' or slalittype = '07206' or
          slalittype = '07207' or slalittype = '07208' or slalittype = '07209' )

  group by mandt,
           bukrs,
           anln1,
           anln2,
           gjahr,
           afabe,
           slalittype,
           movcat,
           poper,                    
           bwasl

union all

// the same for group assets

-----------------------------
select from faat_doc_it

{     mandt,
      bukrs,
      anlgr  as anln1,
      anlgr2 as anln2,
      gjahr,
      afabe,
      slalittype,
      movcat,
      faat_doc_it.poper as poperx,
      faat_doc_it.poper as poperg,                                      

      case when (     ( bwasl  <> '999'                                                                            )   
                  and ( movcat <> '00' and movcat <> 'C7' and movcat <> '77' and movcat <> '87' and movcat <> '97' ) ) 
           then '999'                    // current year

           else '000' end as poper,      // balance carried forward


  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 = '07000' or
          slalittype = '07001' or slalittype = '07002' or slalittype = '07003' or slalittype = '07004' or
          slalittype = '07005' or slalittype = '07006' or slalittype = '07007' or slalittype = '07008' or
          slalittype = '07009' or
          slalittype = '07010' or
                                  slalittype = '07022' or slalittype = '07023' or slalittype = '07024' or
          slalittype = '07025' or slalittype = '07026' or slalittype = '07027' or slalittype = '07028' or
          slalittype = '07040' or
          slalittype = '07041' or slalittype = '07042' or slalittype = '07043' or slalittype = '07044' or
          slalittype = '07045' or slalittype = '07046' or slalittype = '07047' or slalittype = '07048' or
          slalittype = '07050' or
          slalittype = '07203' or slalittype = '07204' or slalittype = '07205' or slalittype = '07206' or
          slalittype = '07207' or slalittype = '07208' or slalittype = '07209' )

  group by mandt,
           bukrs,
           anlgr,
           anlgr2,
           gjahr,
           afabe,
           slalittype,
           movcat,
           poper,                          
           bwasl
      
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAAT_DOC_IT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More