I_MAINTENANCEITEMOBJECT

CDS View
9 Fields 26 CDS Views

Maintenance Item Object List

I_MAINTENANCEITEMOBJECT is a CDS View in S/4HANA. Maintenance Item Object List. It contains 9 fields. 26 CDS views read from this table.

CDS Views using this table (26)

ViewTypeJoinVDMDescription
A_MaintenanceItemObj view from BASIC CDS view for API exposure
A_MaintenanceItemObj_1 view from BASIC CDS view for API exposure
A_MaintenanceItemObjList view from BASIC CDS View for Maintenance Item Object List
A_MaintenanceItemObjList_1 view from BASIC CDS View for Maintenance Item Object List
A_ReturnsDeliveryMaintObj view from BASIC Returns Delivery Maintenance Object
A_ReturnsDeliveryMaintObj_1 view from BASIC Returns Delivery Maintenance Object
C_CustRetRefDocSrlNmbr view_entity inner CONSUMPTION Returns Order Reference Document Serial Number
C_MaintItemObjPgObjectList view from CONSUMPTION Object List for the Maintenance Item Object Page
C_MaterialDocumentSerialNoFDP view inner CONSUMPTION Material Document Serial Numbers Output Forms
C_PT_SAFTBillingItemSerialNmbr view inner CONSUMPTION SAF-T PT Item Serial Numbers
C_PT_SAFTProductSerialNumber view_entity inner CONSUMPTION Product Serial Number - Cube
C_SAFTDeliverySerialNumber view inner CONSUMPTION PT SAFT MOG Serial Number
C_SerialNmbrEquipNmbrDelivery view left_outer CONSUMPTION Serial and Equipment Numbers
I_CustomerReturnSerialNumber view inner COMPOSITE Returns Order Serial Number
I_FldLogsMaintObjListDelivPO view_entity from COMPOSITE Serial Number
I_FldLogsSrlNmbrItems view inner COMPOSITE Field Logistics Serial Numbers
I_InspLotSerialNumber view_entity inner COMPOSITE Serial Numbers of Inspection Lot
I_InspLotSerialNumber_2 view_entity inner COMPOSITE Serial Number of Inspection Lot
I_MaintItemObjListTechObj view from COMPOSITE Maintenance Item Object List with Technical Object
I_MaintItemObjListTechObj view union_all COMPOSITE Maintenance Item Object List with Technical Object
I_MfgOrderItemSerialNumber view inner COMPOSITE Manufacturing Order Item Serial Number
I_OpenMaintOrderForTechObject view union COMPOSITE Open Maintainance Orders for Technical Object
I_PlantMaintObjectListData view from COMPOSITE Object List Data (Extractor)
I_ProdnOrderItemSerialNumber view_entity inner COMPOSITE Serial Number of Production Order Item
I_SerialNumberMaterialDocument view inner COMPOSITE Serial Number Material Documents
P_PhysInvtryDocSrlNmbr view inner COMPOSITE

Fields (9)

KeyField CDS FieldsUsed in Views
KEY Equipment Equipment 8
KEY MaintenanceItemObject MaintenanceItemObject 9
KEY MaintenanceItemObjectList MaintenanceItemObjectList 7
KEY SerialNumber SerialNumber 15
Assembly Assembly 6
FunctionalLocation FunctionalLocation 6
MaintenanceNotification MaintenanceNotification 6
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr 6
Material Material 7

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 Object List
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTENANCEITEMOBJECT (
    EQUIPMENT,
    MAINTENANCEITEMOBJECT,
    MAINTENANCEITEMOBJECTLIST,
    SERIALNUMBER,
    ASSEMBLY,
    FUNCTIONALLOCATION,
    MAINTENANCENOTIFICATION,
    MAINTOBJECTLOCACCTASSGMTNMBR,
    MATERIAL,
    PRIMARY KEY (EQUIPMENT, MAINTENANCEITEMOBJECT, MAINTENANCEITEMOBJECTLIST, SERIALNUMBER)
);

Learn More