P_WorkCenterOpDistrPct

DDL: P_WORKCENTEROPDISTRPCT SQL: PWCOPDISTRPCT Type: view COMPOSITE
10 Fields 1 Data Sources

P_WorkCenterOpDistrPct is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_WrkCtrCapOpWrkDays) and exposes 10 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, CapacityRequirement.

Data Sources (1)

SourceAliasJoin Type
P_WrkCtrCapOpWrkDays P_WrkCtrCapOpWrkDays from

Parameters (2)

NameTypeDefault
P_StartDate datum
P_EndDate datum

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PWCOPDISTRPCT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID CapacityPerShift WorkCenterInternalID Work Center
KEY WorkCenterTypeCode CapacityPerShift WorkCenterTypeCode Object Type
KEY CapacityCategoryAllocation CapacityPerShift CapacityCategoryAllocation
KEY CapacityInternalID CapacityPerShift CapacityInternalID Capacity ID
KEY CapacityRequirement CapacityPerShift CapacityRequirement
KEY Operation CapacityPerShift Operation Transaction
WorkCenter CapacityPerShift WorkCenter Work Center
TotRequirementInSeconds CapacityPerShift TotRequirementInSeconds
TotalAvailableCapacity
CapacityDistrPercent

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_WorkCenterOpDistrPct.
-- 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: PWCOPDISTRPCT
-- Parameters: P_StartDate : datum, P_EndDate : datum

CREATE VIEW P_WorkCenterOpDistrPct AS
SELECT
  CapacityPerShift.WorkCenterInternalID AS WorkCenterInternalID,
  CapacityPerShift.WorkCenterTypeCode AS WorkCenterTypeCode,
  CapacityPerShift.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  CapacityPerShift.CapacityInternalID AS CapacityInternalID,
  CapacityPerShift.CapacityRequirement AS CapacityRequirement,
  CapacityPerShift.Operation AS Operation,
  CapacityPerShift.WorkCenter AS WorkCenter,
  CapacityPerShift.TotRequirementInSeconds AS TotRequirementInSeconds,
  sum(CapacityPerShift.CalCapacityInParallel) AS TotalAvailableCapacity,
  ((cast(CapacityPerShift.TotRequirementInSeconds as abap.fltp) / cast( sum(CapacityPerShift.CalCapacityInParallel) as abap.fltp)) * cast( 100 as abap.fltp)) AS CapacityDistrPercent
FROM P_WrkCtrCapOpWrkDays
;

Learn More