P_ProcOrdMgmtOpWithStdSequence

DDL: P_PROCORDMGMTOPWITHSTDSEQUENCE Type: view_entity COMPOSITE Package: VDM_PP_PROC_ORD_MNG

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 21 fields with key fields OrderInternalID, OrderOperationInternalID. Part of development package VDM_PP_PROC_ORD_MNG.

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 (21)

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
ScheduledBasicStartDate ScheduledBasicStartDate
ScheduledBasicEndDate ScheduledBasicEndDate
@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,
       //Expose Start and End dates to push-down filters

       ScheduledBasicStartDate,
       ScheduledBasicEndDate
}
where ManufacturingOrderCategory  = '40'
and   MfgOrderOperationIsPhase    = ''           // Phases are not relevant

and   Sequence                    = '000000'     // Only standard sequence

and   SuperiorOperationInternalID = '00000000'