topic Re: problem in Inner join in Application Development and Automation Discussions

problem in Inner join

Former Member — Thu, 01 Mar 2007 13:38:54 GMT

Hi All,

selection screen

select-options: vkorg for vbak-vkorg obligatory. " Sales Org

select-options: erdat for vbak-erdat. " Creation Date

select-options: auart for vbak-auart. " Order type

select-options: knkli for vbak-knkli. " Customer Account

*----

Start-of-selection.

select a~bstnk

a~vbeln

b~kdmat

b~matnr

b~werks

b~posnr

b~kwmeng

into corresponding fields of table itab

from vbap as b inner join vbak as a on a_{vbeln = b}vbeln

where vkorg in vkorg

and auart in auart and knkli in knkli and erdat in erdat.

Error (During Ctrl F2)

The column name "ERDAT" has two meanings. ABAP/4 Open SQL Statement.

Kindly let me know what is this error msg.

Thanks

Re: problem in Inner join

Former Member — Thu, 01 Mar 2007 13:41:58 GMT

hi,

check the data declaration part you would have declared erdat in you internal table or in parameters .

regards,

pankaj singh

Re: problem in Inner join

Former Member — Thu, 01 Mar 2007 13:43:11 GMT

Hi,

Please give proper alias.

select a~bstnk

a~vbeln

b~kdmat

b~matnr

b~werks

b~posnr

b~kwmeng

into corresponding fields of table itab

from vbap as b inner join vbak as a on a_{vbeln = b}vbeln

where a~vkorg in vkorg

and a_{auart in auart and a}knkli in knkli and a~erdat in erdat. (not exactly plz check in table).

if helps plz reward points

Regards

Bhupal Reddy

Re: problem in Inner join

Former Member — Thu, 01 Mar 2007 13:46:04 GMT

hi,

try giving like this...

select a~bstnk

a~vbeln

b~kdmat

b~matnr

b~werks

b~posnr

b~kwmeng

into corresponding fields of table itab

from vbap as b inner join vbak as a on a_{vbeln = b}vbeln

where vkorg in vkorg

and a_{auart in auart and a}knkli in knkli and a~erdat in erdat.

regards,

priya.

Re: problem in Inner join

Former Member — Thu, 01 Mar 2007 13:47:21 GMT

Hi ,

Change the naming convension of the Select Options as S_VKORG...etc.then change the select stmt as below and execute the same join. I hope you won't get

the error now.

select a~bstnk

a~vbeln

b~kdmat

b~matnr

b~werks

b~posnr

b~kwmeng

into corresponding fields of table itab

from vbap as b inner join vbak as a

on b_{vbeln = a}vbeln

where vkorg in vkorg

and auart in s_auart and

knkli in s_knkli and

erdat in s_erdat.

Regards,

Jayaram...

Regards,

Jayaram...

Re: problem in Inner join

Former Member — Thu, 01 Mar 2007 13:54:30 GMT

Hi,

There are conflicting names for erdat.

You have given the select-option name aslo as erdat.

change it to some other name say s_erdat.

select-options: s_erdat for vbak-erdat. " Creation Date

change the same in select also

Start-of-selection.

select a~bstnk

a~vbeln

b~kdmat

b~matnr

b~werks

b~posnr

b~kwmeng

into corresponding fields of table itab

from vbap as b inner join vbak as a on a_{vbeln = b}vbeln

where vkorg in vkorg

and auart in auart and knkli in knkli and erdat in s_erdat.

Hope it helps.

Reward if useful

Regards,

Saumya