Table Maintainence generator

[Former Member]

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.

[Former Member]

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.

[FredericGirod]

Hi Aima,

what do you mean with "view these changes" ?

Rgd

Frédéric

[Former Member]

Hi Frédéric Girod ,

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

[FredericGirod]

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.

[Former Member]

hi

you have to delete and generate another time the table maintaincence

bye

enzo

[Former Member]

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?

[FredericGirod]

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

[abdul_hakim]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[abdul_hakim]

Hi

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

Regards,

Abdul

[Former Member]

Please close the thread if answered.

[Former Member]

Hi Srinivas,

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