topic Re: BDC and dropdown list in Application Development and Automation Discussions

BDC and dropdown list

snursalim — Fri, 31 Oct 2008 04:31:26 GMT

Hi Expert

Can BDC be used to upload data where the transaction have field which is filled by using a combo box/drop down list like when we are filling personnal data and entering employee title from pa30? if yes, how do you specify that in the upload document?

Thanks before.

Re: BDC and dropdown list

Former Member — Fri, 31 Oct 2008 04:37:15 GMT

Hi,

Simple example is general BDC which is used to uplaod material master data there in MM01 first screen has 2 drop down boxes Industry sector and Material Type.

But the only thing which you have to take care is like when you select Industry sector as Mechanical Engineering in the back end i mean in Table it is stored as M so in the excel sheet we write as M.

In the same way find out what are all the dropdoen boxes present and in the dropdown boxes in which way the data is stored in the database table and prepare your excel accordingly that solves your issue.

Cheers!!

VEnk@

Re: BDC and dropdown list

Former Member — Fri, 31 Oct 2008 04:39:08 GMT

Hi,

Hope the following Threads will help you regarding your problem.

Thanks.

Nitesh

Re: BDC and dropdown list

Former Member — Fri, 31 Oct 2008 04:46:06 GMT

Hi,

While uploading if you want to select the check box for the field, enter the value as X so that the particular check box or radiobutton will be selected.

Thanks,

ThiruKumaran. R

Re: BDC and dropdown list

Former Member — Fri, 31 Oct 2008 04:51:00 GMT

hi,

before filling the bdc table with the field data just use a IF condition like IF filed is NE Initial. or some thing like if the chack box value is 'X' if yes then only process the recore ie put the field data in bdc table other wise go for next record.

shiva

Re: BDC and dropdown list

mahaboob_pathan — Fri, 31 Oct 2008 05:01:33 GMT

Hi,

While uploading you have to check in which way the data is stored in the database table and find out what are all the dropdoen boxes present and in the dropdown boxes in the transaction and check with corresponing in table and prepare your excel accordingly that solves your issue.

To select the check box for the field, enter the value as X so that the particular check box or radiobutton will be selected.