I_OperationActivity

DDL: I_OPERATIONACTIVITY SQL: IMPEOA Type: view BASIC Package: MPE_OAN

Operation Activity

I_OperationActivity is a Basic CDS View (Dimension) that provides data about "Operation Activity" in SAP S/4HANA. It reads from 1 data source (mpe_oa) and exposes 15 fields with key fields OperationActivity, OperationActyVersionCounter. It has 5 associations to related views. Part of development package MPE_OAN.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
mpe_oa OperationActivity from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_OperationActivityInternalID _OperationActivityInternalId $projection.OperationActivity = _OperationActivityInternalId.OperationActivity -- Operation Activity Text
[0..*] I_OperationActivityText _Text $projection.OperationActivity = _Text.OperationActivity and $projection.OperationActyVersionCounter = _Text.OperationActyVersionCounter -- Status and Action Schema OA VH
[1..1] I_SASOperationActivityVH _SASOpAct $projection.OperationActStsAndActnSchema = _SASOpAct.StatusAndActionSchema -- Status and Action Schema SFI@OA VH
[1..1] I_SASShopFloorItemOpActyVH _SASShopFloorItemOpAct $projection.SFIStatusAndActionSchema = _SASShopFloorItemOpAct.StatusAndActionSchema
[0..1] E_OperationActivity _Extension $projection.OperationActivity = _Extension.OperationActivity and $projection.OperationActyVersionCounter = _Extension.OperationActyVersionCounter

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IMPEOA 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 OperationActyVersionCounter view
Metadata.allowExtensions true view
EndUserText.label Operation Activity view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY OperationActivity mpe_oa id
KEY OperationActyVersionCounter mpe_oa version_no
OperationActStsAndActnSchema mpe_oa activity_sasname
SFIStatusAndActionSchema mpe_oa sfi_sasname
AssemblySqncCheckIsRequired mpe_oa process_sequence
IsReleased mpe_oa released
OriginalChgAlertCount mpe_oa original_count
CreatedByUser mpe_oa created_by
CreationDateTime mpe_oa created_at
ChangedBy mpe_oa changed_by
LastChangeDateTime mpe_oa changed_at
Associations_OperationActivityInternalId
_Text _Text
_SASOpAct _SASOpAct
_SASShopFloorItemOpAct _SASShopFloorItemOpAct 
@AbapCatalog.sqlViewName: 'IMPEOA'
@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:       ['OperationActivity', 'OperationActyVersionCounter'],
  representativeKey: 'OperationActyVersionCounter'
}
@Metadata.allowExtensions:true
@EndUserText.label: 'Operation Activity'
define view I_OperationActivity
  as select from mpe_oa as OperationActivity

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

  -- Operation Activity Text
  association [0..*] to I_OperationActivityText       as _Text                        on  $projection.OperationActivity           = _Text.OperationActivity
                                                                                      and $projection.OperationActyVersionCounter = _Text.OperationActyVersionCounter
  -- Status and Action Schema OA VH
  association [1..1] to I_SASOperationActivityVH      as _SASOpAct                    on  $projection.OperationActStsAndActnSchema = _SASOpAct.StatusAndActionSchema

  -- Status and Action Schema SFI@OA VH
  association [1..1] to I_SASShopFloorItemOpActyVH    as _SASShopFloorItemOpAct       on  $projection.SFIStatusAndActionSchema = _SASShopFloorItemOpAct.StatusAndActionSchema
  
  association [0..1] to E_OperationActivity           as _Extension                   on  $projection.OperationActivity    = _Extension.OperationActivity
                                                                                      and $projection.OperationActyVersionCounter = _Extension.OperationActyVersionCounter      
{
      @ObjectModel.text.association: '_Text'
      @ObjectModel.foreignKey.association: '_OperationActivityInternalId'
  key OperationActivity.id                      as OperationActivity,

  key OperationActivity.version_no              as OperationActyVersionCounter,

      @ObjectModel.foreignKey.association: '_SASOpAct'
      OperationActivity.activity_sasname        as OperationActStsAndActnSchema,

      @ObjectModel.foreignKey.association: '_SASShopFloorItemOpAct'
      OperationActivity.sfi_sasname             as SFIStatusAndActionSchema,
      OperationActivity.process_sequence        as AssemblySqncCheckIsRequired,
      OperationActivity.released                as IsReleased,
      
      OperationActivity.original_count          as OriginalChgAlertCount,

      @Semantics.user.createdBy: true
      OperationActivity.created_by              as   CreatedByUser,
      
        // @Semantics.systemDateTime.createdAt: true

      OperationActivity.created_at              as CreationDateTime,
      
      @Semantics.user.lastChangedBy: true
      OperationActivity.changed_by              as ChangedBy,
      
//      @Semantics.systemDateTime.lastChangedAt: true

      OperationActivity.changed_at              as LastChangeDateTime,

      -- Associations
      _OperationActivityInternalId,
      _Text,
      _SASOpAct,
//      _Extension,

      _SASShopFloorItemOpAct
}

Learn More