Condition types + SD invoices
Hello all BW friends,
I need to be able to report on:
net amount, net quantity, rebate and cost of sales per material, plant and calendar day.
All this info is not available in the same extractor. I have to use both 2_LIS_13_SD-item + 2_LIS_13_condition type.. (don't remember their exact names) since the source data is collected from 2 different R/3 tables: VBKP and KOND.
How would you solve this? According to business content, I should use two different cubes.. But how can I get the data in the same report?