Faa_Anlc2_Stat

DDL: FAA_ANLC2_STAT SQL: FAAV_ANLC2_STAT Type: view

Intern: Parallele Waehrungen auf AfA-Bereiche mappen

Faa_Anlc2_Stat is a CDS View that provides data about "Intern: Parallele Waehrungen auf AfA-Bereiche mappen" in SAP S/4HANA. It reads from 2 data sources (Faa_Anlc1_Stat, Faa_Curtyp) and exposes 9 fields.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
Faa_Anlc1_Stat v1 from
Faa_Curtyp v2 inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_ANLC2_STAT view
EndUserText.label Intern: Parallele Waehrungen auf AfA-Bereiche mappen view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (9)

KeyFieldSource TableSource FieldDescription
mandt Faa_Anlc1_Stat mandt
bukrs Faa_Anlc1_Stat bukrs
anln1 Faa_Anlc1_Stat anln1
anln2 Faa_Anlc1_Stat anln2
gjahr Faa_Anlc1_Stat gjahr
afabe Faa_Curtyp afabe
slalittype slalittype
movcat movcat
poper poper 
@AbapCatalog.sqlViewName: 'FAAV_ANLC2_STAT'
@EndUserText.label: 'Intern: Parallele Waehrungen auf AfA-Bereiche mappen'

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

// this view is just to map parallel currencies to depr. areas

--------------------------------------------------------------
define view Faa_Anlc2_Stat

as select from Faa_Anlc1_Stat  as v1

inner join     Faa_Curtyp      as v2
   on v1.bukrs = v2.bukrs
  and v1.afabe = v2.lead_afabe

{     v1.mandt as mandt,
      v1.bukrs as bukrs,
      v1.anln1 as anln1,
      v1.anln2 as anln2,
      v1.gjahr as gjahr,
      v2.afabe as afabe,
      slalittype,
      movcat,
//      poperx,                    // note 2364559, 2381967

      poper,

  case
  when v2.hsl = 'X' then cast( v1.hsl as aufwp ) //AFLE Enablement abap.dec(13,2)

  when v2.ksl = 'X' then cast( v1.ksl as aufwp ) //AFLE Enablement abap.dec(13,2)

  when v2.osl = 'X' then cast( v1.osl as aufwp ) //AFLE Enablement abap.dec(13,2)

  when v2.vsl = 'X' then cast( v1.vsl as aufwp ) //AFLE Enablement abap.dec(13,2)

  when v2.bsl = 'X' then cast( v1.bsl as aufwp ) //AFLE Enablement abap.dec(13,2)

  when v2.csl = 'X' then cast( v1.csl as aufwp ) //AFLE Enablement abap.dec(13,2)

  when v2.dsl = 'X' then cast( v1.dsl as aufwp ) //AFLE Enablement abap.dec(13,2)

  when v2.esl = 'X' then cast( v1.esl as aufwp ) //AFLE Enablement abap.dec(13,2)

  when v2.fsl = 'X' then cast( v1.fsl as aufwp ) //AFLE Enablement abap.dec(13,2)

  when v2.gsl = 'X' then cast( v1.gsl as aufwp ) //AFLE Enablement abap.dec(13,2)

  else 0 end as amount }






/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAA_ANLC1_STAT",
"FAA_CURTYP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More