Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Material Name | Material Code | Component Code |
Level 1 Material | 91019PC0 | 000000000009101900 |
Level 2 Material | 000000000009101900 | 000000000002001900 |
Level 2 Material | 000000000009101900 | 000000000009101911 |
Level 3 Material | 000000000002001900 | 000000000002101900 |
Level 3 Material | 000000000002001900 | MU0001 |
Level 3 Material | 000000000009101911 | 91667JL0 |
Level 3 Material | 000000000009101911 | 000000000002001800 |
Level 3 Material | 000000000009101911 | 000000000009106700 |
Level 3 Material | 000000000009101911 | 000000000050049000 |
i don't have the component name
Hierarchy (COMPONENT_CODE,MATERIAL_CODE,??)
Hi Amien,
try my suggestion:
Hierarchy (Component_Code, Material_Code, Component_Name)
LOAD
*,
Component_Code AS Component_Name
From . . .
Regards
Roland