A_WorkCenterCapDayOp

DDL: A_WORKCENTERCAPDAYOP SQL: AWCCAPDAYOP Type: view COMPOSITE
37 Fields 1 Data Sources

Daily Operations Capacity

A_WorkCenterCapDayOp is a Composite CDS View that provides data about "Daily Operations Capacity" in SAP S/4HANA. It reads from 1 data source (A_WorkCenterCapPplineOp) and exposes 37 fields with key fields Plant, MRPController, WorkCenter, CapacityInternalID, CapacityRequirement.

Data Sources (1)

SourceAliasJoin Type
A_WorkCenterCapPplineOp WrkCtrCapPplineOp from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName AWCCAPDAYOP 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 Daily Operations Capacity view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY Plant A_WorkCenterCapPplineOp Plant Valuation Area
KEY MRPController A_WorkCenterCapPplineOp MRPController MRP Controller
KEY WorkCenter A_WorkCenterCapPplineOp WorkCenter Work Center
KEY CapacityInternalID A_WorkCenterCapPplineOp CapacityInternalID Capacity ID
KEY CapacityRequirement A_WorkCenterCapPplineOp CapacityRequirement
KEY Material A_WorkCenterCapPplineOp Material Vehicle Model
KEY OrderID A_WorkCenterCapPplineOp OrderID Order ID
KEY Operation A_WorkCenterCapPplineOp Operation Transaction
WorkCenterDesc A_WorkCenterCapPplineOp WorkCenterDesc
WorkCenterResponsible A_WorkCenterCapPplineOp WorkCenterResponsible
WorkCenterCategoryCode A_WorkCenterCapPplineOp WorkCenterCategoryCode
WorkCenterInternalID A_WorkCenterCapPplineOp WorkCenterInternalID Work Center
CapacityRequirementOrigin A_WorkCenterCapPplineOp CapacityRequirementOrigin
CapacityRequirementUnit A_WorkCenterCapPplineOp CapacityRequirementUnit
OrderType A_WorkCenterCapPplineOp OrderType Order Type
OrderTypeName A_WorkCenterCapPplineOp OrderTypeName
OrderPlannedTotalQty A_WorkCenterCapPplineOp OrderPlannedTotalQty
BaseUnit A_WorkCenterCapPplineOp BaseUnit Unit of Measure
ProductionVersion A_WorkCenterCapPplineOp ProductionVersion Version ID
OperationPlanningStatusText A_WorkCenterCapPplineOp OperationPlanningStatusText
OperationPlanningStatusCode A_WorkCenterCapPplineOp OperationPlanningStatusCode
OperationLatestStartDate A_WorkCenterCapPplineOp OperationLatestStartDate
OperationLatestStartTime A_WorkCenterCapPplineOp OperationLatestStartTime
OperationLatestEndDate A_WorkCenterCapPplineOp OperationLatestEndDate
OperationLatestEndTime A_WorkCenterCapPplineOp OperationLatestEndTime
OrderStatusText A_WorkCenterCapPplineOp OrderStatusText
OrderStatusCode A_WorkCenterCapPplineOp OrderStatusCode
OrderFirmingStatusText A_WorkCenterCapPplineOp OrderFirmingStatusText
OpLtstSchedldProcgStrtDte A_WorkCenterCapPplineOp OpLtstSchedldProcgStrtDte
OpLtstSchedldProcgStrtTme A_WorkCenterCapPplineOp OpLtstSchedldProcgStrtTme
OpLtstSchedldTrdwnStrtDte A_WorkCenterCapPplineOp OpLtstSchedldTrdwnStrtDte
OpLtstSchedldTrdwnStrtTme A_WorkCenterCapPplineOp OpLtstSchedldTrdwnStrtTme
RemainingCapReqOpSegSetupDurn A_WorkCenterCapPplineOp RemainingCapReqOpSegSetupDurn
RemainingCapReqOpSegProcgDurn A_WorkCenterCapPplineOp RemainingCapReqOpSegProcgDurn
RemainingCapReqOpSegTrdwnDurn A_WorkCenterCapPplineOp RemainingCapReqOpSegTrdwnDurn
CapacityRequirementsAreDtmnd A_WorkCenterCapPplineOp CapacityRequirementsAreDtmnd
OrderInternalID A_WorkCenterCapPplineOp OrderInternalID Plan No.f.Oper.

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 A_WorkCenterCapDayOp.
-- 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: AWCCAPDAYOP

CREATE VIEW A_WorkCenterCapDayOp AS
SELECT
  WrkCtrCapPplineOp.Plant AS Plant,
  WrkCtrCapPplineOp.MRPController AS MRPController,
  WrkCtrCapPplineOp.WorkCenter AS WorkCenter,
  WrkCtrCapPplineOp.CapacityInternalID AS CapacityInternalID,
  WrkCtrCapPplineOp.CapacityRequirement AS CapacityRequirement,
  WrkCtrCapPplineOp.Material AS Material,
  WrkCtrCapPplineOp.OrderID AS OrderID,
  WrkCtrCapPplineOp.Operation AS Operation,
  WrkCtrCapPplineOp.WorkCenterDesc AS WorkCenterDesc,
  WrkCtrCapPplineOp.WorkCenterResponsible AS WorkCenterResponsible,
  WrkCtrCapPplineOp.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  WrkCtrCapPplineOp.WorkCenterInternalID AS WorkCenterInternalID,
  WrkCtrCapPplineOp.CapacityRequirementOrigin AS CapacityRequirementOrigin,
  WrkCtrCapPplineOp.CapacityRequirementUnit AS CapacityRequirementUnit,
  WrkCtrCapPplineOp.OrderType AS OrderType,
  WrkCtrCapPplineOp.OrderTypeName AS OrderTypeName,
  WrkCtrCapPplineOp.OrderPlannedTotalQty AS OrderPlannedTotalQty,
  WrkCtrCapPplineOp.BaseUnit AS BaseUnit,
  WrkCtrCapPplineOp.ProductionVersion AS ProductionVersion,
  WrkCtrCapPplineOp.OperationPlanningStatusText AS OperationPlanningStatusText,
  WrkCtrCapPplineOp.OperationPlanningStatusCode AS OperationPlanningStatusCode,
  WrkCtrCapPplineOp.OperationLatestStartDate AS OperationLatestStartDate,
  WrkCtrCapPplineOp.OperationLatestStartTime AS OperationLatestStartTime,
  WrkCtrCapPplineOp.OperationLatestEndDate AS OperationLatestEndDate,
  WrkCtrCapPplineOp.OperationLatestEndTime AS OperationLatestEndTime,
  WrkCtrCapPplineOp.OrderStatusText AS OrderStatusText,
  WrkCtrCapPplineOp.OrderStatusCode AS OrderStatusCode,
  WrkCtrCapPplineOp.OrderFirmingStatusText AS OrderFirmingStatusText,
  WrkCtrCapPplineOp.OpLtstSchedldProcgStrtDte AS OpLtstSchedldProcgStrtDte,
  WrkCtrCapPplineOp.OpLtstSchedldProcgStrtTme AS OpLtstSchedldProcgStrtTme,
  WrkCtrCapPplineOp.OpLtstSchedldTrdwnStrtDte AS OpLtstSchedldTrdwnStrtDte,
  WrkCtrCapPplineOp.OpLtstSchedldTrdwnStrtTme AS OpLtstSchedldTrdwnStrtTme,
  WrkCtrCapPplineOp.RemainingCapReqOpSegSetupDurn AS RemainingCapReqOpSegSetupDurn,
  WrkCtrCapPplineOp.RemainingCapReqOpSegProcgDurn AS RemainingCapReqOpSegProcgDurn,
  WrkCtrCapPplineOp.RemainingCapReqOpSegTrdwnDurn AS RemainingCapReqOpSegTrdwnDurn,
  WrkCtrCapPplineOp.CapacityRequirementsAreDtmnd AS CapacityRequirementsAreDtmnd,
  WrkCtrCapPplineOp.OrderInternalID AS OrderInternalID
FROM A_WorkCenterCapPplineOp AS WrkCtrCapPplineOp
;

Learn More