cancel
Showing results for 
Search instead for 
Did you mean: 

Document creation statistic data

former_member202516
Participant
0 Kudos

Hi,

I've been task to create report that will show some kind of statistic about document creation, by date, username etc in our ERP system. First thing I came up with is to pull documents header data and count them in query designer.

I know i need data from EKKO and VBAK tables for purchasing and sales, any other?

Also if you have any better suggestion ...?

Regards,

Mijodrag

Accepted Solutions (0)

Answers (2)

Answers (2)

anshu_lilhori
Active Contributor
0 Kudos

So you mean to say that you need to create a report which will give you the count of creation date based on different type of orders.

You have only considered--Purchase orders and sales orders..How about Production orders and Planning orders.

Please think about them as well.

Regards,

AL

former_member202516
Participant
0 Kudos

Lets say that I only need to count created documents by user.

For second part of your reply, it's mostly trading company and they do not have production. What about documents created through FI or MM module (invoices for some kind of services or transfer of materials between storage locations via transfer note)?

Regards

RamanKorrapati
Active Contributor
0 Kudos

Hi,

if you check with source team you will get exact tables which are needs to do the report on purchase creation.

check the data source -2LIS_02_HDR.

look for the fields - user name who created purchase doc and create date.

Thanks