Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Creating Text Table for a Ztable

former_member632729
Contributor
0 Likes
1,934

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.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,403

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 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.

8 REPLIES 8
Read only

Former Member
0 Likes
1,403

hi

chk this

hope this helps

regards

Aakash Banga

Read only

Former Member
0 Likes
1,403

HI,

Refer ro this link...

Read only

Former Member
0 Likes
1,404

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.

Read only

former_member632729
Contributor
0 Likes
1,403

Found my self..

Edited by: Raghunath Shyamala on Mar 4, 2009 9:53 AM

Read only

Former Member
0 Likes
1,403

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

Read only

Former Member
0 Likes
1,403

hi,

check th efollowing link

[TEXT TABLE|;

Hope this help you..

Regards

Ritesh J

Read only

Former Member
0 Likes
1,403

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.

Read only

former_member632729
Contributor
0 Likes
1,403

Find my self..