OPERATION

OPERATION is an SAP database table in S/4HANA. It contains 23 fields.

Fields (23)

KeyField CDS FieldsUsed in Views
KEY OrderInternalID MaintOrderRoutingNumber 2
KEY OrderOperationInternalID MaintOrderOperationCounter 2
Equipment OperationEquipment 2
FunctionalLocation RelevantOperationFuncLocation 2
Language Language 2
ltxa1 OperationDescription 1
MaintOperationExecStageCode MaintOperationExecStageCode 2
MaintOrdOpProcessPhaseCode MaintOrdOpProcessPhaseCode 1
MaintOrdOpProcessSubPhaseCode MaintOrdOpProcessSubPhaseCode 1
NumberOfCapacities NumberOfCapacities 2
ObjectInternalID MaintOrderOperationInternalID 2
Operation MaintenanceOrderOperation 2
OperationConfirmation MaintOrderConfirmation 2
OperationControlProfile OperationControlKey 2
OperationHasLongText OperationHasLongText 1
OperationPersonResponsible OperationPersonResponsible 2
OperationSystemCondition OperationSystemCondition 2
OperationText OperationDescription 2
Plant Plant 2
Reservation Reservation 1
SuperiorOperationInternalID SuperiorOperationInternalID 2
WorkCenterInternalID WorkCenterInternalID 2
WorkCenterTypeCode WorkCenterTypeCode 2

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 OPERATION (
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    EQUIPMENT,
    FUNCTIONALLOCATION,
    LANGUAGE,
    LTXA1,
    MAINTOPERATIONEXECSTAGECODE,
    MAINTORDOPPROCESSPHASECODE,
    MAINTORDOPPROCESSSUBPHASECODE,
    NUMBEROFCAPACITIES,
    OBJECTINTERNALID,
    OPERATION,
    OPERATIONCONFIRMATION,
    OPERATIONCONTROLPROFILE,
    OPERATIONHASLONGTEXT,
    OPERATIONPERSONRESPONSIBLE,
    OPERATIONSYSTEMCONDITION,
    OPERATIONTEXT,
    PLANT,
    RESERVATION,
    SUPERIOROPERATIONINTERNALID,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (ORDERINTERNALID, ORDEROPERATIONINTERNALID)
);