Upload Long Text in BDC Templates

The steps below explain how to upload long text fields using Data Workbench. This method uses the SAP Control  instead of the simple editor.

  1. Go to the Record Template Page.
  2. On the Template Information tab, enter the transaction code that you would like to record. The following steps use MM02 as an example.
  3. In the Template Type field, select BDC Template.
  4. Go to the Recording Options tab.
  5. Check Record Long Text. This enables the recording of long text SAP Controls.

    Figure 1 – Template Recording Page with Recording Options Tab Displayed
  6. Give the template a meaningful name, typically a brief description of what actions you are performing during the recording.
  7. Optionally, add a description. This may be helpful if you have notes to add about the recording or you want to distinguish this recording from other similar recordings.
  8. Click Record Template. The SAP GUI opens with the initial screen for the transaction.
  9. Fill out the header data, making sure to "touch" all of the fields to use for the upload.

    Figure 2 – Template Recording Page, Record Template
  10. Type in a Material Number and press <ENTER> as shown in Figure 3 below.

    Figure 3 – MM02 Initial Screen
  11. Select the “Basic Data 1” view and then click the green checkmark.

    Figure 4 – MM02 Select View Screen
  12. Scroll down to the bottom of the Basic Data 1 Screen.

    Figure 5 –MM02 Basic Data 1 Screen
  13. Click the “Basic Data Text” button.

    Figure 5 – MM02 Basic Data Text Screen
  14. Enter text into the Basic Data Text textbox.
  15. Click Save in the SAP GUI or end the transaction however you normally would. The SAP GUI closes and Data Workbench creates the template.

    Figure 6 – Load File with Sample Data
  16. Save and close the Excel load file.
  17. Go to the Upload Data to SAP page.
  18. Select the load file and click Upload as show in Figure 7 below.

    Figure 7 – Upload Section with Upload Button Pressed
  19. The long text has now been changed. Verify the data by using the appropriate view transaction from within the SAP GUI.

NOTE: If records fail, see Troubleshoot Error Messages.