on 09-25-2007 4:23 AM
Hi All,
I would like to check all discounts offered to customers in the last one year. Is there a standard report where i can enter customer number, the period & the report lists out - Plant, customer number, invoice number, invoice amount, discount offered or should i look into some table? If i have to look into a table, can you please let me know which tables do i need to join to get this information. Hope my problem is clear, await inputs.
Vivek
Thanks a lot - Jitesh & Saurabh,
I have requested the ABAPer to write the code for me, as it is not a simple extraction which i initially thought it would be.
Keep the good working going.
Regards,
Vivek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hitesh,
The steps suggested by you is not solving my issue. I think this report is to create & maintain conditions & not to extract data. I want to extract data, so can anyone help me on this issue?
Vivek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
if you are using conditions for this purpose then you can choose pricing reports for this. go to v/ld choose the report 17 and u will get the data. you may hve to do sme wrk on excel to get customer wise data and all.
alternatively you can use abap query. create an infoset in sq02 with the tables vbrk and konv, the system will establish the join itself based on doc. condition no. create a querry on the basis of this infoset and you will get the desired data.
saurabh
Hi Vivek
<b>
Method 1</b>
Two process check in the Access sequence tables for e.g. your access sequence for 999 is table A999, you can refer this table directly in SE16
<b>Method 2</b>
You can create your own pricing reports with the transaction "V/LA".
The path is IMG-Sales and Distribution-Basic functions-Pricing-Maintain Pricing reports.
Step 1
Enter a short text name, consisting of two characters, the first of which must be a letter, and the title of a pricing report that you would like to create. On the next data screen you will see all key fields used in conditions, listed in alphabetical order. Select all key fields that should be taken into consideration in the pricing report.
Step 2:
If you choose Edit -> continue with AND, all condition tables are evaluated, that contain at least one of the selected key fields. If you choose Edit -> continue with AND, all condition tables are evaluated, that contain at least one of the selected key fields. In the next dialog box, mark all condition tables that are to be evaluated.
Step 3:
Choose Continue to list structure to define the screen structure for the pricing report. Make sure that on the next screen all key fields from the selected tables appear. Fields, that are not used as selection criteria when displaying the list later, can be removed by undoing selection in the Selection column. Fields can be marked as obligatory fields on the selection screen. The structure of the pricing reports means that information can be placed in different places in the list. The layout contains the following elements:
Page Header
Group Header
Item
To execute this report, use the transaction V/LD.
Path: Logistics-SD-Master Data-Information system-Conditions and Pricing-Pricing reports
Also, check the existing reports in V/LD like 28/15/17.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.