It looks like you recorded the long text. That's something you don't need to do for the Function Module long text that Tammy described above.
Please try disabling line 5 with the long text, which is set to fixed and blank, which explains why it's blanking it out.
To use the the Function Module, which added rows 6-8, namely row 7 with the Long Text - Long text on PM notification, all you have to record is opening the object - in this case the PM notification in IW22.
*Precisely Software Inc.
Original Message:
Sent: 09-15-2025 21:53
From: Jesse Dytioco
Subject: Tip of the Week - Using Transaction to DOWNLOAD long text
Thank you, Tammy for this tip and detailed steps. I was trying to do it for notifications (IW22), but unable to download. Instead, when I execute, the long text is overwritten with blank, even if the mapping of the field is set to Download. I attach the script, not sure what is wrong.
------------------------------
Jesse Dytioco
Original Message:
Sent: 07-22-2025 10:09
From: Tammy Lake
Subject: Tip of the Week - Using Transaction to DOWNLOAD long text
Managing SAP long text associated with both master and transactional data can sometimes be tough. Fortunately, Studio offers a solution to make this easier.
In today's tip, let's talk about material master long text. I'll show you how to create a Transaction script to download existing material text to Excel.
First, start by creating an Excel template that will allow users to review/update material master long text. In this use case, we will give the users the ability to interact with the Basic Data Text, Purchase Order Text, Internal Note, and Inspection Text fields - Example Excel file is attached.
Create a Transaction script to download existing material text to Excel. Steps:
- File, New
- Transaction
- Create from SAP Recording
- Log in to a non-production SAP system
- Enter MM02 in the Transaction Code field
- Click Start Recording
- Note: You can select an existing data file if you have one you want to use.
We will be adding long text from within Studio, so it is not necessary to go to the long text screens in the MM02 transaction. The only steps to be completed during the recording are enter a material number, deselect default views, and exit SAP.
Steps:
- Enter a material number
- Click Continue
- Click Deselect All to remove default view selections
- Click the check box next to Basic Data 1
- Click the green check to open MM02
- It is not necessary to enter any data in the screen, simply click Save to stop the recording.
- Studio returns the steps to the Map screen.
- In the Map screen, click Add Long Text
- Click the checkbox next to each long text type you would like to add to your workbook and then click OK
- For each long text type, there will be three rows added to your script:
- Material Number
- Long Text
- Language
- Mapping Long Text
- Material number, you only need to have the material number listed in one column.
- Map to the material number column for each long text type
- Long Text - The mapping direction for the long text will need to be download
- Language - You can have language in your Excel file or you can use a fixed value for each long text type. For example, "E".
- Now you are ready to download the long text data to your Excel file.
- Note, when using Transaction to download material long text (or other material-related data), you must provide the material number to return data for that material. Example below:
- Go to the Run tab and click Test to see the data.
- Deploy as normal.
- Sample Transaction script and Excel template are attached.
- Stay tuned for more future long text tips on how to write If Statements to update specific data.
NOTE: For a list of transactions that support the long text feature, go here: Welcome to the Precisely Help Center
------------------------------
Tammy Lake
Principal Sales Engineer
*Precisely Software Inc.
------------------------------