cancel
Showing results for 
Search instead for 
Did you mean: 

Pricing Download

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hello Franck and thank you for the reply.

What is the standart output to Excel for price list ?

Thanks

Livnat

Former Member
0 Kudos

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

Former Member
0 Kudos

HI Livnat

you could use SE11-->KONP table.

Display the table in ALV grid format and then download.

try and revert

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi There,

I hope u can download the prices by simply creating Query by SQVI with table KONP. Here you can also design the Layout i mean u can increase or decrease the length and the output in Excel is also good,.

Thanks,

Raja

Former Member
0 Kudos

Thanks,

Tried the SE11 for KONP - it gives only the amount with no indication for the access seq. I need to create a report for KONP and KONH and then I will get the information.

Thank you

Livnat

Former Member
0 Kudos

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