P_StkPostgHistCancelBasic01

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Stock posting history cancel documents part 1'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM:
      {
        viewType: #COMPOSITE,
        private: true
      }
define view entity P_StkPostgHistCancelBasic01

  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_StartDate : sydate,
    @Environment.systemField: #SYSTEM_DATE
    P_EndDate   : sydate

  as select from I_MaterialDocumentRecord as matdoc

  association [1..1] to I_MaterialDocumentRecord as matdoc_successor on  matdoc.MaterialDocument                        =  matdoc_successor.ReversedMaterialDocument
                                                                     and matdoc.MaterialDocumentYear                    =  matdoc_successor.ReversedMaterialDocumentYear
                                                                     and matdoc.MaterialDocumentItem                    =  matdoc_successor.ReversedMaterialDocumentItem
                                                                     and matdoc_successor.ReversedMaterialDocument      <> ''
                                                                     and matdoc.StockIdentifyingMaterial                =  matdoc_successor.StockIdentifyingMaterial
                                                                     and matdoc.Plant                                   =  matdoc_successor.Plant
                                                                     and matdoc.StockIdfgStorageLocation                =  matdoc_successor.StockIdfgStorageLocation
                                                                     and matdoc.StockIdentifyingBatch                   =  matdoc_successor.StockIdentifyingBatch
                                                                     and matdoc.SpecialStockIdfgSupplier                =  matdoc_successor.SpecialStockIdfgSupplier
                                                                     and matdoc.SpecialStockIdfgSalesOrder              =  matdoc_successor.SpecialStockIdfgSalesOrder
                                                                     and matdoc.SpecialStockIdfgSalesOrderItem          =  matdoc_successor.SpecialStockIdfgSalesOrderItem
                                                                     and matdoc.SpecialStockIdfgWBSElement              =  matdoc_successor.SpecialStockIdfgWBSElement
                                                                     and matdoc.SpecialStockIdfgCustomer                =  matdoc_successor.SpecialStockIdfgCustomer
                                                                     and matdoc.InventoryStockType                      =  matdoc_successor.InventoryStockType
                                                                     and matdoc.InventorySpecialStockType               =  matdoc_successor.InventorySpecialStockType
                                                                     and matdoc.SpecialStockIdfgStockOwner              =  matdoc_successor.SpecialStockIdfgStockOwner
                                                                     and matdoc.ResourceID                              =  matdoc_successor.ResourceID
                                                                     and matdoc_successor.GoodsMovementCancellationType =  '2'

{
  key    MaterialDocument,
  key    MaterialDocumentYear,
  key    MaterialDocumentItem,

         CostEstimate,
         matdoc.CompanyCode             as CompanyCode,

         // stock fields for filter

         StockIdentifyingMaterial       as Material,
         Plant,
         StockIdfgStorageLocation       as StorageLocation,
         StockIdentifyingBatch          as Batch,
         SpecialStockIdfgSupplier       as Supplier,
         SpecialStockIdfgSalesOrder     as SalesOrder,
         SpecialStockIdfgSalesOrderItem as SalesOrderItem,
         SpecialStockIdfgWBSElement     as WBSElementInternalID,
         SpecialStockIdfgCustomer       as Customer,
         InventoryStockType,
         InventorySpecialStockType,
         SpecialStockIdfgStockOwner,
         ResourceID,
         InventoryValuationType,

         // stock quantity

         MaterialBaseUnit,
         @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
         MatlStkChangeQtyInBaseUnit,

         CompanyCodeCurrency,
         @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
         GoodsMovementStkAmtInCCCrcy,

         // reference documents

         PurchaseOrder,
         PurchaseOrderItem,
         ManufacturingOrder,
         ManufacturingOrderItem,
         DeliveryDocument,
         DeliveryDocumentItem,
         Reservation,
         ReservationItem,

         // other fields

         GoodsMovementType,
         GoodsMovementRefDocType,
         GoodsReceiptType,
         ConsumptionPosting,
         PostingDate,

         // Reversal Document

         matdoc_successor.PostingDate   as SuccessorPostingDate
}
where
       PostingDate                   >= $parameters.P_StartDate
  and  PostingDate                   <= $parameters.P_EndDate
  and  GoodsMovementIsCancelled      =  'X'
  and(
       GoodsMovementCancellationType =  ''
    or GoodsMovementCancellationType =  '1'
  )
  and(
       matdoc_successor.PostingDate  < $parameters.P_StartDate
    or matdoc_successor.PostingDate  > $parameters.P_EndDate
  )
  and(
       MatlStkChangeQtyInBaseUnit    <> 0
    or TotalGoodsMvtAmtInCCCrcy      =  0
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIALDOCUMENTRECORD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/