rfm_psst_assign

@AbapCatalog.sqlViewName: 'RFM_PSST_VIEW'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking:#('TRANSACTIONAL_DATA')
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass:#MIXED
@EndUserText.label: 'PSST Assignment monitor view'
define view rfm_psst_assign  
as select distinct
from vbak as vbak
     inner join vbap as vbap on vbap.vbeln = vbak.vbeln     
     inner join vbep as vbep on vbep.vbeln = vbap.vbeln
                             and vbep.posnr = vbap.posnr
                             and vbep.etenr = '0001'  
     inner join mara as mara on vbap.matnr = mara.matnr
     
     left outer join arun_bdbs as arun_bdbs on vbap.vbeln = arun_bdbs.salesdoc_num
                                           and  vbap.posnr = arun_bdbs.salesdoc_item                                                     
     left outer join kna1 as kna1 on vbak.kunnr = kna1.kunnr
     
     left outer join tvakt as tvakt on vbak.auart = tvakt.auart
                                   and tvakt.spras = $session.system_language
     
     left outer join tvkot as TVKOT on vbak.vkorg = TVKOT.vkorg
                                    and TVKOT.spras = $session.system_language
                                    
     left outer join tvtwt as tvtwt on vbak.vtweg = tvtwt.vtweg
                                   and tvtwt.spras = $session.system_language
                                   
     left outer join tspat as tspat on vbak.spart = tspat.spart
                                   and tspat.spras = $session.system_language
     
     left outer join t001w as t001w on vbap.werks = t001w.werks
                                   and t001w.spras = $session.system_language
     
     left outer join makt as makt on vbap.matnr = makt.matnr
                                 and makt.spras = $session.system_language
                                    
                     
     
{
    key vbap.vbeln,
    key vbap.posnr,
        vbap.matnr,
        vbap.pstyv,   
        vbap.spart,     
        vbap.werks,
        vbap.vstel,
        vbap.meins,
        vbap.kwmeng,
        vbap.kbmeng,
        vbap.klmeng, 
        vbap.vrkme,
        vbap.reqqty_bu,
        vbap.lfgsa,        
        vbap.sgt_rcat,
        vbap.fsh_season_year,
        vbap.fsh_season,
        vbap.fsh_collection,
        vbap.fsh_theme,
        vbap.rfm_psst_rule,
        vbap.rfm_psst_group,
        vbak.erdat,
        vbak.auart,        
        vbak.vkorg,
        vbak.vtweg,        
        vbak.kunnr,
        vbep.edatu as vdatu,
        mara.matkl,
        mara.color_atinn,
        mara.size1_atinn,
        mara.size2_atinn,
        mara.color,
        mara.size1,
        mara.size2,   
        sum (arun_bdbs.alloc_qty) as ALLOC_QTY,             
        kna1.name1  as kunnr_name1, 
        tvakt.bezei as BEZEI_AUART,        
        TVKOT.vtext as VTEXT_VKORG,       
        tvtwt.vtext as VTEXT_VTWEG,        
        tspat.vtext as VTEXT_SPART,        
        t001w.name1 as WERKS_NAME1,              
        makt.maktx
        
}group by
        vbap.vbeln,
        vbap.posnr,
        vbap.matnr,
        vbap.pstyv,
        vbap.spart,
        vbap.werks,
        vbap.vstel,
        vbap.meins,
        vbap.kwmeng,
        vbap.kbmeng,
        vbap.klmeng,
        vbap.vrkme,
        vbap.reqqty_bu,
        vbap.lfgsa,
        vbap.sgt_rcat,
        vbap.fsh_season_year,
        vbap.fsh_season,
        vbap.fsh_collection,
        vbap.fsh_theme,
        vbap.rfm_psst_rule,
        vbap.rfm_psst_group,
        vbak.erdat,
        vbak.auart,
        vbak.vkorg,
        vbak.vtweg,
        vbep.edatu,
        vbak.kunnr,
        mara.matkl,
        mara.color_atinn,
        mara.size1_atinn,
        mara.size2_atinn,
        mara.color,
        mara.size1,
        mara.size2,
        kna1.name1,
        tvakt.bezei,
        TVKOT.vtext,
        tvtwt.vtext,
        tspat.vtext,
        t001w.name1,
        makt.maktx