I_SupDmndReservationBasic

@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Basic View for Reservations'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'ISDORESERVATNB',
  compiler.compareFilter: true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #X,
     sizeCategory:   #XXL
   }
}
define view I_SupDmndReservationBasic
  as select from    resb as resb
//    inner join      ekpo as item on  resb.ebeln = item.ebeln

//                                 and resb.ebelp = item.ebelp

//    inner join      ekko as head on(

//      head.ebeln     = item.ebeln

//      and head.mandt = item.mandt

//    )

//

//    inner join      lfa1 as ven  on(

//       resb.lifnr     = ven.lifnr

//       and resb.mandt = ven.mandt

//     )

//    inner join      marc as marc on(

//      resb.matnr               = marc.matnr

//      and resb.werks           = marc.werks

//      and marc.fsh_mg_arun_req = '1'

//    )

//    inner join      mara as mara on(

//      mara.matnr     = resb.matnr

//      and mara.mandt = resb.mandt

//    )

    left outer join lips as delv on(
//      head.ebeln     = delv.vgbel

       resb.matnr = delv.matnr
      and resb.rsnum = delv.fsh_rsnum
      and resb.rspos = delv.fsh_rspos
    )

{
//  head.bsart                                                                             as   PurchasingDocumentType,

//  head.lifnr                                                                             as   Supplier,

  resb.ebeln                                                                             as   PurchasingDocument,
  resb.ebelp                                                                             as   PurchasingDocumentItem,
  resb.bdmng * DIV(resb.umrez,resb.umren)                                                as   OpenDemandQuantity,
  resb.bdter                                                                             as   RequirementDate,
  resb.sgt_rcat                                                                          as   RequirementSegment,
  resb.matnr                                                                             as   Material,
  resb.werks                                                                             as   Plant,
  resb.lgort                                                                             as   StorageLocation,
  resb.bdart                                                                             as   RequirementType,
  resb.charg                                                                             as   Batch,
  resb.meins                                                                             as   BaseUnit,
  resb.umrez                                                                             as   OrderItemQtyToBaseQtyNmrtr,
  resb.umren                                                                             as   OrderItemQtyToBaseQtyDnmntr,
  resb.rsnum                                                                             as   RequirementDocumentNumber,
  resb.rspos                                                                             as   RequirementDocumentItem,
//  ven.kunnr                                                                              as   Customer,

//  mara.fsh_mg_at1                                                                        as   FreeDefinedProductAttribute01,

//  mara.fsh_mg_at2                                                                        as   FreeDefinedProductAttribute02,

//  mara.fsh_mg_at3                                                                        as   FreeDefinedProductAttribute03,

//  mara.color                                                                             as   RetailArticleColor,

//  mara.size1                                                                             as   RetailArticleMainSize,

//  mara.size2                                                                             as   RetailArticleSecondSize,

  resb.aufnr                                                                             as   OrderID,
  resb.bdter                                                                             as   RequestedDate,
  resb.bdter                                                                             as   ProductAvailabilityDate,
  resb.sgt_scat                                                                          as   StockSegment
//  item.fsh_season_year                                                                   as   ProductSeasonYear,

//  item.fsh_season                                                                        as   ProductSeason,

//  item.fsh_collection                                                                    as   ProductCollection,

//  item.fsh_theme                                                                         as   ProductTheme

//  marc.fsh_mg_arun_req                                                                   as   SupplyAssignmentRelevant,

//  mara.matkl                                                                             as   MaterialGroup,

//  mara.satnr                                                                             as   CrossPlantConfigurableProduct

}

where
//      item.matnr      between 'ARUN_SDO_A' and 'ARUN_SDO_Z'

  resb.bdart      =       'BB' -- subcon purchasing type
  and(
      resb.xloek != 'X'
  ) -- deleted item should not be selected
  and(
      resb.kzear != 'X'
  ) -- final issue for this reservation
//  and(

//      head.bstyp      =       'F'

//  ) -- purchase order

//  and(

//      head.memorytype =       ' '

//  ) -- incomplete po

//  and(

//      item.loekz != 'X'

//  ) -- deletion indicator , pick from item

//  and(

//      item.attyp != '01'

//  )

//  and(

//      item.attyp != '20'

//  )

//  and(

//      item.attyp != '21'

//  )

//  and(

//      item.attyp != '22'

//  )

//  and(

//      item.attyp != '30'

//  ) --- no generic article , pick from ekpo

//  and(

//      item.pstyp      =       '3'

//  ) -- subcon PO


//union all

//

//select from  resb as resb

//  inner join afpo as item on(

//    item.aufnr     = resb.aufnr

//    and item.posnr = resb.posnr

//  )

//

//  inner join marc as marc on(

//    marc.matnr               = resb.matnr

//    and marc.werks           = resb.werks

//    and marc.fsh_mg_arun_req = '1'

//  )

//  inner join mara as mara on(

//    mara.matnr     = resb.matnr

//    and mara.mandt = resb.mandt

//  )

//{

////  ''                                                                                     as   PurchasingDocumentType,

////  ''                                                                                     as   Supplier,

//  ''                                                                                     as   PurchasingDocument,

//  '00000'                                                                                as   PurchasingDocumentItem,

//  resb.bdmng * DIV(resb.umrez,resb.umren)                                                as   OpenDemandQuantity,

//  resb.bdter                                                                             as   RequirementDate,

//  resb.sgt_rcat                                                                          as   RequirementSegment,

//  resb.matnr                                                                             as   Material,

//  resb.werks                                                                             as   Plant,

//  resb.lgort                                                                             as   StorageLocation,

//  resb.bdart                                                                             as   RequirementType,

//  resb.charg                                                                             as   Batch,

//  resb.meins                                                                             as   BaseUnit,

//  resb.umrez                                                                             as   OrderItemQtyToBaseQtyNmrtr,

//  resb.umren                                                                             as   OrderItemQtyToBaseQtyDnmntr,

//  resb.rsnum                                                                             as   RequirementDocumentNumber,

//  resb.rspos                                                                             as   RequirementDocumentItem,

////  ''                                                                                     as   Customer,

////  mara.fsh_mg_at1                                                                        as   FreeDefinedProductAttribute01,

////  mara.fsh_mg_at2                                                                        as   FreeDefinedProductAttribute02,

////  mara.fsh_mg_at3                                                                        as   FreeDefinedProductAttribute03,

////  mara.color                                                                             as   RetailArticleColor,

////  mara.size1                                                                             as   RetailArticleMainSize,

////  mara.size2                                                                             as   RetailArticleSecondSize,

//  resb.aufnr                                                                             as   OrderID,

//  resb.bdter                                                                             as   RequestedDate,

//  resb.bdter                                                                             as   ProductAvailabilityDate,

//  resb.sgt_scat                                                                          as   StockSegment

////  item.fsh_season_year                                                                   as   ProductSeasonYear,

////  item.fsh_season                                                                        as   ProductSeason,

////  item.fsh_collection                                                                    as   ProductCollection,

////  item.fsh_theme                                                                         as   ProductTheme

////  marc.fsh_mg_arun_req                                                                   as   SupplyAssignmentRelevant,

////  mara.matkl                                                                             as   MaterialGroup,

////  mara.satnr                                                                             as   CrossPlantConfigurableProduct

//}

//where

//      item.matnr between 'ARUN_SDO_A' and 'ARUN_SDO_Z'

//  and resb.bdart =       'AR'

//  and(

//      resb.xloek != 'X'

//  ) -- deleted item should not be selected

//  and(

//      resb.kzear != 'X'

//  ) -- final issue for this reservation

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