P_OPACTYINSTCEEQUIPACTVREGN

CDS View
25 Fields 1 CDS Views

P_OPACTYINSTCEEQUIPACTVREGN is a CDS View in S/4HANA. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_OpActyInstceEquipActvRegn view from CONSUMPTION Actv Equipment Registration at OA Instce

Fields (25)

KeyField CDS FieldsUsed in Views
KEY Equipment Equipment 1
KEY MfgOrderOpProdnRsceToolIntID MfgOrderOpProdnRsceToolIntID 1
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OpActyNtwkInstance OpActyNtwkInstance 1
KEY OrderInternalID OrderInternalID 1
_Equipment _Equipment 1
_Material _Material 1
_MfgOrderCategory _MfgOrderCategory 1
_MfgOrderType _MfgOrderType 1
_OpActyNtwkInstance _OpActyNtwkInstance 1
_OperationActivityInstance _OperationActivityInstance 1
_OrderInternalID _OrderInternalID 1
_ProdnRsceToolCategory _ProdnRsceToolCategory 1
_ProductionPlant _ProductionPlant 1
ManufacturingOrderCategory ManufacturingOrderCategory 1
ManufacturingOrderType ManufacturingOrderType 1
Material Material 1
MfgOrderOperationText MfgOrderOperationText 1
MiscProductionResourceTool MiscProductionResourceTool 1
ProdnRsceToolCategory ProdnRsceToolCategory 1
ProdnRsceToolItemNumber ProdnRsceToolItemNumber 1
ProductionPlant ProductionPlant 1
PRTIsUsedAsTestEquipment PRTIsUsedAsTestEquipment 1
PRTRegistrationControl PRTRegistrationControl 1
PRTRegistrationControlName PRTRegistrationControlName 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_OPACTYINSTCEEQUIPACTVREGN (
    EQUIPMENT,
    MFGORDEROPPRODNRSCETOOLINTID,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    ORDERINTERNALID,
    _EQUIPMENT,
    _MATERIAL,
    _MFGORDERCATEGORY,
    _MFGORDERTYPE,
    _OPACTYNTWKINSTANCE,
    _OPERATIONACTIVITYINSTANCE,
    _ORDERINTERNALID,
    _PRODNRSCETOOLCATEGORY,
    _PRODUCTIONPLANT,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDERTYPE,
    MATERIAL,
    MFGORDEROPERATIONTEXT,
    MISCPRODUCTIONRESOURCETOOL,
    PRODNRSCETOOLCATEGORY,
    PRODNRSCETOOLITEMNUMBER,
    PRODUCTIONPLANT,
    PRTISUSEDASTESTEQUIPMENT,
    PRTREGISTRATIONCONTROL,
    PRTREGISTRATIONCONTROLNAME,
    PRIMARY KEY (EQUIPMENT, MFGORDEROPPRODNRSCETOOLINTID, OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, ORDERINTERNALID)
);

Learn More