Skip to Content
0
Jan 10, 2011 at 09:33 AM

problem in select query in QUERY INFOSET

201 Views

Hi All

I have requirement to find the sales text maintained for sales order in mass in production. By using the FM READ_TEXT i can pass the necessary values to get the sales text. We dont want to write a program and then transprot to P01. So what i did in SQ02 i create a infoset and worte code in the infoset. Here i am facing the problem that in the select query where clause what ever on the selection screen values, for that the query need to fetch the records. But selection screen is dymically selected based on SQVI t-code.

In select query if i write like this

SELECT TDOBJECT TDNAME TDID TDSPRAS
       FROM STXH
       INTO TABLE IT_TEXT_DETAIL
       WHERE TDOBJECT     EQ C_KNMT .

Here i have hardcoded KNMT so it will fetch only that value irrespective of any values on the selection screen. How to get the values based on the selection screen. I debugged the query it automatically generates the code for selection screen which i am not able to pass in the program.

SAP has generated this code

select-options SP$00004 for STXH-TDOBJECT.
select-options SP$00005 for STXH-TDNAME.
select-options SP$00006 for STXH-TDID.

If i pass SP$00004 on where clause its giving me error. So how to pass it dynamically. Waiting for experts answer.

Regards

Vijay