topic Promotion table in Application Development and Automation Discussions

Promotion table

Former Member — Thu, 27 Apr 2006 05:40:59 GMT

Hello,

I have a small problem with a report. I need to select materials in promotion. I create promotions with WAK1 transaction. The problem is that I don't know where to get the data, from what table... I have created a promotion, and in display mode I see only structures... Can anyone help me?

Thank you!

Re: Promotion table

Former Member — Thu, 27 Apr 2006 05:52:00 GMT

Hi,

Check the following tables:-

S017 SIS: Sales promotions

S018 SIS: Address list for sales promotion

T5D7L Utility table for higher grouping and promotion

T5J59 HR Job promotion - pay scale level ordering JPN

TW3W Parameter for promotion ad. media HTML generator

WALE Material to store assignment to promotion

Regards,

Sameena

Re: Promotion table

Former Member — Thu, 27 Apr 2006 05:52:33 GMT

Hi,

I think the tables are

WAKH - Header

WAKP - Items

WAKT - Promotion Desc Short Text.

Regards,

Ravi

Note :Please mark the helpful answers

Re: Promotion table

Former Member — Thu, 27 Apr 2006 05:53:13 GMT

hi,

Try using WALE/WAKH/WAKP/WAKT

Regards,

Santosh

Re: Promotion table

vinod_gunaware2 — Thu, 27 Apr 2006 05:53:44 GMT

Tables

WAKH promotion header data

WAKHIND promotion header data index table for codition

WAKP promotion item data

WAKR promotion discounts

WAKRW promotion discounts for plant

WAKT promotion for descriptin

TWAA TWAAT TWAT TWAAT

regards

vinod

Re: Promotion table

Former Member — Thu, 27 Apr 2006 05:56:26 GMT

Hi,

U can find promotions in the Table WAKH.

Regards,

GSR.

Re: Promotion table

Former Member — Wed, 07 Feb 2007 18:06:57 GMT

In transaction WAK1 in IS-Retail we want to add a custom screen to capture 6 custom fields which will be stored in a custom Z-table.

Only BADI that is available for customer use for this transaction WAK1 is WAKT_BADI_001. This can be used to capture the custom field values entered by user in an internal table however to save these values at the time Promotion is saved we either need a BADI or an event which is called at the time Promotion is saved. However this BADI / event is not available.

Please suggest how this can be implemented...

Thanks