Automate

Hi all,

I'm struggling with a script for CL20N to update characteristics for a certain class. The script works fine for the first material, but whenever I add a new material in the Excel file I get the error that "Field (RMCBC-MATNR Material) . SAPLCLFM 1100 is not an input field". I tried creating a loop in the script to avoid this, but doesn't work like it should.

When entering transaction CL20N for the first time, you need to enter the Class Type (always 001 in my case), then you're asked for the material number. After doing the changes (I use the binocular to find the correct line in the list as it is not visible in the screen directly) and clicking Save, the script is saved. In SAP however, the cursor automatically jumps then to the material field, so that you can update another material. My script will go and add the Class Type 001 again, then making the material field ineditable. If I create a loop to avoid the class type for being entered, it still doesn't work as it should. I'm obviously missing something here, but can't find it. Is there anyone who can help?

Thanks in advance,

Kind regards,

Petra van Houwelingen

AkzoNobel Decorative Coatings

HI Petra

Because the class type pop-up only happens on the first one, you will need an IF statement around that for IF First Transaction

If you attach your script, we can show you where to add it if you're unsure.

Best Regards,

Sigrid

Hi all,

I'm struggling with a script for CL20N to update characteristics for a certain class. The script works fine for the first material, but whenever I add a new material in the Excel file I get the error that "Field (RMCBC-MATNR Material) . SAPLCLFM 1100 is not an input field". I tried creating a loop in the script to avoid this, but doesn't work like it should.

When entering transaction CL20N for the first time, you need to enter the Class Type (always 001 in my case), then you're asked for the material number. After doing the changes (I use the binocular to find the correct line in the list as it is not visible in the screen directly) and clicking Save, the script is saved. In SAP however, the cursor automatically jumps then to the material field, so that you can update another material. My script will go and add the Class Type 001 again, then making the material field ineditable. If I create a loop to avoid the class type for being entered, it still doesn't work as it should. I'm obviously missing something here, but can't find it. Is there anyone who can help?

Thanks in advance,

Kind regards,

Petra van Houwelingen

AkzoNobel Decorative Coatings

Thank you Sigrid! This worked indeed, wasn't aware of the 'first transaction' option.

HI Petra

Because the class type pop-up only happens on the first one, you will need an IF statement around that for IF First Transaction

If you attach your script, we can show you where to add it if you're unsure.

Best Regards,

Sigrid

Hi all,

I'm struggling with a script for CL20N to update characteristics for a certain class. The script works fine for the first material, but whenever I add a new material in the Excel file I get the error that "Field (RMCBC-MATNR Material) . SAPLCLFM 1100 is not an input field". I tried creating a loop in the script to avoid this, but doesn't work like it should.

When entering transaction CL20N for the first time, you need to enter the Class Type (always 001 in my case), then you're asked for the material number. After doing the changes (I use the binocular to find the correct line in the list as it is not visible in the screen directly) and clicking Save, the script is saved. In SAP however, the cursor automatically jumps then to the material field, so that you can update another material. My script will go and add the Class Type 001 again, then making the material field ineditable. If I create a loop to avoid the class type for being entered, it still doesn't work as it should. I'm obviously missing something here, but can't find it. Is there anyone who can help?

Thanks in advance,

Kind regards,

Petra van Houwelingen

AkzoNobel Decorative Coatings