select stmt

[Former Member]

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.

[anversha_s]

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

[Former Member]

WHERE ekko~ebeln = pa_ebeln.

[Former Member]

Hi

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 = <b>p_ebeln. "ekko~ebeln</b>. - <b>Parameter</b>

or

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 <b>s_ebeln. "= ekko~ebeln</b>. - <b>Select-Option</b>

or

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

<b> FOR ALL ENTRIES IN t_output</b>

WHERE ebeln = <b>t_output-ebeln. "ekko~ebeln.</b> - <b>With reference to another internal table</b>

Kind Regards

Eswar

[Former Member]

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.

[Former Member]

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

<b>WHERE ebeln = p_ebeln.</b>

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

<b>WHERE ebeln IN S_ebeln.</b>

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

<b> FOR ALL ENTRIES IN t_output

<b>WHERE ebeln = t_output-ebeln.</b></b>

reward if helpful..

Rgds,

Ajith

[Former Member]

hi

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.

[Former Member]

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,