C_Purchaseorderitemcount

DDL: C_PURCHASEORDERITEMCOUNT SQL: CVPOITEMCOUNT Type: view CONSUMPTION

Count of Purchase Order Item

C_Purchaseorderitemcount is a Consumption CDS View that provides data about "Count of Purchase Order Item" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderItem) and exposes 7 fields with key fields PurchaseOrder, PurchaseOrderItem.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderItem I_PurchaseOrderItem from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CVPOITEMCOUNT view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Count of Purchase Order Item view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
NumberOfPurchaseOrderItems
PurchaseOrderType _PurchaseOrder PurchaseOrderType
PurchasingOrganization _PurchaseOrder PurchasingOrganization
PurchasingGroup _PurchaseOrder PurchasingGroup
Plant Plant 
@AbapCatalog.sqlViewName: 'CVPOITEMCOUNT'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@EndUserText.label: 'Count of Purchase Order Item'
define view C_Purchaseorderitemcount
  as select from I_PurchaseOrderItem


{
  key PurchaseOrder,
  key PurchaseOrderItem,
  cast( 1 as  mm_a_contractitems ) as NumberOfPurchaseOrderItems,
  @UI.hidden: true
  _PurchaseOrder.PurchaseOrderType,
  @UI.hidden: true
  _PurchaseOrder.PurchasingOrganization,
  @UI.hidden: true
  _PurchaseOrder.PurchasingGroup,
  @UI.hidden: true
  Plant

}
where
      PurchasingDocumentDeletionCode = ''

  and IsCompletelyDelivered          = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDER",
"I_PURCHASEORDERITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More