I_MAINTENANCEOBJECTLISTITEM

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);