I am trying to call an SAP function module (Z_FIN_STATEMENT_LAYOUT) in SQLTerm in Cognos Data Manager using an SAP source connection
and I get an error:
SELECT * FROM CALL Z_FIN_STATEMENT_LAYOUT TEST
DM-DBM-0400 UDA driver reported the following on connection SAP:1:
UDA-SQL-0107 A general exception has occurred during the operation “Z_FIN_STATEMENT_LAYOUT”.
UDA-SQL-0196 The table or view “Z_FIN_STATEMENT_LAYOUT” was not found in the dictionary.
UDA-SQL-0107 A general exception has occurred during the operation “Z_FIN_STATEMENT_LAYOUT”.
It says that the function (Z_FIN_STATEMENT_LAYOUT) was not found in the dictionary. But I can’t find a way to add a function in a dictionary (in Table Selector for SAP R/3 where you build a dictionary). You can only add tables and views in there.
Anyone knows how to call this function module or how to add it to a dictionary?