Question Re: Text tables STXH and STXL in Technology Q&A

Text tables STXH and STXL

patrickbachmann — Mon, 17 Mar 2014 20:30:29 GMT

Hi folks,

I have a project requirement that has a component that requires extracting pieces of information from text tables STXH and STXL. Apparently we have data being concatenated into single text fields with pipe delimiters that will need to be extracted and parsed for a reporting requirement. We have discussed possibility of replicating these tables into HANA but in our environment these tables are enormous. Not to mention the ABAP logic that typically reads these tables via READ_TEXT function module is apparently quite complex. I've been asked by our ABAP developers to find out if there is a way to call the READ_TEXT function module directly inside a HANA view and if not there must be others using HANA that are having the same issue and how have you handles retrieving this data?

Thanks,

-Patrick

Re: Text tables STXH and STXL

Former Member — Tue, 18 Mar 2014 13:28:25 GMT

Hi Patrick,

I haven't worked with long texts much, but perhaps 's document on this topic is helpful?

Cheers,

Jody

Re: Text tables STXH and STXL

justin_molenaur2 — Tue, 18 Mar 2014 13:41:59 GMT

Thanks for the ref Jody.

Patrick - the How to document should be just what you are looking for. The pain point is that you need an ABAP box in order to convert the compressed text columns, which HANA cannot do.

Regarding volumes, you actually don't even need STXH at all as long as you know the object types, etc that you are looking for from STXL. Additionally, you can filter out the data you don't need through SLT configurations for replication (still have the pain of initial load). Good news is that this is solved in SLT DMIS 2011 SP06, where you can filter the initial load too.

See the following discussion in conjunction with the How To document and you should be golden.

Let me know if you have questions.

Regards,

Justin

Re: Text tables STXH and STXL

patrickbachmann — Wed, 19 Mar 2014 14:03:18 GMT

Guys many thanks for leading me to these excellent posts! I'm just digesting them further before I close this thread. Indeed looks like exactly what I need. Thanks.

-Patrick

Re: Text tables STXH and STXL

patrickbachmann — Wed, 19 Mar 2014 20:15:10 GMT

Ok closing this thread. Also I DID search the forums for STXL before I posted this but I never thought to check SLT forum. Actually I didn't even know there was one until this. Thanks again guys. Great stuff. Justin you're quickly moving to the top of my HANA guru pedestal with Ravi and Lars. Keep up the great work.

Re: Text tables STXH and STXL

justin_molenaur2 — Thu, 20 Mar 2014 01:56:26 GMT

Well, that may be a stretch putting me in the same category as those gentlemen, but thanks for the kind words. Glad I could help out and that my document will be put to practical use!

Let me know if you hit any snags. Just out of curiosity, what texts are you targeting and how are you planning to use once you land in HANA?

Regards,

Justin

Re: Text tables STXH and STXL

patrickbachmann — Thu, 20 Mar 2014 13:44:36 GMT

Sure thing will do. We have some change information that is stored in texts for sales orders. Inside the texts are time stamps separated with pipe delimiters. We are going to parse that and do some time calculations for on time delivery metrics.

Thanks again!

-Patrick