How To Know Table where Total Unit Cost is saved from Review Item Cost Aplication

Summary:

Tables where Total Unit Cost exis

Content (required):

We try to use CST_TRANSACTION_COSTS table according to documentation to get Item_cost field, but the value foun to some items is incorrect, then we fetch cst_perpavg_cost table, but to extract the correct cost, is necessary to find the most recent date, so the custom Bi that we build alwasy end with timeout, this because that table store a history information and is not possible to fetch using some index, then we need to know what is the best way to know that cost

Version (include the version you are using, if applicable):