Faa_Anek_Add_An

DDL: FAA_ANEK_ADD_AN SQL: FAAV_ANEK_ADD_AN Type: view

Intern: Ermittlung von Zusatzfeldern fuer ANLN1

Faa_Anek_Add_An is a CDS View that provides data about "Intern: Ermittlung von Zusatzfeldern fuer ANLN1" in SAP S/4HANA. It reads from 2 data sources (acdoca, Faa_Rep_Ledger) and exposes 13 fields with key fields mandt, bukrs, anln1, anln2, gjahr.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
acdoca adoc inner
Faa_Rep_Ledger ldnr from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_ANEK_ADD_AN view
EndUserText.label Intern: Ermittlung von Zusatzfeldern fuer ANLN1 view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY mandt acdoca rclnt
KEY bukrs acdoca rbukrs
KEY anln1 acdoca anln1
KEY anln2 acdoca anln2
KEY gjahr acdoca ryear
KEY subta acdoca subta
sbusa
mwskz
sgtxt
bzdat
parob1
zuonr
rassc 
@AbapCatalog.sqlViewName: 'FAAV_ANEK_ADD_AN'
@EndUserText.label: 'Intern: Ermittlung von Zusatzfeldern fuer ANLN1'

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

// this view is to determine additional fields on LNRAN-level for ANLN1

------------------------------------------------------------------

define view Faa_Anek_Add_An as select 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 )
         or (    ldnr.tech_ledger = adoc.rldnr 
             and ldnr.lead_afabe = adoc.afabe ) )
  and ldnr.xstore     = 'X'                     
                           
{ key adoc.rclnt       as mandt,
  key adoc.rbukrs      as bukrs,
  key adoc.anln1       as anln1,
  key adoc.anln2       as anln2,
//  key adoc.gjahr       as gjahr,

  key adoc.ryear       as gjahr,
  key adoc.subta       as subta,
    max (adoc.sbusa)   as sbusa,     // trading partner's business area 

    max (adoc.mwskz)   as mwskz,     // tax on sales/purchases Code

    max (adoc.sgtxt)   as sgtxt,     // item text

    max (adoc.bzdat)   as bzdat,     // asset value date

    max (adoc.parob1)  as parob1,    // partner object

    max (adoc.zuonr)   as zuonr,     // assignment number

    max (adoc.rassc)   as rassc      // VBUND company ID

}
            

  where adoc.anln1 <> ''
    and adoc.awtyp <> 'AMDP'
    and adoc.afabe <> '00'
    and bstat      <> 'C'    
    and ( mig_source = 'A' or mig_source = '' ) 

    group by adoc.rclnt,
             adoc.rbukrs,
             adoc.anln1,
             adoc.anln2,
//             adoc.gjahr,

             adoc.ryear,
             adoc.subta
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAA_REP_LEDGER",
"ACDOCA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More