topic Re: select query in Application Development and Automation Discussions

select query

Former Member — Wed, 09 Jul 2008 13:07:16 GMT

Hi,

can anyone tell me what this code is doing?

SELECT matnr labst

FROM mard

APPENDING TABLE i_stock

FOR ALL ENTRIES IN i_matdoc

WHERE matnr = i_matdoc-matnr

AND werks = i_matdoc-werks.

why is this appending written?

regards,

Poonam

Re: select query

Former Member — Wed, 09 Jul 2008 13:08:42 GMT

hi,

If there is already any data in the internal table it is not refreshed,

this select stmt. will just keep appending the new values to the same internal table.

Regards,

Subramanian

Re: select query

Former Member — Wed, 09 Jul 2008 13:11:54 GMT

I very good way to learn about a ABAP is to become familiar with the F1 Function key in the Text Editor when you are unfamilar with a Statement and Syntax. It is much faster than posting a thread here.

Re: select query

Former Member — Wed, 09 Jul 2008 13:12:03 GMT

Hi,

The records that are allready there in the Internal table will not be refreshed . The new records from the select statement will be appended to the allready exsisting records .

Re: select query

Former Member — Wed, 09 Jul 2008 13:12:35 GMT

hi,

if my internal table has data before select stmt triggers.

once select stmt is executed then the data in the internal table is refreshed and new data is stored as per the select stmt.

to avoid that we use append stmt in select , the purpose the selected values are appended to the existing internal table values.

Rgds

subash

Re: select query

suredarreddy_pulimamidi — Wed, 09 Jul 2008 13:13:15 GMT

hi,

in ABAP edtor on select keyword put cursor and press F1 you will get detail documentation for this.

warm regards,

surendar reddy.

Re: select query

Former Member — Wed, 09 Jul 2008 13:14:02 GMT

Hi Poonam,

The select statement is selecting the matnr and labst from mard table and appending them into table i_stock for all those entries in the internal table i_matdoc which are satisfying the condition.

Here instead of into table we are using APPENDING TABLE, which appends the records into the table.

Hope this helps you.

Regards,

Chandra Sekhar

Re: select query

Former Member — Wed, 09 Jul 2008 13:14:14 GMT

i_stock might be having entries even before executing to this

select .. In order to retain old values along with the new values

APPENDING is used ...

Re: select query

Former Member — Wed, 09 Jul 2008 13:17:51 GMT

Hi ,

It is similar to ... INTO TABLE lt_tab, but the difference is that read lines are appended to the previous contents of the internal table lt_tab.

Best regards,

raam

Re: select query

Former Member — Wed, 09 Jul 2008 13:26:29 GMT

thanks.

Re: select query

Former Member — Wed, 09 Jul 2008 13:27:05 GMT

if the criteria is to select data from 2 db tables into the 1 internal table and where u cannot use joins this statement is used..