I_OPACTYNTWKINSTANCEBASIC

CDS View

Operation Activity Network Instance

I_OPACTYNTWKINSTANCEBASIC is a CDS View in S/4HANA. Operation Activity Network Instance. It contains 17 fields. 25 CDS views read from this table.

Used by 25 CDS view(s) 17 fields

CDS Views using this table (25)

ViewTypeJoinVDMDescription
C_MfgOrdPlanInspCharInfo view inner CONSUMPTION Order PIC Info
C_MfgQualifnOpActyAssgmt view inner CONSUMPTION Qualification Assignment to OA
C_SFIPlanInspCharInfo view inner CONSUMPTION SFI Plan Insp Char Information
I_MfgBuyOffActionHistory view from COMPOSITE Buyoff view for action log
I_MfgOrderOpActyInspCharcs view inner COMPOSITE Inspection Char for OA in MfgOrder
I_MfgOrderOpLastOpActy view from COMPOSITE Last Op Activity of Mfg Order Operation
I_OpActyInstceOpActyNtwkBasic view_entity inner BASIC OAInstance OANetworkInstance
I_OpActyNtwkInstance view from BASIC Operation Activity Network Instance
I_OpActyNtwkInstceNtwkElmntBsc view_entity from BASIC OAN element of OAN instance
I_OpenOpActyWlOfCurrentUser view inner COMPOSITE Open Op Acty Worklist of Current User
I_SFIOpActyInspCharcsAggrg view inner COMPOSITE Insp Chars for SFI in MFG Order
P_MfgOrderHeaderHoldUnionBasic view inner CONSUMPTION
P_MfgOrderNmbrOfOpActyHolds view from CONSUMPTION
P_MfgOrderOperActyHoldCount view_entity from COMPOSITE
P_OpActyAffectedByProdnHold view inner COMPOSITE
P_OpActyNtwkNumberOfProdnHold view from CONSUMPTION
P_OpActyPreviousOpActy view inner COMPOSITE
P_OperationActivityInstanceBsc view inner BASIC
P_ProductionHold view inner COMPOSITE
P_ProductionHoldOpAndOpActy view inner COMPOSITE
P_SFIAssembledComponent view inner CONSUMPTION
P_SFINotAssldTrcblComponent1 view_entity inner COMPOSITE SFI Not Assembled Traceable Components
P_SFOTrcblComponentAssembly view_entity inner COMPOSITE
P_ShopFloorItemComponent view inner CONSUMPTION
P_ShopFloorOrderHoldUnion view inner CONSUMPTION

Fields (17)

KeyField CDS FieldsUsed in Views
KEY ManufacturingOrder ManufacturingOrder 11
KEY OpActyNtwkInstance OpActyNtwkInstance 9
_ManufacturingOrder _ManufacturingOrder 4
_MfgOrder _MfgOrder 3
_MfgOrderOperation _MfgOrderOperation 3
_OpActyNtwkInternalId _OpActyNtwkInternalId 3
_OperationActivityNetwork _OperationActivityNetwork 3
_OrderInternalID _OrderInternalID 3
_OrderOperation _OrderOperation 3
_OrderOperationBasic _OrderOperationBasic 3
OpActyConfirmationIsAllowed OpActyConfirmationIsAllowed 4
OpActyConfIsSFIBased OpActyConfIsSFIBased 4
OpActyConfNotAllowedReason OpActyConfNotAllowedReason 4
OpActyNtwkVersionCounter OpActyNtwkVersionCounter 7
OperationActivityNetwork OperationActivityNetwork 6
OrderInternalID OrderInternalID 8
OrderOperationInternalID OrderOperationInternalID 9 
@AbapCatalog.sqlViewName: 'IMPEOANINSTB'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true 
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@ObjectModel.representativeKey: 'OpActyNtwkInstance'
@VDM.viewType: #BASIC
@EndUserText.label: 'Operation Activity Network Instance'
define view I_OpActyNtwkInstanceBasic
  as select from mpe_oan_instance as oan
  association [1..1] to I_OpActyNtwkInternalID        as _OpActyNtwkInternalId     on  $projection.OperationActivityNetwork = _OpActyNtwkInternalId.OperationActivityNetwork
  association [1..1] to I_OperationActivityNetwork    as _OperationActivityNetwork on  $projection.OperationActivityNetwork = _OperationActivityNetwork.OperationActivityNetwork
                                                                                   and $projection.OpActyNtwkVersionCounter = _OperationActivityNetwork.OpActyNtwkVersionCounter
  association [1..1] to I_MfgOrder                    as _MfgOrder                 on  $projection.ManufacturingOrder = _MfgOrder.ManufacturingOrder
  association [1..1] to I_ManufacturingOrder          as _ManufacturingOrder       on  $projection.ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder
  association [1..1] to I_MfgOrderOperation           as _MfgOrderOperation        on  $projection.OrderInternalID          = _MfgOrderOperation.OrderInternalBillOfOperations
                                                                                   and $projection.OrderOperationInternalID = _MfgOrderOperation.OrderIntBillOfOperationsItem
  association [1..1] to I_OrderOperation              as _OrderOperation           on  $projection.OrderInternalID          = _OrderOperation.OrderInternalID
                                                                                   and $projection.OrderOperationInternalID = _OrderOperation.OrderOperationInternalID
  association [1..1] to I_OrderOperationBasic         as _OrderOperationBasic      on  $projection.OrderInternalID          = _OrderOperationBasic.OrderInternalID
                                                                                   and $projection.OrderOperationInternalID = _OrderOperationBasic.OrderOperationInternalID

  association [1..1] to I_OrdInternalBillOfOperations as _OrderInternalID          on  $projection.OrderInternalID = _OrderInternalID.OrderInternalBillOfOperations
{
  key oan.oan_instance_id                             as OpActyNtwkInstance,
      @ObjectModel.foreignKey.association: '_OpActyNtwkInternalId'
      oan.oan_id                                      as OperationActivityNetwork,
      @ObjectModel.foreignKey.association: '_OperationActivityNetwork'
      oan.oan_version_no                              as OpActyNtwkVersionCounter,
      @ObjectModel.foreignKey.association: '_MfgOrder'
      oan.aufnr                                       as ManufacturingOrder,
      @ObjectModel.foreignKey.association: '_OrderInternalID'
      oan.aufpl                                       as OrderInternalID,
      oan.aplzl                                       as OrderOperationInternalID,
      oan.sfi_conf                                    as OpActyConfIsSFIBased,
      oan.conf_allwd                                  as OpActyConfirmationIsAllowed,
      oan.conf_not_allwd_rsn                          as OpActyConfNotAllowedReason,

      _OpActyNtwkInternalId,
      _OperationActivityNetwork,
      _OrderInternalID,
      _MfgOrder,
      _ManufacturingOrder,
      _MfgOrderOperation,
      _OrderOperation,
      _OrderOperationBasic
}

Learn More