topic Re: Issue creating a Database table with a decimal key field in Application Development and Automation Discussions

Issue creating a Database table with a decimal key field

Former Member — Wed, 03 Nov 2010 12:14:43 GMT

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.

Re: Issue creating a Database table with a decimal key field

ThomasZloch — Wed, 03 Nov 2010 14:06:00 GMT

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

Re: Issue creating a Database table with a decimal key field

Former Member — Wed, 03 Nov 2010 15:42:13 GMT

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]

Re: Issue creating a Database table with a decimal key field

Former Member — Wed, 03 Nov 2010 15:45:13 GMT

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.

Re: Issue creating a Database table with a decimal key field

Former Member — Tue, 09 Nov 2010 15:38:52 GMT

Any ideas?

Re: Issue creating a Database table with a decimal key field

Former Member — Wed, 10 Nov 2010 04:21:18 GMT

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