Alternative to text table?

[Former Member]

Hi All

I have created a custom table where the superannuation fund code (data element P13Q_FCODE), along with a start date and end date are primary keys.

The texts for the superannuation fund code are maintained in table T5QSD.

What I am after is as follows: when a user wants to see the contents of the table I want to also include the description (from table T5QSD).

I cannot use the text table concept as table T591A is already using table T5QSD as a text table.

Does anyone know if there is an alternative way to perform the task. Should I be looking at creating an event?

Thanks in advance.

Rajdeep Kumar

[venkat_o]

Rajdeep Kumar Text table for the field Fcode and data element P13Q_FCODE is T591S. Check how this is ? Click on below link. [http://bp2.blogger.com/_O5f8iAlgdNQ/R_rThSm1qyI/AAAAAAAAA98/P1bxw8tUWzE/s1600-h/Superannuation-785278.jpg|http://bp2.blogger.com/_O5f8iAlgdNQ/R_rThSm1qyI/AAAAAAAAA98/P1bxw8tUWzE/s1600-h/Superannuation-785278.jpg] Double click on search help H_T591A for the field FCODE and data element P13Q_FCODE . Then check the below link. [http://bp1.blogger.com/_O5f8iAlgdNQ/R_rTiCm1qzI/AAAAAAAAA-E/SVvdn3DJvtw/s1600-h/H_T591A-788788.jpg|http://bp1.blogger.com/_O5f8iAlgdNQ/R_rTiCm1qzI/AAAAAAAAA-E/SVvdn3DJvtw/s1600-h/H_T591A-788788.jpg] Here you can see Check tabel T591A and Corresponding Text table T591S for the field FCODEand data element P13Q_FCODE. I hope that it helps u. Regards, Venkat.O

[Former Member]

Hi

You are correct - I mentioned the wrong table. I will re-phrase my original message->

I have created a custom table where the superannuation fund code (data element P13Q_FCODE), along with a start date and end date are primary keys.

The texts for the superannuation fund code are maintained in table T591S.

What I am after is as follows: when a user wants to see the contents of the custom table I want to also include the description (from table T591S).

I cannot use the text table concept as table T591A is already using table T591S as a text table.

Does anyone know if there is an alternative way to perform the task. Should I be looking at creating an event?

Thanks in Advance

Rajdeep Kumar

[Former Member]

Hi Rajdeep,

First of all to use the functions offered by a text table,

(a) you need to create a 'Z' table in the ABAP Dictionary with the same key as your custom table <ZXXXXXXXXX> and

(b) an extra field with type SPRAS.

(c) Define the text fields as non-key fields in this table.

(d) Then define a foreign key from this text table to your custom table <ZXXXXXXXXX>. While defining the foreign key make sure that under Semantic attributes and under the option Foreign key field type -> Key fields of a text table is selected.

(e) Activate both the tables

After all these steps then mainatin the corresponding texts in the text table and here you go with achieving your requirement.

Hope this helps you our. Reward accordingly.

Thanks and Regards,

Maddineni Bharath.