I_OPACTYNTWKINSTANCEBASIC

CDS View
17 Fields 23 CDS Views

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.

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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Operation Activity Network Instance
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_OPACTYNTWKINSTANCEBASIC (
    MANUFACTURINGORDER,
    OPACTYNTWKINSTANCE,
    _MANUFACTURINGORDER,
    _MFGORDER,
    _MFGORDEROPERATION,
    _OPACTYNTWKINTERNALID,
    _OPERATIONACTIVITYNETWORK,
    _ORDERINTERNALID,
    _ORDEROPERATION,
    _ORDEROPERATIONBASIC,
    OPACTYCONFIRMATIONISALLOWED,
    OPACTYCONFISSFIBASED,
    OPACTYCONFNOTALLOWEDREASON,
    OPACTYNTWKVERSIONCOUNTER,
    OPERATIONACTIVITYNETWORK,
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    PRIMARY KEY (MANUFACTURINGORDER, OPACTYNTWKINSTANCE)
);

Learn More