Hi,I think the idea of using SharePoint on premise is a very good idea.We have solution that can "bridge the gap" between S4HC and SharePoint, in practice it does not work as CMIS storage because that has many limitations regarding folders generation...
Hello,the only solution we found to achieve this is to make use of a "Cloud attachment storage connector" that is able to manage attachments of various cloud solutions (C4C is one of them) and to store them into many types of content / archive server...
Sorry I can only refer to the SAP Helphttps://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/4c3d1c6b3d744f84aab4c273f979f430/bc275e43f1b043cc8f97710d5de64e97.html?locale=en-US