C_JITMaterialValueHelp

DDL: C_JITMATERIALVALUEHELP SQL: CJITMAT_VALUEH Type: view CONSUMPTION

Material

C_JITMaterialValueHelp is a Consumption CDS View that provides data about "Material" in SAP S/4HANA. It reads from 1 data source (I_ProductPlant) and exposes 7 fields with key fields Product, Plant. It has 1 association to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_ProductPlant I_ProductPlant from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_JITPlantValueHelp _JITPlantValueHelp $projection.Plant = _JITPlantValueHelp.Plant

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CJITMAT_VALUEH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Material view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey Product view
AbapCatalog.preserveKey true view
ObjectModel.dataCategory #VALUE_HELP view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Consumption.ranked true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Product Product Material
KEY Plant Plant
ProductName Material Name
SerialNumberProfile SerialNumberProfile
_Product _Product
_Plant _Plant
_JITPlantValueHelp _JITPlantValueHelp 
@AbapCatalog.sqlViewName: 'CJITMAT_VALUEH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Material'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MASTER}
@ObjectModel.representativeKey: 'Product'
@AbapCatalog.preserveKey: true
@ObjectModel.dataCategory: #VALUE_HELP
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
@Consumption.ranked: true
define view C_JITMaterialValueHelp
  as select from I_ProductPlant
  association [0..1] to C_JITPlantValueHelp as _JITPlantValueHelp on $projection.Plant = _JITPlantValueHelp.Plant

{
      @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
      //   @ObjectModel.text.element: ['ProductName']

      @EndUserText.label: 'Material'
      @EndUserText.quickInfo: 'Material'
//      @ObjectModel.text.element: ['ProductName']

//      @UI.textArrangement: #TEXT_LAST

  key Product,

      //@Consumption.filter.hidden: true

  key Plant,

      @Semantics.text: true
      @EndUserText.label: 'Material Name'
      @Search:{ defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
      _Product._Text[1:Language = $session.system_language].ProductName,
      
     @UI.hidden: true
     SerialNumberProfile,

      @UI.hidden: true
      @Consumption.filter :{ hidden : true}
      _Product,
      @UI.hidden: true
      @Consumption.filter :{ hidden : true}
      _Plant,
      _JITPlantValueHelp

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCT",
"I_PRODUCTPLANT",
"I_PRODUCTTEXT"
],
"ASSOCIATED":
[
"C_JITPLANTVALUEHELP",
"I_PLANT",
"I_PRODUCT"
],
"BASE":
[
"I_PRODUCTPLANT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More