Base table for customer texts.

[Former Member]

I want the table name that stores customer texts for sales area data. I have structure info RTEXT  and FM read_text for getting text information, But I need the base table where the texts are stored for a customer.

[Former Member]

The point here being that it is impractical to read the data any other way than read_text.

Neal

[Former Member]

Hi Venkat,

You can check tables STXH and STXL, but you'll have to decompress text.

Take care,

[nabheetscn]

Hi Venkat

What do you intend to do with the base tables..?In the standard tcode whereever you are seeing this text you can get technical text details(search SCN for how to ) then use READ_TEXT for the same.

Nabheet

[Former Member]

The point here being that it is impractical to read the data any other way than read_text.

Neal

[nabheetscn]

Yes Neal you are right

[Former Member]

Actually, I have four selection screen fields in my selection screen, 1. customer number as ranges 2. sales org as ranges obligatory 3. dist. channel default '01' 4. division default '01'.

With this input in the selection screen, I have to develop a list display containing customer master details along with 19 customer texts for sales area data(XD03 transaction).

So for each lang 19 texts, similarly we have totally 43 lang.

When Suppose there are 10000+ customers for the selection screen input, Then the FM read_text is being called 10000*43*19 times to get the texts information, this is causing performance issue.

So I thought of looking into tables if this could reduce the performance, or it would be great if there is any simple way to check at the beginning itself whether texts are maintained for some lang or not based on the available input.

[Former Member]

First of all, look at table STXH.  If there isn't a record with the key that you are looking for, then the text does not exist.  So by limiting how many times you call read_text, then you will cut your cost.

As for speeding up Read_text with direct access.  If you could bring in a consultant with 15 years or more of platinum level ABAP and lock him to this sole subject for in excess of 200 hours (you do the math, that's a huge bill).  Then you'd have a chance of making that happen.

I won't say that you shouldn't try.  Every new ABAPer brings something new to the table.  I'm just saying don't put your job at risk over it.  I'd expect it to be excessively difficult.

Neal

[nabheetscn]

Apart fron Neal suggestion check if parallel processing can help you. Do a search on parallel processing ABAP to understand how it can be done

[Former Member]

See that's why you get the big bucks, Nabheet.  I should have mentioned that.

[Former Member]

When I tried parallel processing for the first time, quality system went down for 4 hours, and everybody came to know my name for wrong reasons

I hadn't ensured that some work processes are left out for others.

[Former Member]

If the bill needs to be increased by an order of magnitude, go for HANA. Its fast.

[ThomasZloch]

Next time you should supply such crucial information in your first post.

Maybe you can glean some ideas from here, I think we had solved OPs problem back then:

Plus, it's free (unfortunately ).

Thomas

[nabheetscn]

Hi Manish

Yes the parallel processing comes with its own pros and cons..So work processes..server group etc needs to be taken care of...

Things like these happen....

Yes HANA is the answer

Nabheet