Dynamic Field in Table TCJ1

[Former Member]

Hello Experts,

I have doubt how the description get automatically populated in Table TCJ1.

When I see the fields in TCJ1, I see only 2 fields present. But when I see the table value another field Description gets automatically populated. It fetches the description from TCJ1T and populate the table TCJ1.

How actually this happens? How does TCJ1 table know, its description is present in TCJ1T? Is it specified in Table?

Well reason I am asking is I have simillar requirement in report KKRC.

I have added some fields in table PSMERK (For summarization characteristic tab tcode CJ20n). Now customs fields are added in KKRO ( Customization for KKRC report) .

Currently when KKRC gets executed , description of the custom fields is not getting populated. I dont know how will KKRC know description of the custom fields needs to be fetched from another table.

Thanks,

[Former Member]

Hello Experts,

I have doubt how the description get automatically populated in Table TCJ1.

When I see the fields in TCJ1, I see only 2 fields present. But when I see the table value another field Description gets automatically populated. It fetches the description from TCJ1T and populate the table TCJ1.

How actually this happens? How does TCJ1 table know, its description is present in TCJ1T? Is it specified in Table?

Well reason I am asking is I have simillar requirement in report KKRC.

I have added some fields in table PSMERK (For summarization characteristic tab tcode CJ20n). Now customs fields are added in KKRO ( Customization for KKRC report) .

Currently when KKRC gets executed , description of the custom fields is not getting populated. I dont know how will KKRC know description of the custom fields needs to be fetched from another table.

Thanks,

[Former Member]

Hi Sankar ,

In tables there is a concept called Text Tables , which usually is used to store description.

Now you might think my we need a text table , the reason is the text can be stored in a number of diffrent languages, so a text table will have value for which description is to be stored , language and the description.

Now how u see the text table

SE11--> Enter the table name TCJ1 --> GoTo(In the dropdown there is some thing called text Tables , click on it you go to a table called TCJ1T )

Another very comman example is for MARA , see what is the text table for MARA.

Regards

Arun

• Reward with point if found helpful

[Former Member]

That was really helpful reply..

Could you please tell how to create text table and attach to the custom table?

Thanks,

[Former Member]

Hi Sankar,

The basic steps would be as follows

1. Create a table ( say with fields client (mandt) , material(matnr) , status (char1)

2. Create another table (which will serve as text table ) , with fields client , material , language and descriptions

3.Now for the text table , create a foreign key relationship(10'th button , above fields ,the key symbol) , in the popup window put the check table as the table you created and in foreign key field type select the key field for text table. and save it.

Try this ans incase you have any problem . pleae revert back to me.

Regards

Arun

• Please reward if ans is helpful