C_MaintenancePlannerGroupVH

DDL: C_MAINTENANCEPLANNERGROUPVH SQL: CMAINTPLGRP Type: view CONSUMPTION

Maintenance Planner Group

C_MaintenancePlannerGroupVH is a Consumption CDS View that provides data about "Maintenance Planner Group" in SAP S/4HANA. It reads from 1 data source (I_MaintenancePlannerGroup) and exposes 6 fields with key fields MaintenancePlannerGroup, MaintenancePlanningPlant. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintenancePlannerGroup I_MaintenancePlannerGroup from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Plant _MaintenancePlanningPlant $projection.MaintenancePlanningPlant = _MaintenancePlanningPlant.Plant

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CMAINTPLGRP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Planner Group view
ObjectModel.representativeKey MaintenancePlannerGroup view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #CONSUMPTION view
Search.searchable true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlannerGroup I_MaintenancePlannerGroup MaintenancePlannerGroup
KEY MaintenancePlanningPlant I_MaintenancePlannerGroup MaintenancePlanningPlant
MaintenancePlannerGroupName I_MaintenancePlannerGroup MaintenancePlannerGroupName
MaintPlannerGroupPhoneNumber I_MaintenancePlannerGroup MaintPlannerGroupPhoneNumber
EmailAddress I_MaintenancePlannerGroup EmailAddress
_MaintenancePlanningPlant _MaintenancePlanningPlant
@AbapCatalog.sqlViewName: 'CMAINTPLGRP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Planner Group'
@ObjectModel.representativeKey:  'MaintenancePlannerGroup'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {dataClass: #CUSTOMIZING, serviceQuality: #A, sizeCategory: #S}
@VDM.viewType: #CONSUMPTION
@Search.searchable: true

define view C_MaintenancePlannerGroupVH
  as select from I_MaintenancePlannerGroup
  association [0..1] to I_Plant as _MaintenancePlanningPlant on $projection.MaintenancePlanningPlant = _MaintenancePlanningPlant.Plant
{

      @ObjectModel.text.element:  [ 'MaintenancePlannerGroupName' ]
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key I_MaintenancePlannerGroup.MaintenancePlannerGroup,

      @ObjectModel.foreignKey.association: '_MaintenancePlanningPlant'
      @Consumption.valueHelpDefinition: [{ entity: { name: 'C_MaintenancePlanPlantVH', element: 'MaintenancePlanningPlant' } }]
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
  key I_MaintenancePlannerGroup.MaintenancePlanningPlant,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      I_MaintenancePlannerGroup.MaintenancePlannerGroupName,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Consumption.filter.hidden
      I_MaintenancePlannerGroup.MaintPlannerGroupPhoneNumber,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Consumption.filter.hidden
      I_MaintenancePlannerGroup.EmailAddress,

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