_MAINTENANCEORDEROPERATION

25 Fields

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

Fields (25)

KeyField CDS FieldsUsed in Views
_Equipment _Equipment 1
_MaintenanceOrder _MaintenanceOrder 1
_MaintOperationExecStageCode _MaintOperationExecStageCode 1
_PersonResponsible _PersonResponsible 2
_WorkAssignment _PersonResponsible 3
ActivityType ActivityType 1
Equipment Equipment 2
MaintenanceOrder MaintenanceOrder 1
MaintOperationalChecklistType MaintOperationalChecklistType 2
MaintOperationExecStageCode MaintOperationExecStageCode 4
MaintOrderOperationInternalID MaintOrderOperationInternalID 1
MaintOrdOpProcessPhaseCode MaintOrdOpProcessPhaseCode 3
MaintOrdOpProcessSubPhaseCode MaintOrdOpProcessSubPhaseCode 3
OperationControlKey OperationControlKey 1
OperationDescription OperationDescription 8
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 (
    _EQUIPMENT,
    _MAINTENANCEORDER,
    _MAINTOPERATIONEXECSTAGECODE,
    _PERSONRESPONSIBLE,
    _WORKASSIGNMENT,
    ACTIVITYTYPE,
    EQUIPMENT,
    MAINTENANCEORDER,
    MAINTOPERATIONALCHECKLISTTYPE,
    MAINTOPERATIONEXECSTAGECODE,
    MAINTORDEROPERATIONINTERNALID,
    MAINTORDOPPROCESSPHASECODE,
    MAINTORDOPPROCESSSUBPHASECODE,
    OPERATIONCONTROLKEY,
    OPERATIONDESCRIPTION,
    OPERATIONPERSONRESPONSIBLE,
    OPERATIONPURGINFORECDSEARCHTXT,
    OPERATIONSUPPLIER,
    OPERATIONSYSTEMCONDITION,
    OPERATIONTEXT,
    OPERATIONWORKCENTERINTERNALID,
    PLANT,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASINGGROUP
);

Learn More