Deprecated PUBLIC_LOCAL_API
This CDS view is deprecated in S/4HANA. Use I_MfgOrderOperationVH instead. View all deprecated CDS views →

I_MfgOrdOpBySemanticKeyStdVH

DDL: I_MFGORDOPBYSEMANTICKEYSTDVH SQL: IMOOBSK__VH Type: view COMPOSITE

Manufacturing Order Operation

I_MfgOrdOpBySemanticKeyStdVH (Composite)

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

Manufacturing

I_MfgOrdOpBySemanticKeyStdVH is a Composite CDS View that provides data about "Manufacturing Order Operation" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationBySemKey) and exposes 16 fields with key fields ManufacturingOrder, ManufacturingOrderSequence, ManufacturingOrderOperation.

SAP Help Documentation

CategoryCDS Views for Discrete and Process Manufacturing
Purpose
This view provides value help for a manufacturing order operation. 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 ManufacturingOrder Manufacturing Order ManufacturingOrderSequence Sequence ManufacturingOrderOperation Operation or Phase OperationIsSubOperation Is Suboperation ManufacturingOrderText Order Text MfgOrderOperationText Operation Text ManufacturingOrderCategory Order Category ManufacturingOrderType Order Type ProductionPlant Production Plant OrderInternalID Order Internal ID OrderOperationInternalID Operation Internal ID Material Material

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></p> <p>This view provides value help for a manufacturing order operation. 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 (1)

SourceAliasJoin Type
I_MfgOrderOperationBySemKey I_MfgOrderOperationBySemKey from

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IMOOBSK__VH view
AbapCatalog.compiler.compareFilter true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_MfgOrderOperationVH view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey ManufacturingOrderOperation view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Manufacturing Order Operation view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder ManufacturingOrder Manufacturing Order ID
KEY ManufacturingOrderSequence ManufacturingOrderSequence Sequence
KEY ManufacturingOrderOperation ManufacturingOrderOperation Operation or Phase Number
OperationIsSubOperation Indicator: Operation is Sub-Operation
ManufacturingOrderText _MfgOrder ManufacturingOrderText Manufacturing Order Text
MfgOrderOperationText MfgOrderOperationText Manufacturing Order Operation Text
ManufacturingOrderCategory ManufacturingOrderCategory Order Category
ManufacturingOrderType ManufacturingOrderType Order Type
ProductionPlant ProductionPlant Prod plnt
OrderInternalID OrderInternalID Order Internal ID
OrderOperationInternalID OrderOperationInternalID Internal Identifier of an Operation or Activity
Material _MfgOrder Material Material Number for Order
MfgOrderIsToBeDeleted _MfgOrder IsMarkedForDeletion Purch.org. data
_ManufacturingOrder _MfgOrder
_MfgOrder _MfgOrder
_MfgOrderSequence _MfgOrderSequence

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_MfgOrdOpBySemanticKeyStdVH.
-- 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: IMOOBSK__VH

CREATE VIEW I_MfgOrdOpBySemanticKeyStdVH AS
SELECT
  ManufacturingOrder,
  ManufacturingOrderSequence,
  ManufacturingOrderOperation,
  cast(OperationIsSubOperation as vdm_subop_flag preserving type) AS OperationIsSubOperation,
  _MfgOrder.ManufacturingOrderText AS ManufacturingOrderText,
  MfgOrderOperationText,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  ProductionPlant,
  OrderInternalID,
  OrderOperationInternalID,
  _MfgOrder.Material AS Material,
  _MfgOrder.IsMarkedForDeletion AS MfgOrderIsToBeDeleted
FROM I_MfgOrderOperationBySemKey
;