SAP / PyRFC

Asynchronous, non-blocking SAP NW RFC SDK bindings for Python
http://sap.github.io/PyRFC
Apache License 2.0
500 stars 132 forks source link

BW Query with Parameters - ERROR: IVALID INPUT #348

Closed Yasine001 closed 8 months ago

Yasine001 commented 8 months ago

I have an issue retrieving data using a bw query.

I use the function module RRW3_GET_QUERY_VIEW_DATA to query data from the bw based predefined queries. This function module also give the prossibility the query data based on certain predefined parameters. It works prefectly with queries with no parameters, but once I try al call data from a query with parameters, I get an error.

The Query functions prefectly in Excel (Analysis for Office):

image

But with Pyrfc I get the error the input is invalid:

image

I also tried to give the parameter ID instead of the name, but I get the same error. The Key words "Name" und "Value" are recognized, but somehow I get the same error.

Does anyone please have experince with inputs and can help. Thanks

bsrdjan commented 8 months ago

RRW3_GET_QUERY_VIEW_DATA function module is not supported, please check SAP Help https://help.sap.com/docs/SUPPORT_CONTENT/bwplaolap/3361386636.html

The error is not PyRFC error, more likely the inconsistence of input parameters.

Yasine001 commented 8 months ago

Hallo Srdjan,

I was able to pass parameters. Just In in case someone needs the same Info:

parameters = [{'NAME': 'VAR_NAME_1', 'VALUE': &THE_TECHNICAL_NAME_OF_THE_VARIBALE}, {'NAME': 'VAR_VALUE_EXT_1', 'VALUE': &THE_VALUE}]

Thanks for the information about the function module - from a practical experience, it does indeed have a memory problem. It only retrieves a limited amount of data. . I'll soon be moving to RSDRI_INFOPROV_READ_RFC, which is supported and maintained.