SE11: How to Create new Table and determine sort order

[Former Member]

I have created a new table using SE11.

TableName: Z_NEWTABLE

Fields: Mandt Clnt 3

Description Char 30

Eff_Date Dats 8

Value Dec 6

For the 1st 3 fields I have clicked on Key and Intial Values. The I use the Table Maintenance Generator.

When I access this table view SM30 and add new entries they just get stored in the order I enter them in. I want them to be sorted according to Description and then Eff_Date. Can I not do this somehow though SE11?

[RichHeilman]

I think that if you enter some values, then save them, then back out of the table maintenance, then go back in, they will be in order of the key of your table.

Regards,

Rich Heilman

[Former Member]

Thx! I must be tired and it must be a Friday. That is the same thing I had thought. Turns out it matters what case you are entering it in as well.

[RichHeilman]

Sure, case would play a role with a "Description" field.

Regards,

Rich Heilman