What is Text Table

A text table a special table that contains text in multilingual format, text table also contain the language field ( SPRAS ) as a key field. A table is said to be the text table of another table if it contains all the key fields along with the additional language key field.

For example, Table T2 is a text table of table T1 if table T2 contains the same key fields that are contained by table T1 and an additional language key field. Text table T2 can also contain explanatory text in several languages for each key fields of table T1.

how-to-create-text-table

This article teach you how to create SAP text table and assign to main table, text table have purposed to translated any description into several languages.

  1. You need to create main table via SE11 transaction.

creating-text-table-assign-main-table-sap-abap

Go to Delivery and maintenance and there are two settings are important to allow the data to be maintained in this table, the customizing delivery class setting will classify this data as customizing and set maintenance allowed on the part of Data browser/Table view maintenance. and activate it.

creating-text-table-assign-main-table-sap-abap-2

  1. Create Text table via SE11 transaction.

Create text table via SE11 transaction code, you need including 3 Main key, first is MANDT, and the rest of the keys are language key ( SPRAS ) and then the key from main table for this example is MAJOR. Don’t forget with description field such as MAJOR_DESC .

creating-text-table-assign-main-table-sap-abap-3

  1. Create relationship between main table and text table

You need to create the relationship between his main table and this text table by creating a foreign key relationship for MAJOR field of ZCS2_MAJOR_T. Press button with key icon on the left side Srch Help button to create foreign key relationship.

Position your cursor on MANDT field and click button foreign key relationship, the popup dialog confirmation appeared, and just press Yes, and the new screen will displayed.

creating-text-table-assign-main-table-sap-abap-4

Just press check button, then continue to SPRAS field and the last is MAJOR field to create relationship to main table.

creating-text-table-assign-main-table-sap-abap-5

You can see, SAP System automatically get all table which have this field as key. Entered the value of Cardinality 1:N and then press check button and activate your text table to finish it and the next step you need to create Maintenance View so you can input your data.

creating-text-table-assign-main-table-sap-abap-6

creating-text-table-assign-main-table-sap-abap-7

And the last step you need to create Table Maintenance Generator via Menu Utilities -> Table Maitenance Generator so you can input your data to this table.

Incoming search terms:

Comments

  1. Pingback: get more info

  2. Pingback: clocks for businesses

  3. Pingback: certified parent coach

  4. Pingback: facebook marketing company

  5. Pingback: how to use social media for small business marketing

  6. Pingback: synchronized clocks for stadiums

  7. Pingback: metal clock dials

  8. Pingback: successful social media campaigns

  9. Pingback: clock movement

  10. Pingback: parenting styles

  11. Pingback: Facility wireless clocks

  12. Pingback: time movement hands

  13. Pingback: life coaches for teens

  14. Pingback: outdoor clocks for hospitals

  15. Pingback: wireless time systems

  16. Pingback: parenting classes for new parents

  17. Pingback: clock kits

  18. Pingback: clocks for businesses

  19. Pingback: fire pit ignition systems

  20. Pingback: how to build a propane fire pit in your backyard

  21. Pingback: read more

  22. Pingback: natural gas fire pit kit

  23. Pingback: Montanafirepits

  24. Pingback: accessories for clocks

  25. Pingback: wireless clocks sync

  26. Pingback: parenting coaching

  27. Pingback: clock repair videos

  28. Pingback: clock dials

  29. Pingback: parent coaching models

  30. Pingback: wirelessly synchronize clocks

  31. Pingback: wireless time clocks

  32. Pingback: parenting coach

  33. Pingback: Facility wireless clocks

  34. Pingback: Warming trends fire pit

  35. Pingback: how to replace clock dials

  36. Pingback: diy fire pit burner pan

  37. Pingback: parent coaching models

  38. Pingback: metal hands

  39. Pingback: read more

  40. Pingback: Confident Parent

  41. Pingback: DIY clock dials repair

  42. Pingback: build your own fire pit

  43. Pingback: wireless time clocks

  44. Pingback: parenting coaching

  45. Pingback: USA Made clock movements

  46. Pingback: gas fire pits outdoor

  47. Pingback: how to build a backyard fire pit

  48. Pingback: clock accessories

  49. Pingback: parenting coach

  50. Pingback: warming trends crossfire burner reviews

  51. Pingback: life coaches for teens

  52. Pingback: Clock kits and dials

  53. Pingback: mechanism for clocks

  54. Pingback: sync warehouse clocks

  55. Pingback: Confident Parent Coach

  56. Pingback: online parenting programs

  57. Pingback: outdoor clocks for business

  58. Pingback: fire pit burner pan

  59. Pingback: Clock repair parts

  60. Pingback: threshold jackson outdoor fire bowl

  61. Pingback: burner for fire pit

  62. Pingback: replacement parts for clocks

  63. Pingback: parenting coach

  64. Pingback: Click Here

  65. Pingback: clocks for facilities

  66. Pingback: parent coach professionals

  67. Pingback: USA Made clock movements

  68. Pingback: wireless time systems

  69. Pingback: clocks for businesses

  70. Pingback: parenting coaching

  71. Pingback: online parenting resource

  72. Pingback: synchronized wireless clocks for sale

  73. Pingback: clock inserts suppliers

  74. Pingback: how to build your own clock

  75. Pingback: patio fire pit

  76. Pingback: clock building videos

  77. Pingback: life coach for teens

  78. Pingback: patio fire pit

  79. Pingback: online parenting classes

  80. Pingback: elapsed time clock for operating rooms

  81. Pingback: clock kits

  82. Pingback: synchronized Hospital clocks

  83. Pingback: parts of a clock

  84. Pingback: how to build a backyard fire pit

  85. Pingback: parts for clocks

  86. Pingback: parenting books

Leave a Reply

Your email address will not be published. Required fields are marked *