I_MAINTENANCEITEM

CDS View
13 Fields 16 CDS Views

Maintenance Item

I_MAINTENANCEITEM is a CDS View in S/4HANA. Maintenance Item. It contains 13 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
C_TechObjMaintenanceItem view from CONSUMPTION Maintenance Items for Technical Object
C_TechObjMaintenanceItem view union_all CONSUMPTION Maintenance Items for Technical Object
I_MaintenanceItemSituation view_entity from COMPOSITE Situation Handling Maintenance Item
I_MaintenanceItemStdVH view from COMPOSITE Maintenance Item
I_MaintenanceItemTechObj view from COMPOSITE Maintenance Item with Technical Object
I_MaintenanceItemTechObj view union_all COMPOSITE Maintenance Item with Technical Object
I_MaintenanceItemText view from COMPOSITE Maintenance Item Long Text
I_MaintenanceItemTP view from TRANSACTIONAL Maintenance Item (Transactional Processing)
I_TechObjSrvcMaintenanceItem view from COMPOSITE Technical obj in Maint item for service
I_TechObjSrvcMaintenanceItem view union_all COMPOSITE Technical obj in Maint item for service
P_MaintenanceItemSearch view from COMPOSITE
P_RSHMaintAssetBoard view inner CONSUMPTION Maintenance Asset Board
P_RSHMaintAssetBoardShapes view inner CONSUMPTION Maintenance asset board shapes
P_RSHMaintCallOrderProcStatus view inner CONSUMPTION Processing Status for Maint. Call Orders
P_RSHMaintPlanConsumption view inner CONSUMPTION Maintenance Plan Consumption
R_MaintenanceItemTP view_entity from TRANSACTIONAL Maintenance Item

Fields (13)

KeyField CDS FieldsUsed in Views
KEY MaintenanceItem MaintenanceItem 2
KEY MaintenancePlan MaintenancePlan 1
MaintenanceActivityType MaintenanceActivityType 1
MaintenanceOrderType OrderType 1
MaintenancePlannerGroup MaintenancePlannerGroup 1
MaintenancePlanningPlant MaintenancePlanningPlant 1
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr 1
MaintPriority Priority 1
MaintPriorityType PriorityType 1
ObjectInternalID ObjectInternalID 1
TaskListGroup BillOfOperationsGroup 1
TaskListGroupCounter BillOfOperationsVariant 1
TaskListType BillOfOperationsType 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.

-- Maintenance Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTENANCEITEM (
    MAINTENANCEITEM,
    MAINTENANCEPLAN,
    MAINTENANCEACTIVITYTYPE,
    MAINTENANCEORDERTYPE,
    MAINTENANCEPLANNERGROUP,
    MAINTENANCEPLANNINGPLANT,
    MAINTOBJECTLOCACCTASSGMTNMBR,
    MAINTPRIORITY,
    MAINTPRIORITYTYPE,
    OBJECTINTERNALID,
    TASKLISTGROUP,
    TASKLISTGROUPCOUNTER,
    TASKLISTTYPE,
    PRIMARY KEY (MAINTENANCEITEM, MAINTENANCEPLAN)
);

Learn More