rebates agreements (extremely urgent)

[Former Member]

Dear SAP experts,

I need your help in rebate agreements (RA).

I have setup the condition tables for RAs to accept Sales Area, ship-to, and EAN (MARA-EAN11) as combination. Together with material determination table, it does a mapping/substitution whenever I create a sales order which works like a charm to map to the access sequences and conditions I have created.

However, there is an issue with this setup. Each EAN can actually map to multiple MARA-MATNR (material numbers) depending on the MATNR lifecycle (i.e. 1 EAN to M MATNR).

For instance, EAN 123456 can have material abc assigned to it today, but due to a product being pulled out of market, business reuses that EAN 123456 and assigns it to another MATNR later on. To ensure that the right EAN-MATNR combination happens at a time, the material determination table (MDT) was used as an approach.

However, when I create RAs with condition type Sales Area, ship-to, and EAN (MARA-EAN11) combination, the "material for settlements" field is required as input. As the "material for settlements" field is KONP-BOMAT with check table MARA, it is not possible for me to put in EAN for the material as it requires a MARA-MATNR field.

One of the options I was thinking was to do a conversion using MDT prior to creation of RA. Note however that when the MDT data changes, there will be inconsistencies with what's happening in real life versus what was mapped: the RA's take the conversion from EAN -> MATNR based on the contents of the MDT at the point of RA creation, and do not get updated automatically even when other MATNR get assigned to the same EAN.

My questions as follows:

1. What is really the materials for settlement field? How does this field impact the creation of credit memos? How does this impact the settlements process?

2. I would need to create an output report based on the rebates generated on EAN level. My understanding is that SAP is working on the MATNR level. Is there any way to go about this given the situation described above?

3. Given that the data in the MDT changes against the FPC, is there any way to ensure that the EAN is the "key field" used for data processing in place of the MATNR field in the RA "material for settlement" field?

4. Any advice on how EAN will impact RA creation, order, delivery, shipping, invoicing?

Thanks a lot for your help in advance.

[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.

Rewards point it helps