Arun_Reqsrt_Mm

@AbapCatalog.sqlViewName: 'V_ARUN_SRT_MM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Requirement sorting - MM'
define view Arun_Reqsrt_Mm
  as select from    ekko as h
    inner join      ekpo as i  on(
       h.ebeln = i.ebeln
     )
    inner join      marc as m  on(
       i.matnr     = m.matnr
       and h.reswk = m.werks
     )
    inner join      mara as ma on(
      i.matnr = ma.matnr
    )
    inner join      ekpv as is on(
      i.ebeln       = is.ebeln
      and i.ebelp   = is.ebelp
    )
    left outer join knvv as c  on(
                    is         .kunnr = c.kunnr
       and          is         .vkorg = c.vkorg
       and          is         .vtweg = c.vtweg
       and          is         .spart = c.spart
     )
{
  h.ebeln,
  h.bstyp,
  h.bsart,
  h.bedat,
  h.reswk,
  h.aedat,
  h.ekorg,
  h.kunnr,
  h.bedat as audat,
  i.ebelp,
  i.matnr,
  i.meins,
  i.sgt_rcat,
  i.fsh_season,
  i.fsh_season_year,
  i.fsh_collection,
  i.fsh_theme,
  i.abeln,
  i.abelp,
  i.werks,
  i.lgort,
  i.matkl,
  0 as menge,
  i.umrez,
  i.umren,
  i.lmein,
  is.vkorg,
  is.vtweg,
  is.spart,
  is.lprio,
  ma.satnr,
  ma.mtpos_mara,
  m.xchpf,
  m.sgt_covs,
  m.sgt_stk_prt,
  c.kdgrp,
  c.kvgr1,
  c.kvgr2,
  c.kvgr3,
  c.kvgr4,
  c.kvgr5,
  c.fsh_kvgr6,
  c.fsh_kvgr7,
  c.fsh_kvgr8,
  c.fsh_kvgr9,
  c.fsh_kvgr10
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EKKO",
"EKPO",
"EKPV",
"KNVV",
"MARA",
"MARC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/