topic Re: select stmt in Application Development and Automation Discussions

select stmt

Former Member — Mon, 27 Nov 2006 08:29:10 GMT

hi all

can anyone correct me this select stmt

is the where condition is written correctly

shud i also include and condition in where stmt to validate lfa1 table

SELECT ekko_{ebeln ekko}lifnr lfa1~name1

INTO CORRESPONDING FIELDS OF TABLE t_lifnr

FROM ( ekko

INNER JOIN lfa1

ON ekko_{lifnr = lfa1}lifnr )

INTO TABLE t_lifnr
FOR ALL ENTRIES IN t_output

WHERE ebeln = ekko~ebeln.

Re: select stmt

anversha_s — Mon, 27 Nov 2006 08:31:39 GMT

hi,

corrected

, no need of brackets

SELECT ekko~ebeln ekko~lifnr lfa1~name1
INTO CORRESPONDING FIELDS OF TABLE t_lifnr
FROM ekko 
INNER JOIN lfa1 
ON ekko~lifnr = lfa1~lifnr 

WHERE ebeln = parameter_ebeln.

rgds

Anver

Re: select stmt

Former Member — Mon, 27 Nov 2006 08:31:41 GMT

WHERE ekko~ebeln = pa_ebeln.

Re: select stmt

Former Member — Mon, 27 Nov 2006 08:32:55 GMT

The where condition should specify a value from selection screen or with reference to an internal table:

Eg:

SELECT ekko_{ebeln ekko}lifnr lfa1~name1

INTO CORRESPONDING FIELDS OF TABLE t_lifnr

FROM ( ekko

INNER JOIN lfa1

ON ekko_{lifnr = lfa1}lifnr )

INTO TABLE t_lifnr
FOR ALL ENTRIES IN t_output

WHERE ebeln = p_ebeln. "ekko~ebeln. - Parameter

SELECT ekko_{ebeln ekko}lifnr lfa1~name1

INTO CORRESPONDING FIELDS OF TABLE t_lifnr

FROM ( ekko

INNER JOIN lfa1

ON ekko_{lifnr = lfa1}lifnr )

INTO TABLE t_lifnr
FOR ALL ENTRIES IN t_output

WHERE ebeln IN s_ebeln. "= ekko~ebeln. - Select-Option

SELECT ekko_{ebeln ekko}lifnr lfa1~name1

INTO CORRESPONDING FIELDS OF TABLE t_lifnr

FROM ( ekko

INNER JOIN lfa1

ON ekko_{lifnr = lfa1}lifnr )

INTO TABLE t_lifnr

FOR ALL ENTRIES IN t_output

WHERE ebeln = t_output-ebeln. "ekko~ebeln. - With reference to another internal table

Kind Regards

Eswar

Re: select stmt

Former Member — Mon, 27 Nov 2006 08:36:01 GMT

There is no need to validate as you already linked lfa1 and ekko. in the where condition you need to specify the and selection screen input.

SELECT ekko_{ebeln ekko}lifnr lfa1~name1

INTO CORRESPONDING FIELDS OF TABLE t_lifnr

FROM ( ekko

INNER JOIN lfa1

ON ekko_{lifnr = lfa1}lifnr )

INTO TABLE t_lifnr
FOR ALL ENTRIES IN t_output

WHERE ebeln = ekko~ebeln.

Rgds,

Hemanth.

Re: select stmt

Former Member — Mon, 27 Nov 2006 08:41:03 GMT

Hi,

Check selects given below..

if ebeln is a parameter...

SELECT ekko_{ebeln ekko}lifnr lfa1~name1

INTO CORRESPONDING FIELDS OF TABLE t_lifnr

FROM ( ekko

INNER JOIN lfa1

ON ekko_{lifnr = lfa1}lifnr )

INTO TABLE t_lifnr
FOR ALL ENTRIES IN t_output

WHERE ebeln = p_ebeln.

if ebeln is a select option

SELECT ekko_{ebeln ekko}lifnr lfa1~name1

INTO CORRESPONDING FIELDS OF TABLE t_lifnr

FROM ( ekko

INNER JOIN lfa1

ON ekko_{lifnr = lfa1}lifnr )

INTO TABLE t_lifnr
FOR ALL ENTRIES IN t_output

WHERE ebeln IN S_ebeln.

if you are using for all entries...in the seelct you provided its commented...if u use that statement,.

SELECT ekko_{ebeln ekko}lifnr lfa1~name1

INTO CORRESPONDING FIELDS OF TABLE t_lifnr

FROM ( ekko

INNER JOIN lfa1

ON ekko_{lifnr = lfa1}lifnr )

INTO TABLE t_lifnr

FOR ALL ENTRIES IN t_output

WHERE ebeln = t_output-ebeln.

reward if helpful..

Rgds,

Ajith

Re: select stmt

Former Member — Mon, 27 Nov 2006 08:48:34 GMT

SELECT ekko_{ebeln ekko}lifnr lfa1~name1

INTO CORRESPONDING FIELDS OF TABLE t_lifnr

FROM ( ekko

INNER JOIN lfa1

ON ekko_{lifnr = lfa1}lifnr )

INTO TABLE t_lifnr
FOR ALL ENTRIES IN t_output

WHERE ekko~ebeln = p_ebeln.

in where condition ekko~ebeln = p_ebeln.

Re: select stmt

Former Member — Mon, 27 Nov 2006 08:58:17 GMT

hi lakshmi,

it is correct only.

please check this

DATA : BEGIN OF t_lifnr OCCURS 0,

ebeln LIKE ekko-ebeln,

lifnr LIKE ekko-lifnr,

name1 LIKE lfa1-name1,

END OF t_lifnr.

SELECT ekko_{ebeln ekko}lifnr lfa1~name1

INTO CORRESPONDING FIELDS OF TABLE t_lifnr

FROM ( ekko

INNER JOIN lfa1

ON ekko_{lifnr = lfa1}lifnr )

INTO TABLE t_lifnr

*FOR ALL entries IN t_output

WHERE ebeln = ekko~ebeln.

regards,