Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Re: Base table for customer texts.

Former Member
0 Likes
2,405

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.

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.

12 REPLIES 12
Read only

Former Member
0 Likes
2,338

Hi Venkat,

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

Take care,

Read only

nabheetscn
SAP Champion
SAP Champion
0 Likes
2,338

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

Read only

0 Likes
2,338

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

Neal

Read only

0 Likes
2,338

Yes Neal you are right

Read only

0 Likes
2,338

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.

Read only

0 Likes
2,338

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

Read only

0 Likes
2,338

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

Read only

0 Likes
2,338

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

Read only

0 Likes
2,338

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.

Read only

0 Likes
2,338

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

Read only

0 Likes
2,338

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

Read only

0 Likes
2,338

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