I_OperationActivityInstance

DDL: I_OPERATIONACTIVITYINSTANCE SQL: IMPEOAINST Type: view BASIC Package: MPE_EXEC_COMMON

Operation Activity Instance

I_OperationActivityInstance is a Basic CDS View that provides data about "Operation Activity Instance" in SAP S/4HANA. It reads from 1 data source (mpe_oa_instance) and exposes 18 fields with key fields OpActyNtwkInstance, OpActyNtwkElement. It has 5 associations to related views. It is exposed through 2 OData services (UI_OPACTYSFIGROUP_EXECUTE, UI_OPACTYSFIGROUP_MANAGE). Part of development package MPE_EXEC_COMMON.

1 data source(s) Exposed by 2 service(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
mpe_oa_instance oa from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_OpActyInstanceStatusBasic _OpActyInstanceStatusBasic $projection.OpActyNtwkInstance = _OpActyInstanceStatusBasic.OpActyNtwkInstance and $projection.OpActyNtwkElement = _OpActyInstanceStatusBasic.OpActyNtwkElement
[0..1] I_UnitOfMeasure _UnitOfMeasure $projection.ProductionUnit = _UnitOfMeasure.UnitOfMeasure
[1..1] I_OpActyNtwkInstance _OpActyNtwkInstance $projection.OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance
[1..1] I_OpActyNtwkInstanceBasic _OpActyNtwkInstanceBasic $projection.OpActyNtwkInstance = _OpActyNtwkInstanceBasic.OpActyNtwkInstance
[1..1] I_SASSchema _SASSchema $projection.StatusAndActionSchema = _SASSchema.StatusAndActionSchema

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMPEOAINST view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey OpActyNtwkElement view
VDM.viewType #BASIC view
EndUserText.label Operation Activity Instance view
AbapCatalog.preserveKey true view

OData Services (2)

ServiceBindingVersionContractRelease
UI_OPACTYSFIGROUP_EXECUTE UI_OPACTYSFIGROUP_EXECUTE V2 C1 NOT_RELEASED
UI_OPACTYSFIGROUP_MANAGE UI_OPACTYSFIGROUP_MANAGE V2 C1 NOT_RELEASED

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance mpe_oa_instance oan_instance_id
KEY OpActyNtwkElement mpe_oa_instance oan_element_number
StatusAndActionSchema mpe_oa_instance sas_name
OpPlannedYieldQuantity mpe_oa_instance expd_yield
OpPlannedScrapQuantity mpe_oa_instance expd_scrap
ProductionUnit mpe_oa_instance uom
OpActyExpdExecDurnInSeconds expd_exec_durn
OpActyExpdExecLaborDurnInSecs expd_exec_labor_time
BillOfOperationsType plnty
BillOfOperationsGroup plnnr
BillOfOperationsVariant plnal
BOOOperationInternalID plnkn
BillOfOperationsVersion versn
_OpActyInstanceStatusBasic _OpActyInstanceStatusBasic
_UnitOfMeasure _UnitOfMeasure
_OpActyNtwkInstance _OpActyNtwkInstance
_OpActyNtwkInstanceBasic _OpActyNtwkInstanceBasic
_SASSchema _SASSchema 
@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