I_MAINTENANCEREVISION

CDS View

Maintenance Revision

I_MAINTENANCEREVISION is a CDS View in S/4HANA. Maintenance Revision. It contains 5 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_RSHPlngBucketAndEventDetails view_entity from CONSUMPTION Maintenance Event and Planning bucket
I_MaintenanceEventStdVH view_entity inner COMPOSITE Maintenance Event
I_MaintenanceRevisionStdVH view from COMPOSITE Maintenance Event
I_MaintenanceRevisionValueHelp view_entity from COMPOSITE Maintenance Revisions

Fields (5)

KeyField CDS FieldsUsed in Views
KEY MaintenancePlanningPlant MaintenancePlanningPlant 1
KEY MaintenanceRevision MaintenanceEvent 1
MaintenanceEventType MaintenanceEventType 1
MaintenanceEventTypeCategory MaintenanceEventTypeCategory 1
MaintenanceRevisionDesc MaintenanceEventText 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 Revision
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTENANCEREVISION (
    MAINTENANCEPLANNINGPLANT,
    MAINTENANCEREVISION,
    MAINTENANCEEVENTTYPE,
    MAINTENANCEEVENTTYPECATEGORY,
    MAINTENANCEREVISIONDESC,
    PRIMARY KEY (MAINTENANCEPLANNINGPLANT, MAINTENANCEREVISION)
);