C_MM_MatlBatchValueHelp

DDL: C_MM_MATLBATCHVALUEHELP SQL: CMMMATLBCH_VH Type: view CONSUMPTION

Material Batch Value Help

C_MM_MatlBatchValueHelp is a Consumption CDS View that provides data about "Material Batch Value Help" in SAP S/4HANA. It reads from 1 data source (mch1) and exposes 4 fields with key fields Material, Batch. It has 2 associations to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
mch1 mch1 from

Associations (2)

CardinalityTargetAliasCondition
[1] I_Material _Material $projection.Material = _Material.Material
[0..1] I_MaterialText _Text $projection.Material = _Text.Material and _Text.Language = $session.system_language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CMMMATLBCH_VH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
Consumption.ranked true view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view
EndUserText.label Material Batch Value Help view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Material matnr
KEY Batch charg
_Material _Material
_Text _Text 
@AbapCatalog.sqlViewName: 'CMMMATLBCH_VH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@Consumption.ranked: true
@ObjectModel.dataCategory: #VALUE_HELP
@Search.searchable: true
@ObjectModel.semanticKey: [ 'Material', 'Batch' ]
@ObjectModel.representativeKey: [ 'Material', 'Batch' ]
@EndUserText.label: 'Material Batch Value Help'

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #M
@ObjectModel.usageType.dataClass: #MASTER

define view C_MM_MatlBatchValueHelp
  as select from mch1

  association [1] to I_Material as _Material on $projection.Material = _Material.Material
  association [0..1] to I_MaterialText  as _Text  on $projection.Material = _Text.Material and
                                                     _Text.Language       = $session.system_language

{

      @ObjectModel.foreignKey.association: '_Material'
      @ObjectModel.text.association: '_Text'
      @Search: { defaultSearchElement: true, ranking: #HIGH }
      @UI.lineItem: [{ position: 20 }]
      @UI.selectionField: [{ position: 20 }]
  key matnr as Material,

      @Search: { defaultSearchElement: true, ranking: #HIGH }
      @UI.lineItem: [{ position: 10 }]
      @UI.selectionField: [{ position: 10 }]
  key charg as Batch,
  
       @Consumption.hidden: true
      _Material,
      @Consumption.hidden: true
      _Text

}   
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"MCH1"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_MATERIALTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More