count sales order items

Business Warehouse

Moderators: Snowy, thx4allthefish

Post Reply
M. Adolfsson

count sales order items

Post by M. Adolfsson » Mon Oct 21, 2002 3:04 am

Hello,
I'm trying to count the number of "Sales Order Items" (0ME_SO_ITEM) in a query, but can't figure out how. Any suggestions are greatly appreciated!
Best Regards,
M. Adolfsson

HALAM

Post by HALAM » Mon Oct 21, 2002 4:22 am

Hi,

try to use virtual key figure. You can assign for every items value 1 and then count. Very good documentation is on sapnet. If you can't find this docu, write me email I have it.

Guest

re:

Post by Guest » Mon Oct 21, 2002 4:29 am

Thank you very much! Could you please e-mail me at magado@hotmail.com?
Best regards,
Adolfsson

Guest

Post by Guest » Mon Oct 21, 2002 4:58 am

I think u could count the items creating a KF with a exception aggregation and using the item characteristic in the field Reference Characteristic for Exception Aggregation.

Then try different Exceptions Aggregation to match your needs (counter (all values) for example) .

Hope it helps

:D

jorisv

SapNet How to... guide

Post by jorisv » Mon Oct 21, 2002 5:02 am

Hi,

The "How to... count occurences of a characteristic" guide can be found on sapnet using the following link (login with your sap oss user-id):

https://websmp206.sap-ag.de/~form/sapne ... 822762001E


Greetings :lol: ,
Joris

Guest

Post by Guest » Mon Oct 21, 2002 5:31 am

Thank you!

Post Reply