I_OperationActivityNetwork

DDL: I_OPERATIONACTIVITYNETWORK SQL: IMPEOAN Type: view BASIC

Operation Activity Network

I_OperationActivityNetwork is a Basic CDS View (Dimension) that provides data about "Operation Activity Network" in SAP S/4HANA. It reads from 1 data source (mpe_oan) and exposes 11 fields with key fields OperationActivityNetwork, OpActyNtwkVersionCounter. It has 3 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
mpe_oan OperationActivityNetwork from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_OpActyNtwkInternalID _OpActyNtwkInternalId $projection.OperationActivityNetwork = _OpActyNtwkInternalId.OperationActivityNetwork -- Text
[0..*] I_OperationActivityNtwkText _Text $projection.OperationActivityNetwork = _Text.OperationActivityNetwork and $projection.OpActyNtwkVersionCounter = _Text.OpActyNtwkVersionCounter
[1..1] I_OANSegmentType _OANSegmentType $projection.OpActyNtwkSegmentType = _OANSegmentType.OpActyNtwkSegmentType

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IMPEOAN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.compositionRoot true view
ObjectModel.representativeKey OpActyNtwkVersionCounter view
EndUserText.label Operation Activity Network view
AbapCatalog.preserveKey true view
Metadata.allowExtensions true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY OperationActivityNetwork mpe_oan id
KEY OpActyNtwkVersionCounter mpe_oan version_no
OpActyNtwkSegmentType mpe_oan segment_type
IsReleased mpe_oan released
CreatedByUser mpe_oan created_by
CreationDateTime mpe_oan created_at
ChangedBy mpe_oan changed_by
LastChangeDateTime mpe_oan changed_at
Associations_OpActyNtwkInternalId
_Text _Text
_OANSegmentType _OANSegmentType 
@AbapCatalog.sqlViewName: 'IMPEOAN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@Analytics: {dataCategory: #DIMENSION}
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
  serviceQuality: #A,
  sizeCategory:   #M,
  dataClass:      #MASTER
}
@ObjectModel: {
  compositionRoot:   true,
  semanticKey:       ['OperationActivityNetwork','OpActyNtwkVersionCounter'],
  representativeKey: 'OpActyNtwkVersionCounter'
}
@EndUserText.label: 'Operation Activity Network'
@AbapCatalog.preserveKey:true
@Metadata.allowExtensions:true
define view I_OperationActivityNetwork
  as select from mpe_oan as OperationActivityNetwork

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

  -- Text
  association [0..*] to I_OperationActivityNtwkText as _Text                 on  $projection.OperationActivityNetwork = _Text.OperationActivityNetwork
                                                                             and $projection.OpActyNtwkVersionCounter = _Text.OpActyNtwkVersionCounter
  association [1..1] to I_OANSegmentType            as _OANSegmentType       on  $projection.OpActyNtwkSegmentType = _OANSegmentType.OpActyNtwkSegmentType
{
      @ObjectModel.foreignKey.association: '_OpActyNtwkInternalId'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_OpActyNtwkInternalIDStdVH', element: 'OperationActivityNetwork' } } ]
  key OperationActivityNetwork.id                     as OperationActivityNetwork,

      //      @ObjectModel.text.association: '_Text'

  key OperationActivityNetwork.version_no             as OpActyNtwkVersionCounter,

      @ObjectModel.foreignKey.association: '_OANSegmentType'
      OperationActivityNetwork.segment_type           as OpActyNtwkSegmentType,

      OperationActivityNetwork.released               as IsReleased,

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

      // @Semantics.systemDateTime.createdAt: true

      OperationActivityNetwork.created_at             as CreationDateTime,

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

      // @Semantics.systemDateTime.lastChangedAt: true

      OperationActivityNetwork.changed_at             as LastChangeDateTime,

      -- Associations
      _OpActyNtwkInternalId,
      _Text,
      _OANSegmentType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MPE_OAN"
],
"ASSOCIATED":
[
"I_OANSEGMENTTYPE",
"I_OPACTYNTWKINTERNALID",
"I_OPERATIONACTIVITYNTWKTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More