Show TOC

  Sales Order Selection Locate this document in the navigation structure

Use

List with master data on the sales order and associated key figures in Product Cost by Sales Order . This report belongs to the report category object list .

You use sales order selection to analyze sales order items that carry costs and revenues. You select these sales order items according to various criteria. The sales order items with costs and revenues that meet the selection criteria are shown in user-definable results lists. From an order in the results list, you can go to the detailed reports.

The following criteria are available in the standard system to limit the selection of the sales orders:

  • Time frame of posting periods

    (key figures are only taken from data within the specified posting periods)

  • Characteristics of the sales order header

  • Limit characteristics of the sales order item

    See also:

    Selection Parameters for Sales Order Selection .

The sales order selection is available for the following sales documents:

  • Sales orders

  • Customer quotation

  • Customer inquiry

Sales order selection is not summarized analysis and is not based on classification. It mainly serves to answer ad-hoc questions that arise in Product Cost by Sales Order . The key figures determined are taken from the data with original cost element. The key figures are not in saved form, so you may experience long runtimes with mass data analysis of large results lists.

Notes on Performance

To reduce runtimes during report data formatting, you can use extracts. An extract is a saved dataset containing the report data selected at the time the extract was generated.

The following standard analyses with adapted selection screen are available:

  • Analysis of item data

  • Analysis of header and item data

  • Analysis of header data

You may create your own selection screen based on other requirements. To do this, define your own selection variant that determines the structure of the selection screen.

Sales Order List

The list with the selected sales orders consists of characteristics and key figures.

The data is displayed with the ABAP List Viewer. You can adapt the format of the results list to your individual needs by selecting the characteristics and key figures that you are most interested in. Create a layout and save it.

You can alter the sales order list interactively by choosing a different layout.

You can also switch between the following views within the sales order list:

  • Sales document items

  • Sales documents and their items

  • Sales documents

Depending on the view of the sales order list, only characteristics and key figures of the order header or order item can be selected:

Header

Item

Sales document items

No

Yes

Sales documents and item

Yes

Yes

Sales documents

Yes

No

In reports for header and item data you can only summarize on characteristics of the sales order header. Note also that the data displayed on the sales document header level is obtained from aggregation of only those items that carry costs and revenues. This data is calculated at the time the report is called up and is not saved.

Use the following interactive features to analyze your results list:

  • Set a filter

  • Create subtotals from header characteristics

  • Sort

Notes

Subtotals on long results lists may require long runtimes to calculate.

Possible Key Figures for Results List of Sales Order Selection

Characteristics

The following characteristics are available for the sales document header:

  • Created on

  • Created by

  • Document date

  • Bus.transaction, such as order, inquiry, quotation

  • Purchase order number

  • Sales document type

  • Sales organization

  • Distribution channel

  • Division

  • Sales group

  • Sales office

  • Business area

The following characteristics are available for the sales document item:

  • Material

  • Batch

  • Name

  • Item category

  • Previous document

  • Previous document item

  • Plant

  • Created on

  • Created by

  • Profit center

  • Results analysis key

  • Costing sheet

Key Figures

The account assignment object can only be the sales document item and not the sales document. This means that values such as actual costs and actual revenues, planned costs and planned revenues, and results analysis data are only on sales document items that are relevant to account assignment. This report first dynamically summarizes the key figures to the sales document items, and then dynamically summarizes this data to the sales document header. Note that these key figures are not saved and must be calculated again each time the report is accessed.

The following field groups with key figures are available for the sales document header and sales document items:

  • General key figures

  • Results analysis data

  • Comparison key figures

The field groupgeneral key figurescontains:

  • Planned costs

  • Actual costs

  • Actual costs (balance of debits and credits)

  • Gross planned revenue (without sales deduction)

  • Gross actual revenue (without sales deduction)

  • Planned sales deduction

  • Actual sales deduction

  • Planned revenue (including sales deduction)

  • Actual revenue (including sales deduction)

  • Planned profit

  • Actual profit

  • Item balance against actual (costs and revenues)

  • Planned quantity

  • Confirmed quantity

  • Planned unit of measure

  • Actual unit of measure

The field groupresults analysiscontains:

  • Results analysis: inventory (WIP)

  • Results analysis: revenue in excess of billings

  • Results analysis: total inventory

  • Results analysis: reserves for unrealized costs

  • Results analysis: revenue surplus

  • Results analysis: reserves for imminent loss

  • Results analysis: total reserves

  • Results analysis: cost of sales

  • Results analysis: revenue affecting net income

  • Results analysis: result

The field groupcomparison key figurescontains:

  • Variance plan/actual costs absolute

  • Variance plan/actual revenue absolute

  • Variance plan/actual profit absolute

  • Variance plan/actual costs percentage

  • Variance plan/actual revenue percentage

  • Variance plan/actual profit percentage

  • Planned profit percentage (on basis of planned costs)

  • Actual profit percentage (on basis of actual costs)

Exceptions

Exceptions are used to display traffic light symbols (red/yellow/green) at objects whose variances exceed a predefined threshold. You specify the reference for the threshold values by choosing a rule basis (such as actual costs absolute ). The percentage or absolute threshold values you specify tell the system by how much the reference value must be exceeded before it displays a traffic light symbol on the order.

In sales order lists that display the sales document headers, an exception is set for the sales document header if at least one item fulfills the exception rule.

Integration

From the results list of the sales order selection you can call up detailed reports with original cost elements for any sales order item. The reports available are offered in a dialog box.

The following jumps to detailed reports are possible:

For more information on creating selection variants, see:

Creating Selection Variants

For more information on creating your own display variants, see Creating Display Variants .

For information on using extracts, see Using Extracts .

For information on navigation and formatting functions, see the documentation ABAP List Viewer .

See the following for general information on performance:

Performance in Product Cost Controlling