A_WorkCenterPipeLineOperation

DDL: A_WORKCENTERPIPELINEOPERATION SQL: AWRKCTRPPLINEOP Type: view COMPOSITE Package: ODATA_PP_WORKCENTER_API
19 Fields 1 Data Sources 1 OData Services

Queued Operations

A_WorkCenterPipeLineOperation is a Composite CDS View that provides data about "Queued Operations" in SAP S/4HANA. It reads from 1 data source (I_QueuingOperations) and exposes 19 fields with key fields WorkCenterInternalID, ManufacturingOrder, ManufacturingOrderOperation, ManufacturingOrderCategory. It is exposed through 1 OData service (ASQL_F8997). Part of development package ODATA_PP_WORKCENTER_API.

Data Sources (1)

SourceAliasJoin Type
I_QueuingOperations I_QueuingOperations from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName AWRKCTRPPLINEOP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Queued Operations view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F8997 ASQL_F8997 C2 NOT_RELEASED

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID Work Center
KEY ManufacturingOrder ManufacturingOrder Production Order
KEY ManufacturingOrderOperation ManufacturingOrderOperation Activity
KEY ManufacturingOrderCategory ManufacturingOrderCategory
MfgOrderOperationText MfgOrderOperationText
Material Material Vehicle Model
OperationIsReleased OperationIsReleased Operation Is Released
OpErlstSchedldExecStrtDte OpErlstSchedldExecStrtDte Planned Start Date
OpErlstSchedldExecStrtTme OpErlstSchedldExecStrtTme Planned Start Time
OpErlstSchedldExecEndDte OpErlstSchedldExecEndDte Planned End Date
OpErlstSchedldExecEndTme OpErlstSchedldExecEndTme Planned End Time
OpPlannedTotalQuantity OpPlannedTotalQuantity Total Queue Quantity
OperationUnit OperationUnit Act/op UoM
ConfirmedQuantity ConfirmedQuantity Confirmed Quantity
ConfirmedQuantityInBaseUnit ConfirmedQuantityInBaseUnit Sum of Confirmed Quantities
ConfirmedQuantityUnit ConfirmedQuantityUnit
ErlstSchedldExecDurnInWorkdays ErlstSchedldExecDurnInWorkdays Planned Duration
RemainingDuration RemainingDuration Remaining Duration
ManufacturingOrderSequence ManufacturingOrderSequence

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_WorkCenterPipeLineOperation.
-- 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: AWRKCTRPPLINEOP

CREATE VIEW A_WorkCenterPipeLineOperation AS
SELECT
  WorkCenterInternalID,
  ManufacturingOrder,
  ManufacturingOrderOperation,
  ManufacturingOrderCategory,
  MfgOrderOperationText,
  Material,
  OperationIsReleased,
  OpErlstSchedldExecStrtDte,
  OpErlstSchedldExecStrtTme,
  OpErlstSchedldExecEndDte,
  OpErlstSchedldExecEndTme,
  OpPlannedTotalQuantity,
  OperationUnit,
  ConfirmedQuantity,
  ConfirmedQuantityInBaseUnit,
  ConfirmedQuantityUnit,
  ErlstSchedldExecDurnInWorkdays,
  RemainingDuration,
  ManufacturingOrderSequence
FROM I_QueuingOperations
;

Learn More