How to Create and Run Pricing Report

What is the purpose of Pricing Report in SAP SD:

If you want information about pricing data stored in the system, you can create pricing reports. Pricing reports put together information from condition records, condition types and condition tables according to various different criteria. A report can provide you, for example, with answers to the following questions:

• Which customer-specific price agreements were made within a certain period?
• Which condition records exist for freight charges?
• Which condition records exist for customers in a particular region or country?

Pricing reports are created in Customizing according to your company requirements and can be executed via the application menu. By using specific selection criteria you can change the scope of the pricing report, but you cannot change the criteria used to create the pricing report. This is carried out in Customizing.

How to Create Pricing Report?

You can create your own pricing reports in Customizing (IMG) for Sales and Distribution under Sales and Distribution --> Basic Functions --> Pricing (Transaction V/LA). 

Technically speaking, pricing reports represent ABAP/4 programs.

The SAP Standard System contains pre-defined pricing reports, that can be started via the application menu (Choose Logistics --> Sales and Distribution --> Master Data --> Information system --> Conditions and Pricing --> Pricing Reports). Pricing reports can also be used for maintaining conditions.

Process:

Check the extent to which the pricing reports in the SAP Standard System can be used. You can also display the defined pricing reports.

Create new pricing reports (in Customizing under Sales and Distribution --> Basic Functions --> Pricing, transaction V/LA). Proceed as follows:

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.
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.
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:

Example:

The following figure illustrates a section from a sample pricing report that provides information about customer-specific prices but does not include details of pricing scales. The different layout elements are indicated in the figure.

Running a Pricing Report:

To run a pricing report:

1. In the initial screen choose Logistics --> Sales and Distribution --> Master data --> Information system --> Conditions and pricing --> Pricing Reports (Transaction V/LD). You reach the Execute Pricing Report screen.
2. Enter the name of the pricing report you want to run.
3. If you do not know the name, choose Possible entries. A dialog box appears, in which you can search for a report either by the report name or by the descriptive title or by both. You can also search generically by entering *. If you choose Continue, the system lists all the available pricing reports. If you leave both fields blank and choose Continue, the system displays all available pricing reports.
4. Choose Execute. You reach the selection screen for the pricing report you want to run. The screen sections in the selection screen detail how the list is structured. The fields in the areas Page header, Group header and Items specify where the fields are placed in the pricing report. An arrow in the lower right section of the screen means that there are more fields in the pricing report than displayed on the current data screen.
5. Limit the report by specifying selection criteria so that you obtain the relevant information.
6. You can use Free accruals to enter additional selection criteria, that is not displayed on the selection screen. You can, for example, assign the order taker to a condition as a selection criteria.
7. Choose Execute.
8. The system displays the pricing report.

The more information the list contains, the more complex the handling of the list. You can display wide lists using the horizontal screen strip? You can also work with a larger window.

Printing the Pricing Report:

To print out a pricing report, choose Prin t . on the Pricing Report screen. On the following screen, enter the output device and the specifications on spool control and choose Output --> Print.