I_OperationActivityText

DDL: I_OPERATIONACTIVITYTEXT SQL: IMPEOATEXT Type: view BASIC

Operation Activity Text

I_OperationActivityText is a Basic CDS View that provides data about "Operation Activity Text" in SAP S/4HANA. It reads from 1 data source (mpe_oa_t) and exposes 11 fields with key fields OperationActivity, OperationActyVersionCounter, Language. It has 3 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
mpe_oa_t OperationActivityText from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_OperationActivityInternalID _OperationActivityInternalId $projection.OperationActivity = _OperationActivityInternalId.OperationActivity -- Operation Activity
[1..1] I_OperationActivity _OperationActivity $projection.OperationActivity = _OperationActivity.OperationActivity and $projection.OperationActyVersionCounter = _OperationActivity.OperationActyVersionCounter -- Language
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMPEOATEXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #META view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey OperationActyVersionCounter view
EndUserText.label Operation Activity Text view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY OperationActivity mpe_oa_t id
KEY OperationActyVersionCounter mpe_oa_t version_no
KEY Language mpe_oa_t spras
OperationActivityName mpe_oa_t text
CreatedByUser mpe_oa_t created_by
CreationDateTime mpe_oa_t created_at
ChangedBy mpe_oa_t changed_by
LastChangeDateTime mpe_oa_t changed_at
Associations_OperationActivityInternalId
_Language _Language
_OperationActivity _OperationActivity 
@AbapCatalog.sqlViewName: 'IMPEOATEXT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
  serviceQuality: #A,
  sizeCategory:   #M,
  dataClass:      #META
}
@ObjectModel: {
  dataCategory:      #TEXT,
  semanticKey:       ['OperationActivity','OperationActyVersionCounter'],
  representativeKey: 'OperationActyVersionCounter'
}
@EndUserText.label: 'Operation Activity Text'
define view I_OperationActivityText
  as select from mpe_oa_t as OperationActivityText

  -- Operation Activity Internal Id
  association [1..1] to I_OperationActivityInternalID as _OperationActivityInternalId on  $projection.OperationActivity = _OperationActivityInternalId.OperationActivity

  -- Operation Activity
  association [1..1] to I_OperationActivity           as _OperationActivity           on  $projection.OperationActivity           = _OperationActivity.OperationActivity
                                                                                      and $projection.OperationActyVersionCounter = _OperationActivity.OperationActyVersionCounter
  -- Language
  association [0..1] to I_Language                    as _Language                    on  $projection.Language = _Language.Language
{
      @ObjectModel.foreignKey.association: '_OperationActivityInternalId'
  key OperationActivityText.id                      as OperationActivity,

      @ObjectModel.foreignKey.association: '_OperationActivity'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_OperationActivityStdVH', element: 'OperationActyVersionCounter' } } ] 
  key OperationActivityText.version_no              as OperationActyVersionCounter,
  
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key OperationActivityText.spras                   as Language,

      @Semantics.text: true
      OperationActivityText.text                    as OperationActivityName,

      @Semantics.user.createdBy: true
      OperationActivityText.created_by              as CreatedByUser,

      // @Semantics.systemDateTime.createdAt: true

      OperationActivityText.created_at              as CreationDateTime,

      @Semantics.user.lastChangedBy: true
      OperationActivityText.changed_by              as ChangedBy,

      // @Semantics.systemDateTime.lastChangedAt: true

      OperationActivityText.changed_at              as LastChangeDateTime,

      -- Associations
      _OperationActivityInternalId,
      _Language,
      _OperationActivity
      
}

Learn More