I_BOOMaterialAssignment

DDL: I_BOOMATERIALASSIGNMENT SQL: IBOOMATASSIGN Type: view BASIC
11 Fields 5 Associations

Material assgmt. to Bill of Operations

Material assgmt to Bill of Operations

I_BOOMaterialAssignment (Basic)

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

Manufacturing

I_BOOMaterialAssignment is a Basic CDS View (Dimension) that provides data about "Material assgmt. to Bill of Operations" in SAP S/4HANA. It has 5 associations to related views.

SAP Help Documentation

CategoryCDS Views for Basic Work Center Data
Data CategoryDIMENSION
Purpose
This CDS view can build foreign key associations to the sixth key field of material assignment data (MAPL-ZKRIZ) in analytical CDS views.

Prerequisites
Authorizations Authorization Object ID Description Q_ROUT for inspection plan bill of operations C_ROUT for other bill of operations Users who want to use this CDS view must have a role with the following restriction types set to read access: <Name of restriction type> These restriction types are edited in the Maintain Business Roles app. Users who want to use this CDS view must have the following authorization objects assigned: <technical name of authorization objects> (<human-readable name>) Configuration

Structure
Parameters The parameters of the CDS view are as follows: <Parameter> : This parameter is used to ... Fields Used for Filtering The main filters are as follows: <Field> : This field is used to ... Important Fields Important fields in this view include the following: Field Name Description Material Material number Plant Plant BillOfOperationsType Task list type BillOfOperationsGroup Key for task list group BillOfOperationsVariant Group counter BOOToMaterialInternalID Counter for additional criteria

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentPP-VDM-MD
CapabilitiesAnalytical Dimension, Association Target for Defining CDS Entities
PackageManufacturing for SAP S/4HANA Cloud Private Edition

Documentation

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_BillOfOperationsType _BillOfOperationsType $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
[1..1] I_BillOfOperationsGroup _BillOfOperationsGroup $projection.BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup
[1..1] I_BillOfOperations _BillOfOperations $projection.BillOfOperationsType = _BillOfOperations.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant
[1..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[1..1] I_Material _Material $projection.Material = _Material.Material

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IBOOMATASSIGN view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey BOOToMaterialInternalID view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Material assgmt. to Bill of Operations view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
Metadata.allowExtensions true view
AbapCatalog.preserveKey true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Material mapl matnr Material Number
KEY Plant mapl werks Receiving Plant
KEY BillOfOperationsType mapl plnty Task List Type
KEY BillOfOperationsGroup mapl plnnr Key for Task List Group
KEY BillOfOperationsVariant mapl plnal Referenced BOO Variant
KEY BOOToMaterialInternalID mapl zkriz Counter for Additional Criteria
_Material _Material
_Plant _Plant
_BillOfOperationsType _BillOfOperationsType
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperations _BillOfOperations

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_BOOMaterialAssignment.
-- 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: IBOOMATASSIGN

CREATE VIEW I_BOOMaterialAssignment AS
SELECT
  mapl.matnr AS Material,
  mapl.werks AS Plant,
  mapl.plnty AS BillOfOperationsType,
  mapl.plnnr AS BillOfOperationsGroup,
  mapl.plnal AS BillOfOperationsVariant,
  mapl.zkriz AS BOOToMaterialInternalID
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperations AS _BillOfOperations ON BillOfOperationsType = _BillOfOperations.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
;

Learn More