I_OPACTYINSTANCESTATUSBASIC

CDS View
7 Fields 17 CDS Views

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

CDS Views using this table (17)

ViewTypeJoinVDMDescription
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 (7)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 2
KEY OpActyNtwkInstance OpActyNtwkInstance 2
_OpActyNtwkInstance _OpActyNtwkInstance 1
_OperationActivityInstance _OperationActivityInstance 1
_SASStatus _SASStatus 6
OpActyIsSeldForRtactvPostg OpActyIsSeldForRtactvPostg 6
StatusAndActionSchemaStatus StatusAndActionSchemaStatus 5

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.

-- Basic view on operation activity instance status
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_OPACTYINSTANCESTATUSBASIC (
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    _OPACTYNTWKINSTANCE,
    _OPERATIONACTIVITYINSTANCE,
    _SASSTATUS,
    OPACTYISSELDFORRTACTVPOSTG,
    STATUSANDACTIONSCHEMASTATUS,
    PRIMARY KEY (OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE)
);

Learn More