topic Re: Error while using BDC in Application Development and Automation Discussions

Error while using BDC

Former Member — Wed, 30 Dec 2009 09:31:28 GMT

Hi Experts,

I have used the alv list report

for eg: the output is

vendor.no plant quantity

i had displayed quantity's sum at the end of the field(quantity),using do_sum = 'x'.

that total amount(wrbtr) should display in FB60(in amount field)

i had used bdc for this,but im getting the error as

FIELD INVFO-WRBTR. input value is longer than screen field

Can anyone suggest me on this issue.

Regards,

Sharmila.S

Re: Error while using BDC

Former Member — Wed, 30 Dec 2009 09:36:18 GMT

Check the subtotal , is it more than length 13.

You need to check INVFO-WRBTR it is having length more than what your are giving on screen.

Did you considered 2 decimal length?

Edited by: Harsh Bhalla on Dec 30, 2009 3:06 PM

Re: Error while using BDC

Former Member — Wed, 30 Dec 2009 09:38:50 GMT

the quantity field is based on the calculation.the user will enter the value.

as of now the value is 5,572,347.66

Re: Error while using BDC

Former Member — Wed, 30 Dec 2009 09:40:16 GMT

Check the data type you are using for this field which is passed to BDC.

Preferably use data type as C, with length same as the original data type.

Hope this helps!!!

Re: Error while using BDC

Former Member — Wed, 30 Dec 2009 09:43:26 GMT

If i give date type c with the original llength.Im not getting the sub total amount,it picks only the line item value

Re: Error while using BDC

Former Member — Wed, 30 Dec 2009 09:46:40 GMT

You have to pass this total quantity to the BDC screen, if i get it correctly.

Assign this total Quantity to a variable of data type C.

Pass this new variable to the BDC screen.

Re: Error while using BDC

Former Member — Wed, 30 Dec 2009 09:47:58 GMT

i had done but couldnt get the result

Re: Error while using BDC

Former Member — Wed, 30 Dec 2009 09:52:10 GMT

Also the correct length for this variable would be 16 & not 13.

13 + 2 decimal + . point.

Re: Error while using BDC

Former Member — Wed, 30 Dec 2009 09:52:30 GMT

Hi,

Try using CONVERSION routine to convert the total, that you have calculated, into input format. And then assign this converted value to the BDC table.

Regards,

Bhavesh.

Re: Error while using BDC

Former Member — Wed, 30 Dec 2009 09:55:17 GMT

i have changed field length as 16.

but now also im getting the line item value not the subtotal.

Re: Error while using BDC

Former Member — Wed, 30 Dec 2009 09:57:27 GMT

how to use the conversion routine.

i havent used this type

Re: Error while using BDC

Former Member — Wed, 30 Dec 2009 10:40:26 GMT

Check the value on runtime in debug mode.

Check what value is passed to the BDC session. You can get some help from there on.

Probably the total is not assigned correctly to the variable passed in BDC.

Re: Error while using BDC

Former Member — Wed, 30 Dec 2009 10:50:41 GMT

In debugging mode the total is fetching but in the display it is showing the error as FIELD INVFO-WRBTR. input value is longer than screen field

Re: Error while using BDC

Former Member — Wed, 30 Dec 2009 11:02:48 GMT

Take the quantity in the character field. Use CONDENSE..NO GAPS and then pass that to BDC screen field INVFO-WRBTR.

Re: Error while using BDC

Former Member — Wed, 30 Dec 2009 11:10:37 GMT

applied your concept but only line item value is coming,i need the total value

Re: Error while using BDC

Former Member — Wed, 30 Dec 2009 11:14:42 GMT

Hi Sharmila,

What I want to say is keep the data type of quantity equal to WRBTR in final internal table which you are showing in ALV.

In that case you will get the correct subtotal . And during populating BDC table take the quantity field in character and use CONDENSE..NO GAPS.

Let me know in case of any issues.

Re: Error while using BDC

Former Member — Wed, 30 Dec 2009 11:27:26 GMT

I think you are using do_sum = X for getting the total Quantity.

So the total would be availble during runtime in ALV.

Can you clarify how are you passing the total quantity to the BDC screen.

Re: Error while using BDC

Former Member — Wed, 30 Dec 2009 11:51:11 GMT

i tried exactly the same way as u mentioned

Re: Error while using BDC

Former Member — Wed, 30 Dec 2009 11:53:56 GMT

im passing the quantity to another internal table and collecting it.that collect value only im passing to bdc

Re: Error while using BDC

Former Member — Wed, 30 Dec 2009 12:02:11 GMT

If you are getting a line item value instead of total, then I guess the collect is not working properly for caluculating the total. Check if the collect statement is working properly.