Rebate Report

[Former Member]

Hi All,

I am working on a report requirement on REBATE area which I have not worked before

Selection Screen is

Period/year from/to

Agreement type

Agreement number

Rebate recipient

-

---

The output layout fields are

Rebate type

Rebate number

Recipient

Sales volume

system Accruals

manual accurals

Settlement partial

settlement final

Opening accrual

Closing Accrual

-

---

So far I have identified the following

Period from is KONA-DATAB

Period to is KONA-DATBI

Rebate type is KONA-BOART

Rebate number KONA-KNUMA

Rebate Recipient is KONA-BONEM

For the following I need to understand if the values are stored in a table or do we have any FMs for the data or do we need bespoke logic to calculate them.

opening accural = ?

Closong Accural = ?

Sales Volume = ?

Accurals system = ?

Accurals manual = ?

Settlement Partial = ?

Settlement Final = ?

Any suggestions please

Thanks

Mohamed

[Former Member]

Hi All,

I am working on a report requirement on REBATE area which I have not worked before

Selection Screen is

Period/year from/to

Agreement type

Agreement number

Rebate recipient

-

---

The output layout fields are

Rebate type

Rebate number

Recipient

Sales volume

system Accruals

manual accurals

Settlement partial

settlement final

Opening accrual

Closing Accrual

-

---

So far I have identified the following

Period from is KONA-DATAB

Period to is KONA-DATBI

Rebate type is KONA-BOART

Rebate number KONA-KNUMA

Rebate Recipient is KONA-BONEM

For the following I need to understand if the values are stored in a table or do we have any FMs for the data or do we need bespoke logic to calculate them.

opening accural = ?

Closong Accural = ?

Sales Volume = ?

Accurals system = ?

Accurals manual = ?

Settlement Partial = ?

Settlement Final = ?

Any suggestions please

Thanks

Mohamed

[Former Member]

Hi

Use the following tables

A992 Rebate group

B161 SOrg/Distr.Channel/Division/Rebate Recipie

KONA Rebate Agreements

KOPA Rebate Arrangement/Partner Assignment

KOTE002 Customer/Rebate Group

KOTE010 Vendor Hierarchy: Rebate

KOTE011 Vendor Hierarchy: Material Rebate

KOTE012 Vendor Hierarchy: Vendor Sub-Range Rebate

T6B1 Rebate : Rebate Agreement Types

T6B1T Rebate: Agreement Types : Texts

if needed use KONp and KONV for fetching the Rate and amount for the KNUMH field of the rebates

Regards

Anji

[former_member189629]

Hanif,

U will have to get it from the functional team. Otherwise, ask them to show u which transaction they maintain these values in. (for example : if u need some material related fields and they are maintained in MM01 to 03, you can simply go to the txn, go to the field, press F1 for field help and F9 for field technical info. by doing this, u will get the exact table & field names of the output u want.).

Hope u got it.

Reward if helpful,

Karthik

[Former Member]

HI

Rebates Processs in SAP is divided into three components

1) Configuring Rebates

2) Setting Up Rebates

3) Managing rebate agreeeements and payments

Pre-requsiistes- Check the following:

1.The payer partner needs toi have the rebate field checked in the customer master on the sales area-billing doc tab.

2.The Billing type must be marked as relevant for rebates.

3.The Sales Organisation must be marked as relevant for rebates.

Condition Technique :

Rebates, use the condition technique, but distinguish themselves from pricing in applying to transactions over time, versus on a transaction basis. Rebates have their wn field catalog and their own condition table naming convention.So you could have two condition table "001" one for pricing and one for rebates, which could have different key fields. You need to use the technical names A001 For pricing and KOTe001 for rebates when you use the query type using transaction SE 16..

Use create access sequence (AS). Enter 1 in field category for rebate specific. AS after going thru the right path of maintaining access sequence for rebates.

The big difference between the rebate and the pricing access sequence is that there is no exclsuion flag available for rebate related AS. This means multiple tables for an access sequence can be aplied at the same time.

Rebate related condition types are identified by codnition class -C.

After defining and creating condition types for rebated include them in the pricing proceedure. The requirement should be 24 here which implies that the accruals are calculated on the basis of invoice/bill.

The other fields- alctyp and altcbv does not allow you to manipulate how a rebate is calculated. Also, remove the requiremnt 24, if u want to see reabtes at order time.

Now payment of rebates:

Payments can be maunal or in full settlement. When you do manual payments, it defines how much can be paid out during a partial settlemetn. You use partial settlement only when rebate agreement is defined for a full year but the paoyouts are supposed to happen on a monthly, quarterly or anyother specified period.

These accurals are based on sales volume and when they are posted billing is created int eh follwoing manner. Provision for accruals is debited and Sales revenue is credited. When rebate credit memo is created

Customer account/ is debited and

Accrual provision account is credited.

Also, please note that when rebates are created without dependent ona material but on customer/material you need to refer to a material for settlement.

Try with this tables

KONA - Rebate Agreement

VBAK - Sales Document - Header data

VBRK - Billing Document - Header data

BSEG - Accounting Document Segment

PAYR - Payment Medium File

Check this links

http://help.sap.com/saphelp_46c/helpdata/en/5d/363eb7583f11d2a5b70060087d1f3b/content.htm

Regards

Pavan