Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the server beyond simple SELECT operations with SAP ERP.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from SAP ERP, along with an indication of whether the procedure succeeded or failed.
CData MCP Server for SAP ERP Stored Procedures
| Name | Description |
| ClearCache | Clears the JCoRepository cache to refresh metadata definitions for SAP functions and tables, ensuring the latest versions are used. |
| CreateFunctionSchema | Generates an .rsd schema file based on the metadata of a specified SAP function module, enabling integration tools to map its structure. |
| CreateQuerySchema | Builds a schema file for a specified SAP query, allowing external tools to understand the input and output fields for data extraction. |
| CreateSchema | Creates a schema file for a specified SAP table or view, facilitating structured access to SAP data from external applications. |
| CreateTableSchema | Generates a schema file for a specific SAP table using RFC_READ_TABLE, enabling data retrieval from the SAP backend through remote function calls. |
| ListQueries | Retrieves metadata about available SAP queries and their fields, helping users select the correct query structure for data extraction. |
| PushIDoc | Sends IDoc or IDoc XML data to an SAP system using synchronous or asynchronous modes. Useful for B2B messaging, system integration, or transactional updates. |