P_PPMMATERIALDOCUMNET

CDS View

PPM Material Document

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

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_PPMGoodMaterialDocumnet view from CONSUMPTION Good Material Document for PPM
P_PPMReturnDelivery view from CONSUMPTION Return Delivery 
@AbapCatalog.sqlViewName: 'PPPMMATDOC'
@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: 'PPM Material Document'
define view P_PPMMaterialDocumnet
  with parameters

    P_StartDate : bedat,
    P_EndDate   : bedat
  as select from    P_MaterialDocumentPPMRecords(P_StartDate: $parameters.P_StartDate, P_EndDate: $parameters.P_EndDate) as MatDoc
    inner join      P_PoItemFiltered                                                                                  as PurchaseOrderItem on  PurchaseOrderItem.PurchaseOrder     = MatDoc.PurchaseOrder
                                                                                                                                              and PurchaseOrderItem.PurchaseOrderItem = MatDoc.PurchaseOrderItem    

{

  key MatDoc.MaterialDocument,
  key MatDoc.MaterialDocumentItem,
  key MatDoc.MaterialDocumentYear,
      Supplier,
      PurchaseOrderItem.PurchasingGroup,
      PurchaseOrderItem.PurchasingOrganization,
      MatDoc.Material,
      PurchaseOrderItem.MaterialGroup,
      MatDoc.Plant,
      MatDoc.PurchaseOrder,
      MatDoc.PurchaseOrderItem,
      GoodsReceiptQtyInOrderUnit,
      OrderQuantityUnit,
      GoodsMovementType,
      PostingDate,
      IsReversalMovementType,
      OrderItemQtyToBaseQtyNmrtr,
      OrderItemQtyToBaseQtyDnmntr
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_MATERIALDOCUMENTPPMRECORDS",
"P_POITEMFILTERED"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More