Query related to collective settlement of sales order ( Transaction code: VA88)

[former_member195434]

Hi All,

Can anyone tell me, when we execute settlement of sales order collectively under Transaction code: VA88 then there are 3 options:-

Selection

Processing Options

Statistics

Now under "Statistics", we have processing category such as Number of settlements executed, No change, Not relevant, Inapproporiate status and Error.

Can anyone help me to understand, how can i get details of the sales orders with the "Inappropriate status" and "No change" because i could get details of the sales orders only for "Settlement executed" and "Error" when i click on log.

Appreciate your help in the above case

Thanks

[former_member195434 · Accepted solution]

There seems to be no standard way of getting the exact requirement.

[Former Member]

Hi..

Refer to below sap's description related to processing category.

In the basic list of the log, the selected senders are sorted acco
to the following processing categories if more than one sender was
selected:

Category                       Description
Settlement executed     Number of senders:
                                       - That were executed and for which
                                         WIP calculation or results
                                        analysis was performed, or
                                    - For which only WIP calculation
                                     or results analysis was performed

Settlement reversed        Number of senders that were
                                       reversed (canceled)
                               Note
                               There may, however, be further
                               settlements to be reversed in
                               a settlement period.

No change                      Number of senders for which,
                               according to the settlement rule,
                               there was nothing to be settled
                               and for which no errors occurred
                               in the settlement period.
                               In the case of reversal:
                               Number of senders for which:
                                 - All settlements were reversed
                                   in the settlement period
                                 - No settlements were performed
                                   in the settlement period.

Not relevant                   Number of senders that are not
                               to be settled for the following reasons:
                                 - The sender is statistical.
                                 - The settlement profile specifies
                                   that no actual costs should be
                                   settled.
                                 - The sender is a WBS element
                                   that is not a planning element,
                                   but planned settlement is
                                   being executed.

Inappropriate status           Number of senders that are not
                               to be settled for the following reasons:
                                 - The sender still has the status
                                   "Created".
                                 - The sender is already closed.
                                 - The sender has been flagged
                                   for deletion.
                                 - The sender has been deleted.
                                 - The sender is a production
                                   order that has no results
                                    analysis key and has
                                   neither been technically
                                   completed nor finally delivered
                                   in the settlement period.
                                   The sender has been settled
                                   using worklists and has a
                                   status that prevents settlement
                                   (such as Locked)

Error                          Number of senders for which at least
                                one error occurred.
                                Note
                                In the dialog, the messages
                                can be displayed with
                                the pushbutton Messages.
                                When you run a job in the
                                background, the messages are
                                listed in the spool list.

[former_member195434]

THanks for your reply Choi but I am already aware of the SAP's documentation regarding this.

What I am specifically looking for is if we can get the "list of orders" which belong to "Inappropriate status".

Please suggest if there is any way to get it.

Thanks

[Former Member]

Hi..

You use  "JEST" table to get order with Inappropriate status.

Below example sql is to get order with deletion flag.

SELECT SINGLE STAT

  INTO LV_STAT

FROM JEST
WHERE OBJNR = AUFK-OBJNR (order's object number)
AND STAT EQ ‘I0076’  (You use tj02 to get Status information. )

     AND INACT = SPACE.

[former_member195434]

Hi Choi,

Thanks for this. So shall I presume there is no standard way of getting the list of 'inappropriate status' at the time of / after settlement?

The user wants to be able to see the list of such orders and we're not bery keen on creating SQL report.

Regards

[Former Member]

Hi..

You try to get the sales order using  t-code v.26.