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. 23 CDS views read from this table.

Used by 23 CDS view(s) 17 fields

CDS Views using this table (23)

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_OpActyNtwkInstance view from BASIC Operation Activity Network 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 All holds of a Manufacturing Order (that apply to any node)
P_MfgOrderNmbrOfOpActyHolds view from CONSUMPTION Number of active Prodution Holds of an Operation Activity
P_MfgOrderOperActyHoldCount view_entity from COMPOSITE Number of active Prodution Holds of an Operation Activity
P_OpActyAffectedByProdnHold view inner COMPOSITE Operiaon Activity affeted by production Hold
P_OpActyNtwkNumberOfProdnHold view from CONSUMPTION Number of active Prodution Holds of an Operation Activity
P_OpActyPreviousOpActy view inner COMPOSITE Ready quantity of previous operation activity
P_OperationActivityInstanceBsc view inner BASIC OA Instance with OA network instance
P_ProductionHold view inner COMPOSITE Production Hold
P_ProductionHoldOpAndOpActy view inner COMPOSITE Production Hold
P_SFIAssembledComponent view inner CONSUMPTION Component assembled into a SFI (manual and backflushed)
P_SFILatestAction2 view inner CONSUMPTION Last action executed on a SFI at an OA
P_SFOTrcblComponentAssembly view_entity inner COMPOSITE SFO Assembled or Backflushed Component
P_ShopFloorItemComponent view inner CONSUMPTION SFI Component (Manual and Backflushed) per SFI and Batch
P_ShopFloorOrderHoldUnion view inner CONSUMPTION Holds of a Shop Floor Order (active and released)

Fields (17)

KeyField CDS FieldsUsed in Views
KEY ManufacturingOrder ManufacturingOrder 9
KEY OpActyNtwkInstance OpActyNtwkInstance 7
_ManufacturingOrder _ManufacturingOrder 2
_MfgOrder _MfgOrder 1
_MfgOrderOperation _MfgOrderOperation 1
_OpActyNtwkInternalId _OpActyNtwkInternalId 1
_OperationActivityNetwork _OperationActivityNetwork 1
_OrderInternalID _OrderInternalID 1
_OrderOperation _OrderOperation 1
_OrderOperationBasic _OrderOperationBasic 1
OpActyConfirmationIsAllowed OpActyConfirmationIsAllowed 2
OpActyConfIsSFIBased OpActyConfIsSFIBased 2
OpActyConfNotAllowedReason OpActyConfNotAllowedReason 2
OpActyNtwkVersionCounter OpActyNtwkVersionCounter 4
OperationActivityNetwork OperationActivityNetwork 4
OrderInternalID OrderInternalID 7
OrderOperationInternalID OrderOperationInternalID 8 
@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