I_InspMethVersVH

DDL: I_INSPMETHVERSVH SQL: IIMV__VH1 Type: view COMPOSITE

Inspection Method Version Value Help

I_InspMethVersVH is a Composite CDS View that provides data about "Inspection Method Version Value Help" in SAP S/4HANA. It reads from 1 data source (I_InspectionMethodVersion) and exposes 14 fields with key fields InspectionMethod, InspectionMethodVersion, InspectionMethodPlant.

Data Sources (1)

SourceAliasJoin Type
I_InspectionMethodVersion I_InspectionMethodVersion from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IIMV__VH1 view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey InspectionMethodVersion view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Inspection Method Version Value Help view
Consumption.ranked true view
Search.searchable true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY InspectionMethod InspectionMethod
KEY InspectionMethodVersion InspectionMethodVersion
KEY InspectionMethodPlant InspectionMethodPlant
InspectionMethodStatus InspectionMethodStatus
QltyMstrDataAuthorizationGroup QltyMstrDataAuthorizationGroup
InspectionMethodValidFromDate InspectionMethodValidFromDate
InspectionMethodSearchField InspectionMethodSearchField
InspectorQualification InspectorQualification Inspector Qualification
InspMethInformationField1 InspMethInformationField1
InspMethInformationField2 InspMethInformationField2
InspMethInformationField3 InspMethInformationField3
_InspectionMethodPlant _InspectionMethodPlant
_InspectionMethod _InspectionMethod
_InspectorQualification _InspectorQualification
@AbapCatalog.sqlViewName: 'IIMV__VH1'
@AbapCatalog.compiler.compareFilter: true

@VDM.viewType: #COMPOSITE

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'InspectionMethodVersion'

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

@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: ['_INSPECTIONMETHOD']

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'Inspection Method Version Value Help'

@Consumption.ranked: true
@Search.searchable: true
// Use only within by annotation @Consumption.valueHelpDefinition !!!

define view I_InspMethVersVH
  as select from I_InspectionMethodVersion
{

      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #HIGH
      }
      @ObjectModel.foreignKey.association: '_InspectionMethod'
  key InspectionMethod,

      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #LOW
      }
  key InspectionMethodVersion,

      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #LOW
      }
      @ObjectModel.foreignKey.association: '_InspectionMethodPlant'
  key InspectionMethodPlant,

      @Consumption.hidden: true
      InspectionMethodStatus,
      @Consumption.hidden: true
      QltyMstrDataAuthorizationGroup,

      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #LOW
      }
      @Semantics.businessDate.from: true
      InspectionMethodValidFromDate,

      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #LOW
      }
      InspectionMethodSearchField,

      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #LOW
      }
      @ObjectModel.foreignKey.association: '_InspectorQualification'
      @EndUserText.label: 'Inspector Qualification'
      InspectorQualification,

      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #LOW
      }
      InspMethInformationField1,

      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #LOW
      }
      InspMethInformationField2,

      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #LOW
      }
      InspMethInformationField3,
      @Consumption.hidden: true
      _InspectionMethodPlant,
      @Consumption.hidden: true
      _InspectionMethod,
      @Consumption.hidden: true
      _InspectorQualification
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONMETHODVERSION"
],
"ASSOCIATED":
[
"I_INSPECTIONMETHOD",
"I_INSPECTORQUALIFICATION",
"I_PLANT"
],
"BASE":
[
"I_INSPECTIONMETHODVERSION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/