- Field IsAssembly empty when using CDS view I_BOMComponentWithKeyDate in a Custom Query
- A Component is displayed with the Assembly indictor set in the app Maintain Bill of Material but shown as blank when using the CDS view I_BOMComponentWithKeyDate
- SAP S/4HANA Cloud -All Versions
- Bill of Materials
Reproducing the Issue
Create a Custom query using the CDS view I_BOMComponentWithKeyDate
The CDS view I_BOMComponentWithKeyDate is a single level BOM Component data provider. It is never possible to determine if there is a BOM at the next level from a Data Model perspective because every level's BOM is independent of the other.
Only if we can query the next level again with a defined set of parameters, i.e. Material, Plant, BOM types, that we can determine if a certain component possibly has an assembly within the same plant set.
The IsAssembly flag is a calculated field and provided as a placeholder to model such scenarios.
In the custom data query , it would be possible to join on a BOM header view with appropriate conditions to determine and set the flag.
The flag cannot be filled correctly for every use case from within I_BOMComponentWithKeyDate, when a certain levels item data is being fetched.
If we do this then it is possible that due to support of multiple alternatives at the next levels, the item data would duplicate as 1 component may have multiple alternatives at the next level or may have BOMs with multiple usages for a given Material, Plant, BOM type combination leading to duplicate items.
When you build your solution using the CDS View , it will be possible to construct this determination with calls to Header CDS views like I_MaterialBOMLink for example and then get the Assembly. This will avoid any duplicates when complex scenarios are modelled.
I_BOMComponentWithKeyDate.IsAssembly , KBA , LO-MD-BOM , Bills of Material , LO-MD-BOM-2CL , Bills of Material (Public Cloud) , Problem