C_WorkCenterObjPgCap

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 C_WorkCenterObjPgCap.
-- 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: CWRKCNROBJPGCAP

CREATE VIEW C_WorkCenterObjPgCap AS
SELECT
  CapacityInternalID,
  CapacityCategoryCode,
  CapacityResponsiblePlanner,
  _CapacityCategory._Text[1:Language=$session.system_language].CapacityCategoryName AS CapacityCategoryName,
  cast( _Plant._OrganizationAddress[AddressRepresentationCode = ''].AddressTimeZone as co_plant_timezone ) AS AddressTimeZone,
  cast(_Capacity.CapacityBreakDuration * cast(_UconfCapform.ConversionFactor as abap.dec(26,14)) as abap.quan( 10, 2 )) AS CapacityBreakDuration,
  cast(div((CapacityEndTime - CapacityStartTime - CapacityBreakDuration) * cast(round(_UconfCapform.ConversionFactor, 10) as abap.quan(10,10)) * cast(CapacityPlanUtilizationPercent as abap.dec( 3,0)), 100) as abap.quan(10, 2)) as OperationDuration AS quan102asOperationDuration,
  _UconfCapform.StandardWorkQuantityUnit2 AS DurationUnit,
  CapacityPlanUtilizationPercent,
  CapacityNumberOfCapacities,
  cast(div((CapacityEndTime - CapacityStartTime - CapacityBreakDuration) * cast(round(_UconfCapform.ConversionFactor, 10) as abap.quan(10,10)) * cast(CapacityPlanUtilizationPercent as abap.dec( 3,0)) * CapacityNumberOfCapacities, 100) as abap.quan(10, 2)) as WorkCenterAvailableCapacity AS quan102asWorkCenterAvailableCapacity,
  CapacityQuantityUnit
FROM I_Capacity AS _Capacity
LEFT OUTER JOIN I_Wrkcntrobjpgtimeunitconv AS _UconfCapform ON _UconfCapform.StandardWorkQuantityUnit1 = 'S' AND _UconfCapform.StandardWorkQuantityUnit2 = _Capacity.CapacityQuantityUnit  -- association [0..1]
;