I_BillOfOpsOpWorkCenterCount

DDL: I_BILLOFOPSOPWORKCENTERCOUNT Type: view_entity COMPOSITE Package: ODATA_PP_WORKCENTER_API

Bill of Operations Work Center Count

I_BillOfOpsOpWorkCenterCount is a Composite CDS View that provides data about "Bill of Operations Work Center Count" in SAP S/4HANA. It reads from 1 data source (I_BillOfOpsOpWrkCtrGrouping) and exposes 4 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, AreaOfResponsibility. Part of development package ODATA_PP_WORKCENTER_API.

Data Sources (1)

SourceAliasJoin Type
I_BillOfOpsOpWrkCtrGrouping I_BillOfOpsOpWrkCtrGrouping from

Annotations (6)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Bill of Operations Work Center Count view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID
KEY WorkCenterTypeCode WorkCenterTypeCode
KEY AreaOfResponsibility AreaOfResponsibility
NumberOfBillOfOpsUsdInWrkCtr
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED }
@EndUserText.label: 'Bill of Operations Work Center Count'

define view entity I_BillOfOpsOpWorkCenterCount 
 as select from I_BillOfOpsOpWrkCtrGrouping{
  key WorkCenterInternalID,
  key WorkCenterTypeCode,
  key AreaOfResponsibility,
      count(*) as NumberOfBillOfOpsUsdInWrkCtr
}
group by
  WorkCenterInternalID,
  WorkCenterTypeCode,
  AreaOfResponsibility