topic Re: select query not selecting values into table in Application Development and Automation Discussions

select query not selecting values into table

dayakar_sama — Wed, 11 Apr 2012 08:20:06 GMT

Hi,

i want the AUFNR to be extracted from QMEL for a QMNUM, i used the below statement, but it is showing sy-subrc = 4.

IF git_qmnum[] IS NOT INITIAL.

SELECT qmnum

aufnr

FROM qmel

INTO TABLE git_qmel

FOR ALL ENTRIES IN git_qmnum

WHERE qmnum EQ git_qmnum-qmnum.

ENDIF.

please help

regards,

sama

Moderator message : Not enough re-search before posting, discussion locked.

Message was edited by: Vinod Kumar

Re: select query not selecting values into table

naveen_inuganti2 — Wed, 11 Apr 2012 08:23:30 GMT

Hope your table git_qmel declaration is correct with qmnum and aufnr fields.

Then, check in debug mode what values are coming into for all entries table and copy one of then from debugging screen and check in SE11 if we have data for it.

Regards,

Naveen.I

Re: select query not selecting values into table

Kanagaraja_L — Wed, 11 Apr 2012 08:25:49 GMT

Share your SQL Statement to fill git_qmnum

Re: select query not selecting values into table

Former Member — Wed, 11 Apr 2012 08:27:27 GMT

Hi ,

The query looks correct, so please check the following

1. Does the value that exists in internal table git_qmnum exist in the db table .

2. Data type of the field qmnum in the internal table and the value in the field must have preceding '0' where ever needed . Please see some entry in table QMEL for example.

I think in your scenario case 2 must be more relevant.

Regards

Arun

Re: select query not selecting values into table

former_member404244 — Wed, 11 Apr 2012 08:28:46 GMT

Hi,

Check if the data is there or not in the table...

Regards,

Nagaraj

Re: select query not selecting values into table

dayakar_sama — Wed, 11 Apr 2012 08:37:38 GMT

Hi,

git_qmnum is having the value of qmnum. i checked it, and i also used the conversion_exit_alpha_input for aufnr to get the preceeding 0's.

Re: select query not selecting values into table

dayakar_sama — Wed, 11 Apr 2012 08:38:51 GMT

qit_qmnum is not intiail

Re: select query not selecting values into table

Former Member — Wed, 11 Apr 2012 09:18:22 GMT

Hi ,

is it conversion exit for aufnr or for QMNUM. I would expect the conversion exit to be used for QMNUM.

If you are doing this then really don't understand why the statement does not work , if possible you can post some sample data or attach screen shots.

Regards,

Arun

Re: select query not selecting values into table

Himayatullah — Wed, 11 Apr 2012 09:25:31 GMT

Hello,

check the way fields declared in internal table or types declaration are in the same order as you are selecting in select query.

Best Regards

Himayat