on 05-24-2009 8:54 AM
Hello Friends,
I need a way to download the prices (VK13) into an Excel file. Is there a SAP standart way to do so or do I need to develpoe an ABAP program that will select all the pricing tables and access seq. (and we have plenty of them....) ?
A V/LD report dosn't download the data properly into an an Excel file.
Thanks,
Livnat
Hi Livnat,
Welcome to the user friendly SAP world
If the output to Excel of the standard price list is not adequate to you, you will need to develop a report to extract the data.
We had to do a similar report at a Customer site; what is important is to make it dependent on the pricing customizing, so if someone adds a condition type in the future in the calculation procedure, then the report should take it in account so it's not needed to make changes in ABAP coding.
Regards,
Franck
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
My reply was not so good, because I forgot to mention that if you go to VK13, press "Condition information" and run the report, you see all condition master records, but the amount is missing.
From there you can save to spreadsheet, but the price is missing anyway.
Did you evaluate the pricing report functionality? Transaction is V/LD
The amount is part of output. Can be saved to Excel, but format is ugly.
Check also the net price list, tcode V_NL.
Best Regards,
Franck
Thanks again for the respond.
In other words - there is no good solution in SAP for the pricing report - and what is standart pricing report without the amount ?????
Tried the V/LD and as you said - the output in Excel is ugly.
The V_NL does not fit
In VK13 - Condition information there is no amount , So unfortunatly the only solution is an ABAP report .
Thanks,
Livnat
Hi
You can try in VK12 or VK13 after key in the necessary deatils from the menu select list and then print now you can get the options there you can select it has spread sheet as option and enter
regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.