C_MM_PlantValueHelp

DDL: C_MM_PLANTVALUEHELP SQL: CMMPLANT_VH Type: view CONSUMPTION

Plant Value Help

C_MM_PlantValueHelp is a Consumption CDS View that provides data about "Plant Value Help" in SAP S/4HANA. It reads from 1 data source (I_Plant) and exposes 8 fields with key fields Plant, PurchasingOrganization. It has 1 association to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_Plant Plant from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_PlantPurchasingOrganization _PlantPurchasingOrganization $projection.Plant = _PlantPurchasingOrganization.Plant

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CMMPLANT_VH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Plant Value Help view
ObjectModel.dataCategory #TEXT view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Plant I_Plant Plant
KEY PurchasingOrganization _PlantPurchasingOrganization PurchasingOrganization Purchasing Organization
PlantName I_Plant PlantName
PurchasingOrganizationName Purchasing Organization Name
CityName _Address CityName
PostalCode _Address PostalCode
_PlantPurchasingOrganization _PlantPurchasingOrganization
_PurchasingOrganization _PlantPurchasingOrganization _PurchasingOrganization 
@AbapCatalog.sqlViewName: 'CMMPLANT_VH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@ObjectModel.semanticKey: [ 'Plant', 'PurchasingOrganization' ]
@ObjectModel.representativeKey: [ 'Plant', 'PurchasingOrganization' ]
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Plant Value Help'
@ObjectModel.dataCategory: #TEXT
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED

define view C_MM_PlantValueHelp
  as select from I_Plant as Plant

  association [1..*] to I_PlantPurchasingOrganization as _PlantPurchasingOrganization on $projection.Plant = _PlantPurchasingOrganization.Plant

  //association [0..*] to I_MaterialPlant as _MaterialPlant

  //    on $projection.Plant = _MaterialPlant.Plant


  //association [0..*] to I_MaterialText as _MaterialText

  //   on $projection.Material = _MaterialText.Material


{

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

      @ObjectModel.text.element:  [ 'PurchasingOrganizationName' ]
      @ObjectModel.foreignKey.association: '_PurchasingOrganization'
      @Search: { defaultSearchElement: true, ranking: #MEDIUM }
      @EndUserText.quickInfo: 'Purchasing Organization'
      @EndUserText.label: 'Purchasing Organization'
  key _PlantPurchasingOrganization.PurchasingOrganization                             as PurchasingOrganization,

      //@Search: { defaultSearchElement: true, ranking: #MEDIUM }

      //@ObjectModel.foreignKey.association: '_MaterialPlant'

      //@ObjectModel.text.association: '_MaterialText'

      //key _MaterialPlant.Material as Material,

      //_MaterialPlant,

      //  _MaterialText,


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

     // @Semantics.text: true

      @Search: { defaultSearchElement: true, ranking: #MEDIUM }
       @EndUserText.quickInfo: 'Purchasing Organization Name'
       @EndUserText.label: 'Purchasing Organization Name'
      _PlantPurchasingOrganization._PurchasingOrganization.PurchasingOrganizationName as PurchasingOrganizationName,

      @Search: { defaultSearchElement: true, ranking: #LOW }
      _Address.CityName,

      @Search: { defaultSearchElement: true, ranking: #LOW }
      _Address.PostalCode,

      _PlantPurchasingOrganization,

      _PlantPurchasingOrganization._PurchasingOrganization                            as _PurchasingOrganization

}     
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_PLANT",
"I_PLANTPURCHASINGORGANIZATION",
"I_PURCHASINGORGANIZATION"
],
"ASSOCIATED":
[
"I_PLANTPURCHASINGORGANIZATION",
"I_PURCHASINGORGANIZATION"
],
"BASE":
[
"I_PLANTPURCHASINGORGANIZATION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More