P_PurchaseOrderHisTimVar

DDL: P_PURCHASEORDERHISTIMVAR SQL: PMMPURPOHISTV Type: view CONSUMPTION

Purchase Order History for time Variance

P_PurchaseOrderHisTimVar is a Consumption CDS View that provides data about "Purchase Order History for time Variance" 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

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PMMPURPOHISTV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Purchase Order History for time Variance view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.private true view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument _POHistory MaterialDocument
KEY MaterialDocumentItem _POHistory MaterialDocumentItem
KEY MaterialDocumentYear _POHistory MaterialDocumentYear
ReferenceDocument _POHistory ReferenceDocument
ReferenceDocumentItem _POHistory ReferenceDocumentItem
ReferenceDocumentFiscalYear _POHistory ReferenceDocumentFiscalYear
Quantity _POHistory Quantity 
@AbapCatalog.sqlViewName: 'PMMPURPOHISTV'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true 
@EndUserText.label: 'Purchase Order History for time Variance'
@ClientHandling.algorithm: #SESSION_VARIABLE   
@VDM.viewType : #CONSUMPTION
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.private : true 
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view P_PurchaseOrderHisTimVar as select from I_PurchaseOrderHistory _POHistory {
  key _POHistory.MaterialDocument,
  key _POHistory.MaterialDocumentItem,
  key _POHistory.MaterialDocumentYear,
  _POHistory.ReferenceDocument,
    _POHistory.ReferenceDocumentItem, 
   _POHistory.ReferenceDocumentFiscalYear,
   _POHistory.Quantity  
   
}where PurchaseOrderTransactionType = '1' and _POHistory.DebitCreditCode = 'H'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDERHISTORY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More