Selected fields not in order

[former_member211589]

Hello All,

I am selecting few fields from a table with the field in the condition 'rollname' = XXX.The rollname is a field in the table DD04t.If for exapmle in the selection screen if i give values like 'MATNR' 'EBELN' 'EBELP' the select statment will select the fields in the sorted order.It is not in the same order as given in the selection screen.How to fetch this and display in the same order as given by the user in the selection screen.

Thanks,

Rakesh.

[former_member211589]

Hello All,

I am selecting few fields from a table with the field in the condition 'rollname' = XXX.The rollname is a field in the table DD04t.If for exapmle in the selection screen if i give values like 'MATNR' 'EBELN' 'EBELP' the select statment will select the fields in the sorted order.It is not in the same order as given in the selection screen.How to fetch this and display in the same order as given by the user in the selection screen.

Thanks,

Rakesh.

[RichHeilman]

You would have to somehow sort that data manually based on the data from the selection screen after the SELECT statement, This could get quite messy. For example, you would need a couple intermidate tables for 1) the select-option and 2) the output table. Both would need to contain an index value. You would sort the table by this value.

Regards,

Rich Heilman

[ramesh_mahankali]

Hi,

In terms of performance it is good idea to select the fields i the same order as they appear in database table.

Once you have them in internal table you can change the order in which you want to display while using write/field catalog.

Hope this helps,

Ramesh