I_OPACTYINSTCEEQUIPREGN

CDS View
17 Fields 4 CDS Views

Equipment Registration at an OA Instance

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

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_OpActyInstceEquipRegnHistory view from CONSUMPTION History of Equipment Registration
I_OpActyInstceEquipActvRegn view_entity from COMPOSITE Active Equipment Registration at an OA Instance
P_MfgExecEventHistOpActy view union_all COMPOSITE
P_TrackToolUsageOATTUCLAIMED view union COMPOSITE

Fields (17)

KeyField CDS FieldsUsed in Views
KEY Equipment Equipment 3
KEY OpActyInstanceEquipmentRegn OpActyInstanceEquipmentRegn 2
KEY OpActyNtwkElement OpActyNtwkElement 3
_Equipment _Equipment 2
_OpActyNtwkInstance _OpActyNtwkInstance 2
_OpActyNtwkInstanceBasic _OpActyNtwkInstanceBasic 2
_OperationActivityInstance _OperationActivityInstance 2
_OrderInternalID _OrderInternalID 1
_OrdInternalBillOfOperations _OrdInternalBillOfOperations 2
_ShopFloorItem _ShopFloorItem 1
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 2
IsReversed IsReversed 1
MfgOrderOpProdnRsceToolIntID MfgOrderOpProdnRsceToolIntID 2
OpActyNtwkInstance OpActyNtwkInstance 2
OrderInternalID OrderInternalID 2
ShopFloorItem ShopFloorItem 1

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 OA Instance
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_OPACTYINSTCEEQUIPREGN (
    EQUIPMENT,
    OPACTYINSTANCEEQUIPMENTREGN,
    OPACTYNTWKELEMENT,
    _EQUIPMENT,
    _OPACTYNTWKINSTANCE,
    _OPACTYNTWKINSTANCEBASIC,
    _OPERATIONACTIVITYINSTANCE,
    _ORDERINTERNALID,
    _ORDINTERNALBILLOFOPERATIONS,
    _SHOPFLOORITEM,
    CREATEDBYUSER,
    CREATIONDATETIME,
    ISREVERSED,
    MFGORDEROPPRODNRSCETOOLINTID,
    OPACTYNTWKINSTANCE,
    ORDERINTERNALID,
    SHOPFLOORITEM,
    PRIMARY KEY (EQUIPMENT, OPACTYINSTANCEEQUIPMENTREGN, OPACTYNTWKELEMENT)
);

Learn More