topic TABLE in Application Development and Automation Discussions

TABLE

Former Member — Mon, 11 Jun 2007 07:32:07 GMT

HAI,

I HAVE TWO TABLE TAB1 AND TAB2.

NOW I WANT JION SOME FIELD OF TAB1 AND TAB2 ? HOW ?

THANK YOU

ASHOK KUMAR

Re: TABLE

Former Member — Mon, 11 Jun 2007 07:33:04 GMT

hi,

U can use either joins or for all entries.

Re: TABLE

Former Member — Mon, 11 Jun 2007 07:37:03 GMT

HI,

try this

select a~filed from table1

a~filed2 from table1

a~filed3 from table1

a~filed4 from table1

b~filed from table2

b~filed1 from table2

into table Our internal table

from dbtable 1 as a

innerjoin dbtable 2 as b

on ( some conditions )

a~ field = b~ field

a_{field3 = b}field 3

this and

where (conditions ).

eg:

SELECT A_{FICTR D}FIPEX D_{POTYP E}BEZEI

*> 2006/08/29 Add value type.

C~WRTTP

*< 2006/08/29.

C_{OBJNR C}POSIT C_{GJAHR C}GEBER

C_{VERSN C}VORGA C_{TWAER C}FAREA

C_{WTP01 C}WTP02 C_{WTP03 C}WTP04

C_{WTP05 C}WTP06 C_{WTP07 C}WTP08

C_{WTP09 C}WTP10 C_{WTP11 C}WTP12

INTO CORRESPONDING FIELDS OF TABLE LT_BPPE

FROM FMFCTR AS A INNER JOIN FMHISV AS B

ON A_{FIKRS = B}FIKRS

AND A_{FICTR = B}FISTL

AND B~HIVARNT = C_HIVARNT

INNER JOIN BPPE AS C

ON A_{CTR_OBJNR = C}OBJNR

INNER JOIN FMCI AS D

ON C_{POSIT = D}POSIT

AND A_{FIKRS = D}FIKRS

INNER JOIN FMCIT AS E

ON D_{FIKRS = E}FIKRS

AND D_{FIPEX = E}FIPEX

AND E~SPRAS = SY-LANGU

AND E~GJAHR = '0000'

WHERE A~FIKRS EQ V_FIKRS

AND A~FICTR IN R_FICTR

AND b~parent_st NE space

AND B~CHILD_ST EQ SPACE

AND C~GJAHR EQ V_GJAHR

AND C~VERSN EQ C_VERSN

AND C~GEBER IN R_GEBER

AND D~FIPEX IN R_FIPEX

AND D~POTYP IN R_POTYP.

*> 2005/12/13 delete logic.

regards,

venkatesh

Re: TABLE

Former Member — Mon, 11 Jun 2007 07:38:10 GMT

Hi,

use syntax like this.

REPORT demo_select_inner_join.

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.

rgds,

bharat.