I_ProcOrdOpsMgmtEntSrch

DDL: I_PROCORDOPSMGMTENTSRCH SQL: IORDOPSMGMTESH Type: view BASIC Package: VDM_PP_PROC_ORD_MNG
13 Fields 2 Data Sources

Process Order Operations Enterprise Search

I_ProcOrdOpsMgmtEntSrch is a Basic CDS View that provides data about "Process Order Operations Enterprise Search" in SAP S/4HANA. It reads from 2 data sources (I_OrderOperation, I_MfgOrderBasic) and exposes 13 fields with key fields OrderInternalID, OrderOperationInternalID. Part of development package VDM_PP_PROC_ORD_MNG.

Data Sources (2)

SourceAliasJoin Type
I_OrderOperation afvg from
I_MfgOrderBasic aufv inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IORDOPSMGMTESH view
EndUserText.label Process Order Operations Enterprise Search view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalID I_OrderOperation OrderInternalID Plan No.f.Oper.
KEY OrderOperationInternalID I_OrderOperation OrderOperationInternalID Plan No.f.Oper.
ManufacturingOrder I_MfgOrderBasic ManufacturingOrder Order
Operation
OperationText I_OrderOperation OperationText Description
ManufacturingOrderCategory I_MfgOrderBasic ManufacturingOrderCategory Order Category
ManufacturingOrderType I_MfgOrderBasic ManufacturingOrderType Order Type
Plant I_OrderOperation Plant Valuation Area
ProductionSupervisor I_MfgOrderBasic ProductionSupervisor Prodn Supervisor
Material I_MfgOrderBasic BillOfOperationsMaterial Vehicle Model
WorkCenterInternalID I_OrderOperation WorkCenterInternalID Work Center
WorkCenter _OpWorkCenter WorkCenter Work Center
MfgOrderOperationIsPhase I_OrderOperation MfgOrderOperationIsPhase Ind.: Phase

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 I_ProcOrdOpsMgmtEntSrch.
-- 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: IORDOPSMGMTESH

CREATE VIEW I_ProcOrdOpsMgmtEntSrch AS
SELECT
  afvg.OrderInternalID AS OrderInternalID,
  afvg.OrderOperationInternalID AS OrderOperationInternalID,
  aufv.ManufacturingOrder AS ManufacturingOrder,
  cast(afvg.Operation as text4) AS Operation,
  afvg.OperationText AS OperationText,
  aufv.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  aufv.ManufacturingOrderType AS ManufacturingOrderType,
  afvg.Plant AS Plant,
  aufv.ProductionSupervisor AS ProductionSupervisor,
  aufv.BillOfOperationsMaterial AS Material,
  afvg.WorkCenterInternalID AS WorkCenterInternalID,
  _OpWorkCenter.WorkCenter AS WorkCenter,
  afvg.MfgOrderOperationIsPhase AS MfgOrderOperationIsPhase
FROM I_OrderOperation AS afvg
INNER JOIN I_MfgOrderBasic AS aufv ON /* join condition not captured in parsed metadata */
;

Learn More