I_PPS_MaterialDocument

DDL: I_PPS_MATERIALDOCUMENT SQL: IPPSXPOMTDC Type: view BASIC

Extended PO History MKPF

I_PPS_MaterialDocument is a Basic CDS View that provides data about "Extended PO History MKPF" in SAP S/4HANA. It reads from 1 data source (matdoc) and exposes 8 fields with key fields PurchasingHistoryDocument, FiscalYear, PurchasingHistoryDocumentItem.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
matdoc MaterialDocument from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPPSXPOMTDC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Extended PO History MKPF view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY PurchasingHistoryDocument matdoc mblnr
KEY FiscalYear matdoc mjahr
KEY PurchasingHistoryDocumentItem matdoc zeile
PPSPurgHistDocumentType matdoc blart
DocumentDate matdoc bldat
PostingDate matdoc budat
PurchasingDocument matdoc ebeln
PurchasingDocumentItem matdoc ebelp 
@AbapCatalog.sqlViewName: 'IPPSXPOMTDC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Extended PO History MKPF'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XXL,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC 
define view I_PPS_MaterialDocument
  as select from matdoc as MaterialDocument


{
  key   MaterialDocument.mblnr as PurchasingHistoryDocument,
  key   MaterialDocument.mjahr as FiscalYear,
  key   MaterialDocument.zeile as PurchasingHistoryDocumentItem,
        MaterialDocument.blart as PPSPurgHistDocumentType,
        MaterialDocument.bldat as DocumentDate,
        MaterialDocument.budat as PostingDate,
        MaterialDocument.ebeln as PurchasingDocument,
        MaterialDocument.ebelp as PurchasingDocumentItem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MATDOC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More