Faa_Anlp2

DDL: FAA_ANLP2 SQL: FAAV_ANLP2 Type: view

Intern: Parallele Waehrungen auf AfA-Bereiche mappen

Faa_Anlp2 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_Anlp1, Faa_Curtyp) and exposes 9 fields with key fields mandt, bukrs, anln1, anln2, gjahr.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
Faa_Anlp1 v1 from
Faa_Curtyp v2 inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_ANLP2 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
KEY mandt Faa_Anlp1 mandt
KEY bukrs Faa_Anlp1 bukrs
KEY anln1 Faa_Anlp1 anln1
KEY anln2 Faa_Anlp1 anln2
KEY gjahr Faa_Anlp1 gjahr
KEY afabe Faa_Curtyp afabe
KEY peraf Faa_Anlp1 peraf
KEY afbnr Faa_Anlp1 afbnr
rctyp rctyp 
@AbapCatalog.sqlViewName: 'FAAV_ANLP2'
@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_Anlp2

as select from Faa_Anlp1  as v1

inner join     Faa_Curtyp as v2

     on v1.bukrs  = v2.bukrs
    and v1.afaber = v2.lead_afabe

{ key v1.mandt as mandt,
  key v1.bukrs as bukrs,
  key v1.anln1 as anln1,
  key v1.anln2 as anln2,
  key v1.gjahr as gjahr,
  key v2.afabe as afabe,
  key v1.peraf as peraf,
  key v1.afbnr as afbnr,     -- note 2246616
      slalittype,
      rctyp,
------------------------------------------------------
//      kostl,         // note 2196768, 2201824

//      gsber,

//      caufn,

//      belnr,

//      lstar,

//      geber2,

//      fkber2,

//      grant_nbr2,

//      fistl2,

//      budget_pd2,

//      segment,

//      prctr,

------------------------------------------------------
  case
  when v2.hsl = 'X' then cast( v1.hsl as aufwp ) //AFLE Enablement

  when v2.ksl = 'X' then cast( v1.ksl as aufwp ) //AFLE Enablement

  when v2.osl = 'X' then cast( v1.osl as aufwp ) //AFLE Enablement

  when v2.vsl = 'X' then cast( v1.vsl as aufwp ) //AFLE Enablement

  when v2.bsl = 'X' then cast( v1.bsl as aufwp ) //AFLE Enablement

  when v2.csl = 'X' then cast( v1.csl as aufwp ) //AFLE Enablement

  when v2.dsl = 'X' then cast( v1.dsl as aufwp ) //AFLE Enablement

  when v2.esl = 'X' then cast( v1.esl as aufwp ) //AFLE Enablement

  when v2.fsl = 'X' then cast( v1.fsl as aufwp ) //AFLE Enablement

  when v2.gsl = 'X' then cast( v1.gsl as aufwp ) //AFLE Enablement

  else 0 end as amount }






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

Learn More