03-26-2007 12:08 PM
Hi Gurus,
Could you tell me the the Tables for Rebate Agreement...
T-code : VBO3.
egards,
ashok...
03-26-2007 12:11 PM
Hi,
KONA
KOPA
KOTE001,02,03
KOTE010,11,12
reward if useful
regards,
Anji
Message was edited by:
Anji Reddy Vangala
03-26-2007 12:11 PM
Hi,
KONA
KOPA
KOTE001,02,03
KOTE010,11,12
reward if useful
regards,
Anji
Message was edited by:
Anji Reddy Vangala
03-26-2007 12:30 PM
03-27-2007 9:57 PM
Hi Ashok
these are the relevant tables
KONA-->rebate agreements
KONH-->Header of Conditions related to an agreement
KONP-->Item of Conditions related to an agreement
S060-->statistical data (accrual,settlements etc..)
S136-->relevant invoices
S469--> If u use extended rebate
VBOX-->Data for retroactive rebate calculation
Bye
Carmine
03-27-2007 10:58 PM
Hi,
Try the below FM's , may be they can help you get the data required.
SD_BONUS_READ
SD_GET_INVOICE_LIST
And as everybody have replied with so many tables, i think you should be getting the data required from those tables.
For Using the FM SD_BONUS_READ, You need to get the Rebate agreement number for the invoice from VBRK , the field to be used is KNUMA.
And if you pass this to the FM with values for condition & header as 'X', it will return you all the data related to that rebate agreement.
Hope this helps you,
Thanks,
Suresh
03-28-2007 1:21 AM
Try A005 -- get the COndition Record Number --> Then use KONH..etc