02-07-2007 11:31 AM
select avbeln akunag br_desc bcreate_date c~name1 into corresponding
fields of table itab from vbrk as a inner join zsdinvrej as b on
avbeln = bi_vbeln inner join kna1 as c where akunag in s_kunag and bcreate_date
in s_fkdat.
this statement show me error
i adding three table plsea help me solve the problem
02-07-2007 11:35 AM
hi Siva,
Condition missing
select avbeln akunag br_desc bcreate_date c~name1 into corresponding
fields of table itab from vbrk as a inner join zsdinvrej as b on
avbeln = bi_vbeln inner join kna1 as c <b>on<condition></b> where akunag in s_kunag and bcreate_date
in s_fkdat.
02-07-2007 11:33 AM
Hi Siva,
In the statement for the second inner join
inner join kna1 as c
where is the on condition.
Please specify that also and then check.
Regards
Arun
02-07-2007 11:34 AM
Hi,
the problem is with 'inner join kna1 as c', join contion 'ON' is missing...
02-07-2007 11:35 AM
hi Siva,
Condition missing
select avbeln akunag br_desc bcreate_date c~name1 into corresponding
fields of table itab from vbrk as a inner join zsdinvrej as b on
avbeln = bi_vbeln inner join kna1 as c <b>on<condition></b> where akunag in s_kunag and bcreate_date
in s_fkdat.
02-07-2007 11:36 AM
Hi Siva,
What is the error you are getting ?
Use <b>Inner Join as</b>
INNER JOIN AS a ON <i>conditions</i>
AND <i>conditions</i>
AND <i>conditions</i>)
Regards
Kannaiah
02-07-2007 11:41 AM
Hi
there is no condition for join 3 on KNA1
put some condition
select avbeln akunag br_desc bcreate_date c~name1 into corresponding
fields of table itab from vbrk as a inner join zsdinvrej as b on
avbeln = bi_vbeln inner join kna1 as c on
<b>condition</b>
where akunag in s_kunag and bcreate_date
in s_fkdat
Regards
Shiva
02-07-2007 12:42 PM
try this format....
SELECT <choose entries> INTO CORRESPONDING FIELDS OF TABLE IT FROM <table1> INNER JOIN <table2> ON <join condition> INNER JOIN <table 3> ON <join conditions> WHERE <select conditions>.
with regards
vinayaka