P_PurchContractHistory

DDL: P_PURCHCONTRACTHISTORY SQL: PPURCTRHIST Type: view CONSUMPTION

Private View For Purchase Contract History

P_PurchContractHistory is a Consumption CDS View that provides data about "Private View For Purchase Contract History" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContractHistory) and exposes 5 fields with key fields PurchaseContract, PurchaseContractItem.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContractHistory I_PurchaseContractHistory from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PPURCTRHIST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Private View For Purchase Contract History view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract
KEY PurchaseContractItem PurchaseContractItem
ReleaseOrderItemOrderQuantity ReleaseOrderItemOrderQuantity
ReleaseOrderItemQuantityUnit ReleaseOrderItemQuantityUnit
ReleaseOrderCurrency ReleaseOrderCurrency 
@AbapCatalog.sqlViewName: 'PPURCTRHIST'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Private View For Purchase Contract History'
@VDM.private: true
@VDM.viewType: #CONSUMPTION

//*********************************************************//

//                 DEPRECATED                              //

//                 DO NOT USE                              //

//*********************************************************//



define view P_PurchContractHistory as select from I_PurchaseContractHistory

association[1..1] to I_PurchaseContractItem as _PurchaseContractItem on $projection.PurchaseContract = _PurchaseContractItem.PurchaseContract
                                                                   and   $projection.PurchaseContractItem = _PurchaseContractItem.PurchaseContractItem
                                                                   and _PurchaseContractItem.DocumentCurrency != ''

association[1..1] to I_PurchaseContract as _PurchaseContract on $projection.PurchaseContract = _PurchaseContract.PurchaseContract
                                                                  

{

  key PurchaseContract,
  
  key PurchaseContractItem,
  

  cast( currency_conversion(  amount => ReleaseOrderItemNetAmount,
                                            source_currency => ReleaseOrderCurrency,                                          
                                            target_currency => _PurchaseContractItem.DocumentCurrency ,
                                            exchange_rate_date => ReleaseOrderDate, 
                                            error_handling => 'SET_TO_NULL ')
     as bprei)   as   ReleaseOrderItemNetAmount, 
 
 
  ReleaseOrderItemOrderQuantity,
 
  
  @Semantics.unitOfMeasure: true
  ReleaseOrderItemQuantityUnit,
    
  @Semantics.currencyCode:true
  ReleaseOrderCurrency

  
 } where ReleaseOrderItemIsDeleted = ' '     
 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASECONTRACTHISTORY",
"I_PURCHASECONTRACTITEM"
],
"ASSOCIATED":
[
"I_PURCHASECONTRACT",
"I_PURCHASECONTRACTITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More