nsdm_e_mssa_agg

@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName:      'NSDM_V_MSSA_AGG'
@EndUserText.label:            'MSSA Compatibility View: Aggregation'
@DataAging.noAgingRestriction: 'false'
@AccessControl.authorizationCheck:#NOT_REQUIRED

@ObjectModel.usageType.sizeCategory: 'L'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #AUTOMATED
@AbapCatalog.viewEnhancementCategory: #PROJECTION_LIST
define view nsdm_e_mssa_agg as
select from matdoc_extract
{
key mandt, 
key matbf     as matnr,
key werks,
key case sobkz when 'F' then 'E' else sobkz end as sobkz,                       //2971225

key mat_kdauf as vbeln,
key mat_kdpos as posnr,

key lbbsa_sid as lbbsa,

sum(case sobkz when 'E' then stock_qty_l2                                       //2971225

               when 'T' then stock_qty_l2 
               else 0 end)        as stock_qty,
sum(case sobkz when 'E' then /cwm/stock_qty_l2                                  //2971225

               when 'T' then /cwm/stock_qty_l2 
               else 0 end)   as /cwm/stock_qty,                              
max(gjper_curr_per) as gjper_max,
min(cpudt_l2)          as cpudt_min,

kzbws
}
where stock_ind_l2 = ''
  and (
        ((sobkz = 'E' or sobkz = 'F') and mat_kdauf != ''                       //2971225

           and ( lbbsa_sid = '01' or lbbsa_sid = '02' or lbbsa_sid = '06' or
                 lbbsa_sid = '07' or lbbsa_sid = '08' or lbbsa_sid = '10' )  
        )
    
        or 
        
        (sobkz = 'T' and lbbsa_sid = '07' )
      )
     
group by mandt, matbf, werks, sobkz, mat_kdauf, mat_kdpos, lbbsa_sid, kzbws    

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