Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Select Query Failure

Hi All,

I have made a Z table and I am fetching data from it.

But the issue is some data is not being fetched, though the same data exists in the table.

I have 3 variables in where condition.

SELECT * FROM ZFIIST003 " Estimation Data
INTO CORRESPONDING FIELDS OF TABLE GT_ZFIIST003
WHERE PARTNER IN S_PART AND
       ZDATE IN S_DATE and
     VENDOR_NAME = PVENDOR  .


if I remove VENDOR_NAME in this query then it is working fine.

But according to the requirement i have to keep this in the query.


Does any one having a solution.?

Former Member
Former Member replied

HI

I think you have declare PVENDOR is PARAMETER filed. if you wont give in parameter field then you wont get anything.

make that field as select-option with no extension and no intervels and check it.


regards

laxman

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question