I_MfgBOOMaterialAssignment

DDL: I_MFGBOOMATERIALASSIGNMENT SQL: IMFGBOOMATASGNMT Type: view BASIC Package: VDM_PP_MD_RTG
14 Fields 1 Data Sources 5 Associations

Material Assignment to Manufacturing Bill of Operations

I_MfgBOOMaterialAssignment (Basic)

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

Manufacturing

I_MfgBOOMaterialAssignment is a Basic CDS View (Dimension) that provides data about "Material Assignment to Manufacturing Bill of Operations" in SAP S/4HANA. It reads from 1 data source (I_BOOMaterialAssignment) and exposes 14 fields with key fields Product, Plant, BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant. It has 5 associations to related views. Part of development package VDM_PP_MD_RTG.

SAP Help Documentation

CategoryCDS Views for Basic Routing Data
Data CategoryBasic, Dimension
StatusReleased
Purpose
With this CDS view you can retrieve material assignment data (table MAPL ) for a manufacturing bill of operations (routing /recipe). This CDS view provides the prerequisites for answering the following business question: Which materials are assigned to which manufacturing bill of operations?

Prerequisites
You have authorizations to display a 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 Product Plant BOO to Material assignment internal ID

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessManufacturing
Application ComponentPP-VDM-MD-2CL
CapabilitiesAnalytical Dimension,Association Target for Defining CDS Entities,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageManufacturing for SAP S/4HANA Cloud Public Edition
Description <p>With this CDS view you can retrieve material assignment data (table MAPL) for a 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 materials are assigned to which manufacturing bill of operations?</p> </li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_BOOMaterialAssignment mapl from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_MfgBillOfOperations _BillOfOperations $projection.BillOfOperationsType = _BillOfOperations.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant -- to child
[1..*] I_MfgBOOMaterialAssgmtChgSt _BOOMaterialAssgmtChgSt $projection.Product = _BOOMaterialAssgmtChgSt.Product and $projection.Plant = _BOOMaterialAssgmtChgSt.Plant and $projection.BillOfOperationsType = _BOOMaterialAssgmtChgSt.BillOfOperationsType and $projection.BillOfOperationsGroup = _BOOMaterialAssgmtChgSt.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BOOMaterialAssgmtChgSt.BillOfOperationsVariant and $projection.BOOToMaterialInternalID = _BOOMaterialAssgmtChgSt.BOOToMaterialInternalID
[1..1] I_Product _Product $projection.Product = _Product.Product
[1..1] I_ProductPlant _ProductPlant $projection.Product = _ProductPlant.Product and $projection.Plant = _ProductPlant.Plant
[1..1] I_ProductPlantBasic _ProductPlant2 $projection.Product = _ProductPlant2.Product and $projection.Plant = _ProductPlant2.Plant

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IMFGBOOMATASGNMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION 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 BOOToMaterialInternalID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Material Assignment to Manufacturing Bill of Operations view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Product I_BOOMaterialAssignment Material Material Number
KEY Plant I_BOOMaterialAssignment Plant Valuation Area
KEY BillOfOperationsType I_BOOMaterialAssignment BillOfOperationsType Task List Type
KEY BillOfOperationsGroup I_BOOMaterialAssignment BillOfOperationsGroup Key for Task List Group
KEY BillOfOperationsVariant I_BOOMaterialAssignment BillOfOperationsVariant Group Counter
BOOToMaterialInternalID Counter for Additional Criteria
_Product _Product
_ProductPlant _ProductPlant
_ProductPlant2 _ProductPlant2
_Plant _Plant
_BillOfOperationsType _BillOfOperationsType
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperations _BillOfOperations
_BOOMaterialAssgmtChgSt _BOOMaterialAssgmtChgSt

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_MfgBOOMaterialAssignment.
-- 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: IMFGBOOMATASGNMT

CREATE VIEW I_MfgBOOMaterialAssignment AS
SELECT
  mapl.Material AS Product,
  mapl.Plant AS Plant,
  mapl.BillOfOperationsType AS BillOfOperationsType,
  mapl.BillOfOperationsGroup AS BillOfOperationsGroup,
  mapl.BillOfOperationsVariant AS BillOfOperationsVariant
FROM I_BOOMaterialAssignment AS mapl
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_MfgBOOMaterialAssgmtChgSt AS _BOOMaterialAssgmtChgSt ON Product = _BOOMaterialAssgmtChgSt.Product AND Plant = _BOOMaterialAssgmtChgSt.Plant AND BillOfOperationsType = _BOOMaterialAssgmtChgSt.BillOfOperationsType AND BillOfOperationsGroup = _BOOMaterialAssgmtChgSt.BillOfOperationsGroup AND BillOfOperationsVariant = _BOOMaterialAssgmtChgSt.BillOfOperationsVariant AND BOOToMaterialInternalID = _BOOMaterialAssgmtChgSt.BOOToMaterialInternalID  -- association [1..*]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON Product = _ProductPlant.Product AND Plant = _ProductPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlant2 ON Product = _ProductPlant2.Product AND Plant = _ProductPlant2.Plant  -- association [1..1]
;

Learn More