SE30 - ABC Analysis

[Former Member]

hi all,

i ran SE30 (run time analysis) for a program.

when analyzing the hitlist, there is an option of GO TO -> ABC analysis in the Menu.

what is this ABC analysis used for?

i selected the NET column, and GROSS column, but it didnt allowed to perform this analysis on those columns. why?

i performed analysis for NUMBER column, it gave me A B and C catagories.. what does this signify?

is A = 50%, B=30% and C=20% always?

[Former Member]

Hi,

You can use an ABC analysis to classify characteristic values in order of importance for particular key figures.

An ABC analysis divides items into three categories:

A: Important

B: Less important

C: Relatively unimportant

Examples of ABC analysis.

Purchasing Information System:

You can use the ABC analysis to classify vendors in terms of the key figure invoiced amount.

Sales Information System:

You can use the ABC analysis to classify sales organizations with regard to the key figure incoming order or material or the key figure invoiced sales.

Inventory Controlling:

You can use the ABC analysis to classify materials according to the key figure usage value.

Shop Floor Information System:

You can use the ABC analysis to classify work centers in terms of the key figure scrap quantityu2019.

Plant Maintenance Information System:

You can use the ABC analysis to classify object classes with regard to the key figure breakdown duration.

Quality Management Information System:

You can use the ABC analysis to classify vendors according to the key figure number of lots not in order.

Strategies for Performing an ABC Analysis

The following four strategies are available to you:

Total key figure in %

The characteristic values assigned to the A, B, or C segments account for a specific percentage of the total key figure value.

This strategy is only available for key figures that can be expressed as a total. This is not possible for average key figures, for example

Example: Total Key Figure in % Strategy

Number of characteristic values in %

The number of characteristic values assigned to the A, B and C segments are given as a percent of the total number.

Example: Number of Characteristic Values in % Strategy

Key figure (absolute)

You can define the boundaries between the A and B segments, and between the B and C segments.

Example: Key Figure (Absolute) Strategy

Number of characteristic values

You can define the number of characteristic values for the A and B segments. All remaining characteristic values are assigned to the C segment.

Example: Number of Characteristic Values Strategy

Example: Total Key Figure in % Strategy

Specify 70% for the A segment, 20% for the B segment, and 10% for the C segment.

The system creates a list internally and sorts it according to the key figure value in descending order.

All characteristic values that make up the first 70% of the total key figure value are assigned to the A segment, the next 20% are assigned to the B segment. The characteristic values that make up the last 10% of the total key figure value are assigned to the C segment.

Example: Number of Characteristic Values in % Strategy

You specify 10% for the A segment, 30% for the B segment, and 60% for the C segment.

The system creates a list internally and sorts it according to the key figure value in descending order. 10% of the total number of characteristic values with the highest key figure value is assigned to the A segment, the next 30% of the characteristic values is assigned to the B segment, and the 60% of the characteristic values with the lowest key figure value is assigned to the C segment.

Example: Key Figure (Absolute) Strategy

You specify 500,000 as the limit between the A and B segments, and 150,000 as the limit for the B and C segments.

All characteristic values with an key figure value of more than 500,000 are assigned to the A segment, all characteristic values with an key figure value of less than 500,000 but more than 150,000 are assigned to the B segment, and all characteristic values with an key figure value of less than 150,000 are assigned to the C segment.

Example: Number of Characteristic Values Strategy

You specify the value "20" for the A segment, and the value "30" for the B segment.

The system creates a list internally and sorts it according to key figure value in descending order. The first 20 characteristic values in the list are assigned to the A segment, the next 30 characteristic values are assigned to the B segment, and the remaining characteristic values are assigned to the C segment

Creating an ABC Analysis

To create an ABC analysis, proceed as follows:

In the initial or drilldown list, position the cursor on the key figure (or key figure column) that is to be the criterion for your ABC analysis.

Select Edit ® ABC analysis.

A dialog box appears offering four strategies for carrying out the ABC analysis.

Select one ABC strategy according to which your ABC analysis should be carried out.

The following strategies are available to you:

Total key figure in %

This strategy gives you a dialog box, in which you must specify the percentage of the total key figure value in the A, B, and C segments.

This strategy is only available for key figures that can be expressed as a total. For example, this strategy can not be used on average key figures.

Number of characteristic values in %

This strategy gives you a dialog box in which you must specify the percentage of characteristic values in the A, B, and C segments.

Key figure (absolute)

This strategy gives you a dialog box in which you must define the boundary values for the A and B segments and for the B and C segments.

Number of characteristic values

This strategy gives you a dialog box in which you must specify the number of characteristic values that are assigned to the A and B segments. The system automatically calculates the number of characteristic values in the C segment.

Displaying the Results

Depending upon the setting you select (either user-specific settings or the settings in Customizing, see also User-Specific Settings), the results of the ABC analysis will be displayed initially as a graphic or as a list.

Displaying Lists

You can display two types of results lists:

Overview of segments

This gives an overview of all segments.

A, B, or C segment list

This gives you detailed information on a selected segment.

Complete list

Shows all characteristics with the respective characteristic value and allocated ABC indicators.

Overview of segments

The segments overview shows you the following for the A, B, and C segments:

The number of characteristic values that have been assigned to the segments (expressed as absolute and percentage values)

The value of the key figure in each segment (expressed both as an absolute value and as a percentage)

The Graphics function graphically illustrates the data displayed in the list.

The Cumulative curve function gives you a view of the data in the overview list as a cumulative frequency curve (see the following illustration).

The diagram above illustrates the following situation: 3 materials, which make up approximately 75% of the order value have been assigned to the A segment, 5 materials, which make up approximately 16% of the order value have been assigned to the B segment, and 17 materials, which make up approximately 8% of the order value have been assigned to the C segment.

The function New strategy gives you a dialog box in which you can select another strategy and carry out the ABC analysis again.

A, B, and C segment lists

You can view detailed information on a segment of your choice from the initial list using the Detailed info function.

Position the cursor on the segment in the overview list for which you require detailed information and select the function Detailed info (or double-click with the mouse).

This takes you to the segment list. You see all the characteristic values in the specified segment and the corresponding key figure values.

The Graphics function graphically illustrates the data displayed in the list.

Complete list

If you select Goto ® Complete list, a list of all of the characteristics with the corresponding characteristic value and the assigned ABC indicator will appear.

Graphics

Depending upon the user-specific settings or those made in Customizing (see also User-Specific Settings), a graphic is initially displayed.

You can use the pushbuttons to the right of the graph (see the above figure) to branch to the list display or to define a new ABC analysis strategy.

The following pushbuttons are available:

● Segments

The segments overview list is displayed (see Displaying Lists: Overview of Segments).

● A, B, and C segment lists

A list of detailed information on the chosen segment appears (see Displaying Lists : A-, B-, C segment lists).

● Complete list

The complete list shows you a list of all characteristic values with the corresponding ABC indicators and key figure values.

● New strategy

A dialog box appears in which you can select a new ABC analysis strategy.

The data in every list displayed can be graphically represented via the Graphics function.

I hope your problem is solved.

Thanks,

Murali

[Former Member]

dear All,

I wrote an ALV report using data from my custom table and calculated fields.

When running ABC on one of my columns it terminates in this place:

Program " " not found.

because program (l_name),

because the (l_name) is empty.

Main Program SAPLSKBH

Source code of LSKBHF06

form fb_table_create_string.

...

if r_oo_class is initial.

perform (l_form) in program (l_name).

else.

perform (l_form) in program (l_name) using r_oo_class.

endif.

endform. " fb_table_create_string

I'm confused because some other ALV reports run ABC but on the SAP data.

How can I setup my ABC?