MAINTORDOP_D

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.

-- Draft table for entity R_MaintenanceOrderOperationTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MAINTORDOP_D (
    MANDT,                           -- Client [mandt]
    MAINTENANCEORDER,                -- Order [aufnr]
    MAINTENANCEORDEROPERATION,       -- Operation [maintenanceorderoperation]
    MAINTENANCEORDERSUBOPERATION,    -- Suboperation [maintenanceordersuboperation]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    MAINTORDEROPERATIONFOREDIT,      -- Operation [maintenanceorderoperation]
    MAINTORDERSUBOPERATIONFOREDIT,   -- Suboperation [maintenanceordersuboperation]
    MAINTORDERROUTINGNUMBER,         -- Plan No.f.Oper. [co_aufpl]
    MAINTENANCEORDERROUTINGNODE,     -- Counter [co_aplzl]
    SUPERIOROPERATIONINTERNALID,     -- Sup. Op. Node [sumkntnr]
    OPERATIONCONTROLKEY,             -- Control Key [steus]
    OPERATIONDESCRIPTION,            -- Op. Short Text [ltxa1]
    OPERATIONWORKCENTERINTERNALID,   -- Object ID [cr_objid]
    WORKCENTER,                      -- Work Center [pph_arbpl]
    OPERATIONWORKCENTERTYPECODE,     -- abap.char
    PLANT,                           -- Plant [werks_d]
    OPERATIONSTANDARDTEXTCODE,       -- Std Text Key [ktsch_chg]
    LANGUAGE,                        -- Language [spras]
    NUMBEROFTIMETICKETS,             -- No.TimeTickets [lohnanz]
    OPERATIONPURGINFORECDSEARCHTXT,  -- Sort Term [sorti]
    OPERATIONSUPPLIER,               -- Supplier [lifnr]
    OPEXTERNALPROCESSINGPRICE,       -- Price [preis]
    OPEXTERNALPROCESSINGPRICEUNIT,   -- Price unit [peinh]
    COSTELEMENT,                     -- Cost Element [kstar]
    OPEXTERNALPROCESSINGCURRENCY,    -- Currency [waers]
    OPERATIONPURCHASINGINFORECORD,   -- Info Record [infnr]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [ekorg]
    PURCHASINGGROUP,                 -- Purch. Group [vg_ekgrp]
    MATERIALGROUP,                   -- Material Group [matkl]
    OPPURCHASEOUTLINEAGREEMENT,      -- Agreement [konnr]
    OPPURCHASEOUTLINEAGREEMENTITEM,  -- Agreement Item [ktpnr]
    OPERATIONREQUISITIONERNAME,      -- Requisitioner [afnam]
    OPERATIONTRACKINGNUMBER,         -- Tracking Number [bednr]
    NUMBEROFCAPACITIES,              -- Number [anzkap]
    OPERATIONWORKPERCENT,            -- Percent [aprozent]
    OPERATIONCALCULATIONCONTROL,     -- Calculation key [indet]
    ACTIVITYTYPE,                    -- Activity Type [lstar]
    OPERATIONSYSTEMCONDITION,        -- SystemCondition [anlzu]
    OPERATIONGOODSRECIPIENTNAME,     -- Recipient [wempf]
    OPERATIONUNLOADINGPOINTNAME,     -- Unloading Point [ablad]
    OPERATIONPERSONRESPONSIBLE,      -- Personnel no. [co_pernr]
    EAMPLANNEDDELIVERYDURNINDAYS,    -- Pl. Deliv. Time [plifz]
    MAINTORDEROPERATIONDURATION,     -- Normal duration [daunor]
    MAINTORDOPERATIONDURATIONUNIT,   -- Norm.duratn un. [daunore]
    OPBSCSTARTDATECONSTRAINTTYPE,    -- StartConstraint [einschra]
    OPBSCENDDATECONSTRAINTTYPE,      -- Fin. constraint [einschre]
    MAINTORDOPERATIONWORKDURATION,   -- Work [arbeit]
    MAINTORDOPWORKDURATIONUNIT,      -- Unit for work [arbeite]
    MAINTORDOPCONSTRAINTSTRTDTETME,  -- Time Stamp [timestamp]
    CONSTRAINTDATEFORBSCSTARTDATE,   -- abap.dats
    CONSTRAINTTIMEFORBSCSTARTTIME,   -- abap.tims
    MAINTORDOPCSTRTFINISHDTETME,     -- Time Stamp [timestamp]
    CONSTRAINTDATEFORBSCFINISHDATE,  -- abap.dats
    CONSTRAINTTIMEFORBSCFINISHTIME,  -- abap.tims
    MAINTORDOPERATIONEXECUTIONRATE,  -- Execution Fact. [afakt]
    EQUIPMENT,                       -- Equipment [equnr]
    FUNCTIONALLOCATION,              -- Functional Location [vdm_eam_tplnr]
    OPERLSTSCHEDLDEXECSTRTDTETME,    -- Time Stamp [timestamp]
    OPERLSTSCHEDLDEXECSTRTDTE,       -- abap.dats
    OPERLSTSCHEDLDEXECSTRTTME,       -- abap.tims
    OPERLSTSCHEDLDEXECENDDTETME,     -- Time Stamp [timestamp]
    OPERLSTSCHEDLDEXECENDDTE,        -- abap.dats
    OPERLSTSCHEDLDEXECENDTME,        -- abap.tims
    OPLTSTSCHEDLDEXECSTRTDTETME,     -- Time Stamp [timestamp]
    OPLTSTSCHEDLDEXECSTRTDTE,        -- abap.dats
    OPLTSTSCHEDLDEXECSTRTTME,        -- abap.tims
    OPLTSTSCHEDLDEXECENDDTETME,      -- Time Stamp [timestamp]
    OPLTSTSCHEDLDEXECENDDTE,         -- abap.dats
    OPLTSTSCHEDLDEXECENDTME,         -- abap.tims
    OPACTUALEXECUTIONSTARTDATETIME,  -- Time Stamp [timestamp]
    OPACTUALEXECUTIONSTARTDATE,      -- abap.dats
    OPACTUALEXECUTIONSTARTTIME,      -- abap.tims
    OPACTUALEXECUTIONENDDATETIME,    -- Time Stamp [timestamp]
    OPACTUALEXECUTIONENDDATE,        -- abap.dats
    OPACTUALEXECUTIONENDTIME,        -- abap.tims
    ACTYCONFFCSTDENDDATE,            -- abap.dats
    ACTYCONFFCSTDENDTIME,            -- abap.tims
    ACTYCONFFORECASTEDENDDATETIME,   -- Time Stamp [timestamp]
    FORECASTWORKQUANTITY,            -- Forecast work [ofmnw]
    ACTUALWORKQUANTITY,              -- Actual work [co_ismnw]
    MAINTENANCEACTIVITYTYPE,         -- MaintActivType [ila]
    BUSINESSAREA,                    -- Business Area [gsber]
    PROFITCENTER,                    -- Profit Center [prctr]
    COSTINGSHEET,                    -- Costing Sheet [aufkalsm]
    TAXJURISDICTION,                 -- Tax Jur. [txjcd]
    FUNCTIONALAREA,                  -- Functional Area [fkber]
    MAINTORDOPERATIONISMRPRELEVANT,  -- Res./Purc. req. [audisp_plus]
    MAINTCONTROLLINGOBJECTCLASS,     -- Object Class [ps_s4_scope_cv]
    WRKCTRINTCAPRQMTSDISTR,          -- Int. dist. key [cr_vertn]
    MAINTORDOPERATIONOVERHEADCODE,   -- Overhead key [aufzschl]
    MAINTORDEROPERATIONQUANTITY,     -- Operation Qty [mgvrg]
    MAINTORDOPERATIONQUANTITYUNIT,   -- Act/op UoM [vorme]
    ASSEMBLY,                        -- Assembly [istru]
    MAINTOPERATIONEXECSTAGECODE,     -- Execution Stage [eam_premainpost_cds]
    MAINTORDOPASSGDWBSELMNTINT,      -- WBS Internal ID [ps_s4_pspnr]
    WBSELEMENT,                      -- WBS Element [vdm_ps_posid]
    ISMARKEDFORDELETION,             -- Deletion Flag [aufloekz]
    MAINTORDEROPERATIONINTERNALID,   -- Object number [j_objnr]
    MAINTENANCEOBJECTLISTITEM,       -- Object counters [objza]
    PURCHASEREQUISITION,             -- Requisition [co_banfn]
    PURCHASEREQUISITIONITEM,         -- Requisition Itm [co_bnfpo]
    MAINTORDOPPROCESSPHASECODE,      -- Process Phase [eam_ostat_phase]
    MAINTORDOPPROCESSSUBPHASECODE,   -- Process Subphase [eam_ostat_sphase]
    ALLMAINTORDCOMPCMTDQTSAREKEPT,   -- Keep Committed Qties [allmaintordcompcmtdqtsarekept]
    CONTROLLINGAREA,                 -- CO Area [kokrs]
    MAINTORDERCONFIRMATION,          -- Confirmation [co_rueck]
    MAINTORDERCONFCNTRVALUE,         -- Counter [co_rmzhl]
    MAINTORDOPHASNOREMAININGWORK,    -- No Remain. Work [leknw]
    MAINTORDOPHASLEANSERVICES,       -- operation has srv [eam_operation_has_service]
    MAINTENANCENOTIFICATION,         -- Notification [qmnum]
    EXTPROCGOPERATIONHASSUBCONTRG,   -- Subcontracting [co_frdlb]
    MAINTORDOPDELIVDATEADJUSTMENT,   -- Align Date [cc4_delvry_date_adj_oper]
    TASKLISTTYPE,                    -- Task List Type [plnty]
    TASKLISTGROUP,                   -- Group [plnnr]
    TASKLISTGROUPCOUNTER,            -- Group Counter [plnal]
    PRIMARY KEY (MANDT, MAINTENANCEORDER, MAINTENANCEORDEROPERATION, MAINTENANCEORDERSUBOPERATION, DRAFTUUID)
);