I_MasterRecipeMaterialCount

DDL: I_MASTERRECIPEMATERIALCOUNT SQL: IMRMATLCNT Type: view_entity COMPOSITE Package: ODATA_PP_MASTER_RECIPE_API

Count of materials per Recipe Group

I_MasterRecipeMaterialCount is a Composite CDS View that provides data about "Count of materials per Recipe Group" in SAP S/4HANA. It reads from 1 data source (C_RecipeAssignedMaterials) and exposes 4 fields with key fields MasterRecipeGroup, MasterRecipe. Part of development package ODATA_PP_MASTER_RECIPE_API.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
C_RecipeAssignedMaterials C_RecipeAssignedMaterials 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 Recipe Group view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY MasterRecipeGroup MasterRecipeGroup
KEY MasterRecipe MasterRecipe
NumberOfProducts Associated Products
Product 
//@AbapCatalog.sqlViewName: 'IMRMATLCNT'

@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 Recipe Group'
define view entity I_MasterRecipeMaterialCount
  as select from C_RecipeAssignedMaterials
  //I_MasterRecipeMaterialAssgmtTP

{
  key MasterRecipeGroup,
  key MasterRecipe,
      @EndUserText.label: 'Associated Products'
      count(*)                                                     as NumberOfProducts,
      cast( cast( '' as abap.char(40) ) as matnr preserving type ) as Product
}

group by
  MasterRecipeGroup,
  MasterRecipe

Learn More