topic Selecting values from a table using Field value= value* in Application Development and Automation Discussions

Selecting values from a table using Field value= value*

Former Member — Mon, 01 Feb 2010 13:18:01 GMT

Hi ,

I want to retrieve values from STXH table based on TDNAME = vbeln*.

means i am first getting the vbeln values from VBAK table.

Thenks adding a '*' to vbeln values and appending it to another internal table (T_VBAK2).

Means if i am getting '0012345678' as vbeln from VBAK then T_VBAK2-VBELN will contain '0012345678*' as the value.

Then finaly writing the query:

SELECT * FROM STXH

INTO TABLE LT_STXH

FOR ALL ENTRIES IN T_VBAK2

WHERE TDNAME = T_VBAK2-VBELN.

But this query is failing.

But Same thing if we do after going to SE11 we are getting values as obvious.

Please suggest the solution.

Thanks in Advance.

Mayank

Re: Selecting values from a table using Field value= value*

Former Member — Mon, 01 Feb 2010 13:41:56 GMT

Hello

1. Add '%' instead of '*'. You will have '0012345678%' as the value.

2. In select do:


SELECT * FROM STXH
INTO TABLE LT_STXH
FOR ALL ENTRIES IN T_VBAK2
WHERE TDNAME LIKE T_VBAK2-VBELN. " <- LIKE instead of '='

Re: Selecting values from a table using Field value= value*

Former Member — Mon, 01 Feb 2010 13:51:19 GMT

Hi,

On replacing '=' with LIKE i am getting error message:

"The addition 'For All Entries in Itab ' cannot be used in the where condition BETWEEN ,LIKE and IN."

Please look into this.

Re: Selecting values from a table using Field value= value*

Former Member — Mon, 01 Feb 2010 13:54:41 GMT

U need to insert the select in a LOOP, it can't use FOR ALL ENTRIES:

DATA V_TDNAME TYPE STXH-TDNAME.

LOOP AT T_VBAK2.
   
   V_TDNAME = T_VBAK2-VBELN.
   V_TDNAME+10(1) = '%'.
   
   SELECT * FROM STXH
       APPENDING TABLE LT_STXH
                  WHERE TDNAME LIKE V_TDNAME.

ENDLOOP.

Max

Re: Selecting values from a table using Field value= value*

Former Member — Mon, 01 Feb 2010 13:56:21 GMT

Hello

Then loop/endloop instead of 'For All Entries'.

Re: Selecting values from a table using Field value= value*

Former Member — Mon, 01 Feb 2010 14:47:02 GMT

Hi,

I cant use loop endloop here....

As already VBAK table will have hundreds of records and again STXHｈａｖｅ　ａｒｏｕｎｄ　５５００００　ｒｅｃｏｒｄｓ．

Ｓｏ　ｆｏｒ　ｅａｃｈ　ｒｅｃｏｒｄ　ｆｅｔｃｈｉｎｇ　ｔｈｅ　ｄａｔａ　ｆｒｏｍ　ｄａｔａｂａｓｅ　ｗｉｌｌ　ｂｅ　ａ　ｐｅｒｆｏｒｍａｎｃｅ　ｉｓｓｕｅ．

Ｐｌｅａｓｅ　ｐｒｏｖｉｄｅ　ｓｏｍｅ　ａｌｔｅｒｎａｔｉｖｅ．

Edited by: Mayank Verma on Feb 1, 2010 3:47 PM

Re: Selecting values from a table using Field value= value*

Former Member — Mon, 01 Feb 2010 14:54:26 GMT

It depends on what u need to do, give us more information: why u need to read STXH table?

Max

Re: Selecting values from a table using Field value= value*

Former Member — Mon, 01 Feb 2010 15:07:50 GMT

Actually,

By fetching data from STXH table :

I am passing:

STXH-TDID

STXH-TDNAME

STXH-TDOBJ

STXH-TDSPRAS to FM READ_TEXT to fetch TLINE text value.

means after fetching records from STXH table ...i am looping that internal table each time to call FM Read_Text......to get TLINE value.

Finally i want to have TLINE value for each of my sales order number.

This is my requirement.

Edited by: Mayank Verma on Feb 1, 2010 4:08 PM

Re: Selecting values from a table using Field value= value*

Former Member — Mon, 01 Feb 2010 15:21:36 GMT

I believe u've not many solution, u can try to manage the texts of a single sales order:

LOOP AT T_VBAK2.
   
   V_TDNAME = T_VBAK2-VBELN.
   V_TDNAME+10(1) = '%'.
   
   SELECT * FROM STXH
       INTO TABLE LT_STXH
                  WHERE  ( TDOBJECT = 'VBBK' OR TDOBJECT = 'VBBP' ) 
                        AND TDNAME LIKE V_TDNAME.

    LOOP AT LT_STXH.
    ENDLOOP.
 
ENDLOOP.

Else u need to calculate the right key for TDNAME if you don't want to use a LOOP

Max