I_RSHORDER
Maintenance Orders
I_RSHORDER is a CDS View in S/4HANA. Maintenance Orders. It contains 44 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_RSHMaintOperationAssgmtTP | view | inner | TRANSACTIONAL | Maintenance Operation Assignment TP |
| I_RSHMaintSchedExistingOp | view | inner | COMPOSITE | Existing Operations not part of Schedule |
| I_RSHOperationAndSubOperation | view | inner | COMPOSITE | Maintenance Order Operation and Suboperation |
| P_RSHMaintSchedAddlDispOp | view | inner | CONSUMPTION | Additional dispatched operations in frozen schedule |
| P_RSHMaintSchedOperations | view | inner | CONSUMPTION | Operations from frozen schedule |
Fields (44)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| _BasicSchedulingType | _BasicSchedulingType | 3 | |
| _Equipment | _Equipment | 3 | |
| _LocationAccountAssignment | _LocationAccountAssignment | 3 | |
| _MaintenanceActivityType | _MaintenanceActivityType | 3 | |
| _MaintenanceNotification | _MaintenanceNotification | 3 | |
| _MaintenancePriority | _MaintenancePriority | 3 | |
| _Project | _Project | 2 | |
| _WBSElement | _WBSElement | 2 | |
| BasicSchedulingType | BasicSchedulingType | 3 | |
| ControllingArea | ControllingArea | 3 | |
| Equipment | Equipment | 3 | |
| LatestAcceptableCompletionDate | LatestAcceptableCompletionDate | 3 | |
| MaintenanceActivityType | MaintenanceActivityType | 3 | |
| MaintenanceNotification | MaintenanceNotification | 3 | |
| MaintenanceOrder | MaintenanceOrder | 4 | |
| MaintenanceOrderDesc | MaintenanceOrderDesc | 3 | |
| MaintenanceOrderInternalID | MaintenanceOrderInternalID | 3 | |
| MaintenanceOrderType | MaintenanceOrderType | 3 | |
| MaintenancePlan | MaintenancePlan | 3 | |
| MaintenancePlannerGroup | MaintenancePlannerGroup | 3 | |
| MaintenancePlanningPlant | MaintenancePlanningPlant | 3 | |
| MaintenancePlant | MaintenancePlant | 3 | |
| MaintenanceRevision | MaintenanceRevision | 3 | |
| MaintenanceRevisionDesc | MaintenanceRevisionDesc | 1 | |
| MaintObjectLocAcctAssgmtNmbr | MaintObjectLocAcctAssgmtNmbr | 3 | |
| MaintOrdBasicEndDate | MaintOrdBasicEndDate | 3 | |
| MaintOrdBasicEndTime | MaintOrdBasicEndTime | 3 | |
| MaintOrdBasicStartDate | MaintOrdBasicStartDate | 3 | |
| MaintOrdBasicStartTime | MaintOrdBasicStartTime | 3 | |
| MaintOrdProcessPhaseCode | MaintOrdProcessPhaseCode | 1 | |
| MaintOrdProcessSubPhaseCode | MaintOrdProcessSubPhaseCode | 1 | |
| MaintPriority | MaintPriority | 3 | |
| MaintPriorityType | MaintPriorityType | 3 | |
| MainWorkCenter | MainWorkCenter | 3 | |
| MainWorkCenterPlant | MainWorkCenterPlant | 3 | |
| OperationSystemCondition | OrderSystemCondition | 3 | |
| OrderHasLongText | OrderHasLongText | 2 | |
| OrdIsNotSchedldAutomatically | OrdIsNotSchedldAutomatically | 1 | |
| ProjectInternalID | ProjectInternalID | 1 | |
| ResponsibleCostCenter | ResponsibleCostCenter | 3 | |
| SchedulingIsPerformedBackward | SchedulingIsPerformedBackward | 3 | |
| SchedulingType | SchedulingType | 3 | |
| SuperiorProjectNetwork | SuperiorProjectNetwork | 3 | |
| WBSElementInternalID | WBSElementInternalID | 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 Orders
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RSHORDER (
_BASICSCHEDULINGTYPE,
_EQUIPMENT,
_LOCATIONACCOUNTASSIGNMENT,
_MAINTENANCEACTIVITYTYPE,
_MAINTENANCENOTIFICATION,
_MAINTENANCEPRIORITY,
_PROJECT,
_WBSELEMENT,
BASICSCHEDULINGTYPE,
CONTROLLINGAREA,
EQUIPMENT,
LATESTACCEPTABLECOMPLETIONDATE,
MAINTENANCEACTIVITYTYPE,
MAINTENANCENOTIFICATION,
MAINTENANCEORDER,
MAINTENANCEORDERDESC,
MAINTENANCEORDERINTERNALID,
MAINTENANCEORDERTYPE,
MAINTENANCEPLAN,
MAINTENANCEPLANNERGROUP,
MAINTENANCEPLANNINGPLANT,
MAINTENANCEPLANT,
MAINTENANCEREVISION,
MAINTENANCEREVISIONDESC,
MAINTOBJECTLOCACCTASSGMTNMBR,
MAINTORDBASICENDDATE,
MAINTORDBASICENDTIME,
MAINTORDBASICSTARTDATE,
MAINTORDBASICSTARTTIME,
MAINTORDPROCESSPHASECODE,
MAINTORDPROCESSSUBPHASECODE,
MAINTPRIORITY,
MAINTPRIORITYTYPE,
MAINWORKCENTER,
MAINWORKCENTERPLANT,
OPERATIONSYSTEMCONDITION,
ORDERHASLONGTEXT,
ORDISNOTSCHEDLDAUTOMATICALLY,
PROJECTINTERNALID,
RESPONSIBLECOSTCENTER,
SCHEDULINGISPERFORMEDBACKWARD,
SCHEDULINGTYPE,
SUPERIORPROJECTNETWORK,
WBSELEMENTINTERNALID
);
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