P_MATDOCREC

CDS View

P_MATDOCREC is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_EnhPhysInvtryActvStkSep view left_outer COMPOSITE 
@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'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIALDOCUMENTRECORD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More