I_PurchaseContractHistoryAPI01

DDL: I_PURCHASECONTRACTHISTORYAPI01 SQL: IPURCONTRHISTAPI Type: view BASIC

Purchase Contract History

I_PurchaseContractHistoryAPI01 is a Basic CDS View that provides data about "Purchase Contract History" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContractHistory) and exposes 17 fields with key fields PurchaseContract, PurchaseContractItem, ReleaseOrder, ReleaseOrderItem. It has 1 association to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContractHistory I_PurchaseContractHistory from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurchaseContractItemAPI01 _PurchaseContractItemAPI01 $projection.PurchaseContract = _PurchaseContractItemAPI01.PurchaseContract and $projection.PurchaseContractItem = _PurchaseContractItemAPI01.PurchaseContractItem

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPURCONTRHISTAPI view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Contract History view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurchaseContractHistory PurchaseContract
KEY PurchaseContractItem I_PurchaseContractHistory PurchaseContractItem
KEY ReleaseOrder I_PurchaseContractHistory ReleaseOrder
KEY ReleaseOrderItem I_PurchaseContractHistory ReleaseOrderItem
ReleaseOrderItemOrderQuantity I_PurchaseContractHistory ReleaseOrderItemOrderQuantity
ReleaseOrderItemNetAmount I_PurchaseContractHistory ReleaseOrderItemNetAmount
ReleaseOrderItemIsDeleted I_PurchaseContractHistory ReleaseOrderItemIsDeleted
ReleaseOrderDate I_PurchaseContractHistory ReleaseOrderDate
ReleaseOrderItemQuantityUnit I_PurchaseContractHistory ReleaseOrderItemQuantityUnit
ReleaseOrderCurrency I_PurchaseContractHistory ReleaseOrderCurrency
ReleaseOrderItemLastChgDate I_PurchaseContractHistory ReleaseOrderItemLastChgDate
ExchangeRate I_PurchaseContractHistory ExchangeRate
CompanyCode I_PurchaseContractHistory CompanyCode
Plant I_PurchaseContractHistory Plant
PurchasingOrganization I_PurchaseContractHistory PurchasingOrganization
_PurchaseContractAPI01 _PurchaseContractAPI01
_PurchaseContractItemAPI01 _PurchaseContractItemAPI01 
@AbapCatalog.sqlViewName: 'IPURCONTRHISTAPI'
@VDM.viewType : #BASIC
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Purchase Contract History'
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL 
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]

define view I_PurchaseContractHistoryAPI01 as select from I_PurchaseContractHistory
       association[1..1] to I_PurchaseContractAPI01 as _PurchaseContractAPI01 on
       $projection.ReleaseOrder = _PurchaseContractAPI01.PurchaseContract
        
       association [1..1] to I_PurchaseContractItemAPI01 as _PurchaseContractItemAPI01 on
       $projection.PurchaseContract = _PurchaseContractItemAPI01.PurchaseContract and
       $projection.PurchaseContractItem = _PurchaseContractItemAPI01.PurchaseContractItem 
       
{
  key I_PurchaseContractHistory.PurchaseContract, 
  key I_PurchaseContractHistory.PurchaseContractItem, 
  key I_PurchaseContractHistory.ReleaseOrder, 
  key I_PurchaseContractHistory.ReleaseOrderItem, 
  @Semantics.quantity.unitOfMeasure: 'ReleaseOrderItemQuantityUnit'
  I_PurchaseContractHistory.ReleaseOrderItemOrderQuantity, 
  @Semantics.amount.currencyCode: 'ReleaseOrderCurrency'
  I_PurchaseContractHistory.ReleaseOrderItemNetAmount,
  @Semantics.booleanIndicator: true  
  I_PurchaseContractHistory.ReleaseOrderItemIsDeleted, 
  I_PurchaseContractHistory.ReleaseOrderDate, 
  I_PurchaseContractHistory.ReleaseOrderItemQuantityUnit, 
  I_PurchaseContractHistory.ReleaseOrderCurrency, 
  I_PurchaseContractHistory.ReleaseOrderItemLastChgDate, 
  I_PurchaseContractHistory.ExchangeRate, 
  I_PurchaseContractHistory.CompanyCode, 
  I_PurchaseContractHistory.Plant, 
  I_PurchaseContractHistory.PurchasingOrganization,
  _PurchaseContractAPI01,
  _PurchaseContractItemAPI01
}

Learn More