topic Re: conversion error during BDC for VA01 in Application Development and Automation Discussions

conversion error during BDC for VA01

Former Member — Thu, 24 May 2012 09:36:32 GMT

Hi All,

I have recorded va01 transaction.

There i am inserting data into following fields

VBAK-AUART

VBAK-VKORG

VBKD-BSTKD

VBKD-BSTDK

KUAGV-KUNNR

KUWEV-KUNNR

RV45A-KETDAT

RV45A-KPRGBZ

RV45A-MABNR(01)

RV45A-KWMENG(01)

All the field except KWMENG are Char type but KWMENG is of Quantity type with decimal 3.

So i have made an excel sheet containing all data and All the fields except KWMENG are of Text type and KWMENG i have made integet type (with 1000 separator) .

Now i am using TEXT_CONVERT_XLS_TO_SAP Function module to convert but it is showing Conversion Failure Error.

Also i have used ALSM_EXCEL_TO_INTERNAL_TABLE Function module but there also i was facing same problem Conversion Failure.

How to solve this problem ?

Thanks and Regards

Abhishek

Re: conversion error during BDC for VA01

Former Member — Thu, 24 May 2012 13:04:03 GMT

Hi,

It is because SAP is expecting number without thousand separator.

So, it's better if you use it as a text field and then replace the thousand separator programmatically.

Re: conversion error during BDC for VA01

Former Member — Fri, 25 May 2012 09:49:13 GMT

Hi,

You can try doing the following:

Declare one variable of character type and assign the value to that like below:

data : v_quan type p decimals 3,

v_char(18).

v_char = v_quan.

Hope it serves useful to you.

Re: conversion error during BDC for VA01

Former Member — Fri, 25 May 2012 10:15:55 GMT

Hey Akankshi,

Thanks ..:-)

It is working.

Thanks & Regards

Abhishek