C_PurReturnDelItem

@AbapCatalog.sqlViewName: 'CPURRETDELITM'
@VDM.viewType: #CONSUMPTION
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'MM SSP Return Delivery Items'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view C_PurReturnDelItem
  as select from P_PurReqItmforReturnDel       as PurReqItem
    inner join   I_PurchaseOrder               as PurchOrdHdr            on  PurchOrdHdr.PurchaseOrder = PurReqItem.PurchasingDocument 
                                                                         and PurchOrdHdr.PurchasingCompletenessStatus = '' 
    inner join   P_PurDocItmforReturnDel       as PurchOrdItem           on  PurReqItem.PurchaseRequisition     = PurchOrdItem.PurchaseRequisition
                                                                         and PurReqItem.PurchaseRequisitionItem = PurchOrdItem.PurchaseRequisitionItem
    inner join   P_POScheduleLineforReturnDel  as PurchOrdSch            on  PurchOrdSch.PurchaseOrder        = PurchOrdItem.PurchasingDocument     
                                                                         and PurchOrdSch.PurchaseOrderItem    = PurchOrdItem.PurchasingDocumentItem
    inner join   C_POItemDeliveryScheduleCount as POItemDelScheduleCount on  POItemDelScheduleCount.PurchaseOrder = PurchOrdItem.PurchasingDocument     
                                                                         and POItemDelScheduleCount.PurchaseOrderItem = PurchOrdItem.PurchasingDocumentItem 
                                                                         and POItemDelScheduleCount.NumberOfScheduleLines = 1
  association [0..*] to I_MaterialText            as _Text                  on  $projection.Material = _Text.Material
  //association [1..*] to C_PurReturnReasonText     as _PurReturnReasonText   on  _PurReturnReasonText.MovementType = '122'

  //Extension Association

  association [0..1] to E_Purchaserequisitionitem as _PRItemExtension       on  $projection.PurchaseRequisition     = _PRItemExtension.PurchaseRequisition
                                                                            and $projection.PurchaseRequisitionItem = _PRItemExtension.PurchaseRequisitionItem
  association [0..1] to E_PurchasingDocument      as _PurDocHeaderExtension on  $projection.PurchasingDocument = _PurDocHeaderExtension.PurchasingDocument
  association [0..1] to E_PurchasingDocumentItem  as _PurDocItemExtension   on  $projection.PurchasingDocument     = _PurDocItemExtension.PurchasingDocument
                                                                            and $projection.PurchasingDocumentItem = _PurDocItemExtension.PurchasingDocumentItem


{
  @EndUserText.label: 'Return Delivery'
  @EndUserText.quickInfo: 'Return Delivery'
  key concat(PurReqItem.PurchaseRequisition, PurchOrdItem.PurchasingDocument) as ReturnDelivery,
  key PurReqItem.PurchaseRequisitionItem,
  key PurchOrdItem.PurchasingDocumentItem, 
      PurReqItem.ExtCompanyCodeForPurg,

      PurReqItem.PurchaseRequisition,
      PurchOrdItem.PurchasingDocument,          
      PurchOrdSch.ScheduleLine,
      
      PurReqItem.PurchaseRequisitionType,
      //@Consumption.semanticObject: 'Supplier' //chr

      PurchOrdHdr.Supplier,
      @EndUserText.label: 'Purchase Requisition Item Text'
      PurReqItem.PurchaseRequisitionItemText,
      PurReqItem.CreatedByUser,
      PurReqItem.CreationDate,
      PurchOrdItem.PurchasingDocumentDeletionCode,
      @EndUserText.label: 'Purchase Order Item Text'
      PurchOrdItem.PurchasingDocumentItemText,

      _Text[1: Language = $session.system_language].MaterialName              as MaterialName,
      //@Consumption.semanticObject: 'Material' //chr

      PurchOrdItem.Material,

      // @Semantics.quantity.unitOfMeasure: true

      PurchOrdItem.OrderQuantityUnit,
      PurchOrdItem.NetPriceQuantity,

      PurchOrdItem.BaseUnit,
      PurchOrdItem.OrderPriceUnit,
      PurchOrdItem.NetAmount,
      //PurchOrdItem.EffectiveAmount,

      PurchOrdItem.NetPriceAmount,
      PurchOrdItem.DocumentCurrency,
      @EndUserText.label: 'Purchase Order Quantity Unit'
      PurchOrdSch.PurchaseOrderQuantityUnit,      
      PurchOrdSch.RoughGoodsReceiptQty,
      //

      //    PurchOrdItem._BaseUnit,

      //    PurchOrdItem._Material,

      //

      @Semantics.quantity : true
      cast ( 0  as mb_erfmg )                                                 as ReturnQuantity,
      cast ( '' as mb_grbew )                                                 as ReasonforReturn

      //_PurReturnReasonText

      //    PRItemExtension,    //PR Item Extension

      //    _PurDocItemExtension //Purchasing Document Item Extension

}                                             
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_POITEMDELIVERYSCHEDULECOUNT",
"I_MATERIALTEXT",
"I_PURCHASEORDER",
"P_POSCHEDULELINEFORRETURNDEL",
"P_PURDOCITMFORRETURNDEL",
"P_PURREQITMFORRETURNDEL"
],
"ASSOCIATED":
[
"E_PURCHASEREQUISITIONITEM",
"E_PURCHASINGDOCUMENT",
"E_PURCHASINGDOCUMENTITEM",
"I_MATERIALTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/