QUERY

[Former Member]

Hi,

I have selected ebeln aedat lifnr fields from table ekko on condition

ebeln in s_ebeln into table t_ekko.

now i want to retrieve fields lifnr name spras from table lfa1

on lifnr must be equal to the lifnr which we have retrieved into table t_ekko.

like

lifnr = t_ekko-lifnr.

Pls suggest me the query.

Regards,

Nasru

[Former Member]

if not t_ekko[] is initial.

  select lifnr name spras  into table it_lifnr from lfa1 for all entries in t_ekko where lifnr eq t_ekko-lifnr.

ebdif.

[Former Member]

Hi Chandrasekhar,

Thank u.

Regards,

Nasru

[Former Member]

Hi,

use a Join for EKKO and LFA1 tables

select a_{ebeln a}aedat a_{lifnr b}name1 b_{land1 b}ort01 b~pstlz

into table t_ekko from

ekko as a join lfa1 on a_{lifnr = b}lifnr where

a~ebeln in s_ebeln.

reward points if useful

regards,

ANJI

[Former Member]

Hi,

Use FOR ALL ENTRIES to serve for your purpose.

<b>select *

from lfa1

into <tab name>

for all entries in t_ekko

where lifnr = t_ekko-lifnr.</b>

Regards,

[Former Member]

Hai Nasru,

Select ebeln

aedat

lifnr fields

from table ekko

into table t_ekko

where ebeln in s_ebeln .

<b>Select lifnr_name

spras

from table lfa1

into table t_ekko

for all entries in t_ekko

where lifnr = t_ekko-lifnr.</b>

Hope you got it.

<b>Reward points if it helps you.</b>

Regds,

Rama chary.Pammi