Use business user rather than communication user for CDS oData call in MS Excel

[Wolfgang_Mayer]

Hello community,

on this community page, there are some blogs dealing with the integration of API calls into MS Excel, e.g. https://community.sap.com/t5/enterprise-resource-planning-blogs-by-sap/s-4hana-cloud-integration-an-....

However, all of these tutorials use a communication user rather than a named business user (CB...). In our case, we want several business users to use this feature in MS Excel, however, the system has to deliver only data filtered on the individual authorizations/restrictions of each user (e.g. based on company code, sales org, ...).

Any idea on how to achieve this?

Thanks & regards

Wolfgang

[varunvenkat]

Hi Wolfgang,

anytime you are making inbound calls into the S/4HANA Cloud system, a communication user has to be used. A business user is used used when executing transactions within the S/4HANA Cloud system itself.

Please refer to the communication management documentation for further details on the communication management setup.

Best regards
Varun

[Wolfgang_Mayer]

Dear Varun, thanks for your feedback. I'm aware of this, was just wondering whether there's an alternative option since - as mentioned - there's no way to distinguish authorization-wise if all calls use the same user. Regards Wolfgang