I_OPERATIONACTIVITYINSTANCE

CDS View

Operation Activity Instance

I_OPERATIONACTIVITYINSTANCE is a CDS View in S/4HANA. Operation Activity Instance. It contains 18 fields. 15 CDS views read from this table.

Used by 15 CDS view(s) 18 fields

CDS Views using this table (15)

ViewTypeJoinVDMDescription
C_MfgOpActyWithAssgmt view inner CONSUMPTION OA list with assigned users
C_MfgOrdPlanInspCharInfo view inner CONSUMPTION Order PIC Info
C_MfgQualifnOpActyAssgmt view union_all CONSUMPTION Qualification Assignment to OA
C_SFIPlanInspCharInfo view inner CONSUMPTION SFI Plan Insp Char Information
I_OpActyDocInfoRecdObjLink view inner COMPOSITE Operation Activity Document Info Record Object Link
I_OpActyInstceAggrgdConfdQts view from COMPOSITE Aggregated Confirmed Quantities of an Operation Activity
I_OpActyInstceOpActyNtwkBasic view_entity from BASIC OAInstance OANetworkInstance
I_OpActyInstceStdVH view from COMPOSITE Operation Activity Instance
I_SFIOpActyInspCharcsAggrg view inner COMPOSITE Insp Chars for SFI in MFG Order
P_MfgOrdOpActyPlanInspChar view inner CONSUMPTION
P_OpActyAffectedByProdnHold view from COMPOSITE
P_OpActyPreviousOpActy view from COMPOSITE
P_OperationActivityInstance view from COMPOSITE
P_OperationActivityInstanceBsc view from BASIC
P_SFIOpActyPlanInspChar view inner CONSUMPTION

Fields (18)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 12
KEY OpActyNtwkInstance OpActyNtwkInstance 8
_OpActyInstanceStatusBasic _OpActyInstanceStatusBasic 4
_OpActyNtwkInstance _OpActyNtwkInstance 4
_OpActyNtwkInstanceBasic _OpActyNtwkInstanceBasic 4
_SASSchema _SASSchema 4
_UnitOfMeasure _UnitOfMeasure 4
BillOfOperationsGroup BillOfOperationsGroup 6
BillOfOperationsType BillOfOperationsType 5
BillOfOperationsVariant BillOfOperationsVariant 6
BillOfOperationsVersion BillOfOperationsVersion 6
BOOOperationInternalID BOOOperationInternalID 3
OpActyExpdExecDurnInSeconds OpActyExpdExecDurnInSeconds 5
OpActyExpdExecLaborDurnInSecs OpActyExpdExecLaborDurnInSecs 5
OpPlannedScrapQuantity OpPlannedScrapQuantity 4
OpPlannedYieldQuantity OpPlannedYieldQuantity 4
ProductionUnit ProductionUnit 4
StatusAndActionSchema StatusAndActionSchema 4 
@AbapCatalog.sqlViewName: 'IMPEOAINST'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@ObjectModel.representativeKey: 'OpActyNtwkElement'
@VDM.viewType: #BASIC
@EndUserText.label: 'Operation Activity Instance'
@AbapCatalog.preserveKey:true
define view I_OperationActivityInstance
  as select from mpe_oa_instance as oa
  association [0..1] to I_OpActyInstanceStatusBasic as _OpActyInstanceStatusBasic on  $projection.OpActyNtwkInstance = _OpActyInstanceStatusBasic.OpActyNtwkInstance
                                                                                  and $projection.OpActyNtwkElement  = _OpActyInstanceStatusBasic.OpActyNtwkElement
  association [0..1] to I_UnitOfMeasure             as _UnitOfMeasure             on  $projection.ProductionUnit = _UnitOfMeasure.UnitOfMeasure
  association [1..1] to I_OpActyNtwkInstance        as _OpActyNtwkInstance        on  $projection.OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance
  association [1..1] to I_OpActyNtwkInstanceBasic   as _OpActyNtwkInstanceBasic   on  $projection.OpActyNtwkInstance = _OpActyNtwkInstanceBasic.OpActyNtwkInstance

  association [1..1] to I_SASSchema                 as _SASSchema                 on  $projection.StatusAndActionSchema = _SASSchema.StatusAndActionSchema
{
      @ObjectModel.foreignKey.association: '_OpActyNtwkInstance'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_OpActyNtwkInstanceStdVH', element: 'OpActyNtwkInstance' } } ]
  key oa.oan_instance_id    as OpActyNtwkInstance,
  key oa.oan_element_number as OpActyNtwkElement,
      @ObjectModel.foreignKey.association: '_SASSchema'
      oa.sas_name           as StatusAndActionSchema,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      oa.expd_yield         as OpPlannedYieldQuantity,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      oa.expd_scrap         as OpPlannedScrapQuantity,
      @Semantics.unitOfMeasure: true
      oa.uom                as ProductionUnit,
      @Semantics.durationInSeconds: true
      expd_exec_durn        as OpActyExpdExecDurnInSeconds,
      @Semantics.durationInSeconds: true
      expd_exec_labor_time  as OpActyExpdExecLaborDurnInSecs,
      plnty                 as BillOfOperationsType,
      plnnr                 as BillOfOperationsGroup,
      plnal                 as BillOfOperationsVariant,
      plnkn                 as BOOOperationInternalID,
      versn                 as BillOfOperationsVersion,


      _OpActyInstanceStatusBasic,
      _UnitOfMeasure,
      _OpActyNtwkInstance,
      _OpActyNtwkInstanceBasic,
      _SASSchema
}

Learn More