C_SupDmndOvwSupAssgmtQuery

@AbapCatalog: {
  sqlViewName: 'CSDOOVWQUERY',
  compiler.compareFilter: true
}
@ObjectModel:{
  usageType.serviceQuality: #X,
  usageType.sizeCategory: #XXL
  }
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
//@Analytics.query: true

@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Consumption view for Assignments'
//@OData.publish: true

@AccessControl.authorizationCheck: #CHECK

define view C_SupDmndOvwSupAssgmtQuery
  as select from    I_SupDmndOvwSupAssgmtCube as Ovw
    left outer join I_SalesOrganizationText   as SalesOrgText on  Ovw.SalesOrganization = SalesOrgText.SalesOrganization
                                                              and SalesOrgText.Language = $session.system_language
    left outer join I_MaterialText            as MaterialText on  Ovw.Material          = MaterialText.Material
                                                              and MaterialText.Language = $session.system_language
    left outer join I_MaterialGroupText       as MatGrpText   on  Ovw.MaterialGroup     = MatGrpText.MaterialGroup
                                                              and MatGrpText.Language   = $session.system_language
                                                              and MaterialText.Language = $session.system_language
    left outer join I_DistributionChannelText as DistChl      on  Ovw.DistributionChannel = DistChl.DistributionChannel
                                                              and DistChl.Language        = $session.system_language
  //    left outer join I_DivisionText            as Div          on  Ovw.Division = Div.Division

  //                                                              and Div.Language = $session.system_language

  //    left outer join I_SalesDistrictText       as SalesDist    on  Ovw.Division       = SalesDist.SalesDistrict

  //                                                              and SalesDist.Language = $session.system_language

    left outer join I_Plant                   as Plant        on Ovw.Plant = Plant.Plant
    left outer join I_CompanyCode             as CompanyCode  on  Ovw.CompanyCode      = CompanyCode.CompanyCode
{
  key  Ovw.Plant,
  key  Ovw.Material,
  key  StorageLocation,
       @EndUserText.label: 'Batch'
  key  Batch,
       @EndUserText.label: 'Requirement Type'
  key  RequirementType,
       @EndUserText.label: 'Requirement Document Number'
  key  RequirementDocumentNumber,
       @EndUserText.label: 'Requirement Document Item'
  key  RequirementDocumentItem,
       @EndUserText.label: 'Supply Source'
  key  AssignedSupplyType,
       @EndUserText.label: 'Supply Document No.'
  key  SupplyNumber,
       @EndUserText.label: 'Supply Document Item'
  key  SupplyItem,
       @EndUserText.label: 'Supply Document Schedule Line'
  key  SupplyScheduleLine,
       @EndUserText.label: 'Requested Date'
  key  RequestedDate,
       @EndUserText.label: 'Material Availability Date'
  key  ProductAvailabilityDate,
       @EndUserText.label: 'Requested Delivery Date'
       RequestedDeliveryDate,
       @EndUserText.label: 'Requirement Type'
       AssignedDemandTypeName,
       @EndUserText.label: 'Supply Source'
       AssignedSupplyTypeName,
       @EndUserText.label: 'Mat. Avail Date - Supply Delivery Date'
       TimeHorizonInDays,
       @EndUserText.label: 'Total Assigned Quantity'
       @DefaultAggregation: #SUM
       AssignedQuantityInBaseUnit,
       @EndUserText.label: 'Normal Assigned Quantity'
       @DefaultAggregation: #SUM
       NormalAssignedQuantityInBsUnt,
       @EndUserText.label: 'Ready for Delivery Quantity'
       @DefaultAggregation: #SUM
       FixedQuantityInBaseUnit,
       //       @EndUserText.label: 'Reserved Quantity'

       //       @DefaultAggregation: #SUM

       //       SupAssgmtReservedQtyInBaseUnit,

       @EndUserText.label: 'On Hold Quantity'
       @DefaultAggregation: #SUM
       OnHoldQuantityInBaseUnit,
       @EndUserText.label: 'Open for Release Check Quantity'
       @DefaultAggregation: #SUM
       ReadyForReleaseQtyInBaseUnit,
       @EndUserText.label: 'IFO Assigned Quantity'
       @DefaultAggregation: #SUM
       InboundAssignedQuantityInBsUnt,
       @EndUserText.label: 'Ready for Delivery (Preview)'
       @DefaultAggregation: #SUM
       PreviewFixedAssignedQtyInBsUnt,
       @EndUserText.label: 'Reserved (Preview)'
       @DefaultAggregation: #SUM
       PreviewReservedAssgdQtyInBsUnt,
       @EndUserText.label: 'On Hold (Preview)'
       @DefaultAggregation: #SUM
       PreviewOnHoldAssgdQtyInBsUnt,
       @EndUserText.label: 'Open for Release Check (Preview)'
       @DefaultAggregation: #SUM
       PreviewRdyForReleaseQtyInBsUnt,
       @EndUserText.label: 'Preview Assigned Quantity'
       @DefaultAggregation: #SUM
       PreviewAssignedQuantityInBsUnt,

       //       BaseUnitOfMeasure,

       SupplyDeliveryDate,
       @Feature:'SW:RFM_SEGMTN_UI'
       RequirementSegment,
       @Feature:'SW:RFM_SEGMTN_UI'
       StockSegment,
       OrderType,
       Ovw.SalesOrganization,
       Ovw.DistributionChannel,
       Ovw.MaterialGroup,
       @Feature:'SW:RFM_SEASON_UI'
       ProductSeasonYear,
       @Feature:'SW:RFM_SEASON_UI'
       ProductSeason,
       @Feature:'SW:RFM_SEASON_UI'
       ProductCollection,
       @Feature:'SW:RFM_SEASON_UI'
       ProductTheme,
       ShippingGroupRule,
       ShippingGroupNumber,
       CustomerGroup,
       SalesDistrict,
       CrossPlantConfigurableProduct,
       @EndUserText.label: 'Company Code'
       Ovw.CompanyCode,
       SalesOrgText.SalesOrganizationName,
       MaterialText.MaterialName,
       MatGrpText.MaterialGroupName,
       DistChl.DistributionChannelName,
       //  Div.DivisionName,

       //  SalesDist.SalesDistrictName,

       Plant.PlantName,
       CompanyCode.CompanyCodeName
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_DISTRIBUTIONCHANNELTEXT",
"I_MATERIALGROUPTEXT",
"I_MATERIALTEXT",
"I_PLANT",
"I_SALESORGANIZATIONTEXT",
"I_SUPDMNDOVWSUPASSGMTCUBE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/