Select count in SAP Query

Former Member — Thu, 04 Oct 2007 16:09:12 GMT

Hi all,

i make a SAP Query that extract some data about PO.

Now I need to know the number of document per document type.

In other words, i need a query like

select count xxx

group by zzzz.

Any suggestion? is it possible do it with sap query?

thanks

enzo

Re: Select count in SAP Query

Former Member — Thu, 04 Oct 2007 17:20:07 GMT

SAP query has got some limitations in that aspect.

You can't get the results like that

if you write a single select query to EKKO table with EBELN and BSART fields you will get the output

or goto SE16

enter table EKKO

enter the one BSART DOcumnet type

execute

you will get the number of PO documents

it will be displayed as table entries

You can enter another doc type like that and see

or if you are a developer you can write a single select query to EKKO it will serve the purpose

Regards

Anji