promotion in retail
I need to be able to report on promotion for retail. The data source for BW-extraction of actual promotion records is 2LIS_13_VDITM. However, here I am missing the plan values for promotion. The plan values are available in R/3 table WAKH/WAKP (header/items). To my knowledge there is no standard extractor which uses these source tables. Is there?
Somehow I need to be able to report on both plan and actual values for promotion. How would you go ahead with this? WAKP is on promotion/article level and 2_LIS_13_VDITM is on document level... Perhaps a generic extractor for the plan values and to combine this with the actuals in a multicube?
Diego Lombardini replied
You can make a generic datasource from a view (created in transaction SE11, you will need developer access) that joins WAKH and WAKP tables. I guess this tables should't be too large, so you can make a full update.
Hope it helps.