I_OperationActivityNtwkText

DDL: I_OPERATIONACTIVITYNTWKTEXT SQL: IMPEOANTEXT Type: view BASIC Package: MPE_OAN

Operation Activity Network Text

I_OperationActivityNtwkText is a Basic CDS View that provides data about "Operation Activity Network Text" in SAP S/4HANA. It reads from 1 data source (mpe_oan_t) and exposes 11 fields with key fields OperationActivityNetwork, OpActyNtwkVersionCounter, Language. It has 3 associations to related views. Part of development package MPE_OAN.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
mpe_oan_t OperationActivityNtwkText from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_OpActyNtwkInternalID _OpActyNtwkInternalId $projection.OperationActivityNetwork = _OpActyNtwkInternalId.OperationActivityNetwork -- Operation Activity Network
[1..1] I_OperationActivityNetwork _OpActyNtwk $projection.OperationActivityNetwork = _OpActyNtwk.OperationActivityNetwork and $projection.OpActyNtwkVersionCounter = _OpActyNtwk.OpActyNtwkVersionCounter -- Language
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMPEOANTEXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED 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 OpActyNtwkVersionCounter view
EndUserText.label Operation Activity Network Text view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY OperationActivityNetwork mpe_oan_t id
KEY OpActyNtwkVersionCounter mpe_oan_t version_no
KEY Language mpe_oan_t spras
OperationActivityNetworkName mpe_oan_t text
CreatedByUser mpe_oan_t created_by
CreationDateTime mpe_oan_t created_at
ChangedBy mpe_oan_t changed_by
LastChangeDateTime mpe_oan_t changed_at
Associations_Language
_OpActyNtwkInternalId _OpActyNtwkInternalId
_OpActyNtwk _OpActyNtwk 
@AbapCatalog.sqlViewName: 'IMPEOANTEXT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
  serviceQuality: #A,
  sizeCategory:   #M,
  dataClass:      #META
}
@ObjectModel: {
  dataCategory:      #TEXT,
  semanticKey:       ['OperationActivityNetwork','OpActyNtwkVersionCounter'],
  representativeKey: 'OpActyNtwkVersionCounter'
}
@EndUserText.label: 'Operation Activity Network Text'
define view I_OperationActivityNtwkText
  as select from mpe_oan_t as OperationActivityNtwkText

  -- Operation Activity Network Internal Id
  association [1..1] to I_OpActyNtwkInternalID     as _OpActyNtwkInternalId on  $projection.OperationActivityNetwork = _OpActyNtwkInternalId.OperationActivityNetwork

  -- Operation Activity Network
  association [1..1] to I_OperationActivityNetwork as _OpActyNtwk           on  $projection.OperationActivityNetwork = _OpActyNtwk.OperationActivityNetwork
                                                                            and $projection.OpActyNtwkVersionCounter = _OpActyNtwk.OpActyNtwkVersionCounter
  -- Language
  association [0..1] to I_Language                 as _Language             on  $projection.Language = _Language.Language

{
      @ObjectModel.foreignKey.association: '_OpActyNtwkInternalId'
  key OperationActivityNtwkText.id                     as OperationActivityNetwork,

      @ObjectModel.text.element: 'OpActyNtwkVersionCounter'
      @ObjectModel.foreignKey.association: '_OpActyNtwk'
  key OperationActivityNtwkText.version_no             as OpActyNtwkVersionCounter,

      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
      @ObjectModel.readOnly: true
  key OperationActivityNtwkText.spras                  as Language,

      @Semantics.text: true
      OperationActivityNtwkText.text                   as OperationActivityNetworkName,

      @Semantics.user.createdBy: true
      @ObjectModel.readOnly:true
      OperationActivityNtwkText.created_by             as CreatedByUser,

      // @Semantics.systemDateTime.createdAt: true

      @ObjectModel.readOnly:true
      OperationActivityNtwkText.created_at             as CreationDateTime,

      @Semantics.user.lastChangedBy: true
      @ObjectModel.readOnly:true
      OperationActivityNtwkText.changed_by             as ChangedBy,

      // @Semantics.systemDateTime.lastChangedAt: true

      @ObjectModel.readOnly:true
      OperationActivityNtwkText.changed_at             as LastChangeDateTime,

      -- Associations
      _Language,
      _OpActyNtwkInternalId,
      _OpActyNtwk
}

Learn More