topic Re: Select query in Application Development and Automation Discussions

Select query

Former Member — Thu, 09 Feb 2006 11:10:01 GMT

Hello All,

SELECT fieldname FROM edsappl

INTO TABLE l_t_appl

WHERE segtyp = 'E1MAKTM'.

In the above selection, the internal table is populated as :

MAKTX

MSGFN

SPRAS

SPRAS_ISO

whereas, in SE16 it is in the below order :

MSGFN

SPRAS

MAKTX

SPRAS_ISO

Is it possible to populate the internal table, as shown in SE16 itself.

Thanks,

Bharadwaj

Re: Select query

Former Member — Thu, 09 Feb 2006 11:14:07 GMT

Hi br,

1. order by pos

u can use order by.

SELECT fieldname FROM edsappl

INTO TABLE l_t_appl

WHERE segtyp = 'E1MAKTM'

order by pos.

regards,

amit m.

Re: Select query

Former Member — Thu, 09 Feb 2006 11:36:58 GMT

Hi,

To use "ORDER BY pos" , i need to add the pos field also to the internal table(l_t_appl). Is there any possibility avoiding this!

Re: Select query

Former Member — Thu, 09 Feb 2006 11:41:42 GMT

hi again,

1. i need to add the pos field also to the internal table(l_t_appl

NOT REQUIRED.

No need to add any field in your internal table.

It will work fine.

regards,

amit m.

Re: Select query

Former Member — Thu, 09 Feb 2006 11:47:07 GMT

Hello BR,

i have used the following code and I get the same result as in SE16.

<b>tables: edsappl.

data: begin of i_edsappl occurs 0.

data: fieldname like edsappl-fieldname.

data: end of i_edsappl.

clear i_edsappl.

refresh i_edsappl.</b>

select fieldname from edsappl

into table i_edsappl

where segtyp = 'E1MAKTM'.

I am using ur code only.

Re: Select query

Former Member — Thu, 09 Feb 2006 11:48:39 GMT

After the select statement sort the internal table in the order of primery key as in se11 table. this will solve ur problem

Re: Select query

former_member186741 — Fri, 10 Feb 2006 03:14:21 GMT

you could do:

SELECT pos fieldname FROM edsappl

INTO corresponding fields of TABLE l_t_appl

WHERE segtyp = 'E1MAKTM'

order by pos.

....

Hopefully pos will be used for the order by but isn't in the output table.

Re: Select query

Former Member — Fri, 10 Feb 2006 04:47:18 GMT

Hi B R,

Define ur internal table by this way:

data : begin of L_T_APPL occurs 0,

MSGFN like <table Name>-MSGFN,

SPRAS like <table Name>-SPRAS,

MAKTX like <table Name>-MAKTX,

SPRAS_ISO like <table Name>-SPRAS_ISO,

end of L_T_APPL.

Regards,

Digesh Panchal