You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DFF value set to get values for each item at PO line level

edited May 6, 2025 9:31PM in Purchasing 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!