I_RSHASSIGNEDWORKCENTERS
Work Centers Assigned to Me
I_RSHASSIGNEDWORKCENTERS is a CDS View in S/4HANA. Work Centers Assigned to Me. It contains 8 fields. 22 CDS views read from this table.
CDS Views using this table (22)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_RSHEAMUserVariant | view | from | CONSUMPTION | Work Centers Assigned to Me |
| C_RSHMaintSchedMissingWrkCtr | view | left_outer | CONSUMPTION | Unassigned Work Centers in Schedule |
| C_RSHMaintSchedSmltdOrdAndOp | view | left_outer | CONSUMPTION | Maint Scheduling Simulation Operations |
| C_RSHOrderGanttCalendar | view | from | CONSUMPTION | Calendars for order gantt |
| C_RSHOrderGanttNonWrkgTmeIntvl | view | from | CONSUMPTION | Non working time display in order gantt |
| C_RSHOverloadedWC | view | from | CONSUMPTION | Work Center Utilization Overview |
| C_RSHWorkCtrUtilization | view | from | CONSUMPTION | |
| C_RSHWorkCtrUtilznIndicator | view | from | CONSUMPTION | |
| I_RSHMaintOperationAssgmtTP | view | inner | TRANSACTIONAL | Maintenance Operation Assignment TP |
| I_RSHOperationAndSubOperation | view | inner | COMPOSITE | Maintenance Order Operation and Suboperation |
| P_RSHDueOperForKPIDetails | view | inner | CONSUMPTION | Due Order Operation KPI Details |
| P_RSHExOpsForScheduling | view | inner | CONSUMPTION | |
| P_RSHOperationsForKPI | view | inner | CONSUMPTION | Operations and Sub Operations for overview page |
| P_RSHOperationsForKPIDetails | view | inner | CONSUMPTION | Order KPI Details |
| P_RSHOperationsForUtilization | view | inner | CONSUMPTION | Operations and Sub Operations for utilization |
| P_RSHOpsForUtilization | view_entity | inner | CONSUMPTION | Operations and Sub Operations for utilization |
| P_RSHPastOperForKPIDetails | view | inner | CONSUMPTION | Past Order Operation KPI Details |
| P_RSHSmltdOpCapacity | view | inner | CONSUMPTION | |
| P_RSHTaskListOperations | view | inner | CONSUMPTION | Task List Operations |
| P_RSHUserVariantWithHdrDetail | view | from | CONSUMPTION | User Variant With Header Detail |
| P_RSHWCHeaderCapacityDefinitio | view | inner | CONSUMPTION | |
| P_RSHWrkCtrPersonResponsibleVH | view | inner | CONSUMPTION | Value help with work centers assigned to the users |
Fields (8)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | WorkCenter | WorkCenter | 8 |
| KEY | WorkCenterInternalID | WorkCenterInternalID | 4 |
| KEY | WorkCenterTypeCode | WorkCenterTypeCode | 4 |
| _WorkCenter | _WorkCenter | 1 | |
| _WorkCenterType | _WorkCenterType | 1 | |
| CapacityInternalID | CapacityInternalID | 5 | |
| Plant | Plant | 2 | |
| WorkCenterCategoryCode | WorkCenterCategoryCode | 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.
-- Work Centers Assigned to Me
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RSHASSIGNEDWORKCENTERS (
WORKCENTER,
WORKCENTERINTERNALID,
WORKCENTERTYPECODE,
_WORKCENTER,
_WORKCENTERTYPE,
CAPACITYINTERNALID,
PLANT,
WORKCENTERCATEGORYCODE,
PRIMARY KEY (WORKCENTER, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);
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