I_WorkCenterCapOrderPerBucket

DDL: I_WORKCENTERCAPORDERPERBUCKET SQL: IWCCAPORDER Type: view COMPOSITE
43 Fields 1 Data Sources

Load Distribution at shift level for operations

I_WorkCenterCapOrderPerBucket is a Composite CDS View that provides data about "Load Distribution at shift level for operations" in SAP S/4HANA. It reads from 1 data source (P_WorkCenterCalcdField) and exposes 43 fields with key fields Plant, MRPController, WorkCenter, WorkCenterTypeCode, CapacityCategoryAllocation.

Data Sources (1)

SourceAliasJoin Type
P_WorkCenterCalcdField CapacityPerDailyShift from

Parameters (3)

NameTypeDefault
P_CapEvalStartDate datum
P_CapEvalEndDate datum
P_CapEvalBucketType char1

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IWCCAPORDER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Load Distribution at shift level for operations view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY Plant P_WorkCenterCalcdField Plant Valuation Area
KEY MRPController P_WorkCenterCalcdField MRPController MRP Controller
KEY WorkCenter P_WorkCenterCalcdField WorkCenter Work Center
KEY WorkCenterTypeCode P_WorkCenterCalcdField WorkCenterTypeCode Object Type
KEY CapacityCategoryAllocation P_WorkCenterCalcdField CapacityCategoryAllocation
KEY CapacityInternalID P_WorkCenterCalcdField CapacityInternalID Capacity ID
KEY Material P_WorkCenterCalcdField Material Vehicle Model
KEY OrderID P_WorkCenterCalcdField OrderID Order ID
KEY Operation P_WorkCenterCalcdField Operation Transaction
KEY ShiftName P_WorkCenterCalcdField ShiftName
CapacityEvaluationTimePeriod
CapEvalBucketType
FactoryCalendar P_WorkCenterCalcdField FactoryCalendar Factory Calendar
WorkCenterResponsible P_WorkCenterCalcdField WorkCenterResponsible Person Responsible
WorkCenterCategoryCode P_WorkCenterCalcdField WorkCenterCategoryCode Work Center Category
WorkCenterInternalID P_WorkCenterCalcdField WorkCenterInternalID Work Center Internal ID
CapacityRequirementOrigin P_WorkCenterCalcdField CapacityRequirementOrigin Requirement Origin
CapacityRequirementUnit P_WorkCenterCalcdField CapacityRequirementUnit Requirement Origin Unit
OrderType P_WorkCenterCalcdField OrderType Order Type
OrderCategory P_WorkCenterCalcdField OrderCategory Order Category
OrderPlannedTotalQty P_WorkCenterCalcdField OrderPlannedTotalQty Order Quantity
BaseUnit P_WorkCenterCalcdField BaseUnit Unit of Measure
ProductionVersion P_WorkCenterCalcdField ProductionVersion Source Of Supply
OperationPlanningStatusCode P_WorkCenterCalcdField OperationPlanningStatusCode Operation Planning Status Code
OperationLatestStartDate P_WorkCenterCalcdField OperationLatestStartDate Latest Start Date
OperationLatestStartTime P_WorkCenterCalcdField OperationLatestStartTime Latest Start Time
OperationLatestEndDate P_WorkCenterCalcdField OperationLatestEndDate Latest End Date
OperationLatestEndTime P_WorkCenterCalcdField OperationLatestEndTime Latest End Time
OrderStatusCode P_WorkCenterCalcdField OrderStatusCode Order Status Code
OrderFirmingStatusCode P_WorkCenterCalcdField OrderFirmingStatusCode Firming Status Code
OpLtstSchedldProcgStrtDte P_WorkCenterCalcdField OpLtstSchedldProcgStrtDte Scheduled Start Processing Time
OpLtstSchedldProcgStrtTme P_WorkCenterCalcdField OpLtstSchedldProcgStrtTme Scheduled End Processing Time
OpLtstSchedldTrdwnStrtDte P_WorkCenterCalcdField OpLtstSchedldTrdwnStrtDte Scheduled Start Teardown Time
OpLtstSchedldTrdwnStrtTme P_WorkCenterCalcdField OpLtstSchedldTrdwnStrtTme Scheduled End teardown Time
RemainingCapReqOpSegSetupDurn P_WorkCenterCalcdField RemainingCapReqOpSegSetupDurn Remaining Setup Duration
RemainingCapReqOpSegProcgDurn P_WorkCenterCalcdField RemainingCapReqOpSegProcgDurn Remaining processing Duration
RemainingCapReqOpSegTrdwnDurn P_WorkCenterCalcdField RemainingCapReqOpSegTrdwnDurn Remaining Teardown Duration
OrderInternalID P_WorkCenterCalcdField OrderInternalID Order Internal ID
CapacityStartTime Capacity Start Time
CapacityEndTime Capacity End Time
WorkCenterAvailableCapacity Available Capacity
WorkCenterCapRqmtInCapUnit Consumed Capacity
WorkCenterCapacityUnit Work Center Capacity Unit

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_WorkCenterCapOrderPerBucket.
-- 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: IWCCAPORDER
-- Parameters: P_CapEvalStartDate : datum, P_CapEvalEndDate : datum, P_CapEvalBucketType : char1

CREATE VIEW I_WorkCenterCapOrderPerBucket AS
SELECT
  CapacityPerDailyShift.Plant AS Plant,
  CapacityPerDailyShift.MRPController AS MRPController,
  CapacityPerDailyShift.WorkCenter AS WorkCenter,
  CapacityPerDailyShift.WorkCenterTypeCode AS WorkCenterTypeCode,
  CapacityPerDailyShift.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  CapacityPerDailyShift.CapacityInternalID AS CapacityInternalID,
  CapacityPerDailyShift.Material AS Material,
  CapacityPerDailyShift.OrderID AS OrderID,
  CapacityPerDailyShift.Operation AS Operation,
  CapacityPerDailyShift.ShiftName AS ShiftName,
  cast('' as abap.char(10)) AS CapacityEvaluationTimePeriod,
  $parameters.P_CapEvalBucketType AS CapEvalBucketType,
  CapacityPerDailyShift.FactoryCalendar AS FactoryCalendar,
  CapacityPerDailyShift.WorkCenterResponsible AS WorkCenterResponsible,
  CapacityPerDailyShift.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  CapacityPerDailyShift.WorkCenterInternalID AS WorkCenterInternalID,
  CapacityPerDailyShift.CapacityRequirementOrigin AS CapacityRequirementOrigin,
  CapacityPerDailyShift.CapacityRequirementUnit AS CapacityRequirementUnit,
  CapacityPerDailyShift.OrderType AS OrderType,
  CapacityPerDailyShift.OrderCategory AS OrderCategory,
  CapacityPerDailyShift.OrderPlannedTotalQty AS OrderPlannedTotalQty,
  CapacityPerDailyShift.BaseUnit AS BaseUnit,
  CapacityPerDailyShift.ProductionVersion AS ProductionVersion,
  CapacityPerDailyShift.OperationPlanningStatusCode AS OperationPlanningStatusCode,
  CapacityPerDailyShift.OperationLatestStartDate AS OperationLatestStartDate,
  CapacityPerDailyShift.OperationLatestStartTime AS OperationLatestStartTime,
  CapacityPerDailyShift.OperationLatestEndDate AS OperationLatestEndDate,
  CapacityPerDailyShift.OperationLatestEndTime AS OperationLatestEndTime,
  CapacityPerDailyShift.OrderStatusCode AS OrderStatusCode,
  CapacityPerDailyShift.OrderFirmingStatusCode AS OrderFirmingStatusCode,
  CapacityPerDailyShift.OpLtstSchedldProcgStrtDte AS OpLtstSchedldProcgStrtDte,
  CapacityPerDailyShift.OpLtstSchedldProcgStrtTme AS OpLtstSchedldProcgStrtTme,
  CapacityPerDailyShift.OpLtstSchedldTrdwnStrtDte AS OpLtstSchedldTrdwnStrtDte,
  CapacityPerDailyShift.OpLtstSchedldTrdwnStrtTme AS OpLtstSchedldTrdwnStrtTme,
  CapacityPerDailyShift.RemainingCapReqOpSegSetupDurn AS RemainingCapReqOpSegSetupDurn,
  CapacityPerDailyShift.RemainingCapReqOpSegProcgDurn AS RemainingCapReqOpSegProcgDurn,
  CapacityPerDailyShift.RemainingCapReqOpSegTrdwnDurn AS RemainingCapReqOpSegTrdwnDurn,
  CapacityPerDailyShift.OrderInternalID AS OrderInternalID,
  cast(CapacityPerDailyShift.CapacityStartTime as abap.dec(10,2) ) AS CapacityStartTime,
  cast(CapacityPerDailyShift.CapacityEndTime as abap.dec(10,2) ) AS CapacityEndTime,
  cast(0 as abap.dec(10,2)) AS WorkCenterAvailableCapacity,
  cast(0 as abap.dec(10,2)) AS WorkCenterCapRqmtInCapUnit,
  cast ('H' as meins) AS WorkCenterCapacityUnit
FROM P_WorkCenterCalcdField AS CapacityPerDailyShift
;

Learn More