Skip to Content
0
Former Member
Mar 16, 2007 at 07:40 PM

Inner join select

51 Views

I had my data declaration as below.

DATA :BEGIN OF t_plaf OCCURS 0,

normt LIKE mara-normt,

matnr LIKE plaf-matnr,

pwwrk LIKE plaf-pwwrk,

paart LIKE plaf-paart,

verid LIKE plaf-verid,

auffx LIKE plaf-auffx,

psttr LIKE plaf-psttr,

gsmng LIKE plaf-gsmng,

END OF t_plaf.

corresponding inner join statement

SELECT maranormt plafmatnr

plafpwwrk plafpaart plaf~verid

plafauffx plafpsttr plaf~gsmng

INTO TABLE t_plaf

FROM plaf

INNER JOIN mara

ON plafmatnr EQ maramatnr

WHERE plaf~paart = 'LA'.

Now I have changed the declaration as below

DATA : BEGIN OF t_plaf OCCURS 0,

normt LIKE mara-normt.

INCLUDE STRUCTURE plaf.

DATA : END OF t_plaf.

now i have changed the data declaration as mentioned above and need a inner join statement for the data declaration i have specified.

Any suggestions,

MAdhu