Product Structure Hierarchy Levels and Record Processing Capacity
Product structure hierarchy levels and record processing capacity
This topic explains how Product Structure calculates hierarchy levels and applies per-level record limits when the structure contains more than 50,000 records.
Hierarchy Levels
A level refers to the depth of a node in the hierarchy:
• 1 is Level 1 (top-level item)
• 1.1 is Level 2 (child of item 1)
• 1.1.1 is Level 3 (child of item 1.1)
• This nesting continues up to Level 10
Siblings such as 1.1 and 1.2 are at the same level (Level 2), not different levels.
Processing Capacity
For each level in the hierarchy, the system can fetch and display up to 39,000 records. This 39,000 value is a system capacity limit and is not user-configurable. This capacity applies at each level independently: Level 1 supports up to 39,000 items, Level 2 supports up to 39,000 items, Level 3 supports up to 39,000 items, and so on up to Level 10.
 |
Exceeding 39,000 records at any hierarchy level stops hierarchy calculation for additional records; the tree is not displayed, and the Generate Hierarchy button appears.
|
Processing Sequence
The system processes records in a specific sequence at each level:
1. Records at each level are processed in hierarchical order. For example, at Level 2, the system processes 1.1, then 1.2, then 2.1, then 2.2, and so on in sequence.
2. If a hierarchical item exists, the system fetches it and counts it toward the 39,000 record limit for that level.
3. If a hierarchical item does not exist, the system skips it and moves to the next available item.
Example
At Level 1, if your Product Structure includes items 1, 2, 3, 4, and so on, the system displays all items up to 39,000. If more than 39,000 items exist at Level 1, items beyond the 39,000th are not calculated. A Generate Hierarchy button will appear instead.
At Level 2, all items (1.1, 1.2, 2.1, 2.2, and so on) are counted together toward the 39,000 record limit. When this limit is reached, the hierarchy is not calculated or displayed for additional Level 2 items. If 1.1, 1.2, up to 1.39000 are completed, the system will not calculate levels or fetch 2.1, 2.2, and beyond that.
The 39,000 capacity for a level is consumed cumulatively in processing order. If items under parent 1 (1.1, 1.2, and so on) consume 20,000 records at Level 2, then items under parent 2 (2.1, 2.2, and so on) can use the remaining 19,000 records (39,000 - 20,000 = 19,000). Items under parent 3 (3.1, 3.2, and so on) cannot be displayed because the total 39,000 capacity for Level 2 has been exhausted, and the hierarchy will not be calculated for those records. A Generate Hierarchy button will appear instead.