A_WorkCenterPipeLineOperation

DDL: A_WORKCENTERPIPELINEOPERATION SQL: AWRKCTRPPLINEOP Type: view COMPOSITE

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.

1 data source(s) 19 fields

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

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID
KEY ManufacturingOrder ManufacturingOrder Production Order
KEY ManufacturingOrderOperation ManufacturingOrderOperation
KEY ManufacturingOrderCategory ManufacturingOrderCategory
MfgOrderOperationText MfgOrderOperationText
Material Material
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
ConfirmedQuantity ConfirmedQuantity Confirmed Quantity
ConfirmedQuantityInBaseUnit ConfirmedQuantityInBaseUnit
ConfirmedQuantityUnit ConfirmedQuantityUnit
ErlstSchedldExecDurnInWorkdays ErlstSchedldExecDurnInWorkdays Planned Duration
RemainingDuration RemainingDuration Remaining Duration
ManufacturingOrderSequence ManufacturingOrderSequence 
@AbapCatalog.sqlViewName: 'AWRKCTRPPLINEOP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Queued Operations'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
define view A_WorkCenterPipeLineOperation
  as select from I_QueuingOperations
{     
  key        WorkCenterInternalID,
             @EndUserText.label: 'Production Order'
  key        ManufacturingOrder,
             @ObjectModel.text.element: 'MfgOrderOperationText'
  key        ManufacturingOrderOperation,
  key        ManufacturingOrderCategory,
             MfgOrderOperationText,
             Material,
             @EndUserText.label: 'Operation Is Released'
             OperationIsReleased,
             @EndUserText.label: 'Planned Start Date'
             OpErlstSchedldExecStrtDte,
             @EndUserText.label: 'Planned Start Time'
             OpErlstSchedldExecStrtTme,
             @EndUserText.label: 'Planned End Date'
             OpErlstSchedldExecEndDte,
             @EndUserText.label: 'Planned End Time'
             OpErlstSchedldExecEndTme,
             @Semantics.quantity.unitOfMeasure: 'OperationUnit'
             @EndUserText.label: 'Total Queue Quantity'
             OpPlannedTotalQuantity,
             @Semantics.unitOfMeasure: true
             OperationUnit,
             @Semantics.quantity.unitOfMeasure: 'ConfirmedQuantityUnit'
             @EndUserText.label: 'Confirmed Quantity'
             ConfirmedQuantity,
             @Semantics.quantity.unitOfMeasure: 'ConfirmedQuantityUnit'
             ConfirmedQuantityInBaseUnit,
             @Semantics.unitOfMeasure: true
             ConfirmedQuantityUnit,
             @EndUserText.label: 'Planned Duration'
             ErlstSchedldExecDurnInWorkdays,
             @EndUserText.label: 'Remaining Duration'
             RemainingDuration,
             ManufacturingOrderSequence
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_QUEUINGOPERATIONS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More