bdc while uploading a data

[former_member661105]

hi,

I am facing a problem while uploading a excel-file through BDC in the transaction code - QP02 in which assinging material to group. I need to add 22000 materials so kindly help me out.And we are getting a errror as mapl-werks is not a input field.

please give me a solution..

[Abinathsiva]

Hi Alagu Muthu,

If more number of records it's better to push with BAPI's - Try with FM - CO_QM_INSPECTION_LOT_UPDATE or BAPI BAPI_INSPECTIONPLAN_CREATE.

Regards

Abinath S

[former_member1716]

alagu123,

Strongly recommend you to consider BAPI for this Herculean task.

However with respect to the error you face request you to check the input field name if they are mapped right and also the data in the file is mapped to the right field.

Double check on all the fields you update and ensure only those fields are filled during the run.

Do remember to apply proper conversion exits where ever required.

Regards!

[Sandra_Rossi]

I am 100% sure that entering 22.000 materials via batch input (unless you would have a standard option to paste all these values from the clipboard, but I doubt a lot) is completely unreasonable because batch input performance is very low (my rule-of-thumb: 1 second per screen). Use a BAPI instead or any other possible solution.