We are upgrading from WF4.5 to WF76 and see that now you can access SAP Queries. I can create the Metadata for the SAP Query and can create a report against the Metadata but receive the error message (FOC1587) NO SELECTION SPECIFIED FOR SAP/R3 QUERY ACCESS. How do you access data in SAP Queries? This is a basic query in SAP of KNA1 to KNVV and I have the criteria to enter the customer number only.
thank you,
Geri

This message has been edited. Last edited by: Geri,

quote:

1587

Doing

? 1587

gives this message:

quote:

(FOC1587) NO SELECTION SPECIFIED FOR SAP/R3 QUERY ACCESS
There is no WHERE/IF condition specified for "VARIANT" and READLIMIT is equal to 0

Does this help?

I haven't worked with SAP, but don't you have to filter for the current row only?

I have a statement that says:
WHERE KNA1_KUNNR EQ '&KNA1_KUNNR.CSTMR.'; so this should be my filter. KUNNR is the SAP customer number.

But does VARIANT mean anything to you? You probably need to have another filter to ensure you're only getting the current rows.

The variant name was the cause of the problem. I needed to create a name for the variant of the ABAP query and enter the variant name as cirteria in the WebFOCUS query. thank you for your help.