Skip to Content

how to display promotional material and Regular Material in SAP BW

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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.

    Add comment
    10|10000 characters needed characters exceeded