Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Issue creating a Database table with a decimal key field

Former Member
0 Kudos
203

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.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
48

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

5 REPLIES 5

ThomasZloch
Active Contributor
0 Kudos
48

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

0 Kudos
48

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]

0 Kudos
48

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.

0 Kudos
48

Any ideas?

Former Member
0 Kudos
49

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