Multiple Origin Composition

Data from several back-ends can be retrieved by adding ;mo to the service root URI. The response now contains a new key field “SAP__ORIGIN”. This is necessary to distinguish the results from all the connected back-end systems.

For example, the customer has connected several ERP systems to SAP Gateway. The customer number is used as a key field of the OData service. A problem would occur if there are identical customer numbers in the different SAP back-end systems.

Note: Routing will also be performed. That means a user will only retrieve data from those back-end systems to which they have access, based on the routing. Nevertheless the user has to have appropriate authorizations in the back end to retrieve the data.

Multiple Origin Composition Manager — EMEA and APJ Call the Service

Since the managers role has been assigned to both system aliases, ERP_EMEA and ERP_APJ, the manager will retrieve results with the new key field SAP__ORIGIN where SAP__Origin will have the value ERP_EMEA as well as ERP_APJ.

Since employee EMEA’s role has only been assigned to the alias ERP_EMEA, the employee will only retrieve results with the new key field SAP__ORIGIN where SAP__Origin will have the name ERP_EMEA.