C_ProcOrdOpsMgmtAllOperations

DDL: C_PROCORDOPSMGMTALLOPERATIONS Type: view_entity CONSUMPTION Package: ODATA_PP_PROC_ORD_MNG

Process Order Operations All Operations

C_ProcOrdOpsMgmtAllOperations is a Consumption CDS View that provides data about "Process Order Operations All Operations" in SAP S/4HANA. It reads from 1 data source (I_ProcOrdOpsMgmtAllOperations) and exposes 33 fields with key fields OrderInternalBillOfOperations, OrderOperationInternalID, OrderIntBillOfOperationsItem. It is exposed through 1 OData service (ASQL_F5323). Part of development package ODATA_PP_PROC_ORD_MNG.

Data Sources (1)

SourceAliasJoin Type
I_ProcOrdOpsMgmtAllOperations I_ProcOrdOpsMgmtAllOperations projection

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Process Order Operations All Operations view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value OperationText view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value OperationText view
UI.headerInfo.typeName Related Operation view
UI.headerInfo.typeNamePlural Related Operations view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F5323 ASQL_F5323 C2 NOT_RELEASED

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations OrderInternalBillOfOperations Order Internal Bill of Operations
KEY OrderOperationInternalID OrderOperationInternalID
KEY OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
ProcessOrder ProcessOrder Order
ManufacturingOrderCategory ManufacturingOrderCategory
ManufacturingOrderType ManufacturingOrderType
ProductionPlant ProductionPlant Prod plnt
OperationText OperationText Description
WorkCenter WorkCenter Work Center
WorkCenterText WorkCenterText Work Center Text
ProcOrdOpStatusCode ProcOrdOpStatusCode
OpPlannedTotalQuantity OpPlannedTotalQuantity
Material Material Vehicle Model
MaterialName MaterialName Material Description
ProcOrdOpSchedldStartDateTime ProcOrdOpSchedldStartDateTime
ProcOrdOpSchedldEndDateTime ProcOrdOpSchedldEndDateTime
ProcOrdOpActualStartDateTime ProcOrdOpActualStartDateTime
ProcOrdOpActualEndDateTime ProcOrdOpActualEndDateTime
OperationExecutionStartIsLate OperationExecutionStartIsLate
OperationExecutionEndIsLate OperationExecutionEndIsLate
ProcOrdOpCompAvailyStatusCode ProcOrdOpCompAvailyStatusCode
ProcOrdOpQltyIssStatusCode ProcOrdOpQltyIssStatusCode
OperationUnit OperationUnit Act/op UoM
TotNmbrOfProcOrdOpConfdPhases TotNmbrOfProcOrdOpConfdPhases
TotNmbrOfProcOrdOpPhases TotNmbrOfProcOrdOpPhases
ProcOrdOpProgressPercent ProcOrdOpProgressPercent
NmbrOfInterruptedProcOrdPhases NmbrOfInterruptedProcOrdPhases
OperationIsInterrupted OperationIsInterrupted
PlannedActualStartDateDvtnDurn PlannedActualStartDateDvtnDurn
PlannedCurrentStrtDateDvtnDurn PlannedCurrentStrtDateDvtnDurn
PlannedActualEndDateDvtnDurn PlannedActualEndDateDvtnDurn
PlannedCurrentEndDateDvtnDurn PlannedCurrentEndDateDvtnDurn
OperationIsConfirmed OperationIsConfirmed

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 C_ProcOrdOpsMgmtAllOperations.
-- 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.

CREATE VIEW C_ProcOrdOpsMgmtAllOperations AS
SELECT
  OrderInternalBillOfOperations,
  OrderOperationInternalID,
  OrderIntBillOfOperationsItem,
  ProcessOrder,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  ProductionPlant,
  OperationText,
  WorkCenter,
  WorkCenterText,
  ProcOrdOpStatusCode,
  OpPlannedTotalQuantity,
  Material,
  MaterialName,
  ProcOrdOpSchedldStartDateTime,
  ProcOrdOpSchedldEndDateTime,
  ProcOrdOpActualStartDateTime,
  ProcOrdOpActualEndDateTime,
  OperationExecutionStartIsLate,
  OperationExecutionEndIsLate,
  ProcOrdOpCompAvailyStatusCode,
  ProcOrdOpQltyIssStatusCode,
  OperationUnit,
  TotNmbrOfProcOrdOpConfdPhases,
  TotNmbrOfProcOrdOpPhases,
  ProcOrdOpProgressPercent,
  NmbrOfInterruptedProcOrdPhases,
  OperationIsInterrupted,
  PlannedActualStartDateDvtnDurn,
  PlannedCurrentStrtDateDvtnDurn,
  PlannedActualEndDateDvtnDurn,
  PlannedCurrentEndDateDvtnDurn,
  OperationIsConfirmed
FROM I_ProcOrdOpsMgmtAllOperations
;