P_PurchaseContractHistory

DDL: P_PURCHASECONTRACTHISTORY SQL: PMMCONTRHIST Type: view CONSUMPTION

Purchase Contract History

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

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContractHistory ContractHistory from

Annotations (6)

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

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract
KEY PurchaseContractItem PurchaseContractItem
ReleaseOrderDate 
@AbapCatalog.sqlViewName: 'PMMCONTRHIST'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Purchase Contract History'
@VDM.private: true
@VDM.viewType: #CONSUMPTION
//@Search.searchable: true

define view P_PurchaseContractHistory

  as select from I_PurchaseContractHistory as ContractHistory

{
  key PurchaseContract,
  key PurchaseContractItem,

      //@Search: { defaultSearchElement: true, ranking: #HIGH }

      cast( max( ReleaseOrderDate ) as mm_a_latest_release_date )   as ReleaseOrderDate

}
group by
  PurchaseContractItem,
  PurchaseContract
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASECONTRACTHISTORY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More