I_MfgBillOfOperationsOperation

DDL: I_MFGBILLOFOPERATIONSOPERATION SQL: IMFGBOOOPERATION Type: view BASIC
13 Fields 1 Data Sources 3 Associations

Manufacturing Bill of Operations Operation

I_MfgBillOfOperationsOperation (Basic)

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

ProductionRoutingOperation · Manufacturing

I_MfgBillOfOperationsOperation is a Basic CDS View (Dimension) that provides data about "Manufacturing Bill of Operations Operation" in SAP S/4HANA. It reads from 1 data source (I_BillOfOperationsOperation) and exposes 13 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BillOfOperationsSequence, BOOOperationInternalID. It has 3 associations to related views.

SAP Help Documentation

CategoryCDS Views for Basic Routing Data
Data CategoryBasic, Dimension
StatusReleased
Purpose
With this CDS view you can retrieve operation data (table PLAS ) for manufacturing bill of operations (routing/recipe). This CDS view provides the prerequisites for answering the following business question: Which operations exist for a manufacturing bill of operations?

Prerequisites
You have authorizations to display bill of operations by type ( C_ROUT ).

Structure
Measures and attributes The following main attributes are provided: Bill of operations type Bill of operations Bill of operations variant Bill of operations sequence Bill of operations operation internal ID

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentPP-VDM-MD
CapabilitiesAnalytical Dimension, Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities, Data Source for Data Extraction
PackageManufacturing for SAP S/4HANA Cloud Private Edition
Description <p>With this CDS view you can retrieve operation data (table PLAS) for manufacturing bill of operations (routing/recipe). </p> <p>This CDS view provides the prerequisites for answering the following business question:</p> <ul> <li><p>Which operations exist for a manufacturing bill of operations?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_BillOfOperationsOperation plas from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_MfgBillOfOperations _BillOfOperations $projection.BillOfOperationsType = _BillOfOperations.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant -- to parent
[1..1] I_MfgBillOfOperationsSequence _BillOfOperationsSequence $projection.BillOfOperationsType = _BillOfOperationsSequence.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperationsSequence.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BillOfOperationsSequence.BillOfOperationsVariant and $projection.BillOfOperationsSequence = _BillOfOperationsSequence.BillOfOperationsSequence -- to child
[1..*] I_MfgBOOOperationChangeState _BOOOperationChangeState $projection.BillOfOperationsType = _BOOOperationChangeState.BillOfOperationsType and $projection.BillOfOperationsGroup = _BOOOperationChangeState.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BOOOperationChangeState.BillOfOperationsVariant and $projection.BillOfOperationsSequence = _BOOOperationChangeState.BillOfOperationsSequence and $projection.BOOOperationInternalID = _BOOOperationChangeState.BOOOperationInternalID

Annotations (20)

NameValueLevelField
AbapCatalog.sqlViewName IMFGBOOOPERATION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey BOOOperationInternalID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Manufacturing Bill of Operations Operation view
ObjectModel.sapObjectNodeType.name ProductionRoutingOperation view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType I_BillOfOperationsOperation BillOfOperationsType Task List Type
KEY BillOfOperationsGroup I_BillOfOperationsOperation BillOfOperationsGroup Key for Task List Group
KEY BillOfOperationsVariant I_BillOfOperationsOperation BillOfOperationsVariant Group Counter
KEY BillOfOperationsSequence I_BillOfOperationsOperation BillOfOperationsSequence Sequence
KEY BOOOperationInternalID I_BillOfOperationsOperation BOOOperationInternalID Number of the Task List Node
_BillOfOperationsType _BillOfOperationsType
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperations _BillOfOperations
_BillOfOperationsSequence _BillOfOperationsSequence
_BOOOpMaterialPRTChangeState
_BOOOpEquipmentPRTChangeState
_BOOOpMiscPRTChangeState
_BOOOpDocumentPRTChangeState

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_MfgBillOfOperationsOperation.
-- 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: IMFGBOOOPERATION

CREATE VIEW I_MfgBillOfOperationsOperation AS
SELECT
  plas.BillOfOperationsType AS BillOfOperationsType,
  plas.BillOfOperationsGroup AS BillOfOperationsGroup,
  plas.BillOfOperationsVariant AS BillOfOperationsVariant,
  plas.BillOfOperationsSequence AS BillOfOperationsSequence,
  plas.BOOOperationInternalID AS BOOOperationInternalID
FROM I_BillOfOperationsOperation AS plas
LEFT OUTER JOIN I_MfgBillOfOperations AS _BillOfOperations ON BillOfOperationsType = _BillOfOperations.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant  -- association [1..1]
LEFT OUTER JOIN I_MfgBillOfOperationsSequence AS _BillOfOperationsSequence ON BillOfOperationsType = _BillOfOperationsSequence.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsSequence.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsSequence.BillOfOperationsVariant AND BillOfOperationsSequence = _BillOfOperationsSequence.BillOfOperationsSequence  -- association [1..1]
LEFT OUTER JOIN I_MfgBOOOperationChangeState AS _BOOOperationChangeState ON BillOfOperationsType = _BOOOperationChangeState.BillOfOperationsType AND BillOfOperationsGroup = _BOOOperationChangeState.BillOfOperationsGroup AND BillOfOperationsVariant = _BOOOperationChangeState.BillOfOperationsVariant AND BillOfOperationsSequence = _BOOOperationChangeState.BillOfOperationsSequence AND BOOOperationInternalID = _BOOOperationChangeState.BOOOperationInternalID  -- association [1..*]
;

Learn More