Question Re: ABAP Streaming in Technology Q&A

ABAP Streaming

Former Member — Tue, 16 Jun 2009 12:03:00 GMT

Hi,

is there any way of writing an ICF HTTP GET handler (ABAP) that streams data like any Java servlet, i.e. connects a data source (DB table/Blob) to the response stream w/o the need of loading the complete resource content into an internal table first? Providing large data for download this way will be impossible else.

Thanks, Hans-Juergen

Re: ABAP Streaming

markus_doehr2 — Tue, 16 Jun 2009 13:14:50 GMT

> is there any way of writing an ICF HTTP GET handler (ABAP) that streams data like any Java servlet, i.e. connects a data source (DB table/Blob) to the response stream w/o the need of loading the complete resource content into an internal table first? Providing large data for download this way will be impossible else.

Not sure if this is possible.

An ABAP system was never designed to "stream" a huge amount of data. On top, doing so, would keep the workprocess busy all time.

Markus

Re: ABAP Streaming

Hansi_Richstein — Tue, 16 Jun 2009 14:23:13 GMT

But acting as a webserver, also an ABAP system should somehow be able to provide larger amounts of data not limited to the maximum space for an internal table. How does SAP Marketplace do it? Isn't that an ABAP system as well (and you can download complete DVDs)?

Re: ABAP Streaming

Former Member — Wed, 17 Jun 2009 11:25:37 GMT

Hi,

The ABAP ICM (internal web server) can do it because it is able to publish filesystem directories and files. You can publish full DVDs like this...

If the data comes from a database table, I don't know.

When you speak about the restriction of an internal table, remember that an internal table size may be several GBytes.

Regards,

Olivier

Re: ABAP Streaming

Hansi_Richstein — Wed, 17 Jun 2009 11:35:58 GMT

Hi,

seemingly ICM is really the answer we are looking for -- a colleague pointed this out as well and we are already in contact with that team to clarify the details.

And right, internal tables can grow to that size, however we are talking about a multi tenant, multi user system. And the largest data we need to deliver right now is ~200MB. Supposing only a few users of a few tenants concurrently download it might soon blow up the memory.

Thx, Hans-Juergen

Re: ABAP Streaming

markus_doehr2 — Wed, 17 Jun 2009 14:24:19 GMT

But acting as a webserver, also an ABAP system should somehow be able to provide larger amounts of data not limited to the maximum space for an internal table. How does SAP Marketplace do it? Isn't that an ABAP system as well (and you can download complete DVDs)

Yes - and that's why certain files have to split up

I'm not saying it's not possible. Downloading something à la http "GET /DVD.iso" should certainly work, I am just not sure, if the ICM can handling a streaming (as in Youtube).

Markus

Re: ABAP Streaming

Former Member — Wed, 21 Nov 2012 22:22:39 GMT

Hi Hans-Juergen,

if you need to download huge tables from SAP via RFC you may try RemoteOpenSQL, a little open source project to run queries against SAP DB Tables.

Best regards,

Filippo.