_MAINTENANCEORDEROPERATION

29 Fields

_MAINTENANCEORDEROPERATION is an SAP database table in S/4HANA. It contains 29 fields.

Fields (29)

KeyField CDS FieldsUsed in Views
KEY MaintenanceOrder MaintenanceOrder 2
_Equipment _Equipment 1
_MaintenanceOrder _MaintenanceOrder 1
_MaintOperationExecStageCode _MaintOperationExecStageCode 1
_PersonResponsible _PersonResponsible 2
_WorkAssignment _PersonResponsible 3
ActivityType ActivityType 1
Equipment Equipment 2
MaintenanceOrderOperation MaintenanceOrderOperation 1
MaintOperationalChecklistType MaintOperationalChecklistType 1
MaintOperationExecStageCode MaintOperationExecStageCode 5
MaintOrderOperationCounter MaintOrderOperationCounter 1
MaintOrderOperationInternalID MaintOrderOperationInternalID 2
MaintOrderRoutingNumber MaintOrderRoutingNumber 1
MaintOrdOpProcessPhaseCode MaintOrdOpProcessPhaseCode 3
MaintOrdOpProcessSubPhaseCode MaintOrdOpProcessSubPhaseCode 3
NumberOfCapacities NumberOfCapacities 1
OperationControlKey OperationControlKey 1
OperationDescription OperationDescription 9
OperationPersonResponsible OperationPersonResponsible 6
OperationPurgInfoRecdSearchTxt OperationPurgInfoRecdSearchTxt 1
OperationSupplier OperationSupplier 3
OperationSystemCondition OperationSystemCondition 1
OperationText OperationDescription,OperationText 2
OperationWorkCenterInternalID OperationWorkCenterInternalID 1
Plant Plant 1
PurchaseRequisition PurchaseRequisition,PurReqnAssgdToMaintOrderOp 2
PurchaseRequisitionItem PurchaseRequisitionItem 1
PurchasingGroup PurchasingGroup 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 _MAINTENANCEORDEROPERATION (
    MAINTENANCEORDER,
    _EQUIPMENT,
    _MAINTENANCEORDER,
    _MAINTOPERATIONEXECSTAGECODE,
    _PERSONRESPONSIBLE,
    _WORKASSIGNMENT,
    ACTIVITYTYPE,
    EQUIPMENT,
    MAINTENANCEORDEROPERATION,
    MAINTOPERATIONALCHECKLISTTYPE,
    MAINTOPERATIONEXECSTAGECODE,
    MAINTORDEROPERATIONCOUNTER,
    MAINTORDEROPERATIONINTERNALID,
    MAINTORDERROUTINGNUMBER,
    MAINTORDOPPROCESSPHASECODE,
    MAINTORDOPPROCESSSUBPHASECODE,
    NUMBEROFCAPACITIES,
    OPERATIONCONTROLKEY,
    OPERATIONDESCRIPTION,
    OPERATIONPERSONRESPONSIBLE,
    OPERATIONPURGINFORECDSEARCHTXT,
    OPERATIONSUPPLIER,
    OPERATIONSYSTEMCONDITION,
    OPERATIONTEXT,
    OPERATIONWORKCENTERINTERNALID,
    PLANT,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASINGGROUP,
    PRIMARY KEY (MAINTENANCEORDER)
);

Learn More