Skip to Content
0
Former Member
Oct 23, 2006 at 06:57 PM

possible to determine when order entered from VBAP table

437 Views

I am trying to answer the following business questions by running sql against the base tables of SAP.

1) What is the total dollar value of all orders entered for a given month, i.e. the month of September?

2) What is the total dollar value of all orders cancelled for a given month, i.e. the month of September.

I was looking in the VBAK and VBAP tables and saw some date fields such as aedat (date record entered) and erdat (date record last changed) but these do not seem to correlate to the date an order was entered and only sometimes to when an order was cancelled.

Is it possible to answer the 2 business questions from any tables in SAP? If so, what is the sql query I would need to use?