topic Re: How to sort a custom database table ? in Application Development and Automation Discussions

How to sort a custom database table ?

Former Member — Mon, 27 Apr 2009 07:57:56 GMT

Hi,

how do I sort/order a custom (Z) database table (not internal table) ? Couldn't find a suiting option with F1 for the SORT statement.

Thanks,

Avraham

Re: How to sort a custom database table ?

Sandeep_Panghal — Mon, 27 Apr 2009 08:02:17 GMT

SORT --> Do you mean sort the o/p display?

Re: How to sort a custom database table ?

Former Member — Mon, 27 Apr 2009 08:04:28 GMT

yes you cansort...

just make it display in alv format..

go to SETTING -> USER PARAMETERS ...now select alv grid...now you can sort your tables output.

with regrads

janani

Re: How to sort a custom database table ?

Former Member — Mon, 27 Apr 2009 08:08:39 GMT

I have a database table, just like, say MARA or VBAK, but it's not SAP, it's mine.

Was it an internal table, I would work this out with SORT. But I didn't do this yet to a database table.

Re: How to sort a custom database table ?

Former Member — Mon, 27 Apr 2009 08:10:06 GMT

that is wat i am telling...

now go to se16 ..

give youer table name ...

give F8

THEN you follow the steps of ,my before post you can get it...

Re: How to sort a custom database table ?

Former Member — Mon, 27 Apr 2009 08:13:09 GMT

I have to do this within my program.

Re: How to sort a custom database table ?

Former Member — Mon, 27 Apr 2009 08:13:58 GMT

Hi,

If you just wanted to VIEW the data in a standard SAP table in a sorted order,

then go to the transaction SE16.

GIve the table name.

Press Enter Button.

Then press F8 (Execute button).

In the screen to folow, yo will get the records of the table.

Put the cursor on the column by which you want to sort, then click on the SORT Button(Acending : CTRLSHIFTF5) or Descendin(CTRLSHIFTF6)

Regards,

Ravi

Re: How to sort a custom database table ?

Former Member — Mon, 27 Apr 2009 08:27:52 GMT

hiii,

hey no ...

in se16 ...

Re: How to sort a custom database table ?

christine_evans — Mon, 27 Apr 2009 09:25:09 GMT


> I have to do this within my program.

Use ORDER BY in your select. Or just select your data into an itab and use SORT. I don't see the problem.

If you mean that you want to sort your table in the database itself, then you can't. Database table rows are not held in any specific order; the order is applied when you select the data out of the table.

Re: How to sort a custom database table ?

Former Member — Mon, 27 Apr 2009 09:35:37 GMT

Hi,

By default system database table will be sorted based on the primary key fields. So you can change that sequence now. If you want to sort some other field also, which is not primary key, then make that field to primary key.

In the program, it is normal way of sorting by mentioning the required fields. If you don't mention any thing means, it is again based on the primary keys.

Regards,

Santhosh.