T_EP_ITEM and ITEMS tables
Hi,
I would like to know why do we have two tables T_EP_ITEM and ITEMS. I see for one item_name we can have multiple items in ITEMS table with same T_EP_ITEM_EP_ID. and T_EP_ITEM table has the id's of the item that is last udpated. I am not able to understand this. can some one explain the exact relation between these two tables.
Also would like to know when worksheets display data do they base the ID's from MDP_MATRIX and derive respective levels from group_tables to display data?
Please let me know.