topic Re: QUERY in Application Development and Automation Discussions

QUERY

Former Member — Mon, 23 Apr 2007 12:00:34 GMT

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.

lifnr = t_ekko-lifnr.

Pls suggest me the query.

Regards,

Nasru

Re: QUERY

Former Member — Mon, 23 Apr 2007 12:02:57 GMT

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.

Re: QUERY

Former Member — Mon, 23 Apr 2007 12:04:16 GMT

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

Re: QUERY

Former Member — Mon, 23 Apr 2007 12:05:53 GMT

Hi,

Use FOR ALL ENTRIES to serve for your purpose.

select *

from lfa1

into <tab name>

for all entries in t_ekko

where lifnr = t_ekko-lifnr.

Regards,

Re: QUERY

Former Member — Mon, 23 Apr 2007 12:06:05 GMT

Hai Nasru,

Select ebeln

aedat

lifnr fields

from table ekko

into table t_ekko

where ebeln in s_ebeln .

Select lifnr_name

spras

from table lfa1

into table t_ekko

for all entries in t_ekko

where lifnr = t_ekko-lifnr.

Hope you got it.

Reward points if it helps you.

Regds,

Rama chary.Pammi

Re: QUERY

Former Member — Mon, 23 Apr 2007 12:06:55 GMT

Hi Chandrasekhar,

Thank u.

Regards,

Nasru