cancel
Showing results for 
Search instead for 
Did you mean: 

Condition Table

Former Member
0 Kudos

Dear All,

I have doubt. In Access Sequence (V/07) we have table, this table we maintain in V/03.

But if you look at condition type like BO01(Mat/Group Rebate) Access Sequence is also B001Their you have Table 001(Customer/Material) and Table 002 (Customer/Rebate Group). If you check in V/05 (Display Condition Table) 001 is Vendor/Material combination and 002 Country Tax Class1- Cust.and Tax class. material. Where it suppose to be 001(Customer/Material) and Table 002 (Customer/Rebate Group).

Can any body tell about this?

Regards,

Srikanthraj

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Rebate agreement type conditions are maintained in t. code: VB(2; where Pricing condition types are maintained in V/06.

Different types of rebate agreement types are defined in standard SAP.

Rebate agreement: - A Rebate agreement is an agreement between the business and a customer. The rebate is only relevant if the customer purchases the required sales volume. In rebate agreement, you specify who receives the rebate payment and on what criteria rebate is based. Ex. Customer, customer and material etc,.

Rebate agreement type: - The rebate agreement type determines which data the system is to automatically propose for rebate agreement.

Relationship to Pricing • Rebates differ from other kinds of discounts in that they are based on sales volume over time and are paid retroactively.

• However, the system processes rebates in much the same way as other kinds of pricing elements.

• Rebate data is saved in condition records.

• Controlling for rebate processing is carried out via condition types, pricing procedures and access sequences.

• This control data is defined in Customizing for Sales and Distribution.

Rebate based on Group of Materials:

A rebate group consists of materials to which you want to apply the same rebate. You system administrator can define rebate group in Customizing for Sales according to the need o f the orgn.

You can assign a material to a rebate group in the MMR: view- Sales, field- Rebate Grp. When you create a cond record, you must enter a settlement material.

Rebate Agreement Types:

Agreement Type Basis for Rebate Cond Type

0001 Customer / Material % Rebate BO01

Customer / Rebate Group % Rebate BO01

0002 Customer / Material Quantity Dependent BO02

0003 Customer Percent rebate BO03

0004 Customer hierarchy Percent rebate BO04

Customer hierarchy / Material Percent rebate BO05

0005 Sales Volume Independent BO06

SPRO- IMG- SD- BILLING- REBATE PROCESSING:

• Define rebate agreements

• Condition type groups

o Define cond type groups

o Assign cond types to cond type groups

 Maintain access sequence

 Define condition types

 Assign conditon types to conditon type groups

 Maintain pricing procedure

o Assign condition type groups to rebate agreement types

• Activate rebate processing

o Select billing documents for rebate processing3

o Activate rebate processing for sales organisations

o Activate at customer level.

1. Define Agreement Types:

Copy & rename: 0002 & go to Details

• From

• To

• Reverse accruals: flag it on

• Manual Accrual Doc Type: Doc Type (R4) & Billing Doc Type: B4

• Verification level: payer, material

• Partial payment: Doc Type (R3) & Billing Doc Type: B3

• Rebate credit memo: Doc Type (R1) & Billing Doc Type: B1

2. Define Condition Type Groups:

Copy & rename: 0002. Give the same code as given to agreement type.

3. Assign Condition Type to Condition Type Group:

In this activity one needs to assign the cond type from the pricing procedure to the cond type group found on the rebate agreement type. The sequence no column represents the fields in the cond table that determines what the system is to use as the basis for rebate. In this e.g., 1 determines that the cond type should use the fields customer & material. The cond type group 0002 will use pricing cond type BO02. Before assigning cond type to cond type group, you have to create a cond type.

Cond Technique for rebate processing:

• Create cond table

• Maintain access sequence

• Define cond type: BO02 is the cond type used in pricing, copy & rename.

• Assign cond type to cond type group: BO02 to 0002

• Maintain pricing procedure: assign cond type BO02 to pricing proc, after total discount & before freight. Assign Subtotal: 7, Account Key: ERB, Accruals: ERU (keeping reserve money from customer money), & Requirement: 24 (rebate will get affected in billing doc & not in sales doc)

• The cond type BO02 must use cond class ‘C’- expense reimbursement.

• The rebate procedure in BO02: indicates if the cond is dependent or independent of sales volume

• The accruals correction proc indicates if accruals must be corrected when this cond type is accessed.

4. Assigning Cond Type Groups to Agreement Type:

Here you are presented with a list of agreement types as created in the system & you can assign the relevant cond type group

5. Activate Rebate Processing: at the following levels.

• Sales orgn level: activate rebate processing for sales organisations

• Billing Document: select billing doc for rebate processing

• Customer: active rebate in CMD Sales Area Data, Billing Tab Page.

Billing Document Types

F2 Standard Invoice F1 Order Relate invoice

BV Cash Sale B1, B2, B3, B4 Rebate invoices

G2 Credit Memo L2 Debit Memo

S1 Invoice Cancellation S2 Cancel Credit Memo

IV Inter Company Sales

NOTE: - You cannot activate Rebates for Billing document type – F5 & F8, since they are proforma invoices.

Create Rebate Agreements: VBO1

Easy Access- Logistics- SD- Master Data- Agreements- Rebate Agreements- Create

Agreement type: 0002 & press enter. In the over view screen fill the following details:

• Rebate recipient: payer no

• Currency

• Validity Period

• Agreement Status: open

• Then Go To Conditions Icon & Fill

• Material, Rebate Amount, Accruals & save

• Then create sales order, delivery, picking, goods issue & invoice

• After this in order to see rebate in sales order cycle Go to: VF01 Go to Conditions (item). You can check rebate in VF01 before saving or else you can also see in VF02.

Rebate Settlement: VBO2• The system uses the accumulated amounts in the rebate agreement to create a rebate settlement.

• The system generates a rebate credit memo request for the rebate payment amount specified.

• There are 3 statuses available for rebate agreements

1. Status A refers to an open rebate agreement.

2. Status B means the rebate is released for settlement.

3. Status C means you have actually executed the settlement. The System creates a credit memo request for the accrual amount.

• You can display the sales volume and drill-down in the rebate agreement.

• You can carry out a final settlement for the rebate agreement either:

a. Manually

b. Automatically

c. In the background (batch programs: RV15C001 and RV15C002)

• Accruals are reversed as soon as the rebate agreement is settled by credit memo.

Process of Rebate settlement:• Use VBO2 and type in the agreement Number. Change the Agreement Status to B and click on Final Settlements->Automatic. On doing so, a Credit Memo Request gets created.

• Status is set to C. Save it.

• A credit Memo Request Number is generated.

• Go to VA02 and type in the Credit Memo Request number generated. Remove the Billing Block and Save it.

• Use VA02 to go to Sales Document and Click on Billing. On Saving it, the Credit Memo Request is now Billed

• Go to VBO3 and see the Agreement Status. It would have been set to D, which means that final settlement of agreement has been carried out.

Important:-1. When you save the rebate agreement, the system will automatically create a credit memo request. The system uses this document to create a credit memo. When the credit memo is released, the accruals are posted to FI.

2. If you have posted accruals manually, but these have not been passed on to financial accounting, the manual accruals and manual payments in the rebate agreement are blocked.

3. The system can use the sold to party or ship to party as we as payer as the rebate recipient. You cannot use alternative partner as the rebate recipient, such as alternative payer for the CMD of the sole to party.

Hope this would help you,

Reward points if it helps,

Vamsi P.

Answers (2)

Answers (2)

former_member183879
Active Contributor
0 Kudos

Hi

Check the technical view of the condition table. The description may be misleading

Former Member
0 Kudos

Dear All,

To see or create the Condition table for Rebates, the menupath is IMG - S.D - BILLING - REBATE PROCESSING -

CONDITION TECHNIQUE FOR REBATE PROCESSING - MAINTAIN CONDITION TABLE FOR REBATES.

U can use T.code ov20 to create the condition

table for rebate.Here u can see the tables which are related to Rebates only.

Regards,

Srikanthraj

Former Member
0 Kudos

Dear Lakshmipathi, Ashish, Prashanth Gouda and Murali,

Can any body throw some light on this?

Regards,

Srikanthraj