Review the condition tables that are linked to the access sequence in the condition types.
I think the rebate tables start with KOTE and the pricing tables start with A.
Though I think you can most of the details from the VBAK table and then reference the KNOV via the document condition no.
We already have this report developed as it used to pricing, discounts VS rebates. So we can verify that our GP is still positive.
mark as helpful.
Regards
Waza
| | | ---------------Original Message---------------
From: Pamela79 Pilch
Sent: Tuesday, August 02, 2011 1:24 PM
Subject: Custom Pricing and Rebate reports
Hello,
We need to develop a custom ABAP report. This report will pull the pricing and rebate condition type data from invoices. We need an ABAP report since this report will be sent to a non sap system through middleware ( this is the requirement )..
the section criteria to be used is billing doc type/billing date/sales org
dist chnl/div.
My questions are as follows :-
A ) for pricing conditions
----------
how will we fetch all the pricing related condition types. Pls if someone can inform the logic to be built to pick pricing condition types( like discount, basic price etc) for each line item invoice. Also how can the value which is appearing against " gross price " and subtotals be pickd plus how can the value of a condition type which is determined throug formula be pickd. Pls mention the link from selection criteria above and the link to be formed for all the pricing condition tables in order to access the data relating to all pricing condition types of a invoice line item. I do not think so we can use structures since structures are available at run time.
B) for rebate conditions
------
how will we fetch all the rebate related condition types. Pls if someone can inform the logic to be built to pick rebate condition types for each line item invoice. Pls mention the link from selection criteria above and the link to be formed for all the rebate condition tables in order to access the data relating to all rebate condition types of a invoice line item. I do not think so we can use structures since structures are available at run time.
C) Rebate condition agreement
----------
Also pls inform how to extract data(based on selection criteria above like billing type/sales org etc) from rebate agreements relating to partial settlement/full settlement/accruals/sales volume/invoice no/rebatre credit memo/debit memo
regards
Pamela |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  wnash7658
SAP Logistics Sales and Distribution Top Contributor
Contributed the most posts in a group for 3 consecutive months to earn a Gold Achievement Popular White Papers
In the Spotlight  _.____.__ |
