topic Re: Select Query not working in another client in Application Development and Automation Discussions

Select Query not working in another client

Former Member — Mon, 09 Dec 2013 13:17:47 GMT

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.

Re: Select Query not working in another client

nishantbansal91 — Mon, 09 Dec 2013 18:09:46 GMT

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

Re: Select Query not working in another client

venkat_aileni — Mon, 09 Dec 2013 18:17:06 GMT

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

Re: Select Query not working in another client

vladimir_erakovic — Mon, 09 Dec 2013 18:18:28 GMT

Hi Rajat,

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