Table T100 as text table

[RicardoRomero_1]

Hi all,

Do you know if we can use the table t100 as text table in a custom table?

We can't use it directly because we can't create a foreing key in a standard table, so I don't know if I can add an extra field to my custom table only for display a text, but without storing any value in the database. I don't know if wa can create the field in some event in the maintenance view.

Our custom table has the following fields;

		Key
MANDT	MANDT	X	CLNT	3	0	Client
ARBGB	ARBGB	X	CHAR	20	0	Application Area
MSGNR	MSGNR	X	CHAR	3	0	Message number
MSGTY	BAPI_MTYPE		CHAR	1	0	Message type: S Success, E Error, W Warning, I Info, A Abort

It's a customizing table. We want to display the corresponding text of the message when the user is viewing the data stored in it.

Thanks in advance.
Regards.

[RicardoRomero_1]

Hi all,

Do you know if we can use the table t100 as text table in a custom table?

We can't use it directly because we can't create a foreing key in a standard table, so I don't know if I can add an extra field to my custom table only for display a text, but without storing any value in the database. I don't know if wa can create the field in some event in the maintenance view.

Our custom table has the following fields;

		Key
MANDT	MANDT	X	CLNT	3	0	Client
ARBGB	ARBGB	X	CHAR	20	0	Application Area
MSGNR	MSGNR	X	CHAR	3	0	Message number
MSGTY	BAPI_MTYPE		CHAR	1	0	Message type: S Success, E Error, W Warning, I Info, A Abort

It's a customizing table. We want to display the corresponding text of the message when the user is viewing the data stored in it.

Thanks in advance.
Regards.

[Former Member]

Hi

No but you can create a maintenance view based on your z-table where you can insert the text from t100 in order to show the text in maitenance view for SM30:

I mean you can generate TMG for maintenance view, insted of  Z-table

Max

[RicardoRomero_1]

Hi, thanks for answer.

Sorry, I didn't understand the last sentence.  What does TMG stand for?

Do you mean modify the function group created for maintenance view? In this case I don't like it because you can lose the code if the view is regenerated. In this case I would create a custom program for maintain the table, but before do that I would like to know if there are other posiblities.

Thanks.

[Former Member]

Hi

I mean you should generate a maintenance view based on your Z-table and T100, in this case you can generate the maintenace view for SM30 for the view and not for Z-table.

You don't need any additional code

Max

[RaymondGiuseppi]

Look at table T100C and maintenance view V_T100C, now do the same (did you find the event AA in the maintenance dialog and did you look at dynpro definition)

Or define a foreign key relation with T100, but as it won't generate a text table relation, create a maintenance view with your table and T100 define field T100-TEXT as readonly and generate maintenance dialog on the view.

Regards,

Raymond

[RicardoRomero_1]

Hi, In the end I've created a maintenance view for my table and added T100 in the relationships. Now in SM30 I can see the texts from T100.
But, I don't know how to define the T100-TEXT as readonly. Do I need to do it by events? In which event?

I also have another problem the TEXT is displayed always in the original language. So if I enter in the system in english or spanish or other language the text is always displayed in the original language: i.e english. Do you know how can I pass the value to the field T100-SPRSL to get the text in the correct language.

Thanks in advance.

[Former Member]

But, I don't know how to define the T100-TEXT as readonly. Do I need to do it by events? In which event?

No it's characteristic of field of maintenance view:

After the colunm FIELD, you should see a colunm called P: here set R

[RicardoRomero_1]

OK, thanks I didn't see that column...  sorry, I'm a bit slow today...

For the problem of the language I've tried to use the tab "Selection conditions" adding the following line:

T100

SPRSL

EQ

SYST-LANGU

But doesn't work...

[Former Member]

For the problem of the language I've tried to use the tab "Selection conditions" adding the following line:
T100 SPRSL EQ SYST-LANGU

But doesn't work...

Yes I've tried to do it

I believe it needs to use an event

Max

[RaymondGiuseppi]

Yes use event AA as for V_T100C so you will choose the language yourself.

Regards,

Raymond

[Former Member]

and event AO in order to upload/change the text for the new hit

Max