topic Re: select statement with JOINS in Application Development and Automation Discussions

select statement with JOINS

Former Member — Fri, 24 Aug 2007 11:59:29 GMT

Hi friends,

basically i'm not a ABAPER, but i have to write this code.. and fetch the data .. i want to extract data from three tables INOB (CUOBJ ,OBJEK ), AUSP(OBJEK ,ATINN ,ATWRT ,ATFLV ) and ,CABN (ATINN, ATNAM)

these fields i want to extract so, can one give me the exact select statement with using inner join based on above common fields..

i need it urgent... answers will be highly appriciated..

regards

Babu

Re: select statement with JOINS

Former Member — Fri, 24 Aug 2007 12:09:38 GMT

IF GT_IMAK[] IS NOT INITIAL.

SELECT A~POSNR

A~OBJNR

B~PRNAM

B~POSID

B~GJAHR

FROM IMZO AS A

INNER JOIN IMPR AS B ON

A_{POSNR = B}POSNR

INTO CORRESPONDING FIELDS OF TABLE GT_INVT

FOR ALL ENTRIES IN GT_IMAK

WHERE A~OBJNR = GT_IMAK-OBJNR1.

ENDIF.

try this sample code , u have to join in Primary keys.

Regards

Peram

Re: select statement with JOINS

Former Member — Fri, 24 Aug 2007 12:12:54 GMT

select a~CUOBJ

a~objek

B~ATINN

B~ATWRT

B~ATFLV

c~ATNAM

from INOB as a

INNER JOIN AUSP as b

ON a_{OBJEK = b}OBJEK

INNER JOIN CABN as c

ON b_{ATINN = c}ATINN

into table <your final table>

where <your conditions>.

But using inner joins on three tables is not preferable

you can code like this also

Use innre join on two tables and then for all entries on third table.

rewards if useful,

regards,

nazeer

Message was edited by:

'Nazeer'

Re: select statement with JOINS

varma_narayana — Fri, 24 Aug 2007 12:14:16 GMT

Hi..

Declare ITAB with all these fields:

SELECT INOB_{CUOBJ INOB}OBJEK

AUSP_{ATINN AUSP}ATWRT AUSP~ATFLV

CABN~ATNAM

FROM INOB

INNER JOIN AUSP

ON INOB_{OBJEK = AUSP}OBJEK

INNER JOIN CABN

ON AUSP_{ATINN = CABN}ATINN

INTO TABLE ITAB.

Reward if Helpful.

Re: select statement with JOINS

seshatalpasai_madala — Fri, 24 Aug 2007 12:14:53 GMT

Hi,


DATA: begin of itab occurs 0,
INCLUDE STRUCTURE INOB.
DATA:ATINN TYPE CAMN-ATINN,
end of itab.

SELECT * FROM INOB INNER JOIN AUSP ON INOB~OBJEK = AUSP~OBJEK
INNER JOIN CABN ON INOB~ATINN = CABN~ATINN into corresponding fields of table itab.

Regards,

Sesh