BDC and dropdown list

[snursalim]

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.

[snursalim]

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.

[Former Member]

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@

[Former Member]

Hi,

Hope the following Threads will help you regarding your problem.

Thanks.

Nitesh

[Former Member]

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

[Former Member]

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

[mahaboob_pathan]

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.