C_MM_ProductionVersValueHelp

DDL: C_MM_PRODUCTIONVERSVALUEHELP SQL: CMMPRODVERS_VH Type: view CONSUMPTION Package: ODATA_MM_COMMONS_VH

Production Version Value Help

C_MM_ProductionVersValueHelp is a Consumption CDS View that provides data about "Production Version Value Help" in SAP S/4HANA. It reads from 1 data source (I_ProductionVersion) and exposes 13 fields with key fields Material, Plant, ProductionVersion. It has 1 association to related views. Part of development package ODATA_MM_COMMONS_VH.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_ProductionVersion I_ProductionVersion from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CMMPRODVERS_VH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.representativeKey ProductionVersion view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Production Version Value Help view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Material Material
KEY Plant Plant
KEY ProductionVersion ProductionVersion
PlantName
ProductionVersionText ProductionVersionText
MaterialMinLotSizeQuantity MaterialMinLotSizeQuantity
MaterialMaxLotSizeQuantity MaterialMaxLotSizeQuantity
MaterialBaseUnit MaterialBaseUnit
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
_MaterialText _MaterialText
_Material _Material
_Plant _Plant 
@AbapCatalog.sqlViewName: 'CMMPRODVERS_VH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@ObjectModel.semanticKey: [ 'Material', 'Plant', 'ProductionVersion']
@ObjectModel.representativeKey: 'ProductionVersion'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Production Version Value Help'
@ClientHandling.algorithm: #SESSION_VARIABLE

define view C_MM_ProductionVersValueHelp
  as select from I_ProductionVersion
  
  association [0..1] to I_MaterialText  as _MaterialText          on $projection.Material = _MaterialText.Material and
                                                                     _MaterialText.Language = $session.system_language
  
{

      @ObjectModel.text.association: '_MaterialText'
      @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7}  
      @ObjectModel.foreignKey.association: '_Material'
  key Material,

      @ObjectModel.text.element:  [ 'PlantName' ]
      @Search: {defaultSearchElement: true, ranking: #HIGH}
      @ObjectModel.foreignKey.association: '_Plant'
  key Plant,

  key ProductionVersion,

      @Semantics.text: true
      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
      I_ProductionVersion._Plant.PlantName          as PlantName,

      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
      ProductionVersionText,

      MaterialMinLotSizeQuantity,

      MaterialMaxLotSizeQuantity,
      
      MaterialBaseUnit,
      

      ValidityStartDate,

      ValidityEndDate,
      
      @Consumption.hidden: true
      _MaterialText,
      @Consumption.hidden: true
      _Material,
      @Consumption.hidden: true
      _Plant

}

Learn More