Skip to Content
0
Former Member
May 01, 2009 at 10:15 AM

SQVI Illegal Join condtions

1896 Views

Hi,

When trying to join a table in SQVI, i get the message "illegal join condtions". However if i try to do the same thing in ABAP, the compiler is fine with it.

SELECT bp_id

FROM /vwk/cms_dbbp001 AS bp_mast

JOIN /vwk/ccs_conbupa AS ccs

ON bp_mastbp_id = ccsbupa_id

INTO w_bp_id.

ENDSELECT.

The types of the field which i want to join are different (bp_mastbp_id is type DEC 10 and ccsbupa~id is Char 10).

Please advise how i can get SQVI Quickveiwer to accept the join, or explain why it thinks it is an "illegal join condtion". Many thanks,