I_OPERATIONACTIVITY

CDS View
17 Fields 9 CDS Views

Operation Activity

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

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_ShopFloorItemAtOpActy view inner CONSUMPTION Shop Floor Item At Operation Activity
I_BOOVersionOperationActivity view_entity from COMPOSITE Versioned Routing 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_ProdnModOpActivityTemplate view_entity from COMPOSITE Prodn Model Operation Activity Template
I_ProdnModOperationActivity view_entity from COMPOSITE Production Model Operation Activity
P_ProdnModOpActivityTemplate view_entity from COMPOSITE

Fields (17)

KeyField CDS FieldsUsed in Views
KEY OperationActivity OperationActivity 5
KEY OperationActyVersionCounter OperationActyVersionCounter 5
_SASShopFloorItemOpAct _SASShopFloorItemOpAct 1
AssemblySqncCheckIsRequired AssemblySqncCheckIsRequired 4
ChangedBy ChangedBy 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
IsReleased IsReleased 1
LastChangeDateTime LastChangeDateTime 1
OpActyInspectionRelevance OpActyInspectionRelevance 3
OperationActStsAndActnSchema OperationActStsAndActnSchema 2
OriginalChgAlertCount OriginalChgAlertCount 2
SFIStatusAndActionSchema SFIStatusAndActionSchema 3
ShopFloorRtgTemplateGroup ShopFloorRtgTemplateGroup 3
ShopFloorRtgTemplateGrpVariant ShopFloorRtgTemplateGrpVariant 3
ShopFloorRtgTemplateVersion ShopFloorRtgTemplateVersion 3
ShopFloorRtgTmplTaskListType ShopFloorRtgTmplTaskListType 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,
    OPACTYINSPECTIONRELEVANCE,
    OPERATIONACTSTSANDACTNSCHEMA,
    ORIGINALCHGALERTCOUNT,
    SFISTATUSANDACTIONSCHEMA,
    SHOPFLOORRTGTEMPLATEGROUP,
    SHOPFLOORRTGTEMPLATEGRPVARIANT,
    SHOPFLOORRTGTEMPLATEVERSION,
    SHOPFLOORRTGTMPLTASKLISTTYPE,
    PRIMARY KEY (OPERATIONACTIVITY, OPERATIONACTYVERSIONCOUNTER)
);

Learn More