Skip to Content
0
Former Member
Apr 26, 2016 at 01:21 PM

Confirmations per day

389 Views

Hi All,

In an internal report, we need the count of operations (not quantity) confirmed today (everyday).

We can check by passing orders to table 'AFVC' and fetching 'RUECK' (confirmation no.), and then passing the confirmation number of operation to table 'AFRU' and fetching the count of operations having 'posting date' as today.

But, the problem with this logic is that the confirmation can be done at 'order level' also, and in such case there will not be any data for confirmation no. of operations in table 'AFRU'.

Kindly suggest me with the logic to fetch the count of operations (only finally confirmed) in a particular day.

Thanks in advance.

Regards,

Anuj