P_MatDocRec

DDL: P_MATDOCREC SQL: PMATDOCREC Type: view COMPOSITE

P_MatDocRec is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 19 fields.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentRecord MatDoc from

Annotations (7)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PMATDOCREC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (19)

KeyFieldSource TableSource FieldDescription
MaterialDocumentYear I_MaterialDocumentRecord MaterialDocumentYear
MaterialDocument I_MaterialDocumentRecord MaterialDocument
MaterialDocumentItem I_MaterialDocumentRecord MaterialDocumentItem
StockIdentifyingMaterial StockIdentifyingMaterial
Plant I_MaterialDocumentRecord Plant
StockIdfgStorageLocation StockIdfgStorageLocation
StockIdentifyingBatch StockIdentifyingBatch
SpecialStockIdfgSupplier SpecialStockIdfgSupplier
SpecialStockIdfgSalesOrder SpecialStockIdfgSalesOrder
SpecialStockIdfgSalesOrderItem SpecialStockIdfgSalesOrderItem
SpecialStockIdfgWBSElement SpecialStockIdfgWBSElement
SpecialStockIdfgCustomer SpecialStockIdfgCustomer
InventorySpecialStockType I_MaterialDocumentRecord InventorySpecialStockType
InventoryStockType InventoryStockType
SpecialStockIdfgStockOwner SpecialStockIdfgStockOwner
PostingDate I_MaterialDocumentRecord PostingDate
MaterialBaseUnit I_MaterialDocumentRecord MaterialBaseUnit
MatlStkChangeQtyInBaseUnit MatlStkChangeQtyInBaseUnit
GoodsMovementType GoodsMovementType 
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PMATDOCREC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.private: true
@VDM.viewType: #COMPOSITE
define view P_MatDocRec
as select from I_MaterialDocumentRecord as MatDoc
{
  MatDoc.MaterialDocumentYear, 
  MatDoc.MaterialDocument, 
  MatDoc.MaterialDocumentItem, 
  StockIdentifyingMaterial, 
  MatDoc.Plant, 
  StockIdfgStorageLocation, 
  StockIdentifyingBatch, 
  SpecialStockIdfgSupplier, 
  SpecialStockIdfgSalesOrder, 
  SpecialStockIdfgSalesOrderItem, 
  SpecialStockIdfgWBSElement,
  SpecialStockIdfgCustomer, 
  MatDoc.InventorySpecialStockType, 
  InventoryStockType, 
  SpecialStockIdfgStockOwner, 
  MatDoc.PostingDate,
  MatDoc.MaterialBaseUnit,
  MatlStkChangeQtyInBaseUnit,
  GoodsMovementType
}
where GoodsMovementIsCancelled      <> 'X'
  and GoodsMovementCancellationType <> '2'
  and GoodsMovementCancellationType <> '3'

Learn More