ABAP Streaming

[Former Member]

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

[Former Member]

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.

[Hansi_Richstein]

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)?

[Former Member]

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

[Hansi_Richstein]

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

[markus_doehr2]

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

[markus_doehr2]

> 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