P_PPMGOODMATERIALDOCUMNET

CDS View

Good Material Document for PPM

P_PPMGOODMATERIALDOCUMNET is a CDS View in S/4HANA. Good Material Document for PPM. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_PPMQualityNotification view from CONSUMPTION Parts Per Million Quality Notif.
P_ReturnDeliveryConfgnBased view from CONSUMPTION Return Delivery in PPM 
@AbapCatalog.sqlViewName: 'PPPMGOODMATDOC'
@EndUserText.label: 'Good Material Document for PPM'
@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

define view P_PPMGoodMaterialDocumnet 
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 = 'S' and GoodsMovement.IsReversalMovementType is initial
  and GoodsMovement.GoodsMovementType = MatDoc.GoodsMovementType
  
 association[1..1] to  I_QltyNotification                                                                             as QualityNotification on  
//  MatDoc.PurchaseOrder = QualityNotification.PurchasingDocument and

//  MatDoc.PurchaseOrderItem = QualityNotification.PurchasingDocumentItem

                                                                                                                                          MatDoc.MaterialDocument     = QualityNotification.MaterialDocument
                                                                                                                                          and MatDoc.MaterialDocumentItem = QualityNotification.MaterialDocumentItem
                                                                                                                                          and MatDoc.MaterialDocumentYear = QualityNotification.MaterialDocumentYear                                                                                                               
  
                                                                                                                
{
key MatDoc.MaterialDocument as MaterialDocument,
  key MatDoc.MaterialDocumentItem,
  key MatDoc.MaterialDocumentYear,
      MatDoc.Supplier,
      MatDoc.PurchasingGroup,
      MatDoc.PurchasingOrganization,
      MatDoc.Material,
      MatDoc.MaterialGroup,
      MatDoc.Plant, 
      PurchaseOrder,
      PurchaseOrderItem,
      OrderQuantityUnit,
      MatDoc.GoodsMovementType,
      PostingDate,
      GoodsReceiptQtyInOrderUnit,
      OrderItemQtyToBaseQtyDnmntr,
      OrderItemQtyToBaseQtyNmrtr,      
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
        cast(case
                when OrderItemQtyToBaseQtyNmrtr = 0
                then 0
                else DIVISION(OrderItemQtyToBaseQtyDnmntr,OrderItemQtyToBaseQtyNmrtr, 3 )
                * QualityNotification.NotificationComplaintQuantity
                end
       as rkmng)                                                 as NotificationComplaintQuantity

}

Learn More