Faa_Anek_Add_Gr

DDL: FAA_ANEK_ADD_GR SQL: FAAV_ANEK_ADD_GR Type: view

Intern: Ermittlung von Zusatzfeldern fuer ANLGR

Faa_Anek_Add_Gr is a CDS View that provides data about "Intern: Ermittlung von Zusatzfeldern fuer ANLGR" in SAP S/4HANA. It reads from 2 data sources (acdoca, Faa_Rep_Ledger) and exposes 13 fields with key fields mandt, bukrs, anlgr, anlgr2, 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_GR view
EndUserText.label Intern: Ermittlung von Zusatzfeldern fuer ANLGR 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 anlgr acdoca anlgr
KEY anlgr2 acdoca anlgr2
KEY gjahr acdoca ryear
KEY subta acdoca subta
sbusa
mwskz
sgtxt
bzdat
parob1
zuonr
rassc 
@AbapCatalog.sqlViewName: 'FAAV_ANEK_ADD_GR'
@EndUserText.label: 'Intern: Ermittlung von Zusatzfeldern fuer ANLGR'

@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 ANLGR

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

define view Faa_Anek_Add_Gr 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.anlgr       as anlgr,
  key adoc.anlgr2      as anlgr2,
//  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.anlgr <> ''
    and (    ( adoc.anlgr  <> adoc.anln1                               ) 
          or ( adoc.anlgr  =  adoc.anln1 and adoc.anlgr2 <> adoc.anln2 ) ) 
    and adoc.awtyp <> 'AMDP'
    and adoc.afabe <> '00'  
    and bstat      <> 'C'    // only current year values

    and ( mig_source = 'A' or mig_source = '' )  

    group by adoc.rclnt,
             adoc.rbukrs,
             adoc.anlgr,
             adoc.anlgr2,
//             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