This website is not affiliated with, sponsored by, or approved by SAP AG.

count sales order items

Business Warehouse

Moderators: Snowy, thx4allthefish

count sales order items

Postby 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
M. Adolfsson
 

Postby 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.
HALAM
 

re:

Postby 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
 

Postby 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
Guest
 

SapNet How to... guide

Postby 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
jorisv
 

Postby Guest » Mon Oct 21, 2002 5:31 am

Thank you!
Guest
 


Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 4 guests





This website is not affiliated with, sponsored by, or approved by SAP AG.