I_OPERATIONACTIVITY

CDS View

Operation Activity

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

Used by 6 CDS view(s) 16 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 (16)

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
ShopFloorRtgTemplateGroup ShopFloorRtgTemplateGroup 1
ShopFloorRtgTemplateGrpVariant ShopFloorRtgTemplateGrpVariant 1
ShopFloorRtgTemplateVersion ShopFloorRtgTemplateVersion 1 
@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

  -- Reference Template
  association [0..1] to I_BillOfOperationsVersion  as _ReferenceTemplateGroup on  $projection.ShopFloorRtgTmplTaskListType   = _ReferenceTemplateGroup.BillOfOperationsType
                                                                              and $projection.ShopFloorRtgTemplateGroup      = _ReferenceTemplateGroup.BillOfOperationsGroup
                                                                              and $projection.ShopFloorRtgTemplateGrpVariant = _ReferenceTemplateGroup.BillOfOperationsVariant
                                                                              and $projection.ShopFloorRtgTemplateVersion    = _ReferenceTemplateGroup.BillOfOperationsVersion

{
      @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,

      OperationActivity.plnty_reft              as   ShopFloorRtgTmplTaskListType,
      OperationActivity.plnnr_reft              as   ShopFloorRtgTemplateGroup,
      OperationActivity.plnal_reft              as   ShopFloorRtgTemplateGrpVariant,
      OperationActivity.versn_reft              as   ShopFloorRtgTemplateVersion,

      @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,
      _ReferenceTemplateGroup,

//      _Extension,

      _SASShopFloorItemOpAct
}

Learn More