BODI XI + SAP R3 Module SD

dataservices job design
1

Hello,

I try to use in DF a RFC Module Function.

I use only mandatory parameters.

The prbolem is that when I execute the workflow with this dataflow it returns this error :

7192 2280 RUN-050802 26/07/07 14:48:18 Cannot convert data <7510.42> into type . Context: Column <>.

But the value is correct ! :hb:
I don’t have choice to the returned parameter’s type.

The worst is that I only call the Module function in my DF I don’t use its results now !! So it means that the call is correct (correct value returned) BUT that BODI is interpreting the value as non decimal !!

I do need some help,

thanks in advance

ausylan :fr: (BOB member since 2005-01-10)

2

Hi,

Does funtion module is returning NULLs or any default values which cant be converted to numbers ?? For NULLS,Please apply the function like nvl(COLUMN,0) and then try…
Try that and let us know if any updates/concerns.

Regards.
Santosh.

SantoshNirmala :india: (BOB member since 2006-03-15)

3

hello

thanks for your advice. but the thing is that the function return a value : 7510.42 BUT it says that it’s impossible to convert into decimal…!! :o

perhaps the code page or any parameter on my SAP datastore in BO DataIntegrator might help solving my issue …???

When I put the result of module function into the next query field with NVL(…) it neither doesn’t work … :hb:

ausylan :fr: (BOB member since 2005-01-10)

4

Hi,

We use UTF-8, we do use some function module which return some 100 thousand values of different type. What is the code page you are using.

Else we can do one thing assin the return value from the function module into a varchar type column and then convert it to whatever format you need, this may/may not work for you, just a suggestion.

Regards.
Santosh.

SantoshNirmala :india: (BOB member since 2006-03-15)

5

hello again,

thanks for you answer. We are about to try to return a varchar instead of decimal like you submited.

my codepage is cp1252 and language is english.

thanks in advance for any new help,

I’ll let you know about the tests…

ausylan :fr: (BOB member since 2005-01-10)

6

R/3 datastore language is english?

Werner Daehn :de: (BOB member since 2004-12-17)

7

Hi,

Yeah, the language the written ABAP can be one of English,German, French and Japanese.

Regards.
Santosh.

SantoshNirmala :india: (BOB member since 2006-03-15)

8

hello,

yes R/3 language is english…

Thanks to your post, I changed datatype of the parameter that I wanna use in return of the module function from decimal to varchar.

It worked ! Bue I got to see why certain values don’t work… I think that SAP return negative value as this : xxx.xxx-

So certainly when I’'l decode the varchar value to see if it contains ‘-’ I’ll be able to pass all values ! :slight_smile:

thanks again,

ausylan :fr: (BOB member since 2005-01-10)