C_SupDmndOvwTotSupQuery

@AbapCatalog: {
  sqlViewName: 'CSDOSUPPLYQUERY',
  compiler.compareFilter: true
}
@ObjectModel:{
  usageType.serviceQuality: #D,
  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: 'Query View for Total Supply'
@AccessControl.authorizationCheck: #CHECK
//@Metadata.ignorePropagatedAnnotations:true

//@OData.publish: true

define view C_SupDmndOvwTotSupQuery
  as select from    I_SupDmndOvwTotalSupplyCube as Supply
    left outer join I_SalesOrganizationText     as SalesOrgText on  Supply.SalesOrganization = SalesOrgText.SalesOrganization
                                                                and SalesOrgText.Language    = $session.system_language
    left outer join I_MaterialText              as MaterialText on  Supply.Material       = MaterialText.Material
                                                                and MaterialText.Language = $session.system_language
    left outer join I_MaterialGroupText         as MatGrpText   on  Supply.MaterialGroup  = MatGrpText.MaterialGroup
                                                                and MatGrpText.Language   = $session.system_language
                                                                and MaterialText.Language = $session.system_language
    left outer join I_DistributionChannelText   as DistChl      on  Supply.DistributionChannel = DistChl.DistributionChannel
                                                                and DistChl.Language           = $session.system_language
    left outer join I_DivisionText              as Div          on  Supply.Division = Div.Division
                                                                and Div.Language    = $session.system_language
    left outer join I_SalesDistrictText         as SalesDist    on  Supply.SalesDistrict = SalesDist.SalesDistrict
                                                                and SalesDist.Language   = $session.system_language
    left outer join I_Plant                     as Plant        on Supply.Plant = Plant.Plant
    left outer join I_CompanyCode               as CompanyCode  on Supply.CompanyCode = CompanyCode.CompanyCode
    left outer join I_PurchasingOrganization    as PurchOrg     on Supply.PurchasingOrganization = PurchOrg.PurchasingOrganization
{
  key Supply.Material,
  key Supply.Plant,
  key StorageLocation,
  key Batch,
      @EndUserText.label: 'Supply Document No.'
  key SupplyNumber,
      @EndUserText.label: 'Supply Document Item'
  key SupplyItem,
      @EndUserText.label: 'Supply Schedule Line'
  key SupplyScheduleLine,
      @EndUserText.label: 'Supply Type'
  key AssignedSupplyType,
      @EndUserText.label: 'Total Quantity'
      @DefaultAggregation: #SUM
      TotalQuantity,
      @EndUserText.label: 'Open Supply Quantity'
      @DefaultAggregation: #SUM
      OpenSupplyQuantity,
      @EndUserText.label: 'Supply Delivery Date'
      SupplyDeliveryDate,
      @EndUserText.label: 'Requested Delivery Date'
      RequestedDeliveryDate,
      @Feature:'SW:RFM_SEGMTN_UI'
      StockSegment,
      Supply.MaterialGroup,
      BaseUnit,
      @EndUserText.label: 'Supply Type'
      AssignedSupplyTypeName,
      FreeDefinedProductAttribute01,
      FreeDefinedProductAttribute02,
      FreeDefinedProductAttribute03,
      RetailArticleColor,
      RetailArticleMainSize,
      RetailArticleSecondSize,
      @EndUserText.label: 'Goods Received Quantity'
      @DefaultAggregation: #SUM
      RoughGoodsReceiptQty,
//            @DefaultAggregation: #SUM

//            MRPReducedQuantity,

      @Feature:'SW:RFM_CHARC_VALS_UI'
      ProductCharacteristic1,
      @Feature:'SW:RFM_CHARC_VALS_UI'
      ProductCharacteristic2,
      @Feature:'SW:RFM_CHARC_VALS_UI'
      ProductCharacteristic3,
      @EndUserText.label: 'Company Code'
      Supply.CompanyCode,
            @DefaultAggregation: #SUM
            NetPriceAmount,
            @DefaultAggregation: #SUM
            NetPriceQuantity,
            @DefaultAggregation: #SUM
            NetAmount,
      Customer,
      ItemIsRejectedBySupplier,
      PurchasingDocumentCategory,
      CrossPlantConfigurableProduct,
      PurchasingOrderReason,
//            SupplyAssignmentRelevant,

      @EndUserText.label: 'Document Type'
      OrderType,
      PaymentTerms,
      Supply.PurchasingOrganization,
      PurchasingGroup,
      DocumentCurrency,
      SupplyingPlant,
      Supplier,
      DeliveryDocument,
      @Feature:'SW:RFM_SEASON_UI'
      ProductSeason,
      @Feature:'SW:RFM_SEASON_UI'
      ProductSeasonYear,
      @Feature:'SW:RFM_SEASON_UI'
      ProductCollection,
      @Feature:'SW:RFM_SEASON_UI'
      ProductTheme,
      InventorySpecialStockType,
      SalesOrder,
      SalesOrderItem,
      @DefaultAggregation: #SUM
      ItemQuantity,
      @DefaultAggregation: #SUM
      MfgOrderItemGoodsReceiptQty,
      @DefaultAggregation: #SUM
      MfgOrderItemActualDeviationQty,
      @DefaultAggregation: #SUM
      MfgOrderItemPlannedScrapQty,
      @EndUserText.label: 'Open Delivery Quantity'
      @DefaultAggregation: #SUM
      DeliveredQuantity,
      @EndUserText.label: 'Month'
      CalendarMonth,
      @EndUserText.label: 'Week'
      CalendarWeek,
      @EndUserText.label: 'Year'
      CalendarYear,
      @EndUserText.label: 'Month'
      CalendarMonthName,

      @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,
      @EndUserText.label: 'SDO Category'
      SupAssgmtCategory,
      @EndUserText.label: 'SDO Category'
      SupAssgmtCategoryName,
      ShippingGroupRule,
      ShippingGroupNumber,
      Supply.SalesOrganization,
      Supply.DistributionChannel,
      Supply.PlantCustomer,
      Supply.PlantSupplier,
      Supply.Division,
      ShippingPoint,
      @EndUserText.label: 'SDO Source'
      SupAssgmtSource,
      @EndUserText.label: 'SDO Source'
      SupAssgmtSourceName,
      Supply.SalesDistrict,
      @EndUserText.label: 'Purchase Order'
      PurchasingDocument,
       MaterialText.MaterialName,
      MatGrpText.MaterialGroupName,
      DistChl.DistributionChannelName,
      Div.DivisionName,
      SalesDist.SalesDistrictName,
      Plant.PlantName,
      CompanyCode.CompanyCodeName,
      PurchOrg.PurchasingOrganizationName
      
      
//      SupAssgmtStockType

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_DISTRIBUTIONCHANNELTEXT",
"I_DIVISIONTEXT",
"I_MATERIALGROUPTEXT",
"I_MATERIALTEXT",
"I_PLANT",
"I_PURCHASINGORGANIZATION",
"I_SALESDISTRICTTEXT",
"I_SALESORGANIZATIONTEXT",
"I_SUPDMNDOVWTOTALSUPPLYCUBE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/