Which column in SALES_DATA refers to %_EP_ID column of level table.
kindly view the snapshot below. It is for one level called 'Buyer Name' and requirement is that I want to filter data in SALES_DATA based on a particular Buyer name.
Is it possible to filter data in SALES_DATA table based of any particular buyer.
I queried with table name and got the %_EP_ID
but I want this in SALES_DATA.
I didn't found any column with name as T_EP_E1_ITEM_CAT_7_EP_ID
So, how to find which column in SALES_DATA refers to Buyer Name .
Regards,
Meraj