I_SupDmndOvwCube

@AbapCatalog.sqlViewName: 'ISDOOVWDCUBE'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@Analytics.dataExtraction.enabled: true
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #X,
     sizeCategory:   #XXL
   }
}
@Analytics.dataCategory: #CUBE
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Supply Demand Overview Cube View'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations:true
@Metadata.allowExtensions:true

define view I_SupDmndOvwCube
  as select from    P_SUPDMNDOVWCUBE          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.SalesDistrict  = 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
    association [0..1] to E_SalesDocumentBasic as _SalesDocHeaderExtension on Ovw.RequirementDocumentNumber = _SalesDocHeaderExtension.SalesDocument
    association [0..1] to E_SalesDocumentItemBasic as _SalesDocItemExtension on Ovw.RequirementDocumentNumber = _SalesDocItemExtension.SalesDocument
                                                                             and Ovw.RequirementDocumentItem = _SalesDocItemExtension.SalesDocumentItem
    association [0..1] to E_PurchasingDocument as _PurDocHeaderExtension on Ovw.RequirementDocumentNumber = _PurDocHeaderExtension.PurchasingDocument
    association [0..1] to E_PurchasingDocumentItem as _PurDocItemExtension on Ovw.RequirementDocumentNumber = _PurDocItemExtension.PurchasingDocument
                                                                           and Ovw.PurchasingDocumentItem = _PurDocItemExtension.PurchasingDocumentItem

{
  RequirementDocumentNumber,
  RequirementDocumentItem,
  Ovw.PurchasingDocumentItem,
  //  @Semantics.systemDate.createdAt: true

  ProductAvailabilityDate,
  RequestedDeliveryDate,
  //cast(ProductAvailabilityDate as char8 ) as ProductAvailabilityDate,

  //cast(ProductAvailabilityDate as abap.dats ) as ProductAvailabilityDate,

  RequirementType,
  SupplyNumber,
  SupplyItem,
  AssignedSupplyType,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  DeliveredQuantityInBaseUnit,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  RequestedRqmtQtyInBaseUnit,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  ConfirmedRqmtQtyInBaseUnit,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  OpenDemandQuantity,
  Ovw.SalesOrganization,
  Ovw.DistributionChannel,
  //  SalesGroup,

  //  SalesOffice,

  //  SoldToParty,

  Ovw.CompanyCode,
  Ovw.Division,
  Ovw.Material,
  Ovw.MaterialGroup,
  BaseUnit,
  Ovw.Plant,
  StorageLocation,
  Batch,
  ShippingPoint,
  RequirementSegment,
  StockSegment,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  ShippingGroupRule,
  ShippingGroupNumber,
  Ovw.SalesDistrict,
  CalendarMonth,
  CalendarWeek,
  CalendarYear,
  CalendarMonthName,
  CrossPlantConfigurableProduct,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  AssignedQuantityInBaseUnit,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  NormalAssignedQuantityInBsUnt,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  FixedQuantityInBaseUnit,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  SupAssgmtReservedQtyInBaseUnit,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  OnHoldQuantityInBaseUnit,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  ReadyForReleaseQtyInBaseUnit,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  InboundAssignedQuantityInBsUnt,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  PreviewFixedAssignedQtyInBsUnt,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  PreviewReservedAssgdQtyInBsUnt,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  PreviewOnHoldAssgdQtyInBsUnt,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  PreviewRdyForReleaseQtyInBsUnt,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  PreviewAssignedQuantityInBsUnt,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  OpenSupplyQuantity,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  AssignedSupplyQtyInBaseUnit,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  NormalSupplyQtyInBaseUnit,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'SupAssgmtAggrgQtyUnit'
  PreviewSupplyQtyInBaseUnit,
  @Semantics.unitOfMeasure: true
  cast( ' ' as meins ) as SupAssgmtAggrgQtyUnit,
  SupAssgmtCategory,
  SupAssgmtCategoryName,
  SupAssgmtSource,
  SupAssgmtSourceName,
  SalesOrgText.SalesOrganizationName,
  MaterialText.MaterialName,
  MatGrpText.MaterialGroupName,
  DistChl.DistributionChannelName,
  Div.DivisionName,
  SalesDist.SalesDistrictName,
  Plant.PlantName,
  CompanyCode.CompanyCodeName,
  ARunApplicationType,
  @DefaultAggregation: #SUM
  @Semantics.amount.currencyCode: 'DocumentCurrency'
  NetPriceAmount,
  @Semantics.currencyCode: true
  DocumentCurrency
  //  0  as AssignedSupplyQtyInBaseUnit,

  //  0  as NormalSupplyQtyInBaseUnit,

  //  0  as PreviewSupplyQtyInBaseUnit

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