04-24-2007 5:18 AM
Hello all,
I have created Ztable and texttable for ztable how to connect these two tables.
i.e when i go to ztable press goto button and press text table then my texttable for ztable should come how to do this
Eg : for mara table in se11 when we press goto and then press textable then makt table will come
04-24-2007 5:24 AM
Hi
To create a text table just goto SEll and create table with the same key fields and an additional Key Field SPRAS ( This should be the first key field ). Add a non key field "description" to this table .
Now to enable the linkage of two in te text table create a foreign key relationship to original table with the first key field ( after SPRAS ) and in the cardinality
make it as key field of a text table.
Cheers.
04-24-2007 5:25 AM
Hi Srinivas,
Go through the following link, it is very clear :
http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ea9e446011d189700000e8322d00/frameset.htm
Structure of the TEXT Table:
1.All primary keys of check table.
2.SPRAS field ( Language key ),
3.Description
Create Foreign key relationship between TEXT table and Check table(Ztable) with fields " primary key fields of check table".
<b>
Reward all helpful answers</b>
Regards,
V.Raghavender.
04-24-2007 5:29 AM
Hi Kota,
Table A is a text table of table B if the key of A comprises the key of B and an additional language key field (field of data type LANG). Table A may therefore contain explanatory text in several languages for each key entry of B.
To link the key entries with the text, text table A must be linked with table B using a foreign key. Key fields of a text table must be selected here for the type of foreign key fields.
If table B is the check table of a field, the existing key entries of table B are displayed as possible input values when the input help (F4) is pressed. The explanatory text (contents of the first character-like non-key-field of text table A) is also displayed in the user's logon language for each key value in table B.
Only one text table can be created for table B! The system checks this when you attempt to activate a table with text foreign keys for B.
Thanks.
Reward If Helpful.