I_PurchaseReqnItemCalcFields

DDL: I_PURCHASEREQNITEMCALCFIELDS SQL: IPREQITMUSHCFDS Type: view COMPOSITE

Collection of calculated fields on PR item level

I_PurchaseReqnItemCalcFields is a Composite CDS View that provides data about "Collection of calculated fields on PR item level" in SAP S/4HANA. It reads from 1 data source (I_Purchaserequisitionitem) and exposes 5 fields with key fields PurchaseRequisition, PurchaseRequisitionItem. It has 3 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_Purchaserequisitionitem I_Purchaserequisitionitem from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Purchaserequisition _PurchaseRequisition $projection.PurchaseRequisition = _PurchaseRequisition.PurchaseRequisition
[1..1] I_PurReqUnSchedldItemRelevance _Relevance $projection.PurchaseRequisition = _Relevance.PurchaseRequisition and $projection.PurchaseRequisitionItem = _Relevance.PurchaseRequisitionItem
[1..1] I_Purchaserequisitionitem _PurchaseRequisitionItem $projection.PurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition and $projection.PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPREQITMUSHCFDS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
EndUserText.label Collection of calculated fields on PR item level view
ObjectModel.representativeKey PurchaseRequisitionItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition PurchaseRequisition
KEY PurchaseRequisitionItem PurchaseRequisitionItem
_PurchaseRequisition _PurchaseRequisition
_Relevance _Relevance
_PurchaseRequisitionItem _PurchaseRequisitionItem 
@AbapCatalog.sqlViewName: 'IPREQITMUSHCFDS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Collection of calculated fields on PR item level'

@ObjectModel: {
  semanticKey: [ 'PurchaseRequisition', 'PurchaseRequisitionItem' ],
  representativeKey: 'PurchaseRequisitionItem'
}

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view I_PurchaseReqnItemCalcFields
  as select from I_Purchaserequisitionitem

  association [1..1] to I_Purchaserequisition          as _PurchaseRequisition on  $projection.PurchaseRequisition = _PurchaseRequisition.PurchaseRequisition

  association [1..1] to I_PurReqUnSchedldItemRelevance as _Relevance           on  $projection.PurchaseRequisition     = _Relevance.PurchaseRequisition
                                                                               and $projection.PurchaseRequisitionItem = _Relevance.PurchaseRequisitionItem
  association [1..1] to I_Purchaserequisitionitem as _PurchaseRequisitionItem on $projection.PurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition
                                                                              and $projection.PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem                                                                               
{
      @ObjectModel.foreignKey.association: '_PurchaseRequisition'
  key PurchaseRequisition,
  key PurchaseRequisitionItem,
      
      //Plant, //Added for DCL

      //PurchasingOrganization, //Added for DCL

      //PurchasingGroup, //Added for DCL


      _PurchaseRequisition,
      _Relevance,
      _PurchaseRequisitionItem
}    
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEREQUISITIONITEM"
],
"ASSOCIATED":
[
"I_PURCHASEREQUISITION",
"I_PURCHASEREQUISITIONITEM",
"I_PURREQUNSCHEDLDITEMRELEVANCE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More