Skip to Content
0
Former Member
Nov 27, 2006 at 08:29 AM

select stmt

29 Views

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 ekkoebeln ekkolifnr lfa1~name1

INTO CORRESPONDING FIELDS OF TABLE t_lifnr

FROM ( ekko

INNER JOIN lfa1

ON ekkolifnr = lfa1lifnr )

  • INTO TABLE t_lifnr

  • FOR ALL ENTRIES IN t_output

WHERE ebeln = ekko~ebeln.