I_Group2AssetEvaluationKey

DDL: I_GROUP2ASSETEVALUATIONKEY Type: view BASIC

Group 2 Asset Evaluation Key

I_Group2AssetEvaluationKey is a Basic CDS View (Dimension) that provides data about "Group 2 Asset Evaluation Key" in SAP S/4HANA. It reads from 1 data source (t087) and exposes 3 fields with key field Group2AssetEvaluationKey. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
t087 t087 from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_AssetEvaluationKeyText _Text $projection.Group2AssetEvaluationKey = _Text.AssetEvaluationKey and _Text.AssetEvaluationGroup = '2'
[0..*] I_Group2AssetEvaluationKeyText _Group2AssetEvaluationKeyText $projection.Group2AssetEvaluationKey = _Group2AssetEvaluationKeyText.Group2AssetEvaluationKey

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IFIASSETEVALKEY2 view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
Analytics.dataCategory #DIMENSION view
EndUserText.label Group 2 Asset Evaluation Key view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey Group2AssetEvaluationKey view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Group2AssetEvaluationKey t087 ord4x
_Text _Text
_Group2AssetEvaluationKeyText _Group2AssetEvaluationKeyText
@AbapCatalog: {sqlViewName: 'IFIASSETEVALKEY2', preserveKey: true, compiler.compareFilter:true}
@Analytics: { dataCategory: #DIMENSION }
@EndUserText.label: 'Group 2 Asset Evaluation Key'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { representativeKey: 'Group2AssetEvaluationKey',
                usageType.serviceQuality: #A,
                usageType.sizeCategory: #S,
                usageType.dataClass: #CUSTOMIZING,
                modelingPattern: #ANALYTICAL_DIMENSION,
                supportedCapabilities: [#ANALYTICAL_DIMENSION]
              }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

define view I_Group2AssetEvaluationKey
  as select from t087
  association [0..*] to I_AssetEvaluationKeyText       as _Text                         on  $projection.Group2AssetEvaluationKey = _Text.AssetEvaluationKey
                                                                                        and _Text.AssetEvaluationGroup           = '2'
  association [0..*] to I_Group2AssetEvaluationKeyText as _Group2AssetEvaluationKeyText on  $projection.Group2AssetEvaluationKey = _Group2AssetEvaluationKeyText.Group2AssetEvaluationKey
{
      @ObjectModel.text.association: '_Group2AssetEvaluationKeyText'
  key t087.ord4x as Group2AssetEvaluationKey,

      @Consumption.hidden
      _Text,
      _Group2AssetEvaluationKeyText
}
where
  t087.ordnr = '2'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T087"
],
"ASSOCIATED":
[
"I_ASSETEVALUATIONKEYTEXT",
"I_GROUP2ASSETEVALUATIONKEYTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/