Streams in RAP (managed BO), how to keep stream content in connected DMS rather than in database

[stefan-keuker]

Hi all,

we have implemented a SAP RAP based app (managed scenario) that allows for uploading of attachments to some datamodel defined in a CDS Data Model to which the attachment entity is a composition child. As per RAP Solution Design the file content (Stream) get's stored in the SAP Database in a field of the the data base table stated in 'draft table' (while in draft state) and 'persistent table' (after draft becomes active entity). 

Our requirement is to store the stream content at time of draft action active and store it in the Document Management System connected to the backend instead of in the persistent table. The problem: when the stream ist meant to be downloaded from the Fiori Elements app the 'Select' statement executed in CL_SADL_SQL_EXECUTOR-> SELECT assumes the data to in the persistent table and there is no way I could find to supplement the stream data from the connected Document Management System instead.

Did you come accross this requirement in the context of managed RAP BOs using streams? How did you solve? I'd appreciate your insights.

Thanks,

Stefan