P_RSHAssignedWorkcenters

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_RSHAssignedWorkcenters.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PRSHASSIGNEDWCS

CREATE VIEW P_RSHAssignedWorkcenters AS
SELECT
  rsh_d_usr_def.username AS UserName,
  rsh_d_usr_wc.wc_objid AS WorkCenterInternalID,
  rsh_d_usr_wc.wc_objty AS WorkCenterTypeCode,
  _WorkCenter.Plant AS Plant,
  _WorkCenter.CapacityInternalID AS CapacityInternalID,
  _WorkCenter.WorkCenter AS WorkCenter,
  _WorkCenter.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  ' ' AS DummyTypeCode
FROM rsh_d_usr_def
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode  -- association [1..1]
;