Database table name linking SAP Table and Text Tables

[Former Member]

Hi,

Does anybody know the Database table name which links SAP Table and Text Table. Right now in SAP System the Text table for MARA is pointing to a different table instead of MAKT.

To see in your systems just go to SE11 and give MARA --> Click on Display --> Go To Menu --> Text Table now the system takes you to MAKT table but in my case it points to a different table ZZZZZZ which I would like to change to MAKT.

Can anybody tell me how to fix this issue.

Thanks,

Joseph.

Edited by: YJR on Jun 9, 2009 10:58 PM

[Former Member]

Hi,

Does anybody know the Database table name which links SAP Table and Text Table. Right now in SAP System the Text table for MARA is pointing to a different table instead of MAKT.

To see in your systems just go to SE11 and give MARA --> Click on Display --> Go To Menu --> Text Table now the system takes you to MAKT table but in my case it points to a different table ZZZZZZ which I would like to change to MAKT.

Can anybody tell me how to fix this issue.

Thanks,

Joseph.

Edited by: YJR on Jun 9, 2009 10:58 PM

[Former Member]

Hi,

do the following

go to se11 and enter the ztable....

and choose the primary key matnr and assign foreign key to mara table and

foreign key relation ship should Key Fields of text table...

and activate..

Regards,

Prabhudas

[Former Member]

Hi,

Here is the answer. I fixed it myself. We have a Function Module DDUT_TEXTTABLE_GET, which given the results from database table DD08L so what I did it I went to ZZZZZZ table and deleted the foreign key relationship. To get a description of the Problem and the solution refer to OSS Note: 1046978

Thanks,

Joseph.

Edited by: YJR on Jun 10, 2009 12:24 AM