Skip to Content

how to display promotional material and Regular Material in SAP BW

Mar 05 at 08:36 AM


avatar image

Hi All,

I am working on ECC 6 with SAP BW 7.4 I have activated standard sales billing cube and I am able to do a report on sales

now the requirement is they want to see the promo item sales and regular item

so my question is where to maintain that in material master where I can see that in the material attribute

please note that I can not use material group filed becuase it is already used for other stuff

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Jürgen L
Mar 05 at 04:17 PM

The standard material master has no field to indicate whether it is promotional material or normal material.

I would put such information into classification, alternative you may use one of the Material group or product attribute fields from MVKE table.

SAP Standard just uses condition tables maintained with VB31 to create a promotion.

Maybe a Retail Article Master has something on board, maybe it is only available after you bought Retail Promotion Management , I don't know Retail.

If your colleagues have such a requirement, then you might eventually already have a solution in your system, you should ask them where they maintain this info, as only with maintained information a report can be created.

10 |10000 characters needed characters left characters exceeded