I_MfgOrderOperationVH

DDL: I_MFGORDEROPERATIONVH Type: view_entity COMPOSITE
10 Fields 2 Data Sources

Manufacturing Order Operation

I_MfgOrderOperationVH (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Manufacturing

I_MfgOrderOperationVH is a Composite CDS View that provides data about "Manufacturing Order Operation" in SAP S/4HANA. It reads from 2 data sources (P_MfgOrderOperationForVH, I_OrderOperationBasic) and exposes 10 fields with key fields MfgOrderInternalID, OrderOperationInternalID.

SAP Help Documentation

CategoryCDS Views for Discrete and Process Manufacturing
Purpose
This view provides value help for order operations. This view should be used for value help purposes only. If you intend to select the entire business data, use the view I_ManufacturingOrderOperation instead. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: C_AFKO_ATY (CIM: Order category) C_AFKO_AWA (CIM: Authorization for Prod.Order/Order Type/Plant/Activity) C_AFKO_AWK (CIM: Plant for order type of order )

Structure
Important Fields Important fields in this view include the following: Field Name Description MfgOrderInternalID Order Internal ID OrderOperationInternalID Operation Internal ID ManufacturingOrder Manufacturing Order ManufacturingOrderSequence Sequence ManufacturingOrderOperation Operation or Phase

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentPP-VDM
CapabilitiesData Source for Search, Data Provider for Value Help
PackageManufacturing for SAP S/4HANA Cloud Private Edition
Description <p>This view provides value help for order operations. This view should be used for value help purposes only. If you intend to select the entire business data, use the view I_ManufacturingOrderOperation instead.</p> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (2)

SourceAliasJoin Type
P_MfgOrderOperationForVH oper1 from
I_OrderOperationBasic oper2 inner

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.modelingPattern #NONE view
ObjectModel.representativeKey OrderOperationInternalID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Manufacturing Order Operation view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MfgOrderInternalID P_MfgOrderOperationForVH MfgOrderInternalID Order Internal Bill of Operations
KEY OrderOperationInternalID P_MfgOrderOperationForVH OrderOperationInternalID Internal Identifier of an Operation or Activity
ManufacturingOrder P_MfgOrderOperationForVH ManufacturingOrder Manufacturing Order ID
ManufacturingOrderSequence P_MfgOrderOperationForVH ManufacturingOrderSequence Sequence
ManufacturingOrderOperation P_MfgOrderOperationForVH ManufacturingOrderOperation Operation or Phase Number
OperationIsSubOperation Indicator: Operation is Sub-Operation
MfgOrderOperationText I_OrderOperationBasic OperationText Operation Short Text
ManufacturingOrderCategory P_MfgOrderOperationForVH ManufacturingOrderCategory Order Category
ManufacturingOrderType P_MfgOrderOperationForVH ManufacturingOrderType Order Type
ProductionPlant P_MfgOrderOperationForVH ProductionPlant Prod plnt

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_MfgOrderOperationVH.
-- 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 I_MfgOrderOperationVH AS
SELECT
  oper1.MfgOrderInternalID AS MfgOrderInternalID,
  oper1.OrderOperationInternalID AS OrderOperationInternalID,
  oper1.ManufacturingOrder AS ManufacturingOrder,
  oper1.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  oper1.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  cast(oper1.OperationIsSubOperation as vdm_subop_flag preserving type) AS OperationIsSubOperation,
  oper2.OperationText AS MfgOrderOperationText,
  oper1.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  oper1.ManufacturingOrderType AS ManufacturingOrderType,
  oper1.ProductionPlant AS ProductionPlant
FROM P_MfgOrderOperationForVH AS oper1
INNER JOIN I_OrderOperationBasic AS oper2 ON /* join condition not captured in parsed metadata */
;

Learn More