I_OPACTYINSTCEEQUIPREGN

CDS View

Equipment Registration at an Operation Activity Instance

I_OPACTYINSTCEEQUIPREGN is a CDS View in S/4HANA. Equipment Registration at an Operation Activity Instance. It contains 19 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_OpActyInstceEquipRegnHistory view from CONSUMPTION History of Equipment Registration
I_OpActyInstceEquipActvRegn view from BASIC Active Equipment Registration at an OA Instance
P_MfgExecEventHistOpActy view union_all COMPOSITE Operation Activity Execution Event History

Fields (19)

KeyField CDS FieldsUsed in Views
KEY Equipment Equipment 3
KEY OpActyInstanceEquipmentRegn ManufacturingExecutionDocument,OpActyInstanceEquipmentRegn 3
_Equipment _Equipment 2
_OpActyNtwkInstance _OpActyNtwkInstance 2
_OpActyNtwkInstanceBasic _OpActyNtwkInstanceBasic 2
_OperationActivityInstance _OperationActivityInstance 2
_OrdInternalBillOfOperations _OrdInternalBillOfOperations 2
_ShopFloorItem _ShopFloorItem 1
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 2
IsReversed IsReversed 1
MfgActionReasonCodeGroup MfgActionReasonCodeGroup 1
MfgActionReasonCodeGroupCtlg MfgActionReasonCodeGroupCtlg 1
MfgOrderOpProdnRsceToolIntID MfgOrderOpProdnRsceToolIntID 2
OpActyNtwkElement OpActyNtwkElement 3
OpActyNtwkInstance OpActyNtwkInstance 3
OperationActivitySFIGroup OperationActivitySFIGroup 1
OrderInternalID OrderInternalID 2
ShopFloorItem ShopFloorItem 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.

-- Equipment Registration at an Operation Activity Instance
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_OPACTYINSTCEEQUIPREGN (
    EQUIPMENT,
    OPACTYINSTANCEEQUIPMENTREGN,
    _EQUIPMENT,
    _OPACTYNTWKINSTANCE,
    _OPACTYNTWKINSTANCEBASIC,
    _OPERATIONACTIVITYINSTANCE,
    _ORDINTERNALBILLOFOPERATIONS,
    _SHOPFLOORITEM,
    CREATEDBYUSER,
    CREATIONDATETIME,
    ISREVERSED,
    MFGACTIONREASONCODEGROUP,
    MFGACTIONREASONCODEGROUPCTLG,
    MFGORDEROPPRODNRSCETOOLINTID,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    OPERATIONACTIVITYSFIGROUP,
    ORDERINTERNALID,
    SHOPFLOORITEM,
    PRIMARY KEY (EQUIPMENT, OPACTYINSTANCEEQUIPMENTREGN)
);