Example: Material Sales Texts

You want to migrate material sales texts from a legacy system to the SAP system.

Structures and Fields in the SAP System for the Migration Object Class 00

LTXTH: Long text header
STYPE	Record type (technical field)
OBJECT	Application object
NAME	Text name
ID	Text ID
SPRAS	Language

LTXTL: Long text line
STYPE	Record type (technical field)
TEXTFORMAT	Format field (2 characters)
TEXTLINE	Application object

Source structures and fields

Since the SAP system expects a two-level hierarchy, there have to be two hierarchy levels in the project as well.

MVTX1: Material sales text header

Material number C (018)

Language C (002)

MVTX2: Material sales text line

Text line C (050)

Structure relationships between the legacy system and the SAP system

LTXTH <<<< MVTX1

LTXTL <<<< MVTX2

Field relationships and field assignments

Field relationships and field assignments are created in the same way as done with the remaining migration objects as well. However, note that the material number (length 18), sales organization (length 04), and distribution channel (length 02) are included in the SAP field NAME. This means, the field relationship and field assignments for the NAME field might look like this:

Syntax Syntax

NAME      
Textname
          Quellfeld(er):  MVTX1-MATERIALNUMMER ()
          Verarbeitung:
Regel
          Coding:         *
          Zielfeld:       LTXTH-NAME
Textname.

          LTXTH-NAME = MVTX1-MATERIALNUMMER.
          LTXTH-NAME+18 = '0001'.
				   LTXTH-NAME+22 = '01'.

End of the code.

Caution Caution

When you use a rule other than MOVE (for example, translation) to convert the key for migration of the application object, you also have to use this conversion for generation of the NAME field. The text is handled as continuous text if you do not specify a value for the Text Format field.

End of the caution.

Note Note

If you want the lines to be wrapped, branch to the editor and enter the following code: If you want the line breaks to take place, then branch to the editor and enter the follow code:

LTXTL-Textformat = '*'. (<Quotation Mark><Asterisk><Quaotation Mark><Point>).

End of the note.

Example for input data in a Microsoft Excel Table

MATERIAL NUMBER	LANGUAGE	TEXT LINE
material_01234	EN	My material - first line
material_01234	EN	My material - second line
material_01234	EN	My material - third line
material_02345	EN	My material 2 - first line
material_02345	EN	My material 2 - second line
material_02345	EN	My material 2 - third line