Confirmations per day

[Former Member]

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

[Former Member · Accepted solution]

Hello All,

I mapped it using transparent tables only.

I passed today's date as 'posting date' in table 'AFRU', then from all the entries I was getting, I checked for Counter (APLZL).

If the counter is empty, then the confirmation was carried out at 'Order level', if not then the confirmation was carried out at operation level.

Now, for all the entries having 'Counter' (APLZL) as empty, I deleted the entries from table AFRU and passed their 'plan no. of opeartion' (AUFPL) to table AFVC and counted all the operations.

And as the remaining entries in AFRU are entries for which confirmation was carried out at operation level, so I combined the results for both AFRU and AFVC in an internal table to count the number of operations confirmed today.

Thanks all for your help.

Regards,

Anuj

[Former Member]

Issue has been resolved.Thanks.

[rupesh_brahmankar3]

Hello,

Please share the details, how did you map it?

Also close the discussion.

Best Regards,

R.Brahmankar

[dimasluis_defaria]

Hi,

Try:

1) Confirmation quantity - AFVV - using fields: yield confirmation / operation quantity

or

2) Operation status - AFVC (take object number - AFVC-OBJNR) after JEST and TJ02T (JCDS GOOD TABLE) - better solution

or

3)  exists other forms, do you need think about your process..

Regards

Dimas Faria

[rupesh_brahmankar3]

Hello,

If you want to check the order confirmation in detail, please use the Confirmations list to excute the transaction code COOISPI/COOIS. You will see all the confirmation  for each phase/operation.

Confirmation counter in the operation table AFVC-RMZHL must be the same as the confirmations for this operation; that is, the number of records in the table AFRU with confirmation number AFVC

Best Regards,

R.Brahmankar