I_MAINTENANCEJOBANDWORKITEM

CDS View

Maintenance Job and Work Items

I_MAINTENANCEJOBANDWORKITEM is a CDS View in S/4HANA. Maintenance Job and Work Items. It contains 5 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_MalfunctionReportInvlmnts view from CONSUMPTION Malfunction Report User Involvements
I_MaintJobAndWorkItemForUser view_entity from COMPOSITE Current Users Maintenance Jobs and Work Items

Fields (5)

KeyField CDS FieldsUsed in Views
KEY MaintenanceJobInternalID MaintenanceJobInternalID 1
KEY ObjectType ObjectType 1
KEY StatusObject StatusObject 1
PersonResponsible PersonResponsible 1
StatusCode StatusCode 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 Job and Work Items
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTENANCEJOBANDWORKITEM (
    MAINTENANCEJOBINTERNALID,
    OBJECTTYPE,
    STATUSOBJECT,
    PERSONRESPONSIBLE,
    STATUSCODE,
    PRIMARY KEY (MAINTENANCEJOBINTERNALID, OBJECTTYPE, STATUSOBJECT)
);