ARUN_SUP_SP_SO

@AbapCatalog.sqlViewName: 'ARUN_V_I_SUP_SO'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #X
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@EndUserText.label: 'Get supply specific SO online'
define view ARUN_SUP_SP_SO as select from arun_bdbs as bdbs 
    left outer join ekko as ekko on(
      bdbs.purchord_num = ekko.ebeln
    )   
    left outer join ekes                   as ekes on(
      ekes.ebeln        = bdbs.purchord_num
      and ekes.ebelp        = bdbs.purchord_item 
      and ekes.etens        = bdbs.confirmation_no
      and bdbs.stock_source = 'L' )
    left outer join aufk as aufk on(
    aufk.aufnr = bdbs.prodord_num)  {
      
      bdbs.salesdoc_num as salesdoc_num,
      bdbs.salesdoc_item as salesdoc_item,
      bdbs.purchdoc_num as purchdoc_num,
      bdbs.purchdoc_item as purchdoc_item,
      bdbs.req_ind as req_ind,
      bdbs.material_avail_date as material_avail_date,
      bdbs.requested_date as requested_date,
      bdbs.stock_source as stock_source,
      bdbs.purchord_num as purchord_num,
      bdbs.purchord_item as purchord_item,
      bdbs.delivery_date_po as delivery_date_po,
      bdbs.batch as batch,
      bdbs.storage_location as storage_location,
      bdbs.prodord_item as prodord_item,
      bdbs.prodord_num as prodord_num,
      ekko.lifnr as vendor,
      ekko.bsart as purchord_type,
      ekes.vbeln  as    ibd_num,
      ekes.vbelp  as    ibd_itm,
      aufk.auart as prodord_type
      
      }
      where  bdbs.req_ind = 'VC'
        or bdbs.req_ind   = 'VI'
        or bdbs.req_ind   = 'VG'
        or bdbs.req_ind   = 'U1'
      
      
      
      
      
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ARUN_BDBS",
"AUFK",
"EKES",
"EKKO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/