P_PPMReturnDelivery

@AbapCatalog.sqlViewName: 'PPPMRETURNDEL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality:  #D
@ObjectModel.usageType.sizeCategory: #L
@VDM.private: true
@VDM.viewType : #CONSUMPTION
@EndUserText.label: 'Return Delivery'
define view P_PPMReturnDelivery
  with parameters

    P_StartDate : bedat,
    P_EndDate   : bedat
  as select from P_PPMMaterialDocumnet(P_StartDate: $parameters.P_StartDate,
                                                             P_EndDate : $parameters.P_EndDate) as MatDoc

    inner join   I_GoodsMovementType                                                            as GoodsMovement on  BasicMovementTypeReference           = '101'
                                                                                                                 and DebitCreditCode                      = 'H'
                                                                                                                 and GoodsMovement.IsReversalMovementType is initial
                                                                                                                 and GoodsMovement.GoodsMovementType      = MatDoc.GoodsMovementType
  // Bad quantity


{

  key MaterialDocument                                      as MaterialDocument,
  key MaterialDocumentItem,
  key MaterialDocumentYear,
      Supplier,
      PurchasingGroup,
      PurchasingOrganization,
      Material,
      MaterialGroup,
      Plant,
      PurchaseOrder,
      PurchaseOrderItem,
      cast(GoodsReceiptQtyInOrderUnit as abap.dec( 13, 3 )) as NumberOfReturnedParts,
      cast(0 as abap.dec( 13, 3 ))                          as NumberOfReceivedParts,
      //      cast(GoodsReceiptQtyInOrderUnit * -1 as bstmg)        as GoodsReceiptQtyInOrderUnit,

      GoodsReceiptQtyInOrderUnit,
      OrderQuantityUnit,
      GoodsMovement.GoodsMovementType,
      PostingDate

}

//  IsReversalMovementType = 'X' // Bad quantity

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GOODSMOVEMENTTYPE",
"P_PPMMATERIALDOCUMNET"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/