Automate

Hi, everyone!

I am working to revise our order entry script due to a recent change in our functionality.  We now have added substitute items (those that have a direct replacement) into our SAP system and maintain those in VB11.  The functionality interface with customer order entry is a pop-up box that provides the user with the direct replacement item.  The line needs to be selected and the check box clicked for them to accept the new substitute item (they have to do this step).  I have no issue adding that functionality to the script, however our CSRs would like to have the new substitute item downloaded back to the original Excel order entry form so that they are aware and can communicate the change to the customer, etc.  Here is an example of the pop-up:


I need to return the new material value 10032302 (under the Item list) in this case.  I tried clicking in the field to record it, but that didn't work.  I have the following information available from SAP help - SAPMV45A --> Screen Field:  MAT_LISTE-MATNR; Table Name: MATS_AVAIL; Field Name: MATNR.

Any information or guidance that you have will be greatly appreciated!

Thank you.

------------------------------
Sue Ellen Keyser | Head of Continuous Improvement
ACTEGA North America, Inc. | 856-735-2033
------------------------------

Hi Sue

A question on your use case - are you always selecting the first material for the substitution, i.e. there is only one to select?

I don't have that pop-up to try this myself, so in general I would:

(1) look at the sales order line item (or line item details).  Does it show the substituted material selected somewhere?  If so, I would try to download from there.
(2) If not, go into expert mode and find where the substitution pop-up occurs, and then copy a row from a field that is captured into that section of the script, manually updating the technical field name, which you have.  Since it's a grid, you will have to add (01) at the end - assuming it's always the first row.  You can try to download it that way.
(3) look for a BAPI to create a sales order that handles substitution
(4)If that doesn't work, GUI scripting mode is not ideal, but it could capture a read-only field for download. 

Hope this gives you a few ideas.

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle North America
------------------------------