topic data convertion when using 'BAPI_SALESORDER_CREATEFROMDAT2' in Application Development and Automation Discussions

data convertion when using 'BAPI_SALESORDER_CREATEFROMDAT2'

Former Member — Mon, 24 Jul 2006 05:09:56 GMT

Hi.

1. when i call bapi to create sales order, i fill the price condition value

' i_ORDERCONDITIONSIN-COND_TYPE = 'PR01'.

i_ORDERCONDITIONSIN-COND_VALUE = it_sdmaster-NETWR.'

and i_ORDERCONDITIONSIN is the type of BAPICOND in this BAPI.

the value is 50,000,000.000000000 which i assign, but in the order BAPI created is '500,000,000.00'

2. when i upload data from excel to sap, it converts data '0.914' into '914.000 '. The data type is DEC length 23 and decimal 4.

tks for ur help.

Re: data convertion when using 'BAPI_SALESORDER_CREATEFROMDAT2'

naimesh_patel — Mon, 24 Jul 2006 07:12:04 GMT

Hello,

Try by passing the values in the

ORDER_ITEMS_CONDS-CONDVALUE.

And where-ever your values comes like '914.000' instead of '0.914', then devide that value by 1000 (specific to this case).

regards,

Naimesh

Re: data convertion when using 'BAPI_SALESORDER_CREATEFROMDAT2'

Former Member — Mon, 24 Jul 2006 09:49:46 GMT

Hi,

Regarding the formatting issue, you could use the cell formatting in XL by using rightclick on the cell and then choose custom. In here you can specify the format as needed. So here try to keep the source and targer(SAP Format) the same.

Regards,

Re: data convertion when using 'BAPI_SALESORDER_CREATEFROMDAT2'

Former Member — Mon, 24 Jul 2006 10:01:11 GMT

Dear Gang Li

Ignore the length and decimals of the field in the BAPI Structure BAPICOND-COND_VALUE.

Supposing you need the value to be '1234.56'. Pass the value directly i.e IBAPICOND-COND_VALUE = '1234.56'.

After creating the order you can find the value for the condition to be the same, no conversion is done internally.

Do appreciate if you find the info useful.

Thanks

Eswar