I_OPACTYINSTCEEQUIPACTVREGN

CDS View
14 Fields 4 CDS Views

Active Equipment Registration at an OA Instance

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

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_OpActyNrOfActvEquipRegn view from CONSUMPTION Operation Activity Number of active Equipment Registrations
P_OperationActyPRTAssignment2 view_entity union_all CONSUMPTION Shop Floor Item At Operation Activity
P_SFIOpActyInstceEquipActvRegn view_entity from CONSUMPTION Active Equipment Registration at SFI@OA
P_SFIOpActyNrOfActvEquipRegn view from CONSUMPTION Operation Activity Number of active Equipment Registrations

Fields (14)

KeyField CDS FieldsUsed in Views
KEY Equipment Equipment 2
KEY MfgOrderOpProdnRsceToolIntID MfgOrderOpProdnRsceToolIntID 2
KEY OpActyInstanceEquipmentRegn OpActyInstanceEquipmentRegn 1
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OrderInternalID OrderInternalID 2
KEY ShopFloorItem ShopFloorItem 1
_Equipment _Equipment 1
_Material _Material 1
_OperationActivityInstance _OperationActivityInstance 1
_OrdInternalBillOfOperations _OrdInternalBillOfOperations 1
_ShopFloorItem _ShopFloorItem 1
EquipmentMaterial Material 1
EquipmentSerialNumber EquipmentSerialNumber 1
UniqueItemIdentifier UniqueItemIdentifier 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.

-- Active Equipment Registration at an OA Instance
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_OPACTYINSTCEEQUIPACTVREGN (
    EQUIPMENT,
    MFGORDEROPPRODNRSCETOOLINTID,
    OPACTYINSTANCEEQUIPMENTREGN,
    OPACTYNTWKELEMENT,
    ORDERINTERNALID,
    SHOPFLOORITEM,
    _EQUIPMENT,
    _MATERIAL,
    _OPERATIONACTIVITYINSTANCE,
    _ORDINTERNALBILLOFOPERATIONS,
    _SHOPFLOORITEM,
    EQUIPMENTMATERIAL,
    EQUIPMENTSERIALNUMBER,
    UNIQUEITEMIDENTIFIER,
    PRIMARY KEY (EQUIPMENT, MFGORDEROPPRODNRSCETOOLINTID, OPACTYINSTANCEEQUIPMENTREGN, OPACTYNTWKELEMENT, ORDERINTERNALID, SHOPFLOORITEM)
);

Learn More