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.