abap query

[Former Member]

how can i join a table by using abap query?

[Former Member]

Priya-

SELECT lfa1_{lifnr lfa1}stcd1

bsak_{xblnr bsak}augbl bsak~auggj

FROM lfa1

INNER JOIN bsak ON lfa1_{lifnr = bsak}lifnr

INTO TABLE i_lfa1

WHERE lfa1~lifnr = actualvendorid

AND bsak~xblnr = ap03_invoicenumber .

I hope this will help you out...

Thanks,

Venky

[aris_hidalgo]

Hi,

The above example is right. I'll give you another example:

SELECT a_{psphi b}refbn b~lifnr

FROM prps AS a INNER JOIN cooi AS b

ON a_{objnr = b}objnr

INTO CORRESPONDING FIELDS OF it_hdr

WHERE a~psphi IN so_psphi

AND a~pbukr = pa_bukrs

AND a~erdat LE v_budat

AND b~refbn IN so_ebeln

AND b~lifnr IN so_lifnr

AND b~matnr IN so_matnr

AND b~rfart = 'P'.

Regards!

[Former Member]

table should be having pri-foer key relation ship , the only u can join table in SQVI or any Joins , u cannt use Cluster table in ABAP Quey .

[Former Member]

Hi Priya,

You can join tables using JOIN statement in ABAP.

But you can not join on cluster tabels.Be sure that your join tables are not of cluster tables.<b>To Join two tables you need to have a foreign key relation ship between tables.</b> There are two kinds of joins.

<b>1)Inner Join:</b> The inner join joins the columns of every selected line on the left- hand side with the columns of all lines on the right-hand side that jointly fulfil the join_cond condition.

<b>2)Outer Join:</b> The outer join basically creates the same resulting set as the inner join, with the difference that at least one line is created in the resulting set for every selected line on the left-hand side, even if no line on the right-hand side fulfils the join_cond condition.

A maximum of 24 join expressions that join 25 database tables or views with each other can be specified after FROM.

The ABAP statement for joinin tables is as follows.

PARAMETERS p_cityfr TYPE spfli-cityfrom.

DATA: BEGIN OF wa,

carrid TYPE scarr-carrid,

carrname TYPE scarr-carrname,

connid TYPE spfli-connid,

END OF wa,

itab LIKE SORTED TABLE OF wa

WITH NON-UNIQUE KEY carrid.

<b>SELECT s_{carrid s}carrname p~connid

INTO CORRESPONDING FIELDS OF TABLE itab

FROM scarr AS s

INNER JOIN spfli AS p ON s_{carrid = p}carrid

AND p~cityfrom = p_cityfr.</b>

LOOP AT itab INTO wa.

IF wa-connid = '0000'.

WRITE: / wa-carrid, wa-carrname.

ENDIF.

ENDLOOP.

Thanks,

Vinay

Note: plz reward points to helpful answers

[Former Member]

Hi,

select single a~smtp_addr from adr6 as a inner join

kna1 as k

on k_{adrnr = a}addrnumber

into i_clientinfo-Email

where k~KUNNR = i_clientinfo-clientid.

Regards,

abhishek

[Former Member]

hi priya.

try out this.

parameters: p_matno like mkpf-mblnr.

data: begin of wt_mseg occurs 10,

zeile like mseg-zeile,

matnr like mseg-matnr,

maktx like makt-maktx,

menge like mseg-menge,

meins like mseg-meins,

end of wt_mseg.

select mseg_{zeile mseg}matnr

makt_{maktx mseg}menge

mseg~meins

into (wt_mseg-zeile,

wt_mseg-matnr,

wt_mseg-maktx,

wt_mseg-menge,

wt_mseg-meins)

from mseg inner join makt

on mseg_{matnr = makt}matnr

where mblnr = p_matno.

append wt_mseg.

endselect.

[Former Member]

howhat r the steps in table controls in user exits

[Manohar2u]

Refer to this for abap query. In info sets you can do join between tables.

<a href="http://www.sappoint.com/abap/ab4query.pdf">ABAP Query</a>

Regds

Manohar

[Former Member]

Hi,

u can go through the following two examples :

Inner Join:

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.

Outer join :

SELECT s_{carrid s}carrname p~connid

INTO CORRESPONDING FIELDS OF TABLE itab

FROM scarr AS s

LEFT OUTER JOIN spfli AS p ON s_{carrid = p}carrid AND

p~cityfrom = 'FRANKFURT'.

[Former Member]

Hi,

You can join the TABLES in the Functional Area (Info Set in 5.0 ver.) Directly. You have the 'Insert Table' Option in the Tool Bar.

Regards

BaLaji