Hi Apps Gurus,
I have a requirement to show the sub-element cost break up an item as on a particular date.
Which table holds the cost element breakup history information?
Basically what i want is the cost history table for CST_ITEM_COST_DETAILS.
CST_COST_HISTORY_V holds the cost history details of CST_ITEM_COSTS, but i want the history table which holds the cost element break up of items.
The cost is broken up in CST_ITEM_COST_DETAILS w.r.t RESOURCE_ID which is basically the cost element id . I want to know where the cost history of these cost element break up costs are maintained.
Thanks in Advance.
Edited by: user13652353 on Oct 10, 2012 7:33 PM
The cost element break up history is maintained in table "CST_ELEMENTAL_COSTS" and is visible in "CST_COST_HISTORY_V" as "material", "material_overhead", "resource_cost", "outside_processing" and "overhead" columns.
However, can you please elobrate on resouce_id being cost_element_id?
G V Ranjith