topic How can I write this SQL? in Application Development and Automation Discussions

How can I write this SQL?

Former Member — Mon, 02 Jul 2007 07:50:06 GMT

the statement have the question:

stxh-tdname length 70

itab-vbeln length 10

select tdobject into table it_stxh

from stxh

for all entries in itab

where ( tdid = 'Z006' and tdspras = 'E' and tdname+0(10) = itab-vbeln and tdobject = 'VBBK' ).

tdname+0(10) = itab-vbeln ???

Re: How can I write this SQL?

Former Member — Mon, 02 Jul 2007 07:52:18 GMT

the code checks if

the first ten char in tdname match the field itab-vbeln

Regards,

Aparna

Re: How can I write this SQL?

Former Member — Mon, 02 Jul 2007 07:56:44 GMT

any variable of char/string type can be accessed char wise..

char_variable+x(w)

this means we are refering to w characters from the xth character

if char_variable = 'APARNA'

then char_variable+0(3) = 'APA'

Regards,

Aparna

Re: How can I write this SQL?

Former Member — Mon, 02 Jul 2007 08:08:45 GMT

When you define the first Internal Table ITAB, define vbeln as the same type of stxh-tdname.

Eg.

data: begin of itab occurs 0,

vbeln like STXH-TDNAME,

erdat like vbak-erdat,

end of itab.

START-OF-SELECTION.

Select VBELN

ERDAT

from vbak

into CORRSPONDING FIELDS of table itab.

Then you can directly use this ITAB in the next query

select tdobject into table it_stxh

from stxh

for all entries in itab

where ( tdid = 'Z006' and tdspras = 'E' and tdname = itab-vbeln

and tdobject = 'VBBK' ).

Pls reward it if it is useful.

Re: How can I write this SQL?

Former Member — Mon, 02 Jul 2007 08:12:34 GMT

Hi,

This selcts works when the First 10 charecters of the field TDANME should be equals to the VBELN

Regards

Sudheer

Re: How can I write this SQL?

Former Member — Mon, 02 Jul 2007 08:19:28 GMT

i dont think it is possible with for all entries ... you can do like this..

data : vtdname(11).

loop at itab.

concatenate itab-vbeln '%' into vtdname.

select single tdobject into it_stxh

from stxh

where ( tdid = 'Z006' and tdspras = 'E' and tdname like vtdname and tdobject = 'VBBK' ).

append it_stxh.

endloop.

regards

shiba dutta

Re: How can I write this SQL?

Former Member — Mon, 02 Jul 2007 08:32:40 GMT

very thanks to every one,thank you !

Re: How can I write this SQL?

Former Member — Mon, 02 Jul 2007 09:55:10 GMT

Hi ,

Please reward with points if the answer was helpful in solving your quesry