_MAINTENANCEITEM

_MAINTENANCEITEM is an SAP database table in S/4HANA. It contains 7 fields.

Fields (7)

KeyField CDS FieldsUsed in Views
KEY MaintenanceItem MaintenanceItem 2
_MaintenanceStrategy _MaintenanceStrategy 1
MaintenanceItemDescription MaintenanceItemDescription,MaintenancePlanItemDesc 7
MaintenancePlanCategory MaintenancePlanCategory 1
MaintenancePlannerGroup MaintenancePlannerGroup 2
MaintenancePlanningPlant MaintenancePlanningPlant 2
MaintenanceStrategy MaintenanceStrategy 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 _MAINTENANCEITEM (
    MAINTENANCEITEM,
    _MAINTENANCESTRATEGY,
    MAINTENANCEITEMDESCRIPTION,
    MAINTENANCEPLANCATEGORY,
    MAINTENANCEPLANNERGROUP,
    MAINTENANCEPLANNINGPLANT,
    MAINTENANCESTRATEGY,
    PRIMARY KEY (MAINTENANCEITEM)
);