2006 Feb 09 11:10 AM
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 :
Is it possible to populate the internal table, as shown in SE16 itself.
Thanks,
Bharadwaj
hi
After the select statement sort the internal table in the order of primery key as in se11 table. this will solve ur problem
2006 Feb 09 11:14 AM
Hi br,
1. order by pos
u can use order by.
2.
WHERE segtyp = 'E1MAKTM'
order by pos.
regards,
amit m.
2006 Feb 09 11:36 AM
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!
2006 Feb 09 11:41 AM
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.
2006 Feb 09 11:47 AM
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.
2006 Feb 09 11:48 AM
2006 Feb 10 3:14 AM
you could do:
SELECT pos fieldname FROM edsappl
INTO corresponding fields of TABLE l_t_appl
....
Hopefully pos will be used for the order by but isn't in the output table.
2006 Feb 10 4:47 AM
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
Bluesky
