topic Re: Table Maintainence generator in Application Development and Automation Discussions

Table Maintainence generator

Former Member — Fri, 25 Nov 2005 14:01:26 GMT

Hi All,

i had made changes in the length of field in ztable

and how can i view these changes in the screen created via Table Maitainence Genarator.

Regards.

Re: Table Maintainence generator

Former Member — Fri, 25 Nov 2005 14:03:39 GMT

You will have to recreate this table maintenance. So goto SE!1, give the table name and go in change mode. Goto Utilities --> Table Maintenance Generator, Delete present table maintenance and create a new one.

Re: Table Maintainence generator

FredericGirod — Fri, 25 Nov 2005 14:03:50 GMT

Hi Aima,

what do you mean with "view these changes" ?

Rgd

Frédéric

Re: Table Maintainence generator

Former Member — Fri, 25 Nov 2005 14:07:06 GMT

you have to delete and generate another time the table maintaincence

bye

enzo

Re: Table Maintainence generator

Former Member — Fri, 25 Nov 2005 14:11:02 GMT

Hi Frédéric Girod ,

As i am not able to see the changed field lenght for that table field in sm30.

Re: Table Maintainence generator

FredericGirod — Fri, 25 Nov 2005 14:13:47 GMT

As Ashish explains, you have to go to the SE11 table -> Change -> menu utilities -> table generator.

And you have to suppress and re-create the table screen.

you can select all the checkbox, that will create the whole screen, and program.

Re: Table Maintainence generator

abdul_hakim — Fri, 25 Nov 2005 14:14:13 GMT

Do you want to create a table maintenance generator for your table?

Regards,

Abdul

Re: Table Maintainence generator

Former Member — Fri, 25 Nov 2005 14:16:46 GMT

Hi ,

I have a field of 30 char and if i am entering the currency icon as € it is accepting as # and an status message is displayed as

<b>The input field contains prohibited characters. These are generally characters that your frontend can process, but which are not permitted in the R/3 database</b>

Could i not enter the Currency Icon ? Is it not treated as a normal charecter?

Re: Table Maintainence generator

FredericGirod — Fri, 25 Nov 2005 14:18:53 GMT

Maybe you need to be unicode to accept the euro format.

And in SAP the currency are saved in ISO format : 2 digits for the country 1 digit for the devise.

look the table TCURR / TCURT

Re: Table Maintainence generator

abdul_hakim — Fri, 25 Nov 2005 14:44:06 GMT

Hi Aima,

You cannot do like this in R/3

SAP has its own standard for currencies.

For example in the external system you may represent the american dollar as $ but when u want to enter this into SAP R/3 it should be converted into USD.

SAP wont supports these kinds of special characters in the currency field...

Regards,

Abdul

Re: Table Maintainence generator

Former Member — Fri, 25 Nov 2005 15:12:59 GMT

Hi Aima In your Instead of € you enter the hexadecimal Unicode value of the €. In that way you can store the values like that.

if you check icon table you can get some idea.

regards

vijay

Re: Table Maintainence generator

Former Member — Fri, 25 Nov 2005 15:30:58 GMT

Hi vijay,

my field is simple Charecter field ,Could i store in hexadecimal unicode value?

<b>Could any one give me a brief understanding abt unicode?</b>

it would be very kind of all .

Regards.

Re: Table Maintainence generator

Former Member — Fri, 25 Nov 2005 15:40:38 GMT

Check the ICON table , in that id is in hexaformat

but the output is icon(image).

check that.

tables: icon.

data: v_id type icon-id.
v_id = '@01@'.

write: v_id.

may be like that you can store.

regards

vijay

Re: Table Maintainence generator

Former Member — Fri, 25 Nov 2005 15:56:22 GMT

As you might have understood by now, you should not try to store the symbol of EURO in the table. Simply add another column for the currency key, store EUR in it and when it comes to display, if it is EUR, show the symbol.

It is just going to be too much to try and store the symbol as part of the value, in the table.

Regards,

Srinivas

Re: Table Maintainence generator

Former Member — Fri, 25 Nov 2005 16:43:11 GMT

Please close the thread if answered.

Re: Table Maintainence generator

Former Member — Fri, 25 Nov 2005 16:46:45 GMT

Hi Srinivas,

i am still working on it ......