Issue creating a Database table with a decimal key field

[Former Member]

Hi guys!

Can you try this?

- Create a Database Table ZTEST via SE11 with just the client field and a decimal field (which has to be a key field)

- Create a corresponding text table for ZTEST with SPRAS, and a TEXT field

- Create the dialog maintance view and enter some random data through SM30 (5 or 6 rows)

Then go to SE11, display table ZTEST and click contents to show the data you just entered.

Is there anything strange? In my case there is, actually: Not all text fields are shown, nevertheless if i try to display the data through SM30 the data is shown correctly....

I've tried this in several releases and is always the same.

Do you know why this is?

Thanks in advance.

[ThomasZloch]

It seems that you did not link your text table properly to the main table, namely by setting up a foreign key of type "text table". SE16 (or SE11 "display contents") requires this link to display language dependent texts automatically.

You need common primary key fields in both tables, plus the SPRAS field in the text table.

Thomas

[Former Member]

Thanks for the answer.

Unfortunately, this is not the case, the tables are correctly linked.

Please look at the following snapshot, the first one, corresponds to the SE11 of the original table, the second one is the SE11 of the text table, and finally the third one is the SM30 of the original table.

[Snapshot|http://img100.imageshack.us/img100/5071/testkl.jpg]

[Former Member]

I encourage you to try this in your own system, and i am pretty sure that the result will be the same.

Several records are missing when you want to display the whole table through SE11 or SE16

Thanks.

[Former Member]

Any ideas?

[Former Member]

hi,

As i think you double click on the dataelement of text feildthere is a tab feild label there. there you define the description with the range of values

0-5 short

5-15 medium

15-20 long

20 -above heading

as you define that you get your description properly

Sulabh