Select Query not working in another client

[Former Member]

hi i am trying to fetch data from BKPF table and store it in internal table.

The query works fine in the development client but when it goes to the other client the same query results in sy-subrc eq 4.

the data is avaialable in the that client for the respective BELNR,GJAHR,BUKRS.

Please kindly help in resolving this issue.

Please find below the query

SELECT belnr bukrs gjahr stblg usnam

     INTO TABLE it_bkpf

     FROM bkpf

     FOR ALL ENTRIES IN it_exists

     WHERE belnr = it_exists-belnr

     AND  bukrs  = p_wa_final-bukrs

     AND  gjahr  = p_wa_final-rgjahr.

[nishantbansal91]

HI Rajat,

Check the where clause condition using table. Means you have to pass the Same data to the BKPF table while debugging.

Regards.

Nishant

[venkat_aileni]

Hi-

Have you used Conversion Routine for the fields BELNR and GJAHR? Also in debugging mode did you found any entries in it_exists table? Also in debugging mode INSERT valid rows and check whether entries are getting retrieved or not.

Also can share some screen shots of your internal table it_bkpf consisting entries in debugging mode.

-Venkat

Message was edited by: Venkat Aileni

[vladimir_erakovic]

Hi Rajat,

Maybe FOR ALL ENTRIES make problem. What is in it_exists?