I_MATERIALGROUP

CDS View

Material Group

I_MATERIALGROUP is a CDS View in S/4HANA. Material Group. It contains 1 fields. 14 CDS views read from this table.

Used by 14 CDS view(s) 1 fields

CDS Views using this table (14)

ViewTypeJoinVDMDescription
C_EngSnpshtMaterialGroupVH view from CONSUMPTION Material Group Value Help
C_MassUpdtMatlGrpVH view from CONSUMPTION Material Group Value Help
C_MaterialGroupMalfuncManageVH view from CONSUMPTION Material Group
C_MM_MaterialGroupValueHelp view from CONSUMPTION Material Group Value Help
C_PurOrdMaintainMatlGrpValHelp view from CONSUMPTION PO Maintenance: Value Help for Material Group
C_RealTmeWrkInProcMatlGroupVH view from CONSUMPTION Material Group
C_RevnVarMatlGrpVH view from CONSUMPTION Value help for Material Group
C_SSPMaterialGroupVH view from CONSUMPTION SSP Material Group Value Help
C_VisualMaterialGroupVH view from CONSUMPTION Visual Material Group Value Help
I_CnsldtnMasterData view union_all COMPOSITE Consolidation - Combined Master Data
I_SrcgProjMaterialGroupVH view_entity from BASIC Material Group in Sourcing Project
I_SrcgProjQtnMatGroupVH view_entity from BASIC Material Group in Srcg Project Quotation
I_TripMaterialGroupVH view from BASIC Material Group Value Help
P_CnsldtnMaterialGroup view from COMPOSITE

Fields (1)

KeyField CDS FieldsUsed in Views
KEY MaterialGroup MaterialGroup 3 
@AbapCatalog: {
  sqlViewName: 'IMATGROUP',
  preserveKey: true,
  compiler.compareFilter: true
  }
@Analytics: { dataCategory: #DIMENSION }
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Material Group'
@Search.searchable: true
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'MaterialGroup'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #S
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@Consumption.ranked: true

define view I_MaterialGroup
  as select from t023
  association [0..*] to I_MaterialGroupText as _Text on $projection.MaterialGroup = _Text.MaterialGroup
{
      @ObjectModel.text.association: '_Text'

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key cast(t023.matkl as productgroup preserving type ) as MaterialGroup,
      @UI.hidden: true
      @Consumption.hidden: true
      t023.begru                                        as MaterialAuthorizationGroup,

      _Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T023"
],
"ASSOCIATED":
[
"I_MATERIALGROUPTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More