topic Re: hey all! in Application Development and Automation Discussions

hey all!

Former Member — Wed, 10 Oct 2007 05:08:40 GMT

can i populate one internal table by taking data from three different databse tables

...... because the internal table contains fields from different tables....???

what kind of sql query it will be.

Re: hey all!

former_member189629 — Wed, 10 Oct 2007 05:10:45 GMT

Jyoti,

U can do it as shown below,

SELECT VBAK~KUNNR

VBAK~VBELN

VBAK~AUDAT

VBAK~VBTYP

VBAP~MATNR

VBAP~ZMENG

VBAP~NETPR

VBAP~NETWR

MAKT~MAKTX

INTO TABLE IT_OUTPUT

FROM VBAK

INNER JOIN VBAP ON VBAK_{VBELN EQ VBAP}VBELN

INNER JOIN MAKT ON VBAP_{MATNR EQ MAKT}MATNR

WHERE VBAK~KUNNR IN SKUNNR

VBAK~AUDAT IN SAUDAT

VBAK~VBTYP IN SVBTYP

MAKT~SPRAS EQ SY-LANGU.

Reward if helpful,

Karthik

Message was edited by:

Karthik Potharaju

Re: hey all!

former_member376453 — Wed, 10 Oct 2007 05:11:36 GMT

Hi,

You can use JOIN statement. Check the below code.

DATA: BEGIN OF WA,

CARRID TYPE SPFLI-CARRID,

CONNID TYPE SPFLI-CONNID,

FLDATE TYPE SFLIGHT-FLDATE,

BOOKID TYPE SBOOK-BOOKID,

END OF WA,

ITAB LIKE SORTED TABLE OF WA

WITH UNIQUE KEY CARRID CONNID FLDATE BOOKID.

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.

LOOP AT ITAB INTO WA.

AT NEW FLDATE.

WRITE: / WA-CARRID, WA-CONNID, WA-FLDATE.

ENDAT.

WRITE / WA-BOOKID.

ENDLOOP.

Re: hey all!

varma_narayana — Wed, 10 Oct 2007 05:13:07 GMT

Hi ..

We can use the INNER JOIN for this..

Eg:

SELECT MARA_{MATNR MARA}MTART

MAKT~MAKTX

MARC_{WERKS MARC}EKGRP

FROM MARA

INNER JOIN MAKT

ON MARA_{MATNR = MAKT}MATNR

INNER JOIN MARC

ON MARA_{MATNR = MARC}MATNR

INTO TABLE ITAB.

reward if Helpful.

Re: hey all!

Former Member — Wed, 10 Oct 2007 05:22:56 GMT

1 way is by using JOINS

2 by selecting data from one table and then filling rest of cols by using MODIFY cmd

Regards