Hi, I have an Inventory InfoCube 0IC_C03 and I noticed that the validity table has both 0CALDAY and 0PLANT checked.
I read the documentation that it's best to have just 0CALDAY.
The document does mention a 0PLANT scenario, but I'm not quite understanding it.
1. Will it hurt to have 0CALDAY and 0PLANT?
2. What would be the consequences from a reporting perspective if I have 0PLANT in the Validity Table?
*copy paste from some other forum*
Validity table defines the range of the characteristic values for which the non-cumulative KF is valid.
Let us say your cube has 0calday, and it has data from 01/01/1999 to 12/31/2000. If you run a query and check (say its stock cube) stock balance per day per plant, it will calculate balances for each plant and show starting from 01/01/1999 onwards.
However, if you had a plant that became operational on 06/01/2000, you wouldn't want to see a 0 stockbalance for it starting from 01/01/1999 (or say when calculating the average, take as if stock existed from 01/01/1999) but from the date the plant actually existed ie 06/01/2000.
In this case, if your validity table had only 0calday, your report would show 0 stock for each day from 01/01/1999 to 06/01/2000 for this new plant (not a good idea), while if you defined it at plant level, you will see the report starting at 06/01/2000 while it will start from 01/01/1999 for other plants. This is what you want