I_RSHASSIGNEDWORKCENTERS

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);