cancel
Showing results for 
Search instead for 
Did you mean: 

Error while retrieving data thru SAP Function

Former Member
0 Kudos

Hello

I'm trying to extract information from SAP to Crystal Reports 2011 with the following functions:

1. FI_EXPORT_BALANCE_SHEET_POS

2. FI_EXPORT_BALANCE_SHEET_TEXT

I'm getting all the records when I extract from the first function, however second function is giving the following error:

Database Connector Error: '/CRYSTAL/0SQL_EXECUTE_QUERY' returned: subrc: 4. Message Type "%S" is unknown. Line 4. WOrd 0.

Anyone know its workaround, or how can I debug the error further?

Cheers

Nayab

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

On running the RFC and SQL Trace, I found that it tries to find the table in SAP which is not available. 

"SELECT WHERE "TABNAME"='FIBSC_ERGSL_TSTAMP_TAB'  AND ROWNUM <=1"

What should be done now, any good idea?

Former Member
0 Kudos

On further analysis, table FUPARAREF contains wrong entry

Will contact SAP to rectify the entry

Thanks