I_OPERATIONACTIVITYINSTANCE

CDS View

Operation Activity Instance

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

Used by 14 CDS view(s) 18 fields

CDS Views using this table (14)

ViewTypeJoinVDMDescription
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_OpActyInstceStdVH view from COMPOSITE Operation Activity Instance
I_SFIOpActyInspCharcsAggrg view inner COMPOSITE Insp Chars for SFI in MFG Order
P_MfgOrdOpActyPlanInspChar view inner CONSUMPTION Planned Inspection Characteristics for OA of Order
P_OpActyAffectedByProdnHold view from COMPOSITE Operiaon Activity affeted by production Hold
P_OpActyPreviousOpActy view from COMPOSITE Ready quantity of previous operation activity
P_OperationActivityInstance view from COMPOSITE OA Instance with OA network instance
P_OperationActivityInstanceBsc view from BASIC OA Instance with OA network instance
P_SFIOpActyPlanInspChar view inner CONSUMPTION Operation Activity Based PlannedInspChar
P_SFONonTraceableComponent view_entity from CONSUMPTION Shop Floor Order non traceable Component

Fields (18)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 10
KEY OpActyNtwkInstance OpActyNtwkInstance 7
_OpActyInstanceStatusBasic _OpActyInstanceStatusBasic 3
_OpActyNtwkInstance _OpActyNtwkInstance 3
_OpActyNtwkInstanceBasic _OpActyNtwkInstanceBasic 3
_SASSchema _SASSchema 3
_UnitOfMeasure _UnitOfMeasure 3
BillOfOperationsGroup BillOfOperationsGroup 5
BillOfOperationsType BillOfOperationsType 5
BillOfOperationsVariant BillOfOperationsVariant 5
BillOfOperationsVersion BillOfOperationsVersion 5
BOOOperationInternalID BOOOperationInternalID 2
OpActyExpdExecDurnInSeconds OpActyExpdExecDurnInSeconds 3
OpActyExpdExecLaborDurnInSecs OpActyExpdExecLaborDurnInSecs 3
OpPlannedScrapQuantity OpPlannedScrapQuantity 3
OpPlannedYieldQuantity OpPlannedYieldQuantity 3
ProductionUnit ProductionUnit 4
StatusAndActionSchema StatusAndActionSchema 3 
@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