2009 Mar 04 8:47 AM
Hi,
I have to create a text table for a ztable.. for suppose I have a table called ZABC and I need to create the text table for this with the name of ZABCT..
Example : TSTC is the table and the text table for this is TSTCT.
2009 Mar 04 8:52 AM
Hi Raghunath,
You can establish a foreign key relationship with the required ffield.
Make sure the field you want to establish this relation is of type SPRAS.
Hope it helps!
Much Regards,
Amuktha.
Hi,
I have to create a text table for a ztable.. for suppose I have a table called ZABC and I need to create the text table for this with the name of ZABCT..
Example : TSTC is the table and the text table for this is TSTCT.
2009 Mar 04 8:50 AM
2009 Mar 04 8:50 AM
2009 Mar 04 8:52 AM
Hi Raghunath,
You can establish a foreign key relationship with the required ffield.
Make sure the field you want to establish this relation is of type SPRAS.
Hope it helps!
Much Regards,
Amuktha.
2009 Mar 04 8:53 AM
Found my self..
Edited by: Raghunath Shyamala on Mar 4, 2009 9:53 AM
2009 Mar 04 8:53 AM
Hi,
To know language depended we create a text table for transparent table
in text table. we link the field via foreign key to our first table.so Foreign key is created for field in text table to field in ztable. :
In SE11 select Goto->Text table.
Regards,
jaya
2009 Mar 04 8:54 AM
2009 Mar 04 8:59 AM
Hi Raghu,
To create a text table for a table ZABC,
1. you have to create a ZABCT table with the field = all the primary fields of table ZABC + SPRSL type SPRAS + Text field.
2. Every other field except the text field should be primary key fields.
3. Maintain a foreign key relationship between ZABC and ZABCT over the field required field (in TSTCT the required field is TCODE).
4. Activate the table.
5. Now you should be able to traverse to the text table ZABCT from ZABC (menu path: Goto->Text Table)
Regards,
Hari.
2009 Mar 04 9:00 AM
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |