Error
Error Code:
328
SAP S/4HANA Error 328: Invalid Function or Procedure Name
Description
This error indicates that the system encountered an SQL statement referencing a database function or procedure that either does not exist, is misspelled, or is inaccessible. It typically occurs during custom development, reporting, or integration scenarios where direct database calls are made.
Error Message
ERR_SQL_INV_FUNC_PROC
Known Causes
4 known causesIncorrect Function/Procedure Name
The specified function or procedure name in the SQL statement contains a typo or misspelling, preventing the database from finding it.
Missing Database Object
The referenced function or procedure has not been created in the database or was deleted, making it unavailable for execution.
Wrong Schema or Context
The function or procedure exists but is being called from an incorrect database schema or context, or without proper qualification.
Insufficient Database Permissions
The user or application attempting to execute the function or procedure lacks the necessary database privileges.
Solutions
4 solutions available1. Verify Function/Procedure Name in ABAP Code easy
Ensure the function or procedure name used in the ABAP program exactly matches the defined name in the SAP system.
1
Identify the ABAP program that is triggering error 328. This can usually be found in the ST22 dump or SM21 system log. Look for the program name and the specific statement where the function or procedure is called.
2
Navigate to the ABAP Development Tools (ADT) in Eclipse or the ABAP Editor (SE38/SE80) in SAP GUI.
3
Open the identified ABAP program. Search for the statement that calls the function or procedure. It will likely look like `CALL FUNCTION 'FUNCTION_NAME'` or `CALL METHOD object->method_name` or `CALL METHOD cl_class=>static_method`.
4
Carefully compare the name of the function or procedure in the ABAP code with the actual name of the function module or method in the SAP system. Pay close attention to case sensitivity, spelling, and any leading/trailing spaces.
5
If a discrepancy is found, correct the name in the ABAP program to match the exact name of the function module or method.
6
Activate the corrected ABAP program.
2. Check Function Module/Method Existence and Status easy
Confirm that the function module or method exists in the SAP system and is active.
1
Identify the function or procedure name from the error message or the ABAP code.
2
In SAP GUI, execute transaction `SE37` for function modules or `SE24` for class-based methods.
3
Enter the function module or method name and press Enter or click 'Display'.
4
If the function module or method does not exist, it means it was either never created, deleted, or is part of an uninstalled component. You will need to ensure the correct SAP Notes or Support Packages are applied, or the relevant software component is installed.
5
If the function module or method exists but is inactive, you will need to activate it. For function modules, use the 'Activate' button in SE37. For class-based methods, you might need to activate the entire class in SE24 or SE25.
6
If the error persists, consider if the function module/method is part of a specific add-on or custom development that might be missing or not properly activated.
3. Review Database Procedure/Function Name in HANA SQLScript medium
If the error originates from a HANA database procedure or function called by S/4HANA, verify its name and existence within the HANA database.
1
Determine if the error is related to a database-level object. This is more likely if the error message includes HANA-specific context or if the ABAP code is directly executing SQL statements that call database functions/procedures.
2
Connect to your SAP HANA database using a tool like SAP HANA Studio, DBVISUAL, or other SQL clients.
3
Execute a query to list available procedures and functions in the relevant schema. For example, to list procedures:
4
SELECT SCHEMA_NAME, PROCEDURE_NAME FROM SYS.PROCEDURES WHERE SCHEMA_NAME = '<your_schema_name>';5
SELECT SCHEMA_NAME, FUNCTION_NAME FROM SYS.FUNCTIONS WHERE SCHEMA_NAME = '<your_schema_name>';6
Compare the name of the procedure or function being called (as seen in the ABAP trace or error logs) with the names listed in the database. Ensure exact spelling and case matching.
7
If the procedure or function is not found, it needs to be created or deployed. If it exists but is not active (though less common for SQLScript objects), you may need to recompile it.
8
If the procedure or function is part of a transport, ensure the transport was successfully imported into the HANA database.
4. Analyze SAP Notes and Support Packages medium
Check for known issues and solutions in SAP Notes related to function/procedure calls.
1
Go to the SAP Support Portal (launchpad.support.sap.com).
2
Search for SAP Notes using keywords like 'ERR_SQL_INV_FUNC_PROC', 'Error 328', and potentially the name of the function module or the affected SAP module (e.g., 'FI', 'SD', 'MM').
3
Review the search results for relevant SAP Notes that describe the error and provide solutions. Pay attention to the S/4HANA version and specific component versions mentioned in the notes.
4
If a relevant SAP Note is found, carefully read its description and instructions. It might require applying a specific Support Package, implementing a manual correction, or updating a component.
5
If a manual correction is described, follow the steps precisely. This might involve changes in ABAP code, configuration, or even database objects.
6
If a Support Package is recommended, coordinate with your Basis team to plan and apply it during a maintenance window.