_MAINTENANCEORDERDEX

16 Fields

_MAINTENANCEORDERDEX is an SAP database table in S/4HANA. It contains 16 fields.

Fields (16)

KeyField CDS FieldsUsed in Views
Assembly Assembly 1
ControllingArea ControllingArea 1
Equipment Equipment 1
FunctionalLocation FunctionalLocation 1
LastChangeDateTime LastChangeDateTime 1
LatestAcceptableCompletionDate LatestAcceptableCompletionDate 1
MaintenanceActivityType MaintenanceActivityType 1
MaintenanceOrderType MaintenanceOrderType 1
MaintenancePlannerGroup MaintenancePlannerGroup 1
MaintenancePlanningPlant MaintenancePlanningPlant 1
MaintenancePlant MaintenancePlant 1
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr 1
MaintOrderProcessingContext MaintOrderProcessingContext 1
MaintOrdProcessPhaseCode MaintOrdProcessPhaseCode 1
MaintOrdProcessSubPhaseCode MaintOrdProcessSubPhaseCode 1
ResponsibleCostCenter ResponsibleCostCenter 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 _MAINTENANCEORDERDEX (
    ASSEMBLY,
    CONTROLLINGAREA,
    EQUIPMENT,
    FUNCTIONALLOCATION,
    LASTCHANGEDATETIME,
    LATESTACCEPTABLECOMPLETIONDATE,
    MAINTENANCEACTIVITYTYPE,
    MAINTENANCEORDERTYPE,
    MAINTENANCEPLANNERGROUP,
    MAINTENANCEPLANNINGPLANT,
    MAINTENANCEPLANT,
    MAINTOBJECTLOCACCTASSGMTNMBR,
    MAINTORDERPROCESSINGCONTEXT,
    MAINTORDPROCESSPHASECODE,
    MAINTORDPROCESSSUBPHASECODE,
    RESPONSIBLECOSTCENTER
);

Learn More