cancel
Showing results for 
Search instead for 
Did you mean: 

ABC Analysis (revisited again!!!)

Former Member
0 Kudos

Hello Friends,

I saw few posts on how to do ABC analysis, but there were no concrete answers.

To summarize the requiement (say based on Good Receipt Quantities):

1. Top 25 -> indicate as 'A'

2. Bottom 25 -> indicate as 'C'

3. Records between 25 to 75. -> indicate as 'B'.

SAP How to paper(How to.. Realize an ABC Analysis) is on counts and not on cummulative %.

I used CKF, but it is only for display.

I used conditions, but it does not give the middle B records.

The last option would be VB macro, but then this would be not be a fantastic solution, as SAP Query can do ABC analysis, but BW Query would not be able to!!!

Regards

Pranay Dave

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Pranay,

Hi! Did you find any way to acheive this? I am also looking for a similar solution. Just that in my solution it is every 20% we classify differently.

So top 20% is 1st Quintile

next 20% is 2nd Quintile and so on so forth.

Please let me know @ agrawal_pranay@allergan.com if you find a solution (apart from VB coding).

Thanks

Former Member
0 Kudos

Hi,

For example :

  • Classified Object (= a Characteristic)= clients

  • Classification Criterion (= a Key Figure)= revenues

  • You want "20% classes" (five)

The ABC analysis ranks the records from the bigger value to the lower value of the Classification Criterion.

- If you want the APD to classify as a "TOP N" of your Classified Object, you will have to choose the "Cumulated Percentage of Classified Object" while building your ABC model.

==> It will give you a classification that answers to "who are the 20% of my clients that gave me the best revenues?".

- If you want the APD to classify your Classified Object regarding the percentage of the Classification Criterion, you will have to choose the "Cumulated Percentage of Classification Criterion"

==> It will give you a classification that answers to "who are the clients that gave me 20% of my revenues?".

I hope it helps...

Ashwin
Active Contributor
0 Kudos

Hi!

in that how to paper they used the calculate result as "Count records" and hence it is based on count. You can change this property to summation or maximum. but i think Its abit complex to explain the exact solution for your scenario here.

with regards

ashwin

Former Member
0 Kudos

Hello Ashwin,

I tried different properties, but it did not work.

Regards

Pranay

Ashwin
Active Contributor
0 Kudos

Hi!

have you tried ranking.

with regards

ashwin

Former Member
0 Kudos

Hello Ashwin,

I tried ranking, but it did not solve the problem.

Can you please explain your solution. This will be easier way to understand.

Thanks

Regards

Pranay Dave

Ashwin
Active Contributor
0 Kudos

Hi pranav!

are you clasifing Customers into ABC or Orders?

can you give me the following.

What charecters are available?

what are the Key figures?

and on which field do you want to have ABC analysis orders or customers?

with regards

ashwin

Former Member
0 Kudos

See initial mail for example