topic Re: Text Table in Application Development and Automation Discussions

Text Table

Former Member — Wed, 05 Mar 2008 09:03:21 GMT

Hi All,

I have created a custom table where am having four fields (1. sales org-vkorg, 2.text for sales org 3. analysis field its basically Y/N 4. material description which is also Y/N one char field and sales org is primary key in my table) for this table i have created a TEXT TABLE where i have included LANGU field with Sales org and Text for sales org field and created a foreign key relationship with my main table to this text table for the field Sales org and activated it. but am not able to see this TEXT TABLE from my main customj table by going to MENU->GOTO->Text Table.

Please can any one let me know the issue why is this happening?

Thanks & Regards,

Rasheed.

Re: Text Table

Former Member — Wed, 05 Mar 2008 09:15:02 GMT

Hi Rasheed,

Ensure the following:

Go to your text table, select the "Sales Org." field in the text table and click on Foreign Keys button.

You should be then able to see the check table of your.

In Semantic Attributes section (bottom of pop up) select the fourth radiobutton "Key fields of a text table" and maintain Cardinality as 1:N.

This should do it.

Cheers.

Re: Text Table

Former Member — Wed, 05 Mar 2008 09:21:54 GMT

Hi Aditya,

In Semantic Attributes section i forgot to check radiobutton "Key fields of a text table" . now its working fine

Thanks a lot...........