P_EvaltCapWrkCtrOpsInTimestamp

DDL: P_EVALTCAPWRKCTROPSINTIMESTAMP Type: view_entity COMPOSITE Package: PPH_VDM_CAP_EVAL
55 Fields 1 Data Sources

Work Center Capacities Operations

P_EvaltCapWrkCtrOpsInTimestamp is a Composite CDS View that provides data about "Work Center Capacities Operations" in SAP S/4HANA. It reads from 1 data source (P_EvaltCapWrkCtrOpsRqmtInSecs) and exposes 55 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, OrderID. Part of development package PPH_VDM_CAP_EVAL.

Data Sources (1)

SourceAliasJoin Type
P_EvaltCapWrkCtrOpsRqmtInSecs WrkCtrCapOp from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Work Center Capacities Operations view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID P_EvaltCapWrkCtrOpsRqmtInSecs WorkCenterInternalID Work Center
KEY WorkCenterTypeCode P_EvaltCapWrkCtrOpsRqmtInSecs WorkCenterTypeCode Object Type
KEY CapacityCategoryAllocation P_EvaltCapWrkCtrOpsRqmtInSecs CapacityCategoryAllocation
KEY CapacityInternalID P_EvaltCapWrkCtrOpsRqmtInSecs CapacityInternalID Capacity ID
KEY OrderID P_EvaltCapWrkCtrOpsRqmtInSecs OrderID Order ID
KEY Operation P_EvaltCapWrkCtrOpsRqmtInSecs Operation Transaction
KEY CapacityRequirement P_EvaltCapWrkCtrOpsRqmtInSecs CapacityRequirement
KEY Material P_EvaltCapWrkCtrOpsRqmtInSecs Material Vehicle Model
KEY CapacityRequirementItem P_EvaltCapWrkCtrOpsRqmtInSecs CapacityRequirementItem
Plant P_EvaltCapWrkCtrOpsRqmtInSecs Plant Valuation Area
CapacityCategory P_EvaltCapWrkCtrOpsRqmtInSecs CapacityCategory
MRPController P_EvaltCapWrkCtrOpsRqmtInSecs MRPController MRP Controller
WorkCenter P_EvaltCapWrkCtrOpsRqmtInSecs WorkCenter Work Center
WorkCenterResponsible P_EvaltCapWrkCtrOpsRqmtInSecs WorkCenterResponsible
WorkCenterCategoryCode P_EvaltCapWrkCtrOpsRqmtInSecs WorkCenterCategoryCode
CapacityRequirementOrigin P_EvaltCapWrkCtrOpsRqmtInSecs CapacityRequirementOrigin
CapacityRequirementUnit P_EvaltCapWrkCtrOpsRqmtInSecs CapacityRequirementUnit
CapacityBaseQtyUnit P_EvaltCapWrkCtrOpsRqmtInSecs CapacityBaseQtyUnit
OrderInternalID P_EvaltCapWrkCtrOpsRqmtInSecs OrderInternalID Plan No.f.Oper.
OrderType P_EvaltCapWrkCtrOpsRqmtInSecs OrderType Order Type
OrderCategory
ProductionVersion P_EvaltCapWrkCtrOpsRqmtInSecs ProductionVersion Version ID
OrderPlannedTotalQty P_EvaltCapWrkCtrOpsRqmtInSecs OrderPlannedTotalQty
BaseUnit P_EvaltCapWrkCtrOpsRqmtInSecs BaseUnit Unit of Measure
OperationPlanningStatusCode P_EvaltCapWrkCtrOpsRqmtInSecs OperationPlanningStatusCode
OperationLatestStartDate P_EvaltCapWrkCtrOpsRqmtInSecs OperationLatestStartDate
OperationLatestStartTime P_EvaltCapWrkCtrOpsRqmtInSecs OperationLatestStartTime
OperationLatestEndDate P_EvaltCapWrkCtrOpsRqmtInSecs OperationLatestEndDate
OperationLatestEndTime P_EvaltCapWrkCtrOpsRqmtInSecs OperationLatestEndTime
OpLtstSchedldProcgStrtDte P_EvaltCapWrkCtrOpsRqmtInSecs OpLtstSchedldProcgStrtDte
OpLtstSchedldProcgStrtTme P_EvaltCapWrkCtrOpsRqmtInSecs OpLtstSchedldProcgStrtTme
OpLtstSchedldTrdwnStrtDte P_EvaltCapWrkCtrOpsRqmtInSecs OpLtstSchedldTrdwnStrtDte
OpLtstSchedldTrdwnStrtTme P_EvaltCapWrkCtrOpsRqmtInSecs OpLtstSchedldTrdwnStrtTme
RemainingCapReqOpSegSetupDurn P_EvaltCapWrkCtrOpsRqmtInSecs RemainingCapReqOpSegSetupDurn
RemainingCapReqOpSegProcgDurn P_EvaltCapWrkCtrOpsRqmtInSecs RemainingCapReqOpSegProcgDurn
RemainingCapReqOpSegTrdwnDurn P_EvaltCapWrkCtrOpsRqmtInSecs RemainingCapReqOpSegTrdwnDurn
dec102endasCapacityRequirementsAreDtmnd
OrderStatusCode P_EvaltCapWrkCtrOpsRqmtInSecs OrderStatusCode
OrderFirmingStatusCode P_EvaltCapWrkCtrOpsRqmtInSecs OrderFirmingStatusCode
ScheduledBasicStartDate P_EvaltCapWrkCtrOpsRqmtInSecs ScheduledBasicStartDate Sched. start
ScheduledBasicStartTime P_EvaltCapWrkCtrOpsRqmtInSecs ScheduledBasicStartTime
ScheduledBasicStartDateTime
ScheduledBasicEndDate P_EvaltCapWrkCtrOpsRqmtInSecs ScheduledBasicEndDate Sched. finish
ScheduledBasicEndTime P_EvaltCapWrkCtrOpsRqmtInSecs ScheduledBasicEndTime
ScheduledBasicEndDateTime
CurrentDate P_EvaltCapWrkCtrOpsRqmtInSecs CurrentDate
LtstSchedldExecStrtDteTme P_EvaltCapWrkCtrOpsRqmtInSecs LtstSchedldExecStrtDteTme
LtstSchedldExecEndDteTme P_EvaltCapWrkCtrOpsRqmtInSecs LtstSchedldExecEndDteTme
Sequence P_EvaltCapWrkCtrOpsRqmtInSecs Sequence Visit Sequence
ProductConfiguration P_EvaltCapWrkCtrOpsRqmtInSecs ProductConfiguration
PlantTimeZone P_EvaltCapWrkCtrOpsRqmtInSecs PlantTimeZone Time Zone
Customer P_EvaltCapWrkCtrOpsRqmtInSecs Customer Sold-to Party
CustomerABCClassification P_EvaltCapWrkCtrOpsRqmtInSecs CustomerABCClassification ABC class
ProductGroup P_EvaltCapWrkCtrOpsRqmtInSecs ProductGroup Product Sold Group
MRPArea P_EvaltCapWrkCtrOpsRqmtInSecs MRPArea MRP Area

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_EvaltCapWrkCtrOpsInTimestamp.
-- 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.

CREATE VIEW P_EvaltCapWrkCtrOpsInTimestamp AS
SELECT
  WrkCtrCapOp.WorkCenterInternalID AS WorkCenterInternalID,
  WrkCtrCapOp.WorkCenterTypeCode AS WorkCenterTypeCode,
  WrkCtrCapOp.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  WrkCtrCapOp.CapacityInternalID AS CapacityInternalID,
  WrkCtrCapOp.OrderID AS OrderID,
  WrkCtrCapOp.Operation AS Operation,
  WrkCtrCapOp.CapacityRequirement AS CapacityRequirement,
  WrkCtrCapOp.Material AS Material,
  WrkCtrCapOp.CapacityRequirementItem AS CapacityRequirementItem,
  WrkCtrCapOp.Plant AS Plant,
  WrkCtrCapOp.CapacityCategory AS CapacityCategory,
  WrkCtrCapOp.MRPController AS MRPController,
  WrkCtrCapOp.WorkCenter AS WorkCenter,
  WrkCtrCapOp.WorkCenterResponsible AS WorkCenterResponsible,
  WrkCtrCapOp.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  WrkCtrCapOp.CapacityRequirementOrigin AS CapacityRequirementOrigin,
  WrkCtrCapOp.CapacityRequirementUnit AS CapacityRequirementUnit,
  WrkCtrCapOp.CapacityBaseQtyUnit AS CapacityBaseQtyUnit,
  WrkCtrCapOp.OrderInternalID AS OrderInternalID,
  WrkCtrCapOp.OrderType AS OrderType,
  cast(WrkCtrCapOp.OrderCategory as pph_cfs_sch_ordercategory) AS OrderCategory,
  WrkCtrCapOp.ProductionVersion AS ProductionVersion,
  WrkCtrCapOp.OrderPlannedTotalQty AS OrderPlannedTotalQty,
  WrkCtrCapOp.BaseUnit AS BaseUnit,
  WrkCtrCapOp.OperationPlanningStatusCode AS OperationPlanningStatusCode,
  WrkCtrCapOp.OperationLatestStartDate AS OperationLatestStartDate,
  WrkCtrCapOp.OperationLatestStartTime AS OperationLatestStartTime,
  WrkCtrCapOp.OperationLatestEndDate AS OperationLatestEndDate,
  WrkCtrCapOp.OperationLatestEndTime AS OperationLatestEndTime,
  WrkCtrCapOp.OpLtstSchedldProcgStrtDte AS OpLtstSchedldProcgStrtDte,
  WrkCtrCapOp.OpLtstSchedldProcgStrtTme AS OpLtstSchedldProcgStrtTme,
  WrkCtrCapOp.OpLtstSchedldTrdwnStrtDte AS OpLtstSchedldTrdwnStrtDte,
  WrkCtrCapOp.OpLtstSchedldTrdwnStrtTme AS OpLtstSchedldTrdwnStrtTme,
  WrkCtrCapOp.RemainingCapReqOpSegSetupDurn AS RemainingCapReqOpSegSetupDurn,
  WrkCtrCapOp.RemainingCapReqOpSegProcgDurn AS RemainingCapReqOpSegProcgDurn,
  WrkCtrCapOp.RemainingCapReqOpSegTrdwnDurn AS RemainingCapReqOpSegTrdwnDurn,
  case when WrkCtrCapOp.CapacityRequirementsAreDtmnd > 99999999 then cast(99999999.99 as abap.dec( 10,2)) else cast(WrkCtrCapOp.CapacityRequirementsAreDtmnd as abap.dec( 10,2)) end as CapacityRequirementsAreDtmnd AS dec102endasCapacityRequirementsAreDtmnd,
  WrkCtrCapOp.OrderStatusCode AS OrderStatusCode,
  WrkCtrCapOp.OrderFirmingStatusCode AS OrderFirmingStatusCode,
  WrkCtrCapOp.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  WrkCtrCapOp.ScheduledBasicStartTime AS ScheduledBasicStartTime,
  concat(WrkCtrCapOp.OperationLatestStartDate,WrkCtrCapOp.OperationLatestStartTime) AS ScheduledBasicStartDateTime,
  WrkCtrCapOp.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  WrkCtrCapOp.ScheduledBasicEndTime AS ScheduledBasicEndTime,
  concat(WrkCtrCapOp.OperationLatestEndDate,WrkCtrCapOp.OperationLatestEndTime) AS ScheduledBasicEndDateTime,
  WrkCtrCapOp.CurrentDate AS CurrentDate,
  WrkCtrCapOp.LtstSchedldExecStrtDteTme AS LtstSchedldExecStrtDteTme,
  WrkCtrCapOp.LtstSchedldExecEndDteTme AS LtstSchedldExecEndDteTme,
  WrkCtrCapOp.Sequence AS Sequence,
  WrkCtrCapOp.ProductConfiguration AS ProductConfiguration,
  WrkCtrCapOp.PlantTimeZone AS PlantTimeZone,
  WrkCtrCapOp.Customer AS Customer,
  WrkCtrCapOp.CustomerABCClassification AS CustomerABCClassification,
  WrkCtrCapOp.ProductGroup AS ProductGroup,
  WrkCtrCapOp.MRPArea AS MRPArea
FROM P_EvaltCapWrkCtrOpsRqmtInSecs AS WrkCtrCapOp
;

Learn More