cancel
Showing results for 
Search instead for 
Did you mean: 

join

Former Member
0 Kudos

hello

i wanna write join condition between between vbak , vbkd , fplt can anyone please help me..

regards,

pradeep

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Try this..



SELECT a~vbeln INTO TABLE T_VBAK    " Give the appropriate fields
             FROM VBAK AS A INNER JOIN VBKD AS B
                 ON A~VBELN = B~VBELN
             INNER JOIN FPLT AS C
                  ON B~FPLNR = C~FPLNR
             WHERE A~VBELN = '090909'.   " Give the appropriate where clause

Thanks

Naren