I_SupDmndComponentBasic

@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Basic View for Components'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'ISDOCOMPONENTB',
  compiler.compareFilter: true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #X,
     sizeCategory:   #XXL
   }
}
define view I_SupDmndComponentBasic
 as
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
      resb.bdart =       'AR'
  and(
      resb.xloek != 'X'
  ) -- deleted item should not be selected
  and(
      resb.kzear != 'X'
  ) -- final issue for this reservation