conversion error during BDC for VA01

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hey Akankshi,

Thanks ..:-)

It is working.

Thanks & Regards

Abhishek