topic Re: SELECT TABLE in Application Development and Automation Discussions

SELECT TABLE

Former Member — Wed, 08 Aug 2007 08:23:52 GMT

i have six tables ekko, ekpo,ekkn,eskl,eskl,lfa1

and i user for inner join first three table taking ebeln

and another three table how should i write the select statement

points will awarded,help

Re: SELECT TABLE

Former Member — Wed, 08 Aug 2007 08:31:48 GMT

first chk ekko, ekpo,ekkn,eskl,eskl,lfa1

following table primary key .

afer using inner join syntax.

exaple

SELECT p_{carrid p}connid f_{fldate b}bookid

INTO CORRESPONDING FIELDS OF TABLE itab

FROM ( ( spfli AS p

INNER JOIN sflight AS f ON p_{carrid = f}carrid AND

p_{connid = f}connid )

INNER JOIN sbook AS b ON b_{carrid = f}carrid AND

b_{connid = f}connid AND

b_{fldate = f}fldate )

WHERE p~cityfrom = 'FRANKFURT' AND

p~cityto = 'NEW YORK' AND

f_{seatsmax > f}seatsocc.

try this.

Re: SELECT TABLE

Former Member — Wed, 08 Aug 2007 08:35:19 GMT

Hi,

Better go for FOR ALL ENTRIES.

Regards,

Vishvesh

Re: SELECT TABLE

Former Member — Wed, 08 Aug 2007 08:47:33 GMT

Hi Suresh,

It is not at all advisable to use inner joins on 6 tables.this will create a lot of performance problems.

You better go for 'for all entries' .

join ekko and ekkn first on ebeln.(these being the header tables)

then you can go with for all entries using entries from above.

Hope that helps.

Reward points if useful.

Harmeet

Re: SELECT TABLE

Former Member — Wed, 08 Aug 2007 09:12:13 GMT

Hi,

the following link has the relationship betwen the various tables in MM module.. this link will be able to help you find the link between the tables u specified

http://www.erpgenie.com/abap/tables_mm.htm

Regards,

Aparna

Re: SELECT TABLE

Former Member — Wed, 08 Aug 2007 09:13:29 GMT

check this:

First do inner join on ekko and ekpo.

on ekko_{ebeln = ekpo}ebeln into itab

secondly, select * from ekkn .....use for all entries in itab

where ebeln = itab-ebeln and ebelp = itab-ebelp.

third, select * from eskn....for all entries in itab

where zekkn = itab-zekkn (eskn-zekkn = ekkn-zekkn)

fourt, select * from eskl........for all entries in itab

where packno = itab-packno (eskl-packno = eskn-packno)

fifth, select * from lfa1........for all entries in itab

where lifnr = itab-lifnr (lfa1-lifnr = ekko-lifnr)

reward if useful

anju