Skip to Content
Author's profile photo Siva rama Krishna Pabbraju

How to find a Text table, if it exists

Have you ever wondered how to find a text table of a table ?

Well one would say it is lot easier to find. Just  go to the table in SE11, Press on Goto and click on “Text Table”. It will take you to the Text table.

 

Assume that we are programming and want to know whether a table has a text table ? if it exists we would to get texts from that table. So, how to find whether a table has a text table ?

We have a table “DD08L” which has information about relationships. This table has two fields CHECKTABLE and FRKART. These two feilds provide information what we are looking for.

We need to pass the table name, for which we would like to find out whether a text table exists, to field “CHECKTABLE” and pass “TEXT” to field “FRKART”. Execute to know the results.

As we know text table exists, we can find its relevant texts now.

Assigned Tags

      12 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jelena Perfiljeva
      Jelena Perfiljeva

      I'm confused... What's wrong with just using SE11?

       

      Author's profile photo Siva rama Krishna Pabbraju
      Siva rama Krishna Pabbraju
      Blog Post Author

      I am not sure how to use SE11 while coding.

      Author's profile photo Jelena Perfiljeva
      Jelena Perfiljeva

      Um... Open another session? Same way you'd use SE16 shown in the screenshots?

      Sorry, I still don't understand your point. We have a very simple way of finding a text table in SE11 and this blog just seems to offer a more convoluted way to do the same. Why?

      Author's profile photo Siva rama Krishna Pabbraju
      Siva rama Krishna Pabbraju
      Blog Post Author

      This blog explains one of the scenario, when we have list of tables and expected to fetch it's relevant  text table on the go while coding instead of manually finding from SE11.

      Author's profile photo Jelena Perfiljeva
      Jelena Perfiljeva

      How many tables are we talking about "while coding" that you have to use a mass look-up? I might be missing something but this need just never occurred for me. Usually there is some sort of specification and all the tables/fields are identified there already. When we work frequently with the same tables, we learn this by heart usually. And I'd say it's unusual to see a program where you'd need, say, more than 3 text tables. So I'm still scratching my head...

      Could you provide a more specific example of scenario when this would be helpful?

      I feel it would be more helpful if the blog started with this kind of information already. E.g. "I had a business requirement to provide a report with such and such data. This involved many text tables. Using SE11 in this case seemed cumbersome, so I found this easier way." That would make more sense than "here is a simple way that everyone knows and here is a more complex way" without any context, I think.

      Thank you.

      Author's profile photo Siva rama Krishna Pabbraju
      Siva rama Krishna Pabbraju
      Blog Post Author

      Hi Jelena

       

      I have not mentioned my exact business case, because it is confidential.  I cannot say anything about my requirement as of now. I am sorry.

       

      Regards,

      Siva

      Author's profile photo Alok Khanna
      Alok Khanna

      In my instance, I had been given a business requirement to make changes to an existing report used for displaying Condition records in ALV format ( has additional functionality than standard VK13 Condition Info display ) .

      User I/Ps were Condition type and its Key combination.

      Corresponding to V/03 maintenance of "Text field" for the Key combination chosen, I had to show its description in the report.

      To get the Text table for the element marked as text field, I used FM
      "DDUT_TEXTTABLE_GET" ( which is essentially a simple select statement ).

      Here, knowing the tables / FM was the key .

      Author's profile photo Shai Sinai
      Shai Sinai

      Like Jelena Perfiljeva, I'm little confused about the real (confidential) use case for it.

      However, if you really wish to find text table of table programmatically, you may use FM DDUT_TEXTTABLE_GET (which does exactly the same explained in the blog).

       

      Author's profile photo Siva rama Krishna Pabbraju
      Siva rama Krishna Pabbraju
      Blog Post Author

      Hi SHai,

      Had I known about this FM, I would have not written about this information. [ Thought something new so I have shared]

      Regards,

      Siva

      Author's profile photo Enno Wulff
      Enno Wulff

      Thanks Siva!

      It's always good to know how and where information is stored in database tables.

      SE11 and function module DDUT_TEXTTABLE_GET will not help for mass selections or inverse investigations which sometimes are needed.

      Author's profile photo Dhivya Baskaran
      Dhivya Baskaran

      Thanks for sharing your knowledge. Appreciating your efforts.

      Author's profile photo Guillaume Brochet
      Guillaume Brochet

      Thanks for sharing,

      Very useful info while at HANA level.