rfm_psst_sto_assign

@AbapCatalog.sqlViewName: 'RFM_PSST_STO_V'
@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: 'Assignment Monitor STO view'
define view rfm_psst_sto_assign
  as select distinct from ekko             as ekko
    inner join            ekpo             as ekpo             on ekpo.ebeln = ekko.ebeln
    inner join            ekpv             as ekpv             on  ekpv.ebeln = ekpo.ebeln
                                                               and ekpv.ebelp = ekpo.ebelp
    inner join            eket             as eket             on  eket.ebeln = ekpo.ebeln
                                                               and eket.ebelp = ekpo.ebelp
                                                               and eket.etenr = '0001'
    left outer join       arun_bdbs        as arun_bdbs        on  ekpo.ebeln = arun_bdbs.purchdoc_num
                                                               and ekpo.ebelp = arun_bdbs.purchdoc_item
    left outer join       kna1             as kna1             on ekpv.kunnr = kna1.kunnr
    left outer join       t161t            as t161t            on  ekko.bsart  = t161t.bsart
                                                               and t161t.bstyp = 'F'
                                                               and t161t.spras = $session.system_language
    left outer join       tvkot            as tvkot            on  ekpv.vkorg  = tvkot.vkorg
                                                               and tvkot.spras = $session.system_language
    left outer join       tvtwt            as tvtwt            on  ekpv.vtweg  = tvtwt.vtweg
                                                               and tvtwt.spras = $session.system_language
    left outer join       tspat            as tspat            on  ekpv.spart  = tspat.spart
                                                               and tspat.spras = $session.system_language
    left outer join       t001w            as t001w            on  ekko.reswk  = t001w.werks
                                                               and t001w.spras = $session.system_language
    left outer join       fsh_seasons_t    as fsh_seasons_t    on  ekpo.fsh_season     = fsh_seasons_t.fsh_season
                                                               and fsh_seasons_t.spras = $session.system_language
    left outer join       fsh_collection_t as fsh_collection_t on  ekpo.fsh_collection    = fsh_collection_t.fsh_collection
                                                               and fsh_collection_t.spras = $session.system_language
    left outer join       fsh_themes_t     as fsh_themes_t     on  ekpo.fsh_theme     = fsh_themes_t.fsh_theme
                                                               and fsh_themes_t.spras = $session.system_language
    left outer join       makt             as makt             on  ekpo.matnr = makt.matnr
                                                               and makt.spras = $session.system_language
{
  key ekpo.ebeln,
  key ekpo.ebelp,
      ekko.aedat,
      ekko.bsart,
      t161t.batxt,
      ekpv.vkorg,
      tvkot.vtext               as vtext_vkorg,
      ekpv.vtweg,
      tvtwt.vtext               as vtext_vtweg,
      ekpv.spart,
      tspat.vtext               as vtext_spart,
      ekko.reswk,
      t001w.name1               as vtext_name1,
      ekpv.vstel,
      ekpv.kunnr,
      ekko.ekorg,
      ekko.ekgrp,
      ekko.submi,
      eket.eindt                as vdatu,
      ekpo.matnr,
      ekpo.matkl,
      ekpo.werks,
      ekpo.retpo,
      ekpo.abeln,
      ekpo.abelp,
      ekpo.aktnr,
      ekpo.sgt_rcat,
      ekpo.wrf_charstc1,
      ekpo.wrf_charstc2,
      ekpo.wrf_charstc3,
      ekpo.fsh_season_year,
      ekpo.fsh_season,
      fsh_seasons_t.text        as rfm_season_desc,
      ekpo.fsh_collection,
      fsh_collection_t.text     as rfm_collection_des,
      ekpo.fsh_theme            as theme,
      fsh_themes_t.text         as rfm_theme_desc,
      ekpo.menge,
      ekpo.cnfm_qty,
      ekpo.lmein,
      ekpo.meins,
      ekpo.rfm_psst_rule,
      ekpo.rfm_psst_group,
      sum (arun_bdbs.alloc_qty) as ALLOC_QTY,
      kna1.name1                as kunnr_name1,
      makt.maktx
}

group by
  ekpo.ebeln,
  ekpo.ebelp,
  ekko.aedat,
  ekko.bsart,
  t161t.batxt,
  ekpv.vkorg,
  tvkot.vtext,
  ekpv.vtweg,
  tvtwt.vtext,
  ekpv.spart,
  tspat.vtext,
  ekko.reswk,
  t001w.name1,
  ekpv.vstel,
  ekpv.kunnr,
  ekko.ekorg,
  ekko.ekgrp,
  ekko.submi,
  eket.eindt,
  ekpo.matnr,
  ekpo.matkl,
  ekpo.werks,
  ekpo.retpo,
  ekpo.abeln,
  ekpo.abelp,
  ekpo.aktnr,
  ekpo.sgt_rcat,
  ekpo.wrf_charstc1,
  ekpo.wrf_charstc2,
  ekpo.wrf_charstc3,
  ekpo.fsh_season_year,
  ekpo.fsh_season,
  fsh_seasons_t.text,
  ekpo.fsh_collection,
  fsh_collection_t.text,
  ekpo.fsh_theme,
  fsh_themes_t.text,
  ekpo.menge,
  ekpo.cnfm_qty,
  ekpo.lmein,
  ekpo.meins,
  ekpo.rfm_psst_rule,
  ekpo.rfm_psst_group,
  kna1.name1,
  makt.maktx
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ARUN_BDBS",
"EKET",
"EKKO",
"EKPO",
"EKPV",
"FSH_COLLECTION_T",
"FSH_SEASONS_T",
"FSH_THEMES_T",
"KNA1",
"MAKT",
"T001W",
"T161T",
"TSPAT",
"TVKOT",
"TVTWT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/