In order to get all Notification Text (QMEL, IFLOAT, … ), the standard way to do is to call the READ_TEXT which works fine.

But when we have to retrieve texts simultaneously of thousands of Notifications, the READ_TEXT in loop will be not for performance as it performs connection to database then FETCH data.

SAP Text Tables:
STXH – STXD SAPscript text file header
STXL – STXD SAPscript text file lines

Thanks to this algorithm divises the runtime by at least twice.

PS: It can be very usefull to retrieve texts for other master data.
Material Description (MAKTX) can be a good sample for this.

Up to you to update this code snippets with you requirement.