problem in Inner join

[Former Member]

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

S

[Former Member]

hi,

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

regards,

pankaj singh

[Former Member]

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 <b>a~</b>vkorg in vkorg

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

if helps plz reward points

Regards

Bhupal Reddy

[Former Member]

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.

[Former Member]

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...

[Former Member]

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