Document statistics

[#1]

I have been asked by management for a summary of our number of documents by Area, AP, AR, GL etc. Any easier way to get this then to use SE16 and go to table BKPF?

Are there any standard transactions for getting such data?

Thanks.

[JozsefSzikszai · Accepted solution]

hi Paula,

I don't think there is easier way, than you described. And the reason is simple: even SAP created (for example) document type KR for vendor invoice, you can still use it for whatever purposes, according to your business needs. So, jsut go for the SE16...

hope this helps

ec

[Former Member]

As mentioned above, you cannot normally be sure a specific document type represents a specific area of processing unless you have some local validations in place e.g. an "SA" journal might also post lines against customers (AR), vendors (AP), and FI (GL)... in which case you will need to go to the line item level to get your control totals... if this is the case then you'll need BSEG or the pairs of open and clear index tables (e.g. BSIS & BSAS for GL postings).

If the document types alone are sufficient, then it's a fairly simply piece of ABAP to get the count by document type... your friendly Basis team may even have native SQL read-access to the underlying database and generate the counts for you in moments... I can post some sample ABAP logic if it's of any use to you. Or if this is a one-off then you could hop into SE16 and do a "Number of entries" for each separate document type defined in the T003 table in the CPUDT range required... but this could chugg a bit...

Jonathan

[Former Member]

Hey Paula

I dont think so there is any such report available

but u can always create a report by joining tables by creating an infoset query through tcodes sq01, sq02 and sq03.

Morover u can create a transaction code for the infosetQuery. You may need and ABAP folk to help you in creating this infosetquery.

Regards

Ankur

[former_member750938]

Thanks Eric - but I was going through other postings and found this - Anyone know if this works well?

Another easy way is to run SAP Standard Report S_ALR_87012291 Line Item Journal. If you run the report for a Financial Year, the last line of the reports will show the total no. of line itmes posted in the requested financial year. You can download the report to excel and build a pivot table by document type, count(document no.), you will know the no. of line items per doc type.

[JozsefSzikszai]

Paula, thanks for your update!

I had a look at the report, and I am afraid it does not provide the result, you want to have. It only gives back the number of posted documents on company code level (and not on document type level). On the other hand, it selects lots of data, which could easily result in long runtime, if your database is too big.