This document has been created for the benefit of entry level SD consultants with a detailed step-by-step elucidation being provided for the extraction of condition record values to spreadsheet.

Typically in a Sales scenario, the condition types that flow into a Sales order could be saved by maintaining appropriate condition records. These condition records are created using the transaction VK11. Every condition record created would be with reference to the key combinations available.

An example of a condition record created is given as reference below:

For displaying condition records, transaction VK13 is used. The key combination used is “Material with release status”

pic 1.png

Once the desired key combination is checked, the input screen for the condition record needs to be selected as per business requirements. In our case, we have chosen only the Sales organization and the distribution channel

pic 1.png

The output obtained is given below:

pic 1.png

Here we notice that the condition record values could only be printed on the paper or on to the screen

pic 1.png

We would not be able to download the same into an excel file using the transaction VK13.

Moreover, we also observe that even if we try using the condition info tab on VK13, we would not be able to download the values on to an excel file. We would only be able to download the material and the customer number and this would not suffice our requirement as the price/amount would not be available on the spreadsheet.

pic 1.png

pic 1.png

Solution:

Thus, in order to download the condition records created using VK11/VK12 into an excel, use the transaction V/LD. Using V/LD, the data entered could be extracted into an excel file with appropriate values.

V/LD is basically a pricing report where-in we would have to choose the appropriate report to be executed as per our business need. Moreover, we could also create pricing reports as per our business requirement and the same could be accessed using the V/LD report.

pic 1.png

As per our requirement above, we have chosen the report 15 which is basically the Material Price.

pic 1.png

The selection screen of this report is shown below for reference. As we have chosen the Condition type as PR00 for creating our condition record above, we have used the same in our report.

pic 1.png

The output obtained when the report is executed is shown below (only the first page on the output is selected for reference)

pic 1.png

Now in order to download the same into an XLS file, please follow the below path on the output screen obtained above.

pic 1.png

Chose the file option and you would be prompted with a pop up. Chose spreadsheet as shown below and click on the green tick mark.

pic 1.png

You would be prompted to save the above records in a directory of your choice in an XLS format as shown

pic 1.png

Click on the generate button as shown and the file would be available as required in XLS format.

Hope the above explanation helps practicing consultants to extract condition record information onto spreadsheet.

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Sukant Chakraborthy

    Hi Rahul,

    Useful document for starters, thanks for sharing, on the other side you could have given the screen shot of how to download, i tried but its not in order when you save it with Xls. Thanks Sukant Chakraborthy

    (0) 

Leave a Reply