rebate tables

[Former Member]

hi all,

i want to know when rebates apply , what tables are updated and what values are updated, how and where. i mean not just the tables, i want to know when and how the values are updated?

i want somebody to explain me in short rather than giving me huge ones to read

thanks

Sk

[alex_zheng]

Hello Swathi,

There are mainly 3 tables for rebate processing:

S060 Infostructure

Contains accumulated values from the rebate-relevant invoices created after the creation of the agreement

When invoice is sent to accounting:

S060 is filled from XKOMV-KWERT (KWERT_K)

XKOMV-KAWRT (KAWRT_K)

**************************************************************

Info structure S136

filled when invoice is released

Important fields:

KNUMH - condition record number

KOBLNR - document number

KNUMV - document condition number (key of KONV)

S136 is updated if condition is present in the document

S136 is used for drill down list in the new rebate procedure

***************************************************************

VBOX

contains all potentially relevant billing documents for all condition types, even if the condition record itself does not yet exist.

VBOX is needed for:

payment for retroactive settlement

drill down list in old rebate procedure

VBOX is build if:

sales organisation is rebate relevant

Payer is rebate relevant

billing type is rebate relevant

VBOX entries are created, when invoice is released to accounting.

I hope this is helpful with your query.

Regards,

Alex

[Former Member]

Rebate is applied when a Rebate relevant Billing document is created. It is controlled by the Requirement 24 in the Pricing procedure assigned to the rebate condition type.Once the Rebate relevant billing document is saved data are transfered to Accounting and posted to appropriate G/L accounts.

Accruals are also posted to accrual G/L account.Accruals are calculated on the rebate basis subtotals and updated in the accrual G/L account as well as in the Sales volume screen of the Rebate Agreement.

I hope ,to some extend your question is answered.

Regards

Pradyumna