Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata
If you want to create text table for any table, then just need to create table with the key fields of main table plus language key field (field of data type LANG) and a text field for the description.
The main purpose of a text table is that you can translate the table entries into different language.
This tutorial contains the procedure of creation of text table for an existing table.
Start transaction SE11.
On the initial screen, select the database table option and enter table name in customer name space and then click Create button.

On next screen, enter a proper short description for the table and set delivery class to A and choose the Display/Maintenance Allowed from the drop down list.
Then click on the tab Fields and enter the key fields of the table and maintain the proper data elements for the table fields:
Add field MANDT, data element as MANDT and check key and Initial Value check boxes.
Add field SPRAS, data element as SPRAS and check key and Initial Value check boxes.
Add key field  EMPID of the main table, data element as ZEMP_ID and check keyand Initial Value checkboxes.
                                              
Add field Activity, data element as ZACIVITY and check Initial Value check box.

Double click on data element ZACTIVITY(Not yet created), a pop up will open, click Yes button.

It prompts the following

Provide short description, domain and label.


Save, double click on domain name ZACTIVITY.

  A pop up will come asking to create domain, click Yes button.
  Provide short description, data type, no. Characters, save and activate.

Go back and activate data element.

Once all fields are created click on Technical Settings button in the toolbar menu.

A pop up will open, click green tick.

On the next screen, enter the data class as  APPL0 and the size as 0.

Go back to main screen.
Now a pop up will come asking to save the changes
.

Click Yes button and  activate.

Now you need to create the foreign key relationships for the fields MANDT, SPRAS and  EMP_ID.

Select the MANDT field and click on the Foreign Key button.

A pop up will come asking if you want to create a proposal with T000 as the check table, click Yes button.

Accept the proposal by pressing the Copy button.

Repeat the above process for the SPRAS and EMPID field.

Select the SPRAS field and click on the Foreign Key button.

A pop up will come asking if you want to create a proposal with T002 as the check table, click Yes button.

Accept the proposal by pressing the Copy button.

Select the EMPID field and click on the Foreign Key button.

A new pop screen appears in that give the name of main table and select radio button key fields of text table and adding a cardinality of 1:N.

Click on Generate proposal button.

Click Copy button.

                                             


                                              


 

 


 
 
 
  • No labels