topic Re: ABAP database query. in Application Development and Automation Discussions

ABAP database query.

rohit_trivedi — Mon, 26 Jun 2006 08:39:01 GMT

Hi,

I've query like this:

SELECT * FROM /sapsll/adrcon INTO TABLE lt_adrcon_tmp

FOR ALL ENTRIES IN lt_leglrgi

WHERE adrnr EQ lt_leglrgi-adrnr

AND lgreg EQ lt_leglrgi-lgreg.

Now, instead of all entries in lt_leglrgi, i want to select specific entries only. lt_leglrgi has a field SCRVT. I want the above query to work on only those lt_leglrgi entries for which SCRVT is set.

Deleting entries from lt_leglrgi is not a option.

I want to avoid a extra loop.

Is there any way i can restructure this database query for my requirement?

Thanks,

Rohit.

Re: ABAP database query.

Former Member — Mon, 26 Jun 2006 08:48:08 GMT

Hi rohit,

1. only those lt_leglrgi entries for which SCRVT is set

SELECT * FROM /sapsll/adrcon INTO TABLE lt_adrcon_tmp

FOR ALL ENTRIES IN lt_leglrgi

WHERE adrnr EQ lt_leglrgi-adrnr

AND lgreg EQ lt_leglrgi-lgreg

<b>AND LT_LEGLRGI-SCRVT IS NOT INITIAL.</b>

regards,

amit m.

Re: ABAP database query.

Former Member — Mon, 26 Jun 2006 08:49:03 GMT

Hi,

Fill the internal table lt_leglrgi with the required entries only and then use FOR ALL ENTRIES.

i.e. while filling the records into lt_leglrgi, aply the condition of SCRVT.

Regards,

Shashank

Re: ABAP database query.

Former Member — Mon, 26 Jun 2006 08:50:26 GMT

Hai Rohit

Check the Following Code

sort lt_leglrgi by adrnr lgreg.

if not lt_leglrgi[] is initial.

SELECT * FROM /sapsll/adrcon INTO TABLE lt_adrcon_tmp

FOR ALL ENTRIES IN lt_leglrgi

WHERE adrnr EQ lt_leglrgi-adrnr

AND lgreg EQ lt_leglrgi-lgreg

AND LT_LEGLRGI-SCRVT IS NOT INITIAL.

endif.

Thanks & regards

Sreenivasulu P

Re: ABAP database query.

Former Member — Mon, 26 Jun 2006 08:51:32 GMT

Hi Rohit,

Use this

If lt_leglrgi-SCRvt = 'X'.

SELECT * FROM /sapsll/adrcon INTO TABLE lt_adrcon_tmp

WHERE adrnr EQ lt_leglrgi-adrnr

AND lgreg EQ lt_leglrgi-lgreg.

and lt_leglrgi-scrvt is not initial

endif.

Re: ABAP database query.

rohit_trivedi — Mon, 26 Jun 2006 08:56:50 GMT

Hi,

@Shanshank: The table lt_leglri has to be filled by all the entries.

@Sreenivasulu / amit : That is a syntax error. Please check again.

@mukesh : lt_leglrgi is a internal table, not a structure.

Regards,

Rohit.

Re: ABAP database query.

Former Member — Mon, 26 Jun 2006 09:03:20 GMT

This seems to be the only option left:

IT_TEMP[] = LT_LEGLRGI[].

DELETE FROM IT_TEMP WHERE NOT SCRVT IS INITIAL.

and now,

SELECT * FROM /sapsll/adrcon INTO TABLE lt_adrcon_tmp

FOR ALL ENTRIES IN <b>IT_TEMP</b>

WHERE adrnr EQ lt_leglrgi-adrnr

AND lgreg EQ lt_leglrgi-lgreg.

Hope this helps.

Sudha