topic bdc while uploading a data in Application Development and Automation Discussions

bdc while uploading a data

former_member661105 — Wed, 18 Mar 2020 09:45:21 GMT

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..

Re: bdc while uploading a data

Abinathsiva — Wed, 18 Mar 2020 10:00:42 GMT

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

Re: bdc while uploading a data

former_member1716 — Wed, 18 Mar 2020 11:00:26 GMT

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!

Re: bdc while uploading a data

Sandra_Rossi — Wed, 18 Mar 2020 21:10:05 GMT

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.