{"id":2188,"date":"2015-06-25T10:06:00","date_gmt":"2015-06-25T10:06:00","guid":{"rendered":"https:\/\/www.dab-europe.com\/\/articles\/texts-in-sap-now-you-see-me-now-you-dont\/"},"modified":"2025-03-11T12:07:55","modified_gmt":"2025-03-11T12:07:55","slug":"texts-in-sap-now-you-see-me-now-you-dont","status":"publish","type":"articles","link":"https:\/\/www.dab-europe.com\/en\/articles\/texts-in-sap-now-you-see-me-now-you-dont\/","title":{"rendered":"Texts in SAP\u00ae \u2013 Now you see me, now you don\u2019t"},"content":{"rendered":"

Texts in SAP\u00ae \u2013 Now you see me, now you don\u2019t<\/h2>\n

In this article I will explain a fact which might sometimes be a little confusing when looking at SAP\u00ae tables using the SAP\u00ae GUI transaction SE16 compared to downloading the data using a download tool<\/a>. I will explain how SAP\u00ae displays data making it look like it was in one table, but in fact the data is separated in a table containing settings and technical information (a \u201cCustomizing Table\u201d) and a table containing the descriptions and long texts in different languages (a \u201cText table\u201d). I will explain where SAP\u00ae mixes those two, but also how you can find out about where the data really is located in the database tables.<\/p>\n

In my first example, I will display the financial document types using T-Code SE16. (For more detailed SE16 information please refer to my colleagues blogpost which can be found here<\/a>)<\/p>\n

The document types for SAP\u00ae financials are stored in table T003. If we use SE16 to display the content, we see the following result:<\/p>\n

<\/p>\n

We get a list of document types together with their descriptions. I removed a bunch of columns in between, which allows us to focus on the most important columns for this article. Now this result seems to imply that the document types together with the descriptions are stored in the very same table. <\/p>\n

However this is not the case! SAP\u00ae when using transaction SE16 automatically attaches the texts when displaying the content. When displaying the content, it in fact mixes the content of two tables, as texts are not stored in T003, they are located in a separate text table. For those of you who are downloading raw data using download tools, this means that if you will download table T003, you probably will not find any texts in it at all!<\/p>\n

The reason is, that the table T003 actually does not contain a text field. But in which text table can you find the texts, should you want to download them separately? Well, SAP\u00ae often uses a certain naming convention. The text for the financial document types in table T003 are stored in a table named T003T. The texts for the purchase order document types, which are stored in table T161, are stored in table T161T. (Material groups are in T023 and T023T, etc.) So often, just adding a simple \u201cT\u201d to the original table name allows you to find out about the text table.<\/p>\n

Usually in SAP\u00ae the standard table like T003 contains the customizing \/ technical settings, and the table ending with a T like T003T contains the texts in different languages:<\/p>\n

<\/p>\n

So adding a simple T at the end of customizing tables often allows you to find out the text table belonging to it. Sometimes however it is not that easy. Let\u2019s look at the payment terms for example, which are stored in table T052. If we try our rule-by-thumb, and we access the table T052T, we realize that it contains not the payment term descriptions, but something completely different (in this case, \u201cNegotiated Leave Names\u201d).<\/p>\n

<\/p>\n

So obviously the name-guessing (\u201cJust add a T\u201d) will not always work. However there is a T-Code in SAP\u00ae which might help you finding the related text table in a very convenient way. We talked about transaction SE16, but there also is a transaction called SE16N. It allows you to list the content as well, but it also provides transparency aboutvvvvvvvvvscthe related text tables.<\/p>\n

If we use it with T003, the result looks as follows:<\/p>\n

<\/p>\n

So we get the name of the text table. Plus, there is a little checkbox labelled \u201cNo texts\u201d. Doing this, we would only get the \u201creal\u201d T003 content listed, but not the texts. Let\u2019s try this one with our payment terms table T052:<\/p>\n

This provided us the information we were looking for \u2013 the correct texts for the payment terms are located in table T052U.<\/p>\n

I hope that this article provided some helpful information for you. We discussed how SAP\u00ae separates customizing settings from text tables in the data model, where it is mixed up in the SAP\u00ae GUI, and how to track the real table names using SAP\u00ae T-Code SE16N. <\/p>\n

For any comments on this article, feel free to write us at info@dab-gmbh.de<\/a>.<\/p>\n

To contact the author you can also use LinkedIn or XING (you may have to login first before you can access these links).<\/p>\n

LinkedIn: http:\/\/de.linkedin.com\/pub\/stefan-wenig\/54\/1b8\/b30<\/a> <\/p>\n

XING: https:\/\/www.xing.com\/profile\/Stefan_Wenig2?sc_o=mxb_p<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Texts in SAP\u00ae \u2013 Now you see me, now you don\u2019t In this article I will explain a fact which might sometimes be a little confusing when looking at SAP\u00ae tables using the SAP\u00ae GUI transaction SE16 compared to downloading the data using a download tool. I will explain how SAP\u00ae displays data making it […]<\/p>\n","protected":false},"author":2,"featured_media":4696,"template":"","articles_category":[],"articles_tag":[92],"class_list":["post-2188","articles","type-articles","status-publish","has-post-thumbnail","hentry","articles_tag-sap"],"acf":[],"yoast_head":"\nTexts in SAP \u2013 Various display options<\/title>\n<meta name=\"description\" content=\"Using texts correctly in SAP \u2713 Various display options \u2713 Important tips with examples \u2713 Optimized use of texts \u2013 Get informed here!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dab-europe.com\/en\/articles\/texts-in-sap-now-you-see-me-now-you-dont\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Texts in SAP \u2013 Various display options\" \/>\n<meta property=\"og:description\" content=\"Using texts correctly in SAP \u2713 Various display options \u2713 Important tips with examples \u2713 Optimized use of texts \u2013 Get informed here!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dab-europe.com\/en\/articles\/texts-in-sap-now-you-see-me-now-you-dont\/\" \/>\n<meta property=\"og:site_name\" content=\"dab\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-11T12:07:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dab-europe.com\/wp-content\/uploads\/wp-i\/po\/G19A0562.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"4013\" \/>\n\t<meta property=\"og:image:height\" content=\"3648\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/texts-in-sap-now-you-see-me-now-you-dont\\\/\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/texts-in-sap-now-you-see-me-now-you-dont\\\/\",\"name\":\"Texts in SAP \u2013 Various display options\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/texts-in-sap-now-you-see-me-now-you-dont\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/texts-in-sap-now-you-see-me-now-you-dont\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/wp-i\\\/po\\\/G19A0562-scaled.jpg\",\"datePublished\":\"2015-06-25T10:06:00+00:00\",\"dateModified\":\"2025-03-11T12:07:55+00:00\",\"description\":\"Using texts correctly in SAP \u2713 Various display options \u2713 Important tips with examples \u2713 Optimized use of texts \u2013 Get informed here!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/texts-in-sap-now-you-see-me-now-you-dont\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/texts-in-sap-now-you-see-me-now-you-dont\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/texts-in-sap-now-you-see-me-now-you-dont\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/wp-i\\\/po\\\/G19A0562-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/wp-i\\\/po\\\/G19A0562-scaled.jpg\",\"width\":2560,\"height\":2327},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/texts-in-sap-now-you-see-me-now-you-dont\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Articles\",\"item\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Texts in SAP\u00ae \u2013 Now you see me, now you don\u2019t\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/\",\"name\":\"dab\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#organization\",\"name\":\"dab\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/dab_logo-main-color-scaled.png\",\"contentUrl\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/dab_logo-main-color-scaled.png\",\"width\":2560,\"height\":1463,\"caption\":\"dab\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Texts in SAP \u2013 Various display options","description":"Using texts correctly in SAP \u2713 Various display options \u2713 Important tips with examples \u2713 Optimized use of texts \u2013 Get informed here!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dab-europe.com\/en\/articles\/texts-in-sap-now-you-see-me-now-you-dont\/","og_locale":"en_US","og_type":"article","og_title":"Texts in SAP \u2013 Various display options","og_description":"Using texts correctly in SAP \u2713 Various display options \u2713 Important tips with examples \u2713 Optimized use of texts \u2013 Get informed here!","og_url":"https:\/\/www.dab-europe.com\/en\/articles\/texts-in-sap-now-you-see-me-now-you-dont\/","og_site_name":"dab","article_modified_time":"2025-03-11T12:07:55+00:00","og_image":[{"width":4013,"height":3648,"url":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/wp-i\/po\/G19A0562.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.dab-europe.com\/en\/articles\/texts-in-sap-now-you-see-me-now-you-dont\/","url":"https:\/\/www.dab-europe.com\/en\/articles\/texts-in-sap-now-you-see-me-now-you-dont\/","name":"Texts in SAP \u2013 Various display options","isPartOf":{"@id":"https:\/\/www.dab-europe.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dab-europe.com\/en\/articles\/texts-in-sap-now-you-see-me-now-you-dont\/#primaryimage"},"image":{"@id":"https:\/\/www.dab-europe.com\/en\/articles\/texts-in-sap-now-you-see-me-now-you-dont\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/wp-i\/po\/G19A0562-scaled.jpg","datePublished":"2015-06-25T10:06:00+00:00","dateModified":"2025-03-11T12:07:55+00:00","description":"Using texts correctly in SAP \u2713 Various display options \u2713 Important tips with examples \u2713 Optimized use of texts \u2013 Get informed here!","breadcrumb":{"@id":"https:\/\/www.dab-europe.com\/en\/articles\/texts-in-sap-now-you-see-me-now-you-dont\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dab-europe.com\/en\/articles\/texts-in-sap-now-you-see-me-now-you-dont\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dab-europe.com\/en\/articles\/texts-in-sap-now-you-see-me-now-you-dont\/#primaryimage","url":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/wp-i\/po\/G19A0562-scaled.jpg","contentUrl":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/wp-i\/po\/G19A0562-scaled.jpg","width":2560,"height":2327},{"@type":"BreadcrumbList","@id":"https:\/\/www.dab-europe.com\/en\/articles\/texts-in-sap-now-you-see-me-now-you-dont\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dab-europe.com\/en\/"},{"@type":"ListItem","position":2,"name":"Articles","item":"https:\/\/www.dab-europe.com\/en\/articles\/"},{"@type":"ListItem","position":3,"name":"Texts in SAP\u00ae \u2013 Now you see me, now you don\u2019t"}]},{"@type":"WebSite","@id":"https:\/\/www.dab-europe.com\/en\/#website","url":"https:\/\/www.dab-europe.com\/en\/","name":"dab","description":"","publisher":{"@id":"https:\/\/www.dab-europe.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dab-europe.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dab-europe.com\/en\/#organization","name":"dab","url":"https:\/\/www.dab-europe.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dab-europe.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2025\/02\/dab_logo-main-color-scaled.png","contentUrl":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2025\/02\/dab_logo-main-color-scaled.png","width":2560,"height":1463,"caption":"dab"},"image":{"@id":"https:\/\/www.dab-europe.com\/en\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles\/2188","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles"}],"about":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/types\/articles"}],"author":[{"embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/users\/2"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/media\/4696"}],"wp:attachment":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/media?parent=2188"}],"wp:term":[{"taxonomy":"articles_category","embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles_category?post=2188"},{"taxonomy":"articles_tag","embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles_tag?post=2188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}