topic Re: Extract data from ANLA through Background program process? in Application Development and Automation Discussions

Extract data from ANLA through Background program process?

Former Member — Mon, 03 May 2010 14:55:23 GMT

I'm facing a requirement where I need to extract data from ANLA but there are too much records, I have one field which I can select but is not enough.

I was wondering what must be the best way to get data ( SELECT, GET/PUT, etc) without too much memory consumption, selecting data and putting in a background process program without collapse memory.

Thanks in advance.

Re: Extract data from ANLA through Background program process?

TuncayKaraca — Mon, 03 May 2010 15:28:07 GMT

@Tokio Franco Ch...

I think you may use Extracts, check [Extracts|http://help.sap.com/saphelp_nw2004s/helpdata/en/9f/db9ed135c111d1829f0000e829fbfe/frameset.htm]

Re: Extract data from ANLA through Background program process?

Former Member — Mon, 03 May 2010 15:32:24 GMT

And what field is that??

Rob

Re: Extract data from ANLA through Background program process?

Former Member — Mon, 03 May 2010 15:35:08 GMT

Rob the field is ANLKL.

Re: Extract data from ANLA through Background program process?

Former Member — Mon, 03 May 2010 15:48:33 GMT

Then it may use index ANLA~B. Use the PACKAGE Size option of the SELECT statement to avoid memory issues.

Rob

Re: Extract data from ANLA through Background program process?

Former Member — Mon, 03 May 2010 15:49:52 GMT

Thanks Rob

Could you please give an example?

Re: Extract data from ANLA through Background program process?

Former Member — Mon, 03 May 2010 15:51:28 GMT

Time to press F1.

Rob