I_OPACTYNTWKELEMENT

CDS View

Operation Activity Network Element

I_OPACTYNTWKELEMENT is a CDS View in S/4HANA. Operation Activity Network Element. It contains 18 fields. 34 CDS views read from this table.

CDS Views using this table (34)

ViewTypeJoinVDMDescription
C_MfgHumRsceQualifnOAAssgmt view_entity inner CONSUMPTION Qualifications assignments to OA
C_MfgOpActyWithAssgmt view inner CONSUMPTION OA list with assigned users
C_MfgOrdPlanInspCharInfo view inner CONSUMPTION Order PIC Info
C_MfgStdTextVersWhereUsedList view inner CONSUMPTION View for ST Where Used List
C_OpActyProcessingStatus view inner CONSUMPTION
C_SFIPlanInspCharInfo view inner CONSUMPTION SFI Plan Insp Char Information
C_ShopFloorItemAtOpActyVH view inner CONSUMPTION Shop floor items at operation activity
I_ActvShopFloorItemAtOpActyVH view inner COMPOSITE Active shop floor items at operation activity
I_BOOVersionOperationActivity view_entity inner COMPOSITE Versioned Routing Operation Activity
I_ExecRlvtOAInstceOANElmnt view_entity inner COMPOSITE Execution Relevant OA Instance
I_MfgOrderOpActyInspCharcs view_entity inner COMPOSITE Inspection Char for OA in MfgOrder
I_MfgOrderOpLastOpActy view inner COMPOSITE Last Op Activity of Mfg Order Operation
I_OpActyDocInfoRecdObjLink view inner COMPOSITE Operation Activity Document Info Record Object Link
I_OpActyInstceNtwkElmntBasic view inner BASIC OA instance with OA network instance and OA network element
I_OpActyInstceOpActyNtwkElmnt view inner COMPOSITE OA instance with OA network instance and OA network element
I_OpActyNtwkElementStdVH view from COMPOSITE Operation Activity Network Element
I_OpActyNtwkInstceNtwkElmntBsc view_entity inner BASIC OAN element of OAN instance
I_OperationActivityWorklistTP view inner TRANSACTIONAL Personal Work Queue
I_ProdnModOpActivityGroup view_entity inner COMPOSITE Operation Activity Group
I_ProdnModOpActivityTemplate view_entity inner COMPOSITE Prodn Model Operation Activity Template
I_ProdnModOperationActivity view_entity inner COMPOSITE Production Model Operation Activity
I_ProdnModParameterEffectivity view_entity inner COMPOSITE Production Model Parameter Effectivity
I_SFIAtOperationActivityBasic view_entity inner COMPOSITE Basic data of a Shop Floor Item at an Operation Activity
I_SFIOpActyInspCharcsAggrg view_entity inner COMPOSITE Insp Chars for SFI in MFG Order
I_ShopFloorItemAtOpActy view inner COMPOSITE Shop Floor Item At Operation Activity
P_MfgOrdOpActyPlanInspChar view inner CONSUMPTION
P_OpActyNtwkInstceOpActyGroup view_entity inner COMPOSITE
P_OpActyPreviousOpActy view inner COMPOSITE
P_ProdnModBOOOPActyGroup view_entity inner COMPOSITE Production Model BOO Op. Activity Group
P_ProdnModOpActivityTemplate view_entity inner COMPOSITE
P_ProdnModParamEffctyParamChgN view_entity inner COMPOSITE
P_ProductionHold view inner COMPOSITE
P_ProductionHoldOpAndOpActy view inner COMPOSITE
P_SFIOpActyPlanInspChar view inner CONSUMPTION

Fields (18)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 6
KEY OpActyNtwkElementElement OpActyNtwkElementElement 10
KEY OpActyNtwkElementElmntVersCntr OpActyNtwkElementElmntVersCntr 9
KEY OpActyNtwkVersionCounter OpActyNtwkVersionCounter 2
KEY OperationActivityNetwork OperationActivityNetwork 3
_EventText _EventText 4
_OperationActivity _OperationActivity 2
_OperationActivityNtwkEvent _OperationActivityNtwkEvent 4
_OperationActivityText _OperationActivityText 6
ChangedBy ChangedBy 4
ChangeNumber ChangeNumber,OldChangeNumber 1
CreatedByUser CreatedByUser 4
CreationDateTime CreationDateTime 4
LastChangeDateTime LastChangeDateTime 4
OANElementDisplaySqncNumber OANElementDisplaySqncNumber 7
OpActyHasAssgdBuyOffs OpActyHasAssgdBuyOffs 5
OpActyNtwkElementExternalID OpActyNtwkElementExternalID,OpActyNtwkGroupExternalID 20
OpActyNtwkElementType OpActyNtwkElementType 4

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 Element
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_OPACTYNTWKELEMENT (
    OPACTYNTWKELEMENT,
    OPACTYNTWKELEMENTELEMENT,
    OPACTYNTWKELEMENTELMNTVERSCNTR,
    OPACTYNTWKVERSIONCOUNTER,
    OPERATIONACTIVITYNETWORK,
    _EVENTTEXT,
    _OPERATIONACTIVITY,
    _OPERATIONACTIVITYNTWKEVENT,
    _OPERATIONACTIVITYTEXT,
    CHANGEDBY,
    CHANGENUMBER,
    CREATEDBYUSER,
    CREATIONDATETIME,
    LASTCHANGEDATETIME,
    OANELEMENTDISPLAYSQNCNUMBER,
    OPACTYHASASSGDBUYOFFS,
    OPACTYNTWKELEMENTEXTERNALID,
    OPACTYNTWKELEMENTTYPE,
    PRIMARY KEY (OPACTYNTWKELEMENT, OPACTYNTWKELEMENTELEMENT, OPACTYNTWKELEMENTELMNTVERSCNTR, OPACTYNTWKVERSIONCOUNTER, OPERATIONACTIVITYNETWORK)
);