P_WRKCTRCAPREQSINSECS

DDL: P_WRKCTRCAPREQSINSECS SQL: PWCCAPREQSECS Type: view COMPOSITE Package: PPH_VDM_CAP_EVAL
44 Fields 1 Data Sources

Work Center operations in given date range

P_WRKCTRCAPREQSINSECS is a Composite CDS View that provides data about "Work Center operations in given date range" in SAP S/4HANA. It reads from 1 data source (P_WorkCenterCapPplineOp) and exposes 44 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, OrderID. Part of development package PPH_VDM_CAP_EVAL.

Data Sources (1)

SourceAliasJoin Type
P_WorkCenterCapPplineOp WrkCtrCapPplineOp from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PWCCAPREQSECS 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 (44)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID P_WorkCenterCapPplineOp WorkCenterInternalID Work Center
KEY WorkCenterTypeCode P_WorkCenterCapPplineOp WorkCenterTypeCode Object Type
KEY CapacityCategoryAllocation P_WorkCenterCapPplineOp CapacityCategoryAllocation
KEY CapacityInternalID P_WorkCenterCapPplineOp CapacityInternalID Capacity ID
KEY OrderID P_WorkCenterCapPplineOp OrderID Order ID
KEY Operation P_WorkCenterCapPplineOp Operation Transaction
KEY CapacityRequirement P_WorkCenterCapPplineOp CapacityRequirement
KEY CapacityRequirementItem P_WorkCenterCapPplineOp CapacityRequirementItem
KEY Material P_WorkCenterCapPplineOp Material Vehicle Model
Plant P_WorkCenterCapPplineOp Plant Valuation Area
MRPController P_WorkCenterCapPplineOp MRPController MRP Controller
WorkCenter P_WorkCenterCapPplineOp WorkCenter Work Center
WorkCenterResponsible P_WorkCenterCapPplineOp WorkCenterResponsible
WorkCenterCategoryCode P_WorkCenterCapPplineOp WorkCenterCategoryCode
CapacityRequirementOrigin P_WorkCenterCapPplineOp CapacityRequirementOrigin
CapacityRequirementUnit P_WorkCenterCapPplineOp CapacityRequirementUnit
OrderInternalID P_WorkCenterCapPplineOp OrderInternalID Plan No.f.Oper.
OrderType P_WorkCenterCapPplineOp OrderType Order Type
OrderCategory P_WorkCenterCapPplineOp OrderCategory Order Category
ProductionVersion P_WorkCenterCapPplineOp ProductionVersion Version ID
OrderPlannedTotalQty P_WorkCenterCapPplineOp OrderPlannedTotalQty
BaseUnit P_WorkCenterCapPplineOp BaseUnit Unit of Measure
OperationPlanningStatusCode P_WorkCenterCapPplineOp OperationPlanningStatusCode
OperationLatestStartDate P_WorkCenterCapPplineOp OperationLatestStartDate
OperationLatestStartTime P_WorkCenterCapPplineOp OperationLatestStartTime
OperationLatestStartDateTime P_WorkCenterCapPplineOp OperationLatestStartDateTime
OperationLatestEndDate P_WorkCenterCapPplineOp OperationLatestEndDate
OperationLatestEndTime P_WorkCenterCapPplineOp OperationLatestEndTime
OperationLatestEndDateTime P_WorkCenterCapPplineOp OperationLatestEndDateTime
OpLtstSchedldExecStrtTme P_WorkCenterCapPplineOp OpLtstSchedldExecStrtTme
OpLtstSchedldExecEndTme P_WorkCenterCapPplineOp OpLtstSchedldExecEndTme
OpLtstSchedldProcgStrtDte P_WorkCenterCapPplineOp OpLtstSchedldProcgStrtDte
OpLtstSchedldProcgStrtTme P_WorkCenterCapPplineOp OpLtstSchedldProcgStrtTme
OpLtstSchedldTrdwnStrtDte P_WorkCenterCapPplineOp OpLtstSchedldTrdwnStrtDte
OpLtstSchedldTrdwnStrtTme P_WorkCenterCapPplineOp OpLtstSchedldTrdwnStrtTme
RemainingCapReqOpSegSetupDurn P_WorkCenterCapPplineOp RemainingCapReqOpSegSetupDurn
RemainingCapReqOpSegProcgDurn P_WorkCenterCapPplineOp RemainingCapReqOpSegProcgDurn
RemainingCapReqOpSegTrdwnDurn P_WorkCenterCapPplineOp RemainingCapReqOpSegTrdwnDurn
CapacityRequirementsAreDtmnd P_WorkCenterCapPplineOp CapacityRequirementsAreDtmnd
fltpasTotRequirementInSeconds
OrderStatusCode P_WorkCenterCapPplineOp OrderStatusCode
OrderFirmingStatusCode P_WorkCenterCapPplineOp OrderFirmingStatusCode
Sequence P_WorkCenterCapPplineOp Sequence Visit Sequence
PlantTimeZone P_WorkCenterCapPplineOp PlantTimeZone Time Zone

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_WRKCTRCAPREQSINSECS.
-- 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: PWCCAPREQSECS

CREATE VIEW P_WRKCTRCAPREQSINSECS AS
SELECT
  WrkCtrCapPplineOp.WorkCenterInternalID AS WorkCenterInternalID,
  WrkCtrCapPplineOp.WorkCenterTypeCode AS WorkCenterTypeCode,
  WrkCtrCapPplineOp.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  WrkCtrCapPplineOp.CapacityInternalID AS CapacityInternalID,
  WrkCtrCapPplineOp.OrderID AS OrderID,
  WrkCtrCapPplineOp.Operation AS Operation,
  WrkCtrCapPplineOp.CapacityRequirement AS CapacityRequirement,
  WrkCtrCapPplineOp.CapacityRequirementItem AS CapacityRequirementItem,
  WrkCtrCapPplineOp.Material AS Material,
  WrkCtrCapPplineOp.Plant AS Plant,
  WrkCtrCapPplineOp.MRPController AS MRPController,
  WrkCtrCapPplineOp.WorkCenter AS WorkCenter,
  WrkCtrCapPplineOp.WorkCenterResponsible AS WorkCenterResponsible,
  WrkCtrCapPplineOp.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  WrkCtrCapPplineOp.CapacityRequirementOrigin AS CapacityRequirementOrigin,
  WrkCtrCapPplineOp.CapacityRequirementUnit AS CapacityRequirementUnit,
  WrkCtrCapPplineOp.OrderInternalID AS OrderInternalID,
  WrkCtrCapPplineOp.OrderType AS OrderType,
  WrkCtrCapPplineOp.OrderCategory AS OrderCategory,
  WrkCtrCapPplineOp.ProductionVersion AS ProductionVersion,
  WrkCtrCapPplineOp.OrderPlannedTotalQty AS OrderPlannedTotalQty,
  WrkCtrCapPplineOp.BaseUnit AS BaseUnit,
  WrkCtrCapPplineOp.OperationPlanningStatusCode AS OperationPlanningStatusCode,
  WrkCtrCapPplineOp.OperationLatestStartDate AS OperationLatestStartDate,
  WrkCtrCapPplineOp.OperationLatestStartTime AS OperationLatestStartTime,
  WrkCtrCapPplineOp.OperationLatestStartDateTime AS OperationLatestStartDateTime,
  WrkCtrCapPplineOp.OperationLatestEndDate AS OperationLatestEndDate,
  WrkCtrCapPplineOp.OperationLatestEndTime AS OperationLatestEndTime,
  WrkCtrCapPplineOp.OperationLatestEndDateTime AS OperationLatestEndDateTime,
  WrkCtrCapPplineOp.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  WrkCtrCapPplineOp.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  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,
  cast( unit_conversion( QUANTITY => CapacityRequirementsAreDtmnd, SOURCE_UNIT => CapacityRequirementUnit, TARGET_UNIT => cast( 'S' as abap.unit(3) ), ERROR_HANDLING => 'SET_TO_NULL' ) as abap.fltp ) as TotRequirementInSeconds AS fltpasTotRequirementInSeconds,
  WrkCtrCapPplineOp.OrderStatusCode AS OrderStatusCode,
  WrkCtrCapPplineOp.OrderFirmingStatusCode AS OrderFirmingStatusCode,
  WrkCtrCapPplineOp.Sequence AS Sequence,
  WrkCtrCapPplineOp.PlantTimeZone AS PlantTimeZone
FROM P_WorkCenterCapPplineOp AS WrkCtrCapPplineOp
;

Learn More