I_OPACTYINSTANCESTATUSBASIC

CDS View

Basic view on operation activity instance status

I_OPACTYINSTANCESTATUSBASIC is a CDS View in S/4HANA. Basic view on operation activity instance status. It contains 5 fields. 18 CDS views read from this table.

Used by 18 CDS view(s) 5 fields

CDS Views using this table (18)

ViewTypeJoinVDMDescription
C_MfgBuyOffList view left_outer CONSUMPTION Buy Off Cycle Inbox
C_MfgExecDefectRecord view left_outer CONSUMPTION View with UI attributes for defect
C_MfgOpActyWithAssgmt view inner CONSUMPTION OA list with assigned users
C_OpActyProcessingStatus view inner CONSUMPTION
C_ShopFloorItemAtOpActy view inner CONSUMPTION Shop Floor Item At Operation Activity
C_ShopFloorOrderOperationActy view inner CONSUMPTION Shop Floor Order Operation Activity
C_TeamOpenOpActyAssignment view inner CONSUMPTION Open operation activities assigned to a team
I_ActvShopFloorItemAtOpActyVH view inner COMPOSITE Active shop floor items at operation activity
I_OpActyInstanceStatus view from BASIC Operation Activity Instance Status
I_OpenOpActyWlOfCurrentUser view inner COMPOSITE Open Op Acty Worklist of Current User
I_ProcgExecOperationActivity view inner COMPOSITE Operation Activity
I_TrackToolUsageOpActyEquip view inner COMPOSITE List of OAs for Equipment
P_NrOfTeamOpnOpActyAssgmnts view inner COMPOSITE
P_NrOfUsrOpnOpActyAssgmnts view inner COMPOSITE
P_OpActyInstanceWithUserAssgmt view inner TRANSACTIONAL
P_OperationActivityWorklist view inner COMPOSITE
P_ProcgExecOperationActivity view from COMPOSITE
P_TrackToolUsageOAPRTASSGNED view inner COMPOSITE

Fields (5)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OpActyNtwkInstance OpActyNtwkInstance 1
_SASStatus _SASStatus 6
OpActyIsSeldForRtactvPostg OpActyIsSeldForRtactvPostg 7
StatusAndActionSchemaStatus StatusAndActionSchemaStatus 5 
@AbapCatalog.sqlViewName: 'IMPEOAINSTSTSB'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #BASIC
@EndUserText.label: 'Basic view on operation activity instance status'
define view I_OpActyInstanceStatusBasic
  as select from mpe_oa_i_sas_sts as s
  association [1..1] to I_OpActyNtwkInstance        as _OpActyNtwkInstance            on  $projection.OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance
  association [1..1] to I_OperationActivityInstance as _OperationActivityInstance     on  $projection.OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance
                                                                                      and $projection.OpActyNtwkElement  = _OperationActivityInstance.OpActyNtwkElement
  association [1..1] to I_SASStatus                 as _SASStatus                     on  $projection.StatusAndActionSchemaStatus = _SASStatus.StatusAndActionSchemaStatus
  association [1..1] to I_OpActyConfirmation        as _OpActyStsLastChgdByOpActyConf on  $projection.OpActyStsLastChgdByOpActyConf = _OpActyStsLastChgdByOpActyConf.OperationActivityConfirmation
{
      @ObjectModel.foreignKey.association: '_OpActyNtwkInstance'
  key s.oan_instance_id          as OpActyNtwkInstance,
      @ObjectModel.foreignKey.association: '_OperationActivityInstance'
  key s.oan_element_number       as OpActyNtwkElement,
      @ObjectModel.foreignKey.association: '_SASStatus'
      s.sas_status_name          as StatusAndActionSchemaStatus,
      s.is_for_retroact_postg    as OpActyIsSeldForRtactvPostg,
      s.sts_lst_chgd_by_doc_nmbr as OpActyStsLastChgdByOpActyConf,

      _OpActyNtwkInstance,
      _OperationActivityInstance,
      _SASStatus,
      _OpActyStsLastChgdByOpActyConf
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MPE_OA_I_SAS_STS"
],
"ASSOCIATED":
[
"I_OPACTYCONFIRMATION",
"I_OPACTYNTWKINSTANCE",
"I_OPERATIONACTIVITYINSTANCE",
"I_SASSTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More