topic Re: BCD Number in Application Development and Automation Discussions

BCD Number

Former Member — Fri, 09 May 2008 04:40:00 GMT

Hi experts,

I am getting a dump while executing one statement in a FM

The statement is:

INSERT MARA

FROM TABLE ITIO_R_MARA

ACCEPTING DUPLICATE KEYS.

The dump in ST22 says:

An exception occurred. This exception is dealt with in more detail below

. The exception, which is assigned to the class 'CX_SY_OPEN_SQL_DB', was

neither

caught nor passed along using a RAISING clause, in the procedure

"/1CADMC/OLO_000000000043567" "(FUNCTION)"

Since the caller of the procedure could not have expected this exception

to occur, the running program was terminated.

The reason for the exception is:

The data read during a SELECT access could not be inserted into the

target field.

Either conversion is not supported for the target field's type or the

target field is too short to accept the value or the data are not in a

form that the target field can accept.

It seems there is some BCD value that is to be inserted in the field /VSO/R_PAL_OVR_D of the table MARA. This is some invalid

BCD value that is being inserted into this field

Please help me out with your valuable suggestions.

I would reward all the helpful answers.

Thanks,

Ajay.

Edited by: ajay singh on May 9, 2008 6:45 AM

Edited by: ajay singh on May 9, 2008 6:50 AM

Re: BCD Number

Former Member — Fri, 09 May 2008 04:53:54 GMT

hi ajay

what is the data structure of the table u r passing?

table_i_t structurre..may be that structure is not the length of mara..check it out..

regards sas

reward points if useul

Re: BCD Number

Barada_Swain — Fri, 09 May 2008 04:54:06 GMT

Hi,

please tell what particular value you are sending for that field. The field is having a decimal part of length 3 and my first guess is you are sending a value having the decimal part with length more than 3. Which may be problem.

Thanks

Barada

Re: BCD Number

Former Member — Fri, 09 May 2008 04:56:46 GMT

Hi,

It is explaining that ,

Either conversion is not supported for the target field's type or the target field is too short to accept the value or the data are not in a form that the target field can accept.

1.So,check all the fields in Internal table are same data type of MARA or not and same length.

2.It is saying that the length of the internal table field is high.

Regards,

Shiva

Re: BCD Number

Former Member — Fri, 09 May 2008 04:59:30 GMT

Hello,

Thanks for the response.

The structure of ITIO_R_MARA is like MARA

Thanks,

Ajay.

Re: BCD Number

Former Member — Fri, 09 May 2008 05:01:22 GMT

Hi,

The best option would be making the unique index as non-unique index (Not quite sure whether it can be done or not).

https://forums.sdn.sap.com/click.jspa?searchID=11605030&messageID=2745846

Regards

Kiran Sure

Re: BCD Number

Former Member — Fri, 09 May 2008 05:04:37 GMT

Hi Barada,

Thanks for the response.

The value that this field contains is 0.000

Also, ITIO_R_MARA is like MARA.

Thanks,

Ajay.

Edited by: ajay singh on May 9, 2008 7:34 AM