P_ProcOrdMgmtOpWithStdSequence

DDL: P_PROCORDMGMTOPWITHSTDSEQUENCE Type: view_entity COMPOSITE

Process Order Operations Std Sequence

P_ProcOrdMgmtOpWithStdSequence is a Composite CDS View that provides data about "Process Order Operations Std Sequence" in SAP S/4HANA. It reads from 1 data source (P_ProcOrdMgmtOperation) and exposes 19 fields with key fields OrderInternalID, OrderOperationInternalID.

Data Sources (1)

SourceAliasJoin Type
P_ProcOrdMgmtOperation P_ProcOrdMgmtOperation from

Annotations (8)

NameValueLevelField
EndUserText.label Process Order Operations Std Sequence view
AccessControl.authorizationCheck #NOT_REQUIRED 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 (19)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalID OrderInternalID
KEY OrderOperationInternalID OrderOperationInternalID
ProcessOrder ProcessOrder
ProductionPlant ProductionPlant
ProductionSupervisor ProductionSupervisor
Operation Operation
OperationText OperationText
WorkCenterInternalID WorkCenterInternalID
WorkCenter WorkCenter
WorkCenterText WorkCenterText
OpLtstSchedldExecStrtDte OpLtstSchedldExecStrtDte
OpLtstSchedldExecStrtTme OpLtstSchedldExecStrtTme
OpActualExecutionStartDate OpActualExecutionStartDate
OpActualExecutionStartTime OpActualExecutionStartTime
ProcOrdOpSchedldStartDateTime ProcOrdOpSchedldStartDateTime
ProcOrdOpActualStartDateTime ProcOrdOpActualStartDateTime
BillOfOperationsGroup BillOfOperationsGroup
BillOfOperationsType BillOfOperationsType
BillOfOperationsVariant BillOfOperationsVariant
@EndUserText.label: 'Process Order Operations Std Sequence'
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType:  #COMPOSITE
@VDM.private: true
define view entity P_ProcOrdMgmtOpWithStdSequence as select from P_ProcOrdMgmtOperation
{
  key  OrderInternalID,
  key  OrderOperationInternalID,
       ProcessOrder,
       ProductionPlant,
       ProductionSupervisor,
       Operation,
       OperationText, 
       WorkCenterInternalID,
       WorkCenter,
       WorkCenterText,
       OpLtstSchedldExecStrtDte,
       OpLtstSchedldExecStrtTme,
       OpActualExecutionStartDate,
       OpActualExecutionStartTime,
       ProcOrdOpSchedldStartDateTime,
       ProcOrdOpActualStartDateTime,
       BillOfOperationsGroup,
       BillOfOperationsType,
       BillOfOperationsVariant
}
where ManufacturingOrderCategory  = '40'
and   MfgOrderOperationIsPhase    = ''           // Phases are not relevant

and   Sequence                    = '000000'     // Only standard sequence

and   SuperiorOperationInternalID = '00000000'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PROCORDMGMTOPERATION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/