Select count in SAP Query

[Former Member]

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

[Former Member]

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

[Former Member]

Hi

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