I_OPERATIONACTIVITY

CDS View

Operation Activity

I_OPERATIONACTIVITY is a CDS View in S/4HANA. Operation Activity. It contains 13 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 13 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_ShopFloorItemAtOpActy view inner CONSUMPTION Shop Floor Item At Operation Activity
I_ChgAlertOpActy view from BASIC Operation Activity - Change Alert
I_OpActyAssignment view from BASIC Operation Activity Assignments
I_OpActyInstanceDetail view_entity inner COMPOSITE Operation Activity Instance Details
I_OperationActivityStdVH view from COMPOSITE Operation Activity
I_ProdnModOperationActivity view_entity from COMPOSITE Production Model Operation Activity

Fields (13)

KeyField CDS FieldsUsed in Views
KEY OperationActivity OperationActivity 2
KEY OperationActyVersionCounter OperationActyVersionCounter 2
_SASShopFloorItemOpAct _SASShopFloorItemOpAct 1
AssemblySqncCheckIsRequired AssemblySqncCheckIsRequired 3
ChangedBy ChangedBy 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
IsReleased IsReleased 1
LastChangeDateTime LastChangeDateTime 1
OpActyInspectionRelevance OpActyInspectionRelevance 2
OperationActStsAndActnSchema OperationActStsAndActnSchema 1
OriginalChgAlertCount OriginalChgAlertCount 1
SFIStatusAndActionSchema SFIStatusAndActionSchema 2 
@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.extended_quality_checks as OpActyInspectionRelevance,
      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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MPE_OA"
],
"ASSOCIATED":
[
"E_OPERATIONACTIVITY",
"I_OPERATIONACTIVITYINTERNALID",
"I_OPERATIONACTIVITYTEXT",
"I_SASOPERATIONACTIVITYVH",
"I_SASSHOPFLOORITEMOPACTYVH"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More