topic Re: Quantity field. in Application Development and Automation Discussions

Quantity field.

Former Member — Fri, 14 Mar 2008 13:23:47 GMT

Hi experts.

I have Character field in my program.

ex x(13).

This is acutally contains amount.

Now I need to update data base table using this field.

But data base table is WRBTR type.

It results me dump.

I tried using type N.but decimals are trunctaed.

I tired with type P results in dump.

I need to have extact values in Db table.

so that.I can sumup afterwards.

I cannot chnage the Char field in program.Becuase the field I am getting from interface file.

Kindly give me some solutions

Thanks

Re: Quantity field.

Former Member — Fri, 14 Mar 2008 13:27:46 GMT

HI,

Data:temp like bseg-wrbtr.

temp = x.

Re: Quantity field.

Former Member — Fri, 14 Mar 2008 13:29:24 GMT

You have to first define a new field that matches your table field's data element.

data: l_amount like table_name-WRBTR.

l_amount = x. "ABAP engine automatically converts the data

Now, update the database table with l_amount.

Re: Quantity field.

Former Member — Fri, 14 Mar 2008 13:29:34 GMT

Please look that char field v_x does not contain any ','(comas)

Look at below code .. this works fine for me ... (no dump)

data : v_data type WRBTR.

data : v_x(13) value '12345.67'.

move v_x to v_data.

write 😕 v_data.

Re: Quantity field.

Former Member — Fri, 14 Mar 2008 13:35:41 GMT

Thanks for you anwer.

I have rewarded for you answer.

I have one more question.

I have commas to in that field.

Kindly tell me how to proceed

Re: Quantity field.

Former Member — Fri, 14 Mar 2008 13:38:14 GMT

use ...

replace all occurrences of ',' in v_field with ' '.

condense v_field.

Re: Quantity field.

Former Member — Fri, 14 Mar 2008 13:53:25 GMT

hi,

could you correct me on this.

replace all occurrances of ',' in amexbdcsav1-amount with ' '.

condense amexbdcsav1-amount.

thanks and Regards

Re: Quantity field.

Former Member — Fri, 14 Mar 2008 13:59:01 GMT

amexbdcsav1-amount should be the character field ...

and not the amount field ...

replace all occurrences of ',' in amexbdcsav1-amount with ' '.

condense amexbdcsav1-amount.

after this use move ...

data : v_data type WRBTR.

data : v_x(13) value '12,345.67'.

replace all occurrences of ',' in v_x with ' '.

condense v_x.

move v_x to v_data.

Re: Quantity field.

Former Member — Fri, 14 Mar 2008 14:08:06 GMT

yes it is caracter field.

But I am getting error when i am doing the sytax check.

occurrences of ',' in not expected.

Here is my code.

replace all occurrences of ',' in amexbdcsav1-amount with ' '.

condense amexbdcsav1-amount.

W_QUNT = amexbdcsav1-amount.

WA_ZAMEXTRAVEXP-WRBTR = W_QUNT.

Kindly help me.

Thanks and regards

Re: Quantity field.

Former Member — Fri, 14 Mar 2008 14:11:13 GMT

Iam getting the o/p with the same statement ..

don't copy / paste .. type in manually ... this might work ...

replace all occurrences of ',' in v_x with ' '.

condense v_x.

Re: Quantity field.

Former Member — Fri, 14 Mar 2008 14:37:08 GMT

hello,

I have typed manullay its not working with me.

I am in 4.6 will this make any difference.

Re: Quantity field.

Former Member — Fri, 14 Mar 2008 14:45:42 GMT

that might be the reason.

Re: Quantity field.

Former Member — Fri, 14 Mar 2008 14:59:28 GMT

how are you populating the character field with quantity ..

initially. RU getting the amount from any file ..

Re: Quantity field.

Former Member — Wed, 20 Jul 2011 08:07:05 GMT

Self answered