P_HistoryMigration

DDL: P_HISTORYMIGRATION SQL: PMMHISTMIG Type: view CONSUMPTION

PO History for Migration Report

P_HistoryMigration is a Consumption CDS View that provides data about "PO History for Migration Report" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderHistory) and exposes 7 fields with key fields MaterialDocument, MaterialDocumentItem, MaterialDocumentYear.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderHistory I_PurchaseOrderHistory from

Parameters (1)

NameTypeDefault
P_PurchaseOrder ebeln

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMMHISTMIG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label PO History for Migration Report view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument MaterialDocument
KEY MaterialDocumentItem MaterialDocumentItem
KEY MaterialDocumentYear MaterialDocumentYear
ReferenceDocument ReferenceDocument
ReferenceDocumentItem ReferenceDocumentItem
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear
Quantity Quantity 
@AbapCatalog.sqlViewName: 'PMMHISTMIG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'PO History for Migration Report'
define view P_HistoryMigration
  with parameters
    P_PurchaseOrder     : ebeln

  as select from I_PurchaseOrderHistory
{
  key MaterialDocument,
  key MaterialDocumentItem,
  key MaterialDocumentYear,
      ReferenceDocument,
      ReferenceDocumentItem,
      ReferenceDocumentFiscalYear,
      Quantity
}
where
      PurchaseOrderTransactionType = '1'
  and DebitCreditCode              = 'H'
  and PurchaseOrder                = $parameters.P_PurchaseOrder
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDERHISTORY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More