DFF value set to get values for each item at PO line level
I have 2 lines for PO.
Each line has different Item associated to it.
Requirement is to get the HS Code(DFF) Value linked to each item only and not other other items.
Ex: If PO Line 1 has Item=ABC, only HS DFF Value for 'ABC' should be visible in DFF
If PO Line 2 has Item=LMN, only HS DFF Value for 'LMN' should be visible in DFF
Logic used while creating Table Valueset:
FROM: egp_system_items esi,ego_item_eff_b eieb
VALUE: SUBSTR(eieb.attribute_char2,0,30)
Description: eieb.attribute_char3
WHERE:
esi.inventory_item_id = eieb.inventory_item_id
0