R_PPS_PurContrDocHistory

DDL: R_PPS_PURCONTRDOCHISTORY Type: view_entity TRANSACTIONAL

PPS Purchase Contract History Document

R_PPS_PurContrDocHistory is a Transactional CDS View that provides data about "PPS Purchase Contract History Document" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContractHistory) and exposes 26 fields with key fields PurchaseContract, PurchaseContractItem, ReleaseOrder, ReleaseOrderItem. It has 3 associations to related views.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContractHistory I_PurchaseContractHistory from

Associations (3)

CardinalityTargetAliasCondition
[0..*] R_PPS_PurchaseContractTP _PurchaseContract $projection.PurchaseContract = _PurchaseContract.ActivePurchasingDocument
[0..1] R_PPS_PurchaseOrderTP _PurchaseOrder $projection.ReleaseOrder = _PurchaseOrder.PurchaseOrder
[0..1] R_PPS_PurchaseOrderItemTP _PurchaseOrderItem $projection.ReleaseOrder = _PurchaseOrderItem.PurchaseOrder and $projection.ReleaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label PPS Purchase Contract History Document view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract
KEY PurchaseContractItem PurchaseContractItem
KEY ReleaseOrder ReleaseOrder
KEY ReleaseOrderItem ReleaseOrderItem
ReleaseOrderItemOrderQuantity ReleaseOrderItemOrderQuantity
ReleaseOrderItemNetAmount ReleaseOrderItemNetAmount
ReleaseOrderItemIsDeleted ReleaseOrderItemIsDeleted
PurchasingHistoryCategory
ReleaseOrderDate ReleaseOrderDate
ReleaseOrderItemQuantityUnit ReleaseOrderItemQuantityUnit
ReleaseOrderCurrency ReleaseOrderCurrency
ReleaseOrderItemLastChgDate ReleaseOrderItemLastChgDate
ExchangeRate ExchangeRate
CompanyCode CompanyCode
Plant Plant
PurchasingOrganization PurchasingOrganization
PPSPurOrderItemStatus _PurchaseOrderItem PPSPurOrderItemStatus
PPSPurOrderItemStatusText _PurchaseOrderItem PPSPurOrderItemStatusText
PurgConfigurableItemNumber _PurchaseOrderItem PurgConfigurableItemNumber
PPSPurOrdItemStatusCriticality _PurchaseOrderItem PPSPurOrdItemStatusCriticality
PurgDocChangeRequestStatus _PurchaseOrder PurgDocChangeRequestStatus
_PurchaseOrder _PurchaseOrder
_PurchaseContract _PurchaseContract
_PurchaseOrderItem _PurchaseOrderItem
_ReleaseOrderCurrency _ReleaseOrderCurrency
_ReleaseOrderItemQuantityUnit _ReleaseOrderItemQuantityUnit 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'PPS Purchase Contract History Document'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel:{
    usageType:{
      serviceQuality: #X,
      sizeCategory: #XL,
      dataClass: #MIXED
        }
  }

@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}
//@JIRA-KEY<S4PPS-5303>

define view entity R_PPS_PurContrDocHistory
  as select from I_PurchaseContractHistory
  association [0..*] to R_PPS_PurchaseContractTP  as _PurchaseContract  on  $projection.PurchaseContract = _PurchaseContract.ActivePurchasingDocument
  association [0..1] to R_PPS_PurchaseOrderTP     as _PurchaseOrder     on  $projection.ReleaseOrder = _PurchaseOrder.PurchaseOrder
  association [0..1] to R_PPS_PurchaseOrderItemTP as _PurchaseOrderItem on  $projection.ReleaseOrder     = _PurchaseOrderItem.PurchaseOrder
                                                                        and $projection.ReleaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
{


  key PurchaseContract,
  key PurchaseContractItem,
      @ObjectModel.foreignKey.association: '_PurchaseOrder'
  key ReleaseOrder,
  key ReleaseOrderItem,
      @Semantics.quantity.unitOfMeasure: 'ReleaseOrderItemQuantityUnit'
      ReleaseOrderItemOrderQuantity,
      
      @Semantics.amount.currencyCode: 'ReleaseOrderCurrency'
      ReleaseOrderItemNetAmount,
      @Semantics.booleanIndicator: true
      ReleaseOrderItemIsDeleted,
      
      cast( cast ('C' as bewtp )as char1 )  as PurchasingHistoryCategory,

      @Semantics.businessDate.at
      ReleaseOrderDate,

      ReleaseOrderItemQuantityUnit,

      ReleaseOrderCurrency,

      @Semantics.businessDate.at: true
      ReleaseOrderItemLastChgDate,

      ExchangeRate,

      CompanyCode,

      Plant,

      PurchasingOrganization,
       @ObjectModel.text.element: [ 'PPSPurOrderItemStatusText' ]
      _PurchaseOrderItem.PPSPurOrderItemStatus,
      @Semantics.text: true
      _PurchaseOrderItem.PPSPurOrderItemStatusText,

      _PurchaseOrderItem.PurgConfigurableItemNumber,
      
      _PurchaseOrderItem.PPSPurOrdItemStatusCriticality,
      
      _PurchaseOrder.PurgDocChangeRequestStatus,
      

      //Associations

      _PurchaseOrder,
      _PurchaseContract,
      _PurchaseOrderItem,
      _ReleaseOrderCurrency,
      _ReleaseOrderItemQuantityUnit

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASECONTRACTHISTORY",
"R_PPS_PURCHASEORDERITEMTP",
"R_PPS_PURCHASEORDERTP"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_UNITOFMEASURE",
"R_PPS_PURCHASECONTRACTTP",
"R_PPS_PURCHASEORDERITEMTP",
"R_PPS_PURCHASEORDERTP"
],
"BASE":
[
"I_PURCHASECONTRACTHISTORY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More