I_ProdnRtgInspCharcType

DDL: I_PRODNRTGINSPCHARCTYPE Type: view_entity BASIC Package: VDM_PP_MD_RTG

Insp Characteristic Type

I_ProdnRtgInspCharcType is a Basic CDS View (Dimension) that provides data about "Insp Characteristic Type" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field BOOCharacteristicType. It has 1 association to related views. Part of development package VDM_PP_MD_RTG.

Data Sources (1)

SourceAliasJoin Type
dd07l l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ProdnRtgInspCharcTypeText _Text $projection.BOOCharacteristicType = _Text.BOOCharacteristicType

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
ObjectModel.representativeKey BOOCharacteristicType view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #META view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
EndUserText.label Insp Characteristic Type view
Metadata.allowExtensions true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY BOOCharacteristicType
Associations_Text
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@Analytics.dataCategory: #DIMENSION
@Analytics.internalName: #LOCAL
@ObjectModel.representativeKey: 'BOOCharacteristicType'
@ObjectModel.usageType: { serviceQuality: #A, sizeCategory: #M, dataClass: #META }
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE,#ANALYTICAL_DIMENSION]
//@Search.searchable: true

@EndUserText.label: 'Insp Characteristic Type'
@Metadata.allowExtensions:true

define view entity I_ProdnRtgInspCharcType

 as select from dd07l as l
  association [0..*] to I_ProdnRtgInspCharcTypeText as _Text on $projection.BOOCharacteristicType = _Text.BOOCharacteristicType
{
//      @ObjectModel.text.association: '_Text'

  key cast(substring(l.domvalue_l, 1, 1) as qkzeinstmk preserving type) as BOOCharacteristicType,

      --- Associations ---
      _Text
}
where
      l.domname  = 'QKZEINSTMK'
  and l.as4local = 'A'
  and l.as4vers  = '0000';