Selecting values from a table using Field value= value*

[Former Member]

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

[Former Member]

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 '='

[Former Member]

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.

[Former Member]

Hi

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

[Former Member]

Hello

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

[Former Member]

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

[Former Member]

Hi

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

Max

[Former Member]

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

[Former Member]

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