COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: suffix on 30 Nov 2012 08:54:16 AM

Title: Calling SAP Function Modules error
Post by: suffix on 30 Nov 2012 08:54:16 AM
I am trying to call an SAP function module (Z_FIN_STATEMENT_LAYOUT) in SQLTerm 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?