C_PurchaseOrderItemSet

DDL: C_PURCHASEORDERITEMSET Type: view CONSUMPTION

Purchase Order Item Set

C_PurchaseOrderItemSet is a Consumption CDS View that provides data about "Purchase Order Item Set" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderItemTP) and exposes 6 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 2 associations to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderItemTP PurchaseOrderItemTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_PurchaseOrderTP _PurchaseOrder _PurchaseOrder.PurchaseOrder = $projection.PurchaseOrder
[1..1] C_PurchaseOrderItemTP _PurchaseOrderItemSetTP _PurchaseOrderItemSetTP.PurchaseOrder = $projection.PurchaseOrder and _PurchaseOrderItemSetTP.PurchaseOrderItem = $projection.PurchaseOrderItem

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CPURITEMSET view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable false view
EndUserText.label Purchase Order Item Set view
VDM.viewType #CONSUMPTION view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.representativeKey PurchaseOrderItem view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrderItemTP PurchaseOrder
KEY PurchaseOrderItem I_PurchaseOrderItemTP PurchaseOrderItem
PurgConfigurableItemNumber I_PurchaseOrderItemTP PurgConfigurableItemNumber
PurchaseOrderItemText I_PurchaseOrderItemTP PurchaseOrderItemText
_PurchaseOrderItemSetTP _PurchaseOrderItemSetTP
_PurchaseOrder _PurchaseOrder 
@AbapCatalog: { sqlViewName: 'CPURITEMSET' }
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@Search.searchable: false
@EndUserText.label: 'Purchase Order Item Set'
@VDM.viewType: #CONSUMPTION
//@ObjectModel.type: #CONSUMPTION 

@ObjectModel: {
  //  semanticKey   : ['PurchaseOrder', 'ArchObjectNumberForEdit'],

    createEnabled : true,
    deleteEnabled : true,
    updateEnabled : true,
    transactionalProcessingDelegated: true,
        semanticKey: ['PurchaseOrder', 'PurchaseOrderItem'],
    representativeKey: 'PurchaseOrderItem'
    
}
define view C_PurchaseOrderItemSet
  as select from I_PurchaseOrderItemTP as PurchaseOrderItemTP                                                                                                           
 association [1..1] to C_PurchaseOrderTP       as _PurchaseOrder             on _PurchaseOrder.PurchaseOrder               = $projection.PurchaseOrder
   association [1..1] to C_PurchaseOrderItemTP   as _PurchaseOrderItemSetTP  on  _PurchaseOrderItemSetTP.PurchaseOrder     = $projection.PurchaseOrder 
                                                                             and _PurchaseOrderItemSetTP.PurchaseOrderItem = $projection.PurchaseOrderItem    
    
{

      @UI.hidden: true
  key PurchaseOrderItemTP.PurchaseOrder,
      
      @UI: {
        lineItem: [
            { position: 10, importance: #HIGH, qualifier: 'HierItem'},
            { type: #FOR_ACTION, qualifier: 'HierItem' }
            ]
      }
      @ObjectModel.sort.enabled: false
      @Search: { defaultSearchElement: false, ranking: #HIGH, fuzzinessThreshold: 0.8 }
      @ObjectModel: { readOnly: true }
  key PurchaseOrderItemTP.PurchaseOrderItem,
      PurchaseOrderItemTP.PurgConfigurableItemNumber,
      PurchaseOrderItemTP.PurchaseOrderItemText,
      _PurchaseOrderItemSetTP,      
      _PurchaseOrder 
  }

Learn More