I_OPERATIONACTIVITY

CDS View
12 Fields 6 CDS Views

Operation Activity

I_OPERATIONACTIVITY is a CDS View in S/4HANA. Operation Activity. It contains 12 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_ShopFloorItemAtOpActy view inner CONSUMPTION Shop Floor Item At Operation Activity
I_ChgAlertOpActy view from BASIC Operation Activity - Change Alert
I_OpActyAssignment view from BASIC Operation Activity Assignments
I_OpActyInstanceDetail view_entity inner COMPOSITE Operation Activity Instance Details
I_OperationActivityStdVH view from COMPOSITE Operation Activity
I_ProdnModOperationActivity view_entity from COMPOSITE Production Model Operation Activity

Fields (12)

KeyField CDS FieldsUsed in Views
KEY OperationActivity OperationActivity 2
KEY OperationActyVersionCounter OperationActyVersionCounter 2
_SASShopFloorItemOpAct _SASShopFloorItemOpAct 1
AssemblySqncCheckIsRequired AssemblySqncCheckIsRequired 3
ChangedBy ChangedBy 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
IsReleased IsReleased 1
LastChangeDateTime LastChangeDateTime 1
OperationActStsAndActnSchema OperationActStsAndActnSchema 1
OriginalChgAlertCount OriginalChgAlertCount 1
SFIStatusAndActionSchema SFIStatusAndActionSchema 2

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_OPERATIONACTIVITY (
    OPERATIONACTIVITY,
    OPERATIONACTYVERSIONCOUNTER,
    _SASSHOPFLOORITEMOPACT,
    ASSEMBLYSQNCCHECKISREQUIRED,
    CHANGEDBY,
    CREATEDBYUSER,
    CREATIONDATETIME,
    ISRELEASED,
    LASTCHANGEDATETIME,
    OPERATIONACTSTSANDACTNSCHEMA,
    ORIGINALCHGALERTCOUNT,
    SFISTATUSANDACTIONSCHEMA,
    PRIMARY KEY (OPERATIONACTIVITY, OPERATIONACTYVERSIONCOUNTER)
);

Learn More