topic Re: Base table for customer texts. in Application Development and Automation Discussions

Re: Base table for customer texts.

Former Member — Wed, 05 Feb 2014 14:33:54 GMT

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.

Re: Re: Base table for customer texts.

Former Member — Wed, 05 Feb 2014 14:47:38 GMT

Hi Venkat,

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

Take care,

Re: Re: Base table for customer texts.

nabheetscn — Wed, 05 Feb 2014 15:38:59 GMT

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

Re: Re: Base table for customer texts.

Former Member — Wed, 05 Feb 2014 17:17:05 GMT

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

Neal

Re: Re: Base table for customer texts.

nabheetscn — Wed, 05 Feb 2014 17:25:54 GMT

Yes Neal you are right

Re: Re: Base table for customer texts.

Former Member — Thu, 06 Feb 2014 05:58:31 GMT

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.

Re: Re: Base table for customer texts.

Former Member — Thu, 06 Feb 2014 13:36:40 GMT

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

Re: Re: Base table for customer texts.

nabheetscn — Thu, 06 Feb 2014 15:33:03 GMT

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

Re: Re: Base table for customer texts.

Former Member — Thu, 06 Feb 2014 15:41:54 GMT

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

Re: Re: Base table for customer texts.

Former Member — Thu, 06 Feb 2014 15:49:49 GMT

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.

Re: Re: Base table for customer texts.

Former Member — Thu, 06 Feb 2014 15:51:55 GMT

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

Re: Re: Base table for customer texts.

ThomasZloch — Thu, 06 Feb 2014 15:54:02 GMT

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

Re: Re: Base table for customer texts.

nabheetscn — Thu, 06 Feb 2014 15:55:28 GMT

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