P_SFIOPACTYINSTCEEQUIPACTVREGN

CDS View
29 Fields 1 CDS Views

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_SFIOpActyInstceEquipActvRegn view inner CONSUMPTION

Fields (29)

KeyField CDS FieldsUsed in Views
KEY MfgOrderOpProdnRsceToolIntID MfgOrderOpProdnRsceToolIntID 1
KEY OpActyInstanceEquipmentRegn OpActyInstanceEquipmentRegn 1
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OpActyNtwkInstance OpActyNtwkInstance 1
KEY OrderInternalID OrderInternalID 1
KEY ShopFloorItem ShopFloorItem 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
_ShopFloorItem _ShopFloorItem 1
Equipment Equipment 1
EquipmentSerialNumber EquipmentSerialNumber 1
ManufacturingOrderCategory ManufacturingOrderCategory 1
ManufacturingOrderType ManufacturingOrderType 1
Material Material 1
MfgOrderOperationText MfgOrderOperationText 1
MiscProductionResourceTool MiscProductionResourceTool 1
ProdnRsceToolItemNumber ProdnRsceToolItemNumber 1
ProductionPlant ProductionPlant 1
PRTIsUsedAsTestEquipment PRTIsUsedAsTestEquipment 1
PRTRegistrationControl PRTRegistrationControl 1
PRTRegistrationControlName PRTRegistrationControlName 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.

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

Learn More