topic Re: Select query for the table using user input and internal table in Application Development and Automation Discussions

Select query for the table using user input and internal table

ABAPER_P — Fri, 05 Dec 2014 07:29:15 GMT

I have internal table it_characteristics which is type table of structure characteristics which contains some values name_char which are various characteristics of materials and I have fetch the data from the ausp table based on objek (material number which is entered in selection screen ) and all character values from the internal table it_characteristics .

What would be my select query ?

SELECT objek
atinn
atzhl
mafid
klart
adzhl
atwrt
FROM ausp
INTO TABLE it_ausp
WHERE objek EQ s_object(this is material number)

And now I want feach attn. comparing the name_chares values from the internal table it_characteristics

Means atinn must match with the name_char vales

Re: Select query for the table using user input and internal table

Former Member — Fri, 05 Dec 2014 07:44:29 GMT

Hi ,

use this .

sort it_characteristics by name_char.

Loop at it_ausp into wa_ausp.

read table it_characteristics into wa_characteristics with key

name_char = wa_ausp-atinn

binary search.

if sy-subrc eq 0.

"put your logic here .

endif.

endloop.

Regards,

Saddam

Re: Select query for the table using user input and internal table

mayur_priyan — Fri, 05 Dec 2014 07:58:49 GMT

Use

IF NOT it_characteristics[] IS INITIAL.

SELECT objek
atinn
atzhl
mafid
klart
adzhl
atwrt
FROM ausp
INTO TABLE it_ausp

FOR ALL ENTRIES IN it_characteristics <<<
WHERE objek IN s_object(this is material number)

AND atinn EQ it_characteristics-name_char. <<<

ENDIF.

Re: Select query for the table using user input and internal table

ABAPER_P — Fri, 05 Dec 2014 08:41:38 GMT

First of all no use of looping it_ausp because there no data in that internal table.

i want put put values in internal table based on charterstics values.

Re: Select query for the table using user input and internal table

ABAPER_P — Fri, 05 Dec 2014 08:48:07 GMT

getting error

there is conversion routine present for the filed attin field

CONVERSION_EXIT_ATINN_INPUT. but in table it_charaterstics there wont apply the conversion rotine so cant use /....

Re: Select query for the table using user input and internal table

Former Member — Fri, 05 Dec 2014 08:57:01 GMT

Hi,

Befor writing select query convert your it_charaterstics-name_char into the type which you want by using CONVERSION_EXIT_ATINN_INPUT and then write the select query as described by

Mayur Priyan.

LOOP AT it_charaterstics ASSIGNING <FS_CHAR>.

CALL FUNCTION CONVERSION_EXIT_ATINN_INPUT

EXPORTING

INPUT = <FS_CHAR>-MANE_CHAR

IMPORTING

OUTPUT = <FS_CHAR>-MANE_CHAR

ENDLOOP.

IF NOT it_characteristics[] IS INITIAL.

SELECT objek
atinn
atzhl
mafid
klart
adzhl
atwrt
FROM ausp
INTO TABLE it_ausp

FOR ALL ENTRIES IN it_characteristics
WHERE objek IN s_object(this is material number)

AND atinn EQ it_characteristics-name_char.

ENDIF.

Reagrds

Mani