topic mismatch in Application Development and Automation Discussions

mismatch

Former Member — Mon, 02 Jul 2007 12:53:31 GMT

I have 2 selects

select xblnr..

select belnr.. ..for all entries of i_xblnr

where belnr = i_xblnr-xblnr.

iam getting error type mismatch ,bcz iam using for all entries

How can i avoid this error?

Any conversion exit fm??

Thanks

Re: mismatch

Former Member — Mon, 02 Jul 2007 13:09:30 GMT

try FM:- 'CONVERSION_EXIT_ALPHA_INPUT'

Re: mismatch

Former Member — Mon, 02 Jul 2007 13:12:17 GMT

hi,

It might be the type / length mismatch, when you assign / compare the data the source and target strctures should be the same. Just check the For all entries internal table and second where condition fields...so that you will come to know the exact mismatch...

dont forget to check the internal table number of lines before you use 'For all entries.'

regards

reward for all useful answers.

Re: mismatch

Former Member — Mon, 02 Jul 2007 13:16:20 GMT

Hi DJ

I know source and target should be same.

Iam asking how to avoid ....alternative.

Re: mismatch

Clemenss — Mon, 02 Jul 2007 17:26:00 GMT

select xblnr into lv_xblnr.

call function 'CONBERSION_EXIT_ALPHA_INPUT'

input = lv_xblnr

output = lv_belnr.

append lv_belnr to i_belnr.

select belnr ... for all entries in i_belnr

where belnr = i_belnr-belnr.

Type should be same.

Regards,

Clemens

Re: mismatch

Former Member — Mon, 02 Jul 2007 17:31:22 GMT

If you are sure that XBLNR value will have the internal format of the BELNR (with leading zeros) and in the first 10 characters, then you can try

WHERE belnr = i_xblnr-xblnr+0(10).