Select Query Failure
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.?
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.