P_PPMQualityNotification

DDL: P_PPMQUALITYNOTIFICATION SQL: PPPMQUALNOTIF Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS

Parts Per Million Quality Notif.

P_PPMQualityNotification is a Consumption CDS View that provides data about "Parts Per Million Quality Notif." in SAP S/4HANA. It reads from 2 data sources (P_PPMGoodMaterialDocumnet, I_QltyNotification) and exposes 15 fields with key fields MaterialDocument, MaterialDocumentItem, MaterialDocumentYear. Part of development package ODATA_MM_ANALYTICS.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
P_PPMGoodMaterialDocumnet P_PPMGoodMaterialDocumnet from
I_QltyNotification QualityNotification inner

Parameters (2)

NameTypeDefault
P_StartDate bedat
P_EndDate bedat

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPPMQUALNOTIF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.private true view
VDM.viewType #CONSUMPTION view
EndUserText.label Parts Per Million Quality Notif. view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument MaterialDocument MaterialDocument
KEY MaterialDocumentItem MaterialDocument MaterialDocumentItem
KEY MaterialDocumentYear MaterialDocument MaterialDocumentYear
Supplier MaterialDocument Supplier
PurchasingGroup MaterialDocument PurchasingGroup
PurchasingOrganization MaterialDocument PurchasingOrganization
Material MaterialDocument Material
MaterialGroup MaterialDocument MaterialGroup
Plant MaterialDocument Plant
PurchaseOrder PurchaseOrder
PurchaseOrderItem PurchaseOrderItem
GoodsReceiptQtyInOrderUnit MaterialDocument GoodsReceiptQtyInOrderUnit
OrderQuantityUnit OrderQuantityUnit
GoodsMovementType MaterialDocument GoodsMovementType
PostingDate PostingDate 
@AbapCatalog.sqlViewName: 'PPPMQUALNOTIF'
@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: 'Parts Per Million Quality Notif.'
define view P_PPMQualityNotification

  with parameters

    P_StartDate : bedat,
    P_EndDate   : bedat
  as select from    P_PPMGoodMaterialDocumnet(P_StartDate: $parameters.P_StartDate,
                                                                                P_EndDate : $parameters.P_EndDate) as MaterialDocument

    inner join  I_QltyNotification                                                                             as QualityNotification on  MaterialDocument.MaterialDocument     = QualityNotification.MaterialDocument
                                                                                                                                          and MaterialDocument.MaterialDocumentItem = QualityNotification.MaterialDocumentItem
                                                                                                                                          and MaterialDocument.MaterialDocumentYear = QualityNotification.MaterialDocumentYear

{

  key MaterialDocument.MaterialDocument                                   as MaterialDocument,
  key MaterialDocument.MaterialDocumentItem,
  key MaterialDocument.MaterialDocumentYear,
      MaterialDocument.Supplier,
      MaterialDocument.PurchasingGroup,
      MaterialDocument.PurchasingOrganization,
      MaterialDocument.Material,
      MaterialDocument.MaterialGroup,
      MaterialDocument.Plant,
      PurchaseOrder,
      PurchaseOrderItem,
      // Converting NotificationComplaintQuantity (in base unit) to OrderUnit

      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
        cast(case
                when OrderItemQtyToBaseQtyNmrtr = 0
                then 0
                else DIVISION(OrderItemQtyToBaseQtyDnmntr,OrderItemQtyToBaseQtyNmrtr, 3 )
                * QualityNotification.NotificationComplaintQuantity
                end
       as rkmng)                                                 as NotificationComplaintQuantity,      
      MaterialDocument.GoodsReceiptQtyInOrderUnit,
      OrderQuantityUnit,
      MaterialDocument.GoodsMovementType,
      PostingDate

}

Learn More