CDS标准视图：技术对象检验级别描述 I_TechObjInspectionLevelText

@AbapCatalog: {
  sqlViewName: 'ITECHOBJINSPLVLT',
  compiler.compareFilter: true,
  preserveKey: true
}

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Technical Object Inspection Level - Text'

@ObjectModel: {
  usageType:
  {
     dataClass: #META,
     serviceQuality: #A,
     sizeCategory: #S
  },
  dataCategory: #TEXT,
  modelingPattern: #NONE,
  representativeKey: 'TechObjInspectionLevelCode',
  supportedCapabilities: [#SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET,#EXTRACTION_DATA_SOURCE]
}

@VDM.viewType: #BASIC

@ClientHandling.algorithm: #SESSION_VARIABLE

@Analytics.dataExtraction.enabled: true

@Metadata.ignorePropagatedAnnotations: true

define view I_TechObjInspectionLevelText
  as select from dd07t
  association [0..1] to I_Language  as _Language on $projection.Language = _Language.Language

{
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key ddlanguage   as Language,
  key cast(dd07t.domvalue_l as eame_idms_type) as TechObjInspectionLevelCode,

      @Semantics.text: true
      dd07t.ddtext as TechObjInspectionLevelDesc,
      _Language

}
where
      dd07t.domname  = 'EAM_IDMS_TYPE_D'
  and dd07t.as4local = 'A'
  and dd07t.as4vers = '0000'