Faa_Anek_Mwskz_Gr

DDL: FAAV_ANEK_MWSKZ_GR SQL: FAAV_ANEK_MWS_GR Type: view

Ermittlung des Feldes MWSKZ fuer ANLGR

Faa_Anek_Mwskz_Gr is a CDS View that provides data about "Ermittlung des Feldes MWSKZ fuer ANLGR" in SAP S/4HANA. It reads from 2 data sources (acdoca, Faa_Rep_Ledger) and exposes 7 fields with key fields mandt, bukrs, anlgr, anlgr2, gjahr.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
acdoca adoc inner
Faa_Rep_Ledger ldnr from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_ANEK_MWS_GR view
EndUserText.label Ermittlung des Feldes MWSKZ fuer ANLGR view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (7)

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
mwskz 
@AbapCatalog.sqlViewName: 'FAAV_ANEK_MWS_GR'
@EndUserText.label: 'Ermittlung des Feldes MWSKZ fuer ANLGR'

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

// this view is to determine the tax on sales/purchases Code on LNRAN-level for ANLGR

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

define view Faa_Anek_Mwskz_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
  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.mwskz)   as mwskz
}


  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