topic Re: Logic required for select query in Application Development and Automation Discussions

Logic required for select query

Former Member — Tue, 24 Mar 2009 09:54:12 GMT

i have a internal table with 4 columns. 3 columns having varrious material numbers. i want to check every material with mara table. its available or not?

I need to write a single select queary? how to do this?

My internal table looks like

matnr idnrk s_idnrk normt

test10 10UPC3050 F14839030 test.

i wrotes like below

select matnr from mara into table

i_mara2 for all entries in

i_sub_file

where matnr = i_sub_file-matnr and

matnr = i_sub_file-idnrk and

matnr = i_sub_file-s_idnrk.

Its not working, How to manage this? Anyone help this.

Mohaha

Re: Logic required for select query

Former Member — Tue, 24 Mar 2009 09:57:11 GMT

Create 1 ranges TYPE of Matnr.

Append all your 3 fields material into the ranges.

Then just use IN in the select statements

like e.g

select matnr from mara

into table i_mara2

where matnr IN rg_matnr.

Re: Logic required for select query

former_member222860 — Tue, 24 Mar 2009 09:58:01 GMT

What's the error your getting?

May be there's no data for the given where condition.

pl.check your master table: MARA

Re: Logic required for select query

Former Member — Tue, 24 Mar 2009 09:59:40 GMT

hi,

loop at internal table.

insert the values of three columns of material nos into one internal table with field matnr.

select from matnr where mara in internal table.

now u can check with the first internal table value.

process ...

endloop.

Re: Logic required for select query

Former Member — Tue, 24 Mar 2009 10:00:42 GMT

Write three select singles in loop.

For each material one select single.

First take all this material into one internal table and fetch the

all meterial data from MARA.

then in loop use read statement on internal table three times.

Re: Logic required for select query

Former Member — Tue, 24 Mar 2009 10:01:53 GMT

Hi Mohaha.

TRY:

select matnr from mara into table

i_mara2 for all entries in i_sub_file

where matnr = i_sub_file-matnr.

I think this works

Gr. Frank.

Re: Logic required for select query

I355602 — Tue, 24 Mar 2009 10:02:08 GMT

Hi,

Use something like:-


tables : mara.
ranges : r_matnr for mara-matnr.

loop at itab.
  r_matnr-sign = 'I'.
  r_matnr-option = 'EQ'.
  r_matnr-low = itab-matnr.
  append r_matnr.

  r_matnr-sign = 'I'.
  r_matnr-option = 'EQ'.
  r_matnr-low = itab-idnrk.
  append r_matnr.

  r_matnr-sign = 'I'.
  r_matnr-option = 'EQ'.
  r_matnr-low = itab-s_idnrk.
  append r_matnr.
endloop.

select matnr from mara into it_matnr where matnr in r_matnr.
"you will get all matnr for all matnr in itab.

loop at itab.
  if not itab-matnr in r_matnr.
    "code
  elseif not itab-idnrk in r_matnr.
    "code
  elseif not itab-s_idnrk in r_matnr.
    "code
  endif.
endloop.

Hope this helps you.

Regards,

Tarun

Re: Logic required for select query

Former Member — Tue, 24 Mar 2009 10:06:26 GMT

make one more internaltable say itab1.

select matnr from mara into table itab1.

now loop at i_sub_file.

read table itab1 with key matnr = ( i_sub_file-idnrk Or i_sub_file-idnrk-matnr Or..)

if sy-subrc = 0.

entry exist.

else.

not exist.

endloop.

thanks & Regards,

Ruchi Tiwari

Re: Logic required for select query

Former Member — Tue, 24 Mar 2009 10:09:05 GMT

Hi fill the ranges with ur 3 material numbers.

and use it in ur select query.

define a range for mat no.

ranges : r_matnr for mara-matnr.

read table or loop with i_sub_file.

r_matnr-sign = 'I'.

r_matnr-option = 'EQ'.

r_matnr-low = 'i_sub_file-matnr.

append r_matnr. clear r_matnr.

r_matnr-sign = 'I'.

r_matnr-option = 'EQ'.

r_matnr-low = 'i_sub_file-idnrk.

append r_matnr. clear r_matnr.

r_matnr-sign = 'I'.

r_matnr-option = 'EQ'.

r_matnr-low = 'i_sub_file-s_idnrk.

append r_matnr. clear r_matnr.

now in select.

select matnr from mara into table

i_mara2 where matnr in r_matnr.