There are no results when I search the document changes of sales order bill:VA02

[Former Member]

Now, our SAP system appeared a new problem: all SD business documents modify records query function can not be used, the specific symptoms are as follows:

Tcode:VA02

An example which is a definite modify sales orders,and Query Revision History:

At this time, the problem appears, click the "execute" button, nothing happens,

The programe cannt return any results.

But,we can view the table data, found that sales orders to modify records are there.

When I input "/h" to debug the programe in this window, I can find everything is right until the alv show.

Alv report doesnt show . And the programe is over.

I continue to debug the function of alv_show ('REUSE_ALV_LIST_DISPLAY'), and I find the parameter of this function has been setted 'X'

CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'

   EXPORTING

     i_callback_program                = g_repid

     i_callback_pf_status_set          = 'HANDLE_EVENT_PF_STATUS'

     i_callback_user_command           = 'HANDLE_EVENT_USER_COMMAND'

*

     is_layout                         = gt_layout

     it_fieldcat                       = gt_fieldcat

     it_events                         = lt_evthead

     it_except_qinfo                   = gt_exc

     i_suppress_empty_data             = 'X'

   TABLES

     t_outtab                          = gt_output

   EXCEPTIONS

     program_error                     = 1

     OTHERS                            = 2

And I try to copy this function to a new function , I change this setting

i_suppress_empty_data

= 'X'

i_suppress_empty_data

= ''

Then the alv can be showed. I want to know how to change this to show the alv from 'va02'

Please help us, thanks.

[siva_vasireddy2]

Hi,

  i have small Doubt regarding the screen shots

in the first screen shot the Document number starts with 613*****

in the second screen shot the Document number is 606*****

so how are you able to check the change status.

Siva

[Former Member]

Hi,

Hope you have checked the tables CDHDR and CDPOS.If not please check the entries in the same table.Please confirm wether you are getting any message while you are executing..

Raneesh

[Former Member]

Thank you for your answer.

I can find the data from the tables CDHDR and CDPOS.But I can't open the alv from va02-changes-excute

[Former Member]

If you cant find your document in these tables then which  indicates that there is no change happend in the document..You can increase or decrease the order quantity and check is there any entry you are finding in tha table

[Former Member]

But i can find document in these tables.how can i do?

[Former Member]

Go to CDHDR table in the object value filed enter your ordernumber(total 10 characters shoul be there,for eg,If ur order number is 1020 then you to incluse prefix zeros like 0000001020) and then excute.From this table you will get Document number pass the same to CDPOS table.

Reward if the comments are useful otherwise ignore it..

[Former Member]

sorry, can you understand my question? first,I thank you for your help.but you cannt know what's wrong with me. I can find the doucument from table. i cannt  open the query window.

[od_manikandan]

Hai Mose,

In the role : authorisation

Include:

Basis - Central Functions                                    BC_Z

ALV Standard Layout                                          S_ALV_LAYO

Activity                       *                                      ACTVT

___

and

Change documents                                             S_SCD0

Activity                       08                                    ACTVT

Regards,

Mani