I_WrkCtrCapByAreaOfRespy

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 I_WrkCtrCapByAreaOfRespy.
-- 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: IWCCAPBYAOR

CREATE VIEW I_WrkCtrCapByAreaOfRespy AS
SELECT
  _WorkCenterCapacity.WorkCenterInternalID AS WorkCenterInternalID,
  _WorkCenterCapacity.WorkCenterTypeCode AS WorkCenterTypeCode,
  _WorkCenterCapacity.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  _WorkCenterCapacity.CapacityInternalID AS CapacityInternalID,
  _WorkCenterCapacity.Plant AS Plant,
  _WorkCenterCapacity.WorkCenter AS WorkCenter,
  _WorkCenterCapacity.CapacityCategoryCode AS CapacityCategoryCode,
  _WorkCenterCapacity.Capacity AS Capacity,
  _Capacity.CapacityActiveVersion AS CapacityActiveVersion,
  _WorkCenter.WorkCenterResponsible AS WorkCenterResponsible,
  _Capacity.CapacityResponsiblePlanner AS CapacityResponsiblePlanner,
  _WorkCenterCapacity._WorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS WorkCenterDesc,
  cast( _WorkCenterCapacity.CapacityInternalID as abap.dec(15,0) ) AS LastChangeDateTime,
  _Capacity.CapacityLastChangeDateTime AS CapacityLastChangeDateTime,
  _WorkCenterCapacity._Plant.PlantName AS PlantName,
  cast('W' as abap.char( 1 )) AS AreaOfRespyUserPreference
FROM I_WorkCenterCapacity AS _WorkCenterCapacity
INNER JOIN I_WrkCtrUtilznPrsnlzn AS _prsnlzn ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaterialPlant AS _MaterialVH ON /* join condition not captured in parsed metadata */
INNER JOIN P_WrkCtrCapAreaOfRespyHrzn AS _Horizon ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProductionVersion AS _ProductionVersions ON /* join condition not captured in parsed metadata */
INNER JOIN I_BOOMaterialAssgmtChangeState AS _MaterialTaskList ON /* join condition not captured in parsed metadata */
INNER JOIN I_BOOSqncOperationAssgmtChgSt AS _OperationActivities ON /* join condition not captured in parsed metadata */
INNER JOIN I_BillOfOperationsOpBasic AS _OperationActTasks ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationControlProfile AS _OperationControlProfile ON /* join condition not captured in parsed metadata */
INNER JOIN I_WorkCenterCapacity AS _WorkCenterCapacity ON /* join condition not captured in parsed metadata */
INNER JOIN I_WorkCenter AS _WorkCenter ON /* join condition not captured in parsed metadata */
INNER JOIN I_Capacity AS _Capacity ON /* join condition not captured in parsed metadata */
INNER JOIN I_CapPlngWrkCtrGrpRespyArea AS _wrkgrpaor ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_WorkCenterCapacity
;