P_MaterialDocumentPPMRecords

DDL: P_MATERIALDOCUMENTPPMRECORDS SQL: PMATDOCPPMRCD Type: view CONSUMPTION

PPM Material Document Records

P_MaterialDocumentPPMRecords is a Consumption CDS View that provides data about "PPM Material Document Records" in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 13 fields with key fields MaterialDocument, MaterialDocumentItem, MaterialDocumentYear.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentRecord MatDoc from

Parameters (2)

NameTypeDefault
P_StartDate bedat
P_EndDate bedat

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PMATDOCPPMRCD 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 PPM Material Document Records view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument MaterialDocument
KEY MaterialDocumentItem MaterialDocumentItem
KEY MaterialDocumentYear MaterialDocumentYear
Supplier Supplier
Material I_MaterialDocumentRecord Material
Plant I_MaterialDocumentRecord Plant
PurchaseOrder I_MaterialDocumentRecord PurchaseOrder
PurchaseOrderItem I_MaterialDocumentRecord PurchaseOrderItem
GoodsReceiptQtyInOrderUnit GoodsReceiptQtyInOrderUnit
OrderQuantityUnit OrderQuantityUnit
GoodsMovementType GoodsMovementType
PostingDate PostingDate
IsReversalMovementType IsReversalMovementType 
@AbapCatalog.sqlViewName: 'PMATDOCPPMRCD'
@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 Records'
define view P_MaterialDocumentPPMRecords
 with parameters

    P_StartDate : bedat,

    //@Consumption.hidden: true

    P_EndDate   : bedat
  as select from I_MaterialDocumentRecord as MatDoc


{

  key MaterialDocument,
  key MaterialDocumentItem,
  key MaterialDocumentYear,
      Supplier,
      MatDoc.Material,
      MatDoc.Plant,
      MatDoc.PurchaseOrder,
      MatDoc.PurchaseOrderItem,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'  
      GoodsReceiptQtyInOrderUnit,
      @Semantics.unitOfMeasure: true
      OrderQuantityUnit,
      GoodsMovementType,
      PostingDate,
      IsReversalMovementType
}
where
       PostingDate                          >= $parameters.P_StartDate
  and  PostingDate                          <= $parameters.P_EndDate
  and  MatDoc.GoodsMovementIsCancelled      =  ''
  and(
       MatDoc.GoodsMovementCancellationType =  ''
    or MatDoc.GoodsMovementCancellationType =  '1'
  )
  and  MatDoc.PurchaseOrder                 <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIALDOCUMENTRECORD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More