P_ProcOrdMgmtOpRelshpExists

DDL: P_PROCORDMGMTOPRELSHPEXISTS SQL: PPOROPRELEXST Type: view COMPOSITE Package: VDM_PP_PROC_ORD_MNG
50 Fields 2 Data Sources

Process Order Mgmt Operation Finish Start Relshp Exists

P_ProcOrdMgmtOpRelshpExists is a Composite CDS View that provides data about "Process Order Mgmt Operation Finish Start Relshp Exists" in SAP S/4HANA. It reads from 2 data sources (I_MasterRecipe, P_ProcOrdMgmtOpIssueCalc) and exposes 50 fields with key fields OrderInternalID, OrderOperationInternalID. Part of development package VDM_PP_PROC_ORD_MNG.

Data Sources (2)

SourceAliasJoin Type
I_MasterRecipe _MasterRecipe inner
P_ProcOrdMgmtOpIssueCalc Op from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPOROPRELEXST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalID OrderInternalID Plan No.f.Oper.
KEY OrderOperationInternalID OrderOperationInternalID
ProcessOrder ProcessOrder Order
ManufacturingOrderCategory ManufacturingOrderCategory
ProductionPlant ProductionPlant Prod plnt
ProductionSupervisor ProductionSupervisor Prodn Supervisor
Sequence Sequence Visit Sequence
OperationText OperationText Description
Language Language Report Text Language
Operation Operation Transaction
MfgOrderPhaseSuperiorOperation MfgOrderPhaseSuperiorOperation
Plant P_ProcOrdMgmtOpIssueCalc Plant Valuation Area
BillOfOperationsSequence BillOfOperationsSequence Sequence
BillOfOperationsType P_ProcOrdMgmtOpIssueCalc BillOfOperationsType Task List Type
BillOfOperationsGroup P_ProcOrdMgmtOpIssueCalc BillOfOperationsGroup Group
BillOfOperationsVariant P_ProcOrdMgmtOpIssueCalc BillOfOperationsVariant Group Counter
BOOOperationInternalID BOOOperationInternalID Task list node
BillOfOperationsVersion BillOfOperationsVersion Routing Version
SuperiorOperationInternalID SuperiorOperationInternalID Sup. Op. Node
ObjectInternalID ObjectInternalID Object number
OrderIntBillOfOpItemOfPhase OrderIntBillOfOpItemOfPhase
MfgOrderOperationIsPhase MfgOrderOperationIsPhase
WorkCenterInternalID P_ProcOrdMgmtOpIssueCalc WorkCenterInternalID Work Center
OperationUnit OperationUnit Act/op UoM
OpPlannedTotalQuantity OpPlannedTotalQuantity
OpPlannedScrapQuantity OpPlannedScrapQuantity
OpTotalConfirmedYieldQty OpTotalConfirmedYieldQty
OpTotalConfirmedScrapQty OpTotalConfirmedScrapQty
OpPlannedYieldQuantity OpPlannedYieldQuantity
OpLtstSchedldExecStrtDte OpLtstSchedldExecStrtDte Latest start
OpLtstSchedldExecStrtTme OpLtstSchedldExecStrtTme
OpLtstSchedldExecEndDte OpLtstSchedldExecEndDte Lat.finish date
OpLtstSchedldExecEndTme OpLtstSchedldExecEndTme
OpActualExecutionStartDate OpActualExecutionStartDate Execution Start Date
OpActualExecutionStartTime OpActualExecutionStartTime
OpActualExecutionEndDate OpActualExecutionEndDate Execution End Date
OpActualExecutionEndTime OpActualExecutionEndTime
ProcOrdOpSchedldStartDateTime ProcOrdOpSchedldStartDateTime
ProcOrdOpSchedldEndDateTime ProcOrdOpSchedldEndDateTime
ProcOrdOpActualStartDateTime ProcOrdOpActualStartDateTime
ProcOrdOpActualEndDateTime ProcOrdOpActualEndDateTime
PrdcssrBOOGroup PrdcssrBOOGroup
PrdcssrBOOVariant PrdcssrBOOVariant
PrdcssrBOOOpInternalID PrdcssrBOOOpInternalID
SuccssrBOOGroup SuccssrBOOGroup
SuccssrBOOVariant SuccssrBOOVariant
SuccssrBOOOpInternalID SuccssrBOOOpInternalID
MasterRecipeRelationshipType MasterRecipeRelationshipType
BOORelationshipType BOORelationshipType
_OrderInternalID _OrderInternalID

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 P_ProcOrdMgmtOpRelshpExists.
-- 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: PPOROPRELEXST

CREATE VIEW P_ProcOrdMgmtOpRelshpExists AS
SELECT
  OrderInternalID,
  OrderOperationInternalID,
  ProcessOrder,
  ManufacturingOrderCategory,
  ProductionPlant,
  ProductionSupervisor,
  Sequence,
  OperationText,
  Language,
  Operation,
  MfgOrderPhaseSuperiorOperation,
  Op.Plant AS Plant,
  BillOfOperationsSequence,
  Op.BillOfOperationsType AS BillOfOperationsType,
  Op.BillOfOperationsGroup AS BillOfOperationsGroup,
  Op.BillOfOperationsVariant AS BillOfOperationsVariant,
  BOOOperationInternalID,
  BillOfOperationsVersion,
  SuperiorOperationInternalID,
  ObjectInternalID,
  OrderIntBillOfOpItemOfPhase,
  MfgOrderOperationIsPhase,
  Op.WorkCenterInternalID AS WorkCenterInternalID,
  OperationUnit,
  OpPlannedTotalQuantity,
  OpPlannedScrapQuantity,
  OpTotalConfirmedYieldQty,
  OpTotalConfirmedScrapQty,
  OpPlannedYieldQuantity,
  OpLtstSchedldExecStrtDte,
  OpLtstSchedldExecStrtTme,
  OpLtstSchedldExecEndDte,
  OpLtstSchedldExecEndTme,
  OpActualExecutionStartDate,
  OpActualExecutionStartTime,
  OpActualExecutionEndDate,
  OpActualExecutionEndTime,
  ProcOrdOpSchedldStartDateTime,
  ProcOrdOpSchedldEndDateTime,
  ProcOrdOpActualStartDateTime,
  ProcOrdOpActualEndDateTime,
  PrdcssrBOOGroup,
  PrdcssrBOOVariant,
  PrdcssrBOOOpInternalID,
  SuccssrBOOGroup,
  SuccssrBOOVariant,
  SuccssrBOOOpInternalID,
  MasterRecipeRelationshipType,
  BOORelationshipType
FROM P_ProcOrdMgmtOpIssueCalc AS Op
INNER JOIN I_MasterRecipe AS _MasterRecipe ON /* join condition not captured in parsed metadata */
;

Learn More