I_ProdnRtgMatlCount

DDL: I_PRODNRTGMATLCOUNT SQL: IPRMATLCNT Type: view_entity COMPOSITE

Count of materials per Routing Group

I_ProdnRtgMatlCount is a Composite CDS View that provides data about "Count of materials per Routing Group" in SAP S/4HANA. It reads from 1 data source (I_ProdnRoutingMatlAssgmtTP) and exposes 4 fields with key fields ProductionRoutingGroup, ProductionRouting.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_ProdnRoutingMatlAssgmtTP I_ProdnRoutingMatlAssgmtTP from

Annotations (6)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Count of materials per Routing Group view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ProductionRoutingGroup ProductionRoutingGroup
KEY ProductionRouting ProductionRouting
NumberOfProducts Associated Products
Product 
//@AbapCatalog.sqlViewName: 'IPRMATLCNT'

@VDM.viewType: #COMPOSITE
//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey:true

@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED }
//@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Count of materials per Routing Group'

define view entity I_ProdnRtgMatlCount
  as select from I_ProdnRoutingMatlAssgmtTP
{
  key ProductionRoutingGroup,
  key ProductionRouting,
      @EndUserText.label: 'Associated Products'
      count(*)                                                     as NumberOfProducts,
      cast( cast( '' as abap.char(40) ) as matnr preserving type ) as Product
}

group by
  ProductionRoutingGroup,
  ProductionRouting
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODNROUTINGMATLASSGMTTP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More