A_WorkCenterDayOperation

DDL: A_WORKCENTERDAYOPERATION SQL: AWRKCTRDAYOP Type: view COMPOSITE

Daily Operations

A_WorkCenterDayOperation is a Composite CDS View that provides data about "Daily Operations" in SAP S/4HANA. It reads from 1 data source (I_TodaysOperations) and exposes 19 fields with key fields WorkCenterInternalID, ManufacturingOrder, ManufacturingOrderOperation, ManufacturingOrderCategory.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_TodaysOperations I_TodaysOperations from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName AWRKCTRDAYOP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Daily Operations view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true 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
OperationUnit OperationUnit
ConfirmedQuantity ConfirmedQuantity
ConfirmedQuantityInBaseUnit ConfirmedQuantityUnit
ConfirmedQuantityUnit ConfirmedQuantityUnit
ErlstSchedldExecDurnInWorkdays ErlstSchedldExecDurnInWorkdays Planned Duration
OpActualExecutionDays OpActualExecutionDays Actual Duration
ManufacturingOrderSequence ManufacturingOrderSequence 
@AbapCatalog.sqlViewName: 'AWRKCTRDAYOP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Daily Operations'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
define view A_WorkCenterDayOperation
  as select from I_TodaysOperations
{
  key        WorkCenterInternalID,
             @EndUserText.label: 'Production Order'
  key        ManufacturingOrder,
  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'
             OpPlannedTotalQuantity,
             @Semantics.unitOfMeasure: true
             OperationUnit,
             @Semantics.quantity.unitOfMeasure: 'ConfirmedQuantityUnit'
             ConfirmedQuantity,
             @Semantics.quantity.unitOfMeasure: 'ConfirmedQuantityUnit'
             ConfirmedQuantityUnit as ConfirmedQuantityInBaseUnit,
             @Semantics.unitOfMeasure: true
             ConfirmedQuantityUnit,
             @EndUserText.label: 'Planned Duration'
             ErlstSchedldExecDurnInWorkdays,
             @EndUserText.label: 'Actual Duration'
             OpActualExecutionDays,
             ManufacturingOrderSequence
} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TODAYSOPERATIONS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More