C_ProdnSupplyAreaWrkCtrCount

DDL: C_PRODNSUPPLYAREAWRKCTRCOUNT Type: view_entity CONSUMPTION

Count of Work Centers use PSA

C_ProdnSupplyAreaWrkCtrCount is a Consumption CDS View that provides data about "Count of Work Centers use PSA" in SAP S/4HANA. It reads from 2 data sources (I_ProductionSupplyArea, I_WorkCenter) and exposes 2 fields with key fields Plant, ProductionSupplyArea.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_ProductionSupplyArea _ProductionSupplyArea from
I_WorkCenter _WorkCenter left_outer

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Count of Work Centers use PSA view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY Plant I_ProductionSupplyArea Plant
KEY ProductionSupplyArea I_ProductionSupplyArea ProductionSupplyArea 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Count of Work Centers use PSA'

@VDM.viewType: #CONSUMPTION

@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #M, dataClass: #MASTER}
@Metadata.ignorePropagatedAnnotations: true

define view entity C_ProdnSupplyAreaWrkCtrCount
  as select from I_ProductionSupplyArea as _ProductionSupplyArea
  left outer join I_WorkCenter as _WorkCenter on  _ProductionSupplyArea.Plant                = _WorkCenter.Plant 
                                              and _ProductionSupplyArea.ProductionSupplyArea = _WorkCenter.SupplyArea 
{  
  key _ProductionSupplyArea.Plant,
  key _ProductionSupplyArea.ProductionSupplyArea,
  
  case 
    when _WorkCenter.Plant is null then 0
    else count(*) 
  end as NumberOfUsagesOfProdnSupArea
}
group by 
  _ProductionSupplyArea.Plant, 
  _ProductionSupplyArea.ProductionSupplyArea, 
  _WorkCenter.Plant
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCTIONSUPPLYAREA",
"I_WORKCENTER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More