bdc error

[Former Member]

while doing bdc i am unable to pass values from excel to sap program....because in excel i am entering the values ( for XK01) but in excel sheet the account group is taking as 7 but i m trying to enter it as 0007, i managed to pass 0007 but in sap transcation it is not taking 0007 but it is taking 7 can you help out on this

[Former Member]

Hi Mayur,

This is because excel has identified values as numbers thus converted 0007 to 7.

Select the Column, right click on column heading, select format cells, select 'TEXT' from categories in 'NUMBER' tab.

This will convert your number to text and excel will maintain it as 0007.

Thanks and Regards,

Anurag

[Former Member]

You should use conversion routine.

for example.

if you pass material code as 10.

use conversion routine "CONVERSION_EXIT_MATN1_INPUT"

material code will be 000000000000000010

same as you need to find conversion routine for required field.

-Avirat

[Colleen]

Hi Mayur

Are you trying to enter 0007 in Excel but Excel is storing it as 7 (i.e. removing the preceding zeros)?

If that is the case, add a single quotation as the front of your value in the Excel Cell and it will keep the zeros. Then when you save the the files the zeros will be there. This is basic Excel usage

Enter '0007 instead of 0007

If you mean something else can you please include screen shots or attempt to improve your post with basic grammar.

Regards

Colleen