Need to show list of Customers from SAP into choice list in servicenow realtime
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-04-2025 01:09 AM
Dear experts,
We have customer data in SAP and there is a requirement to show the list of customers (sap cust no, sap cust name, sap cust address, active flag), in dropdown in servicenow. This information needs to be realtime i.e. when user clicks on the choice field, the data should be retrieved. We have 2 data sources for this - 1. SAP 2.SQLServer Datawarehouse
Is it possible to achieve this requirement?
We do have a custom table available for use but we want to avoid using additional storage in servicenow.
Best Regards,
Ashwini Pingle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-04-2025 04:19 AM
Did you check on the remote table capabilities?
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-04-2025 05:04 AM
Hi ashwinipingle
The Integration Hub Actions link can guide you on real-time data retrieval from external sources like SAP or SQLServer, enabling dynamic dropdowns without storing data in ServiceNow.
Integration Hub Actions - https://servicenow.com/docs/bundle/yokohama-integrate-applications/page/administer/integrationhub/co...
If this helps, please give it a helpful vote. And if it’s what you were looking for, go ahead and accept the solution. Thanks,
Daniel Madsen
