topic Re: query in Application Development and Automation Discussions

query

Former Member — Wed, 26 Sep 2007 05:19:49 GMT

hai,

tell me what this query do..........

itab is my internal table

SELECT SINGLE matkl INTO mara-matkl

FROM mara

WHERE matnr EQ itab-matnr.

Re: query

Former Member — Wed, 26 Sep 2007 05:22:59 GMT

If this code is not placed in the LOOP statement, then it will pick up header value present in ITAB-MATNR and use it to pick up MATKL from MARA. If there is an entry, the value is placed in MARA-MATKL.

If it is placed in a LOOP Statement, then it will pick up MATKL from MARA for each entry of MATNR from ITAB. If there is an entry, the value is placed in MARA-MATKL.

Re: query

Former Member — Wed, 26 Sep 2007 05:23:13 GMT

this query

SELECT SINGLE matkl INTO mara-matkl

FROM mara

WHERE matnr EQ itab-matnr.

It will fetch one record i.e. matkl value from mara into temp memory mara-matkl

using the where condition matnr EQ itab-matnr(i.e) the values matching in internal table.

Example :

SELECT SINGLE batxt FROM t161t INTO t161t-batxt WHERE

bsart = wa_fitab2-bsart AND

spras = sy-langu.

Re: query

Former Member — Wed, 26 Sep 2007 05:30:03 GMT

so why they are moving tempraveryly in to database table.

Re: query

Former Member — Wed, 26 Sep 2007 05:30:23 GMT

hi Vikram,

for the 'matnr' value present in the header line of the internal table itab, the select query will fetch the corresponding 'matkl' value from th DB table mara and store it in the field 'mara-matkl'.

Regards,

Viji

Re: query

Former Member — Wed, 26 Sep 2007 05:31:51 GMT

so why they are moving tempraveryly in to database table.

Re: query

Former Member — Wed, 26 Sep 2007 05:38:45 GMT

It is not moved to database table. We are just using the work area of standard table MARA which acts like a variable of type MATKL (as we are using MARA-MATKL).

Re: query

Former Member — Wed, 26 Sep 2007 05:40:37 GMT

If you dont want in that way, do in this below way

example :

SELECT SINGLE *

FROM lfa1 INTO wa_lfa1

WHERE lifnr = wa_fitab2-lifnr.

define as below

Data : wa_lfa1 TYPE lfa1.

<b>In your case do it as below

Data : wa_matkl TYPE matkl.

SELECT SINGLE matkl INTO wa_matkl

FROM mara

WHERE matnr EQ itab-matnr.</b>

Re: query

Former Member — Wed, 26 Sep 2007 05:41:45 GMT

And moreover your not updating the database table in the below query

SELECT SINGLE matkl INTO mara-matkl

FROM mara

WHERE matnr EQ itab-matnr.

you are using temporory work area thats it.