EAM_MJP

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.

-- Maintenance Job Package
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EAM_MJP (
    MANDT,                           -- Client [MANDT]
    MAINTENANCEJOBPACKAGEUUID,       -- Job Package UUID [EAM_MJP_UUID]
    MAINTENANCEJOBPACKAGEBUILDUUID,  -- Package Build UUID [EAM_MJP_BUILD_UUID]
    MAINTENANCEJOBPACKAGE,           -- Maintenance Job Pckg [EAM_MJP_ID]
    MAINTENANCEJOBPACKAGENAME,       -- Job Pack Name [EAM_MJP_NAME]
    MAINTENANCEORDER,                -- Order [AUFNR]
    MAINTENANCEORDERTYPE,            -- Order Type [AUFART]
    MAINTENANCEPLANNERGROUP,         -- Planner Group [INGRP]
    MAINTENANCEPLANNINGPLANT,        -- Planning Plant [IWERK]
    MAINTENANCEPLANT,                -- MaintPlant [SWERK]
    PLANTSECTION,                    -- Plant Section [BEBER]
    ABCINDICATOR,                    -- ABC Indic. [ABCKZ]
    EQUIPMENT,                       -- Equipment [EQUNR]
    EQUIPMENTCATEGORY,               -- EquipCategory [EQTYP]
    FUNCTIONALLOCATION,              -- Functional Location [VDM_EAM_TPLNR]
    FUNCTIONALLOCATIONCATEGORY,      -- FunctLocCat. [FLTYP]
    MAINWORKCENTERINTERNALID,        -- Work Center [LGWID]
    MAINWORKCENTER,                  -- Main WorkCtr [GEWRK]
    MAINWORKCENTERTYPECODE,          -- Object Type [PM_OBJTY]
    MAINWORKCENTERPLANT,             -- Plnt WorkCenter [WERGW]
    ASSEMBLY,                        -- Assembly [BAUTL]
    WBSELEMENTINTERNALID,            -- WBS element [VDM_WBS_ELEMENT_INTERNAL]
    PROJECTINTERNALID,               -- Project Def. [PS_S4_PROJ_PSPNR]
    MAINTENANCEREVISION,             -- Revision [REVNI]
    RESPONSIBLECOSTCENTER,           -- Respons. Cost Center [PPH_KOSTL]
    CONTROLLINGAREA,                 -- CO Area [KOKRS]
    MAINTORDPERSONRESPONSIBLE,       -- Person Resp. ID [EAMS_PERSON_RESPONSIBLE]
    MAINTENANCEACTIVITYTYPE,         -- Activity Type [EAM_MAINT_ACTIVITY_TYPE]
    ORDERSYSTEMCONDITION,            -- SystemCondition [ANLZU]
    MAINTPRIORITY,                   -- Priority [PRIOK]
    MAINTPRIORITYTYPE,               -- PriorityType [ARTPR]
    MAINTORDBASICSTARTDATE,          -- Bas. Start Date [PM_ORDGSTRP]
    MAINTORDBASICENDDATE,            -- Basic fin. date [CO_GLTRP]
    LATESTACCEPTABLECOMPLETIONDATE,  -- Final Due Date [VDM_LACD_DATE]
    MAINTENANCEPLAN,                 -- MaintenancePlan [WARPL]
    MAINTENANCEITEM,                 -- MaintItem [WAPOS]
    MAINTORDPROCESSPHASECODE,        -- Process Phase [EAM_OSTAT_PHASE]
    MAINTORDPROCESSSUBPHASECODE,     -- Process Subphase [EAM_OSTAT_SPHASE]
    BUSINESSAREA,                    -- Business Area [GSBER]
    OPERATIONWORKCENTERINTERNALID,   -- Object ID [CR_OBJID]
    OPERATIONCONTROLKEY,             -- Control Key [STEUS]
    COSTCTRACTIVITYTYPE,             -- Activity Type [LSTAR]
    OPERATIONPERSONRESPONSIBLE,      -- Personnel no. [CO_PERNR]
    OPERATIONSYSTEMCONDITION,        -- SystemCondition [ANLZU]
    OPERATIONPURGINFORECDSEARCHTXT,  -- Sort Term [SORTI]
    MAINTOPERATIONEXECSTAGECODE,     -- Execution Stage [EAM_PREMAINPOST_CDS]
    MAINTORDOPPROCESSPHASECODE,      -- Process Phase [EAM_OSTAT_PHASE]
    MAINTORDOPPROCESSSUBPHASECODE,   -- Process Subphase [EAM_OSTAT_SPHASE]
    OPERLSTSCHEDLDEXECSTRTDTE,       -- Earl.start date [FSAVD]
    OPERLSTSCHEDLDEXECENDDTE,        -- EarliestEndDate [FSEDD]
    OPLTSTSCHEDLDEXECSTRTDTE,        -- Latest start [SSAVD]
    OPLTSTSCHEDLDEXECENDDTE,         -- Lat.finish date [SSEDD]
    OPACTUALEXECUTIONSTARTDATE,      -- Execution Start Date [ISDD]
    OPACTUALEXECUTIONENDDATE,        -- Execution End Date [IEDD]
    OPERATIONEQUIPMENT,              -- Equipment (Operation) [RSH_EAMS_OP_EQUIPMENT]
    MAINTJOBPCKGOPSEQUIPCATEGORY,    -- Operation Equip. Cat [EAM_MJP_OPS_EQUIP_CAT]
    OPERATIONFUNCTIONALLOCATION,     -- Functional Location (Operation) [RSH_EAMS_OPER_FUNC_LOC]
    MAINTJOBPCKGOPSFUNCLOCCATEGORY,  -- Operation Func. Loc. Category [EAM_MJP_OP_FUNC_LOC_CAT]
    OPERATIONMAINTENANCENOTIF,       -- Notification [QMNUM]
    CREATIONDATETIME,                -- Created On [ABP_CREATION_TSTMPL]
    CREATEDBYUSER,                   -- Created By [ABP_CREATION_USER]
    LASTCHANGEDATETIME,              -- Changed On [ABP_LASTCHANGE_TSTMPL]
    LASTCHANGEDBYUSER,               -- Changed By [ABP_LASTCHANGE_USER]
    PRIMARY KEY (MANDT, MAINTENANCEJOBPACKAGEUUID)
);