2007 Oct 01 11:57 AM
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
2007 Oct 01 12:10 PM
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
2007 Oct 01 12:04 PM
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
2007 Oct 01 12:07 PM
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
2007 Oct 01 12:10 PM
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
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |