MAINTORD_D

Transparent Table Application Table
114 Fields 2 CDS Views

Draft table for entity R_MAINTENANCEORDERTP

MAINTORD_D is an SAP database table in S/4HANA. Draft table for entity R_MAINTENANCEORDERTP. It contains 114 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_MaintenanceOrderDraft view_entity from EXTENSION Maintenance Order - Extension
R_MaintenanceOrderDraft view_entity from BASIC Maintenance Order Draft data

Fields (114)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY maintenanceorder AUFNR Order
KEY draftuuid SDRAFT_UUID Draft Document ID
maintorderroutingnumber CO_AUFPL Plan No.f.Oper.
maintenanceordertype AUFART Order Type
maintenanceorderdesc AUFTEXT Description
maintordbasicstartdatetime TIMESTAMP Time Stamp
maintordbasicenddatetime TIMESTAMP Time Stamp
maintordbasicstartdate abap.dats
maintordbasicstarttime abap.tims
maintordbasicenddate abap.dats
maintordbasicendtime abap.tims
maintordschedldbscstrtdatetime TIMESTAMP Time Stamp
maintordschedldbscenddatetime TIMESTAMP Time Stamp
scheduledbasicstartdate abap.dats
scheduledbasicstarttime abap.tims
scheduledbasicenddate abap.dats
scheduledbasicendtime abap.tims
maintorderreferencedatetime TIMESTAMP Time Stamp
maintorderreferencedate abap.dats
maintorderreferencetime abap.tims
mainworkcompleteddatetime EAM_MAIN_WORK_COMPLETED_TSTMP Main Work Completed
maintenancenotification QMNUM Notification
ordisnotschedldautomatically CO_NAUTERM No auto. cost.
mainworkcenterinternalid LGWID Work Center
mainworkcentertypecode PM_OBJTY Object Type
mainworkcenter PPH_ARBPL Work Center
mainworkcenterplant WERKS_D Plant
controllingarea KOKRS CO Area
servicedocumenttype CRMT_PROCESS_TYPE Transaction Type
servicedocument CRMT_OBJECT_ID_DB Transaction ID
servicedocumentitem CRMS4_NUMBER_INT Item Number in Doc.
maintenanceplanningplant IWERK Planning Plant
assembly BAUTL Assembly
maintordprocessphasecode EAM_OSTAT_PHASE Process Phase
maintordprocesssubphasecode EAM_OSTAT_SPHASE Process Subphase
companycode BUKRS Company Code
businessarea GSBER Business Area
referenceelement ADDCOMPARE_CORE Ref. Element PM/PS
functionalarea FKBER Functional Area
additionaldevicedata DEVICEID Device Data
equipment EQUNR Equipment
maintenanceorderplanningcode AUF_PLKNZ OrderPlanInd.
maintenanceplannergroup INGRP Planner Group
maintenanceactivitytype EAM_MAINT_ACTIVITY_TYPE Activity Type
maintpriority PRIOK Priority
maintprioritytype ARTPR PriorityType
orderprocessinggroup AUFABKRS Process. group
profitcenter PRCTR Profit Center
responsiblecostcenter PPH_KOSTL Respons. Cost Center
costingsheet AUFKALSM Costing Sheet
conditionusage KVEWE Usage
conditionapplication KAPPL Application
currency AUFWAERS Currency
maintenancerevision REVNI Revision
serialnumber VDM_EAM_GERNR Serial Number
product MATNR Material
superiorprojectnetwork CO_TEILNET Subnetwork of
operationsystemcondition ANLZU SystemCondition
wbselementinternalid PS_S4_PSPNR WBS Internal ID
projectinternalid PS_S4_PROJ_PSPNR Project Def.
locacctassgmtwbselmntintid PS_S4_PSPNR WBS Internal ID
costcenter KOSTL Cost Center
controllingobjectclass PPH_SCOPE Controlling Object Class
functionallocation VDM_EAM_TPLNR Functional Location
maintenanceplant SWERK MaintPlant
assetlocation PMLOC Location
assetroom RAUMNR Room
plantsection BEBER Plant Section
abcindicator ABCKZ ABC Indic.
maintobjectfreedefinedattrib EQFNR Sort Field
workcenterinternalid PPSID PP work ctr
workcentertypecode CR_OBJTY Object Type
workcenter PPH_ARBPL Work Center
locacctassgmtbusinessarea GSBER Business Area
settlementorder ILOM_ORDST SettlementOrder
masterfixedasset ANLN1 Asset
fixedasset ANLN2 Sub-number
standingordernumber DAUFN StandgOrder
salesorganization VKORG Sales Org.
distributionchannel VTWEG Distr. Channel
organizationdivision SPART Division
locacctassgmtcontrollingarea KOKRS CO Area
locacctassgmtcompanycode BUKRS Company Code
maintenanceorderinternalid J_OBJNR Object number
maintenanceitemobjectlist OBJKNR Object list
maintobjectlocacctassgmtnmbr ILOAN Loc/AccAssmt
controllingsettlementprofile FCO_APROF Settlement Profile
basicschedulingtype TERMKZ Scheduling type
latestacceptablecompletiondate VDM_LACD_DATE Final Due Date
maintordpersonresponsible EAMS_PERSON_RESPONSIBLE Person Resp. ID
lastchangebyuser AUFAENAM Changed By
lastchangedatetime TZNTSTMPS Time Stamp
createdbyuser AUFERFNAM Entered By
maintordercreationdatetime TIMESTAMP Time Stamp
orderhaslongtext PPH_AUFLTXT Order Has Long Text
maintorderprocessingcontext MAINTORDERPROCESSINGCONTEXT Processing Context
maintenanceorderoverheadcode AUFZSCHL Overhead key
plannedcostscostingvariant KALKVARPLN Plnd Costing Variant
actualcostscostingvariant KALKVARIST Act. Costing Variant
maintenanceplan WARPL MaintenancePlan
maintenancecall ABNUM Call Number
maintenanceitem WAPOS MaintItem
leadingorder LAUFN Last order
tasklisttype BILLOFOPERATIONSTYPE BOO Type
tasklistgroup BILLOFOPERATIONS Bill of Operations
tasklistgroupcounter BILLOFOPERATIONSVARIANT BOO Variant
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes
dummy_afih_incl_eew_ps CFD_DUMMY Dummy

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_MAINTENANCEORDERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MAINTORD_D (
    MANDT,                           -- Client [MANDT]
    MAINTENANCEORDER,                -- Order [AUFNR]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    MAINTORDERROUTINGNUMBER,         -- Plan No.f.Oper. [CO_AUFPL]
    MAINTENANCEORDERTYPE,            -- Order Type [AUFART]
    MAINTENANCEORDERDESC,            -- Description [AUFTEXT]
    MAINTORDBASICSTARTDATETIME,      -- Time Stamp [TIMESTAMP]
    MAINTORDBASICENDDATETIME,        -- Time Stamp [TIMESTAMP]
    MAINTORDBASICSTARTDATE,          -- abap.dats
    MAINTORDBASICSTARTTIME,          -- abap.tims
    MAINTORDBASICENDDATE,            -- abap.dats
    MAINTORDBASICENDTIME,            -- abap.tims
    MAINTORDSCHEDLDBSCSTRTDATETIME,  -- Time Stamp [TIMESTAMP]
    MAINTORDSCHEDLDBSCENDDATETIME,   -- Time Stamp [TIMESTAMP]
    SCHEDULEDBASICSTARTDATE,         -- abap.dats
    SCHEDULEDBASICSTARTTIME,         -- abap.tims
    SCHEDULEDBASICENDDATE,           -- abap.dats
    SCHEDULEDBASICENDTIME,           -- abap.tims
    MAINTORDERREFERENCEDATETIME,     -- Time Stamp [TIMESTAMP]
    MAINTORDERREFERENCEDATE,         -- abap.dats
    MAINTORDERREFERENCETIME,         -- abap.tims
    MAINWORKCOMPLETEDDATETIME,       -- Main Work Completed [EAM_MAIN_WORK_COMPLETED_TSTMP]
    MAINTENANCENOTIFICATION,         -- Notification [QMNUM]
    ORDISNOTSCHEDLDAUTOMATICALLY,    -- No auto. cost. [CO_NAUTERM]
    MAINWORKCENTERINTERNALID,        -- Work Center [LGWID]
    MAINWORKCENTERTYPECODE,          -- Object Type [PM_OBJTY]
    MAINWORKCENTER,                  -- Work Center [PPH_ARBPL]
    MAINWORKCENTERPLANT,             -- Plant [WERKS_D]
    CONTROLLINGAREA,                 -- CO Area [KOKRS]
    SERVICEDOCUMENTTYPE,             -- Transaction Type [CRMT_PROCESS_TYPE]
    SERVICEDOCUMENT,                 -- Transaction ID [CRMT_OBJECT_ID_DB]
    SERVICEDOCUMENTITEM,             -- Item Number in Doc. [CRMS4_NUMBER_INT]
    MAINTENANCEPLANNINGPLANT,        -- Planning Plant [IWERK]
    ASSEMBLY,                        -- Assembly [BAUTL]
    MAINTORDPROCESSPHASECODE,        -- Process Phase [EAM_OSTAT_PHASE]
    MAINTORDPROCESSSUBPHASECODE,     -- Process Subphase [EAM_OSTAT_SPHASE]
    COMPANYCODE,                     -- Company Code [BUKRS]
    BUSINESSAREA,                    -- Business Area [GSBER]
    REFERENCEELEMENT,                -- Ref. Element PM/PS [ADDCOMPARE_CORE]
    FUNCTIONALAREA,                  -- Functional Area [FKBER]
    ADDITIONALDEVICEDATA,            -- Device Data [DEVICEID]
    EQUIPMENT,                       -- Equipment [EQUNR]
    MAINTENANCEORDERPLANNINGCODE,    -- OrderPlanInd. [AUF_PLKNZ]
    MAINTENANCEPLANNERGROUP,         -- Planner Group [INGRP]
    MAINTENANCEACTIVITYTYPE,         -- Activity Type [EAM_MAINT_ACTIVITY_TYPE]
    MAINTPRIORITY,                   -- Priority [PRIOK]
    MAINTPRIORITYTYPE,               -- PriorityType [ARTPR]
    ORDERPROCESSINGGROUP,            -- Process. group [AUFABKRS]
    PROFITCENTER,                    -- Profit Center [PRCTR]
    RESPONSIBLECOSTCENTER,           -- Respons. Cost Center [PPH_KOSTL]
    COSTINGSHEET,                    -- Costing Sheet [AUFKALSM]
    CONDITIONUSAGE,                  -- Usage [KVEWE]
    CONDITIONAPPLICATION,            -- Application [KAPPL]
    CURRENCY,                        -- Currency [AUFWAERS]
    MAINTENANCEREVISION,             -- Revision [REVNI]
    SERIALNUMBER,                    -- Serial Number [VDM_EAM_GERNR]
    PRODUCT,                         -- Material [MATNR]
    SUPERIORPROJECTNETWORK,          -- Subnetwork of [CO_TEILNET]
    OPERATIONSYSTEMCONDITION,        -- SystemCondition [ANLZU]
    WBSELEMENTINTERNALID,            -- WBS Internal ID [PS_S4_PSPNR]
    PROJECTINTERNALID,               -- Project Def. [PS_S4_PROJ_PSPNR]
    LOCACCTASSGMTWBSELMNTINTID,      -- WBS Internal ID [PS_S4_PSPNR]
    COSTCENTER,                      -- Cost Center [KOSTL]
    CONTROLLINGOBJECTCLASS,          -- Controlling Object Class [PPH_SCOPE]
    FUNCTIONALLOCATION,              -- Functional Location [VDM_EAM_TPLNR]
    MAINTENANCEPLANT,                -- MaintPlant [SWERK]
    ASSETLOCATION,                   -- Location [PMLOC]
    ASSETROOM,                       -- Room [RAUMNR]
    PLANTSECTION,                    -- Plant Section [BEBER]
    ABCINDICATOR,                    -- ABC Indic. [ABCKZ]
    MAINTOBJECTFREEDEFINEDATTRIB,    -- Sort Field [EQFNR]
    WORKCENTERINTERNALID,            -- PP work ctr [PPSID]
    WORKCENTERTYPECODE,              -- Object Type [CR_OBJTY]
    WORKCENTER,                      -- Work Center [PPH_ARBPL]
    LOCACCTASSGMTBUSINESSAREA,       -- Business Area [GSBER]
    SETTLEMENTORDER,                 -- SettlementOrder [ILOM_ORDST]
    MASTERFIXEDASSET,                -- Asset [ANLN1]
    FIXEDASSET,                      -- Sub-number [ANLN2]
    STANDINGORDERNUMBER,             -- StandgOrder [DAUFN]
    SALESORGANIZATION,               -- Sales Org. [VKORG]
    DISTRIBUTIONCHANNEL,             -- Distr. Channel [VTWEG]
    ORGANIZATIONDIVISION,            -- Division [SPART]
    LOCACCTASSGMTCONTROLLINGAREA,    -- CO Area [KOKRS]
    LOCACCTASSGMTCOMPANYCODE,        -- Company Code [BUKRS]
    MAINTENANCEORDERINTERNALID,      -- Object number [J_OBJNR]
    MAINTENANCEITEMOBJECTLIST,       -- Object list [OBJKNR]
    MAINTOBJECTLOCACCTASSGMTNMBR,    -- Loc/AccAssmt [ILOAN]
    CONTROLLINGSETTLEMENTPROFILE,    -- Settlement Profile [FCO_APROF]
    BASICSCHEDULINGTYPE,             -- Scheduling type [TERMKZ]
    LATESTACCEPTABLECOMPLETIONDATE,  -- Final Due Date [VDM_LACD_DATE]
    MAINTORDPERSONRESPONSIBLE,       -- Person Resp. ID [EAMS_PERSON_RESPONSIBLE]
    LASTCHANGEBYUSER,                -- Changed By [AUFAENAM]
    LASTCHANGEDATETIME,              -- Time Stamp [TZNTSTMPS]
    CREATEDBYUSER,                   -- Entered By [AUFERFNAM]
    MAINTORDERCREATIONDATETIME,      -- Time Stamp [TIMESTAMP]
    ORDERHASLONGTEXT,                -- Order Has Long Text [PPH_AUFLTXT]
    MAINTORDERPROCESSINGCONTEXT,     -- Processing Context [MAINTORDERPROCESSINGCONTEXT]
    MAINTENANCEORDEROVERHEADCODE,    -- Overhead key [AUFZSCHL]
    PLANNEDCOSTSCOSTINGVARIANT,      -- Plnd Costing Variant [KALKVARPLN]
    ACTUALCOSTSCOSTINGVARIANT,       -- Act. Costing Variant [KALKVARIST]
    MAINTENANCEPLAN,                 -- MaintenancePlan [WARPL]
    MAINTENANCECALL,                 -- Call Number [ABNUM]
    MAINTENANCEITEM,                 -- MaintItem [WAPOS]
    LEADINGORDER,                    -- Last order [LAUFN]
    TASKLISTTYPE,                    -- BOO Type [BILLOFOPERATIONSTYPE]
    TASKLISTGROUP,                   -- Bill of Operations [BILLOFOPERATIONS]
    TASKLISTGROUPCOUNTER,            -- BOO Variant [BILLOFOPERATIONSVARIANT]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_AFIH_INCL_EEW_PS,          -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, MAINTENANCEORDER, DRAFTUUID)
);

Learn More