I_MAINTENANCEOBJECTLISTITEM
Maintenance Object List Item
I_MAINTENANCEOBJECTLISTITEM is a CDS View in S/4HANA. Maintenance Object List Item. It contains 21 fields. 21 CDS views read from this table.
CDS Views using this table (21)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CustRetsDeliveryItmSrlNmbrDP | view_entity | from | CONSUMPTION | Data Provider for Cust Rets Dlv Item SN |
| C_InboundDeliveryItmSrlNmbrDP | view_entity | from | CONSUMPTION | Data Provider for Inb Delivery Item SN |
| C_MaintOrdObjectListItemDEX | view_entity | from | CONSUMPTION | Maintenance Order Object List Item DEX |
| C_OutboundDeliveryItmSrlNmbrDP | view_entity | from | CONSUMPTION | Data Provider for Outb Delivery Item SN |
| C_PhysInvtryBookSerialNmbrDP | view_entity | inner | CONSUMPTION | Physical Inventory Book Serial Number |
| C_PhysInvtryCountSerialNmbrDP | view_entity | inner | CONSUMPTION | Physical Inventory Count Serial Number |
| I_MaintItemObjectListItem | view | inner | COMPOSITE | Maintenance Item Object List Item |
| I_MaintOrderObjectListItem | view | from | COMPOSITE | Object List of Maintenance Order |
| I_SerialNumberDeliveryDocument | view_entity | inner | COMPOSITE | Serial Number in Delivery Document |
| I_SerialNumberHandlingUnit | view_entity | inner | COMPOSITE | Serial Number in Handling Unit |
| I_SerialNumberInspectionLot | view_entity | inner | COMPOSITE | Serial Number in Inspection Lot |
| I_SerialNumberJITCall | view_entity | inner | COMPOSITE | Serial Number in JIT Call |
| I_SerialNumberMaintenanceOrder | view_entity | inner | COMPOSITE | Serial Number in Maintenance Order |
| I_SerialNumberManufacturingOrd | view_entity | inner | COMPOSITE | Serial Number in Manufacturing Order |
| I_SerialNumberMaterialDoc_2 | view_entity | inner | COMPOSITE | Serial Number in Material Document |
| I_SerialNumberPhysInventoryDoc | view_entity | inner | COMPOSITE | Serial Number in Physical Inventory Doc |
| I_SerialNumberPurchaseOrder | view_entity | inner | COMPOSITE | Serial Number in Purchase Order |
| I_SerialNumberPurchaseReqn | view_entity | inner | COMPOSITE | Serial Number in Purchase Requisition |
| I_SerialNumberSalesOrder | view_entity | inner | COMPOSITE | Serial Number in Sales Order |
| I_SlsDocItemSerialNumber | view_entity | inner | COMPOSITE | Serial Number in Sales Document Item |
| P_SrlNmbrHistLogisticsDocument | view_entity | from | COMPOSITE | Serial Number Logistics Documents |
Fields (21)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Equipment | Equipment | 16 |
| KEY | MaintenanceObjectList | MaintenanceItemObjectList,MaintenanceObjectList,MaintenanceOrderObjectList | 8 |
| KEY | MaintenanceObjectListItem | MaintenanceObjectListItem | 8 |
| KEY | SerialNumber | SerialNumber | 19 |
| _Assembly | _Assembly | 1 | |
| _Equipment | _Equipment | 13 | |
| _LocationAccountAssignment | _LocationAccountAssignment | 1 | |
| _PMNotifMaintenanceData | _PMNotifMaintenanceData | 1 | |
| _Product | _Product | 13 | |
| _SerialNumber | _SerialNumber | 1 | |
| _UniqueItemIdentifier | _UniqueItemIdentifier | 1 | |
| Assembly | Assembly | 2 | |
| CreationDate | CreationDate | 3 | |
| MaintenanceNotification | MaintenanceNotification | 3 | |
| MaintenanceObjectListUsageCode | MaintenanceObjectListUsageCode | 3 | |
| MaintObjectListItemSequence | MaintObjectListItemSequence | 3 | |
| MaintObjectLocAcctAssgmtNmbr | MaintObjectLocAcctAssgmtNmbr | 2 | |
| MaintObjListEntryIsProcessed | MaintObjListEntryIsProcessed | 3 | |
| Material | Material,Product | 17 | |
| ServiceReferenceProduct | ServiceReferenceProduct | 1 | |
| UniqueItemIdentifier | UniqueItemIdentifier | 2 |
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 Object List Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTENANCEOBJECTLISTITEM (
EQUIPMENT,
MAINTENANCEOBJECTLIST,
MAINTENANCEOBJECTLISTITEM,
SERIALNUMBER,
_ASSEMBLY,
_EQUIPMENT,
_LOCATIONACCOUNTASSIGNMENT,
_PMNOTIFMAINTENANCEDATA,
_PRODUCT,
_SERIALNUMBER,
_UNIQUEITEMIDENTIFIER,
ASSEMBLY,
CREATIONDATE,
MAINTENANCENOTIFICATION,
MAINTENANCEOBJECTLISTUSAGECODE,
MAINTOBJECTLISTITEMSEQUENCE,
MAINTOBJECTLOCACCTASSGMTNMBR,
MAINTOBJLISTENTRYISPROCESSED,
MATERIAL,
SERVICEREFERENCEPRODUCT,
UNIQUEITEMIDENTIFIER,
PRIMARY KEY (EQUIPMENT, MAINTENANCEOBJECTLIST, MAINTENANCEOBJECTLISTITEM, SERIALNUMBER)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA