topic Re: Select Statement in Application Development and Automation Discussions

Select Statement

Former Member — Thu, 12 Apr 2007 14:10:31 GMT

Hello Friends,

I am facing a problem in select statement.

DATA : t_caufv LIKE caufv OCCURS 0 WITH HEADER LINE,

t_ihpa LIKE ihpa OCCURS 0 WITH HEADER LINE,

t_lfa1 LIKE lfa1 OCCURS 0 WITH HEADER LINE.

SELECT *

FROM ihpa

INTO TABLE t_ihpa

FOR ALL ENTRIES IN t_caufv

WHERE objnr = t_caufv-objnr

AND parvw = 'VN'.

IF NOT t_ihpa IS INITIAL.

SELECT *

FROM lfa1

INTO TABLE t_lfa1

FOR ALL ENTRIES IN t_ihpa

WHERE lifnr = t_ihpa-parnr.

ENDIF.

But my second select statement gives a Syntax error.

I looked into LFA1-LIFNR and IHPA-Parnr in se11. They both have same data type but have different length.

ANy suggestions.

Ster.

Re: Select Statement

Former Member — Thu, 12 Apr 2007 14:13:57 GMT

LIFNR is of length 10 and PARNr is of length 12 , try this

Re: Select Statement

Former Member — Thu, 12 Apr 2007 14:14:47 GMT

Hi,

use ADRC instead of LFA1 table

define

t_adrc LIKE adrc OCCURS 0 WITH HEADER LINE.

IF NOT t_caufv IS INITIAL.

SELECT *

FROM ihpa

INTO TABLE t_ihpa

FOR ALL ENTRIES IN t_caufv

WHERE objnr = t_caufv-objnr

AND parvw = 'VN'.

endif.

IF NOT t_ihpa IS INITIAL.

SELECT *

FROM adrc INTO TABLE t_adrc

FOR ALL ENTRIES IN t_ihpa

WHERE adrnr = t_ihpa-adrnr.

ENDIF.

ADRC will also have the same data a s LFA1.

reward points if useful

regards,

ANJI

Re: Select Statement

Former Member — Thu, 12 Apr 2007 14:16:17 GMT

Use the below code in bold

DATA : t_caufv LIKE caufv OCCURS 0 WITH HEADER LINE,

t_ihpa LIKE ihpa OCCURS 0 WITH HEADER LINE,

t_lfa1 LIKE lfa1 OCCURS 0 WITH HEADER LINE.

data : begin of itab occurs 0,

lifnr type lfa1-lifnr,

end of itab.

SELECT *

FROM ihpa

INTO TABLE t_ihpa

FOR ALL ENTRIES IN t_caufv

WHERE objnr = t_caufv-objnr

AND parvw = 'VN'.

IF NOT t_ihpa IS INITIAL.

loop at t_ihpa.

move t_ihpa-para to itab-lifnr.

append lifnr.

endloop.

SELECT *

FROM lfa1

INTO TABLE t_lfa1

FOR ALL ENTRIES IN t_ihpa

WHERE lifnr = itab-lifnr.

ENDIF.

Re: Select Statement

Former Member — Thu, 12 Apr 2007 14:16:21 GMT

Thanks, Thats the problem Chandrashekhar.

LIFNR has length 10 and PARNR has length 12.

So the problem.

Whats an alternative for this?

Ster

Re: Select Statement

Former Member — Thu, 12 Apr 2007 14:16:49 GMT

Hi Ster,

Check this code.

IF NOT t_ihpa IS INITIAL.

SELECT *

FROM lfa1

INTO TABLE t_lfa1

FOR ALL ENTRIES IN t_ihpa

WHERE lifnr = t_ihpa-parnr+0(10).

ENDIF.

Thanks,

Vinay

Re: Select Statement

Former Member — Thu, 12 Apr 2007 14:17:42 GMT

Hi,

The fields in the select statement should be of same data type and same length.

Regards,

Re: Select Statement

suresh_datti — Thu, 12 Apr 2007 14:18:01 GMT

To quote from an F1 on FOR ALL ENTRIES..

"Each component of the internal table that occurs in a replacement symbol in the WHERE condition must have exactly the same type and length as the corresponding component in the database table. "

Which is not the case in your second SELECT. Pl change your itab definition to match the type & length of LIFNR

~Suresh

Re: Select Statement

Former Member — Thu, 12 Apr 2007 14:27:23 GMT

DATA : t_caufv LIKE caufv OCCURS 0 WITH HEADER LINE,
t_ihpa LIKE ihpa OCCURS 0 WITH HEADER LINE,
t_lfa1 LIKE lfa1 OCCURS 0 WITH HEADER LINE.

data : it_ranges for ihpa-parnr.

SELECT *
FROM ihpa
INTO TABLE t_ihpa
FOR ALL ENTRIES IN t_caufv
WHERE objnr = t_caufv-objnr
AND parvw = 'VN'.

loop at i_ihpa.
 it_ranges-sign = 'I'.
 it_ranges-option = 'CP'.
 concatenate i_ihpa-parnr '*' into it_ranges-low.
 append it_ranges.
clear it_ranges.
endloop.

delete adjacent duplicates from it_ranges.

IF NOT t_ihpa IS INITIAL.

SELECT *
FROM lfa1
INTO TABLE t_lfa1
WHERE lifnr in  it_ranges.

ENDIF.

Re: Select Statement

Former Member — Thu, 12 Apr 2007 14:31:26 GMT

DATA : t_caufv LIKE caufv OCCURS 0 WITH HEADER LINE,

t_ihpa LIKE ihpa OCCURS 0 WITH HEADER LINE,

t_lfa1 LIKE lfa1 OCCURS 0 WITH HEADER LINE.

data : begin of itab occurs 0,

lifnr type lfa1-lifnr,

end of itab.

SELECT *

FROM ihpa

INTO TABLE t_ihpa

FOR ALL ENTRIES IN t_caufv

WHERE objnr = t_caufv-objnr

AND parvw = 'VN'.

IF NOT t_ihpa IS INITIAL.

loop at t_ihpa.

move t_ihpa-para+2(12) to itab-lifnr.

append lifnr.

endloop.

SELECT *

FROM lfa1

INTO TABLE t_lfa1

FOR ALL ENTRIES IN t_ihpa

WHERE lifnr = itab-lifnr.

ENDIF.

Re: Select Statement

Former Member — Thu, 12 Apr 2007 14:41:45 GMT

Thanks everyone for your suggestions.

I will try as suggested.

Ster.