Create an SAP text table

Source: Internet
Author: User

Http://www.cnblogs.com/qiangsheng/archive/2008/11/12/1332104.html

 

How to create a text table

A text table is a special processing mode designed by SAP to adapt to multi-language support. It is associated with the primary table through a foreign key relationship, and has one more language indicator field than the primary table as the primary key, its text field can be used to describe the same primary key in multiple languages in the master table.

The following is a simple example to illustrate how to create a text table. For the most common company code table t001, SAP does not set the corresponding text table. Instead, according to the rules of the text table, a table that can accommodate multiple types of text is designed with t001t, however, if we do not want to use this table and want to use a text table to specify the company name in multiple languages for company code, we can design a text table by ourselves.

Step 1: Use the transaction code SE11 to create a table named zt001t. The specified fields are as follows:
Mandt clnt 3 0 Client
Spras Lang 1 0 language code
Bukrs char 4 0 company code
Name1 name1 char 30 0 name

Step 2: Go to the entry help/check tab and specify the Foreign keys of spras and bukrs, as shown below:
Spras Lang t002 use the checklist to implement input help h_t002 spras
Bukrs char t001 use checklist to implement input help c_t001 bukrs
Note that when specifying the foreign key of the bukrs, You need to select the following options (Note: select the single option in the red box ):

Next, set the technical attribute of the zt001t table and activate it.

Later, use SE11 to open t001, and click "go to-text table" in the menu to jump to the zt001t text table.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.