Automate

I have created a Winshuttle script to load statistical key figures into SAP from an excel template, but no matter what I try I can't get the script to post the data and then go back to the SAP prompt and process the next row in the load template.  In other words, I can only get the script to process 1 row of data at a time...all subsequent rows fail. 

Any suggestions would be appreciated.

• Recording mode = Non-Batch with controls (10.7.3)
• The SAVE button acts as a POST function for this transaction and when it's triggered SAP returns an informational message with the document number that was posted.  Unfortunately when you perform this function in script recording mode, Winshuttle immediately terminates the recording and leaves you inside the transaction and not at the SAP prompt.  
• I was able to create a script with a Loop to allow for multiple entries within a specific fiscal period, but it also has the same issue.  i.e. I can't get the script to move to the next set of data points

   


------------------------------
Len Landry | Senior Financial Analyst
Clearwater Seafoods | 902-457-2364
------------------------------

Hi Len

I believe there's a simple fix for this.   The first time you go thru the tcode, it will pop-up asking you for a company code.  If you click to skip it if not present, it will work for the subsequent rows, since it only pop-ups for the first one.  You could also use an IF and choose if first row in the dropdown of the If.

It's always good to test more than one posting, because sometimes either the first, or not the first row, will be different.  You can find it if you run 2 postings thru Debug mode and see what's different as it walks thru your script in the tcode.

Am also attaching a version that uses a loop that I created quite some time ago in v11.  It uses the same skip if not present.

Hope that helps!

Best Regards,
Sigrid

------------------------------
Sigrid Kok
pse | Winshuttle North America
------------------------------

Original Message:
Sent: 11-19-2019 16:01
From: Len Landry
Subject: KB31N Transaction - Entering actual Statistical Key Figures

I have created a Winshuttle script to load statistical key figures into SAP from an excel template, but no matter what I try I can't get the script to post the data and then go back to the SAP prompt and process the next row in the load template.  In other words, I can only get the script to process 1 row of data at a time...all subsequent rows fail.

Any suggestions would be appreciated.

• Recording mode = Non-Batch with controls (10.7.3)
• The SAVE button acts as a POST function for this transaction and when it's triggered SAP returns an informational message with the document number that was posted.  Unfortunately when you perform this function in script recording mode, Winshuttle immediately terminates the recording and leaves you inside the transaction and not at the SAP prompt.  
• I was able to create a script with a Loop to allow for multiple entries within a specific fiscal period, but it also has the same issue.  i.e. I can't get the script to move to the next set of data points

------------------------------
Len Landry | Senior Financial Analyst
Clearwater Seafoods | 902-457-2364
------------------------------

Thank you Sigrid that was the issue.  I had put an "If first transaction" condition around the data entry field but not around the entire screen in the script.  Once I corrected this the script worked.

Len Landry

------------------------------
Len Landry | Senior Financial Analyst
Clearwater Seafoods | 902-457-2364
------------------------------

Original Message:
Sent: 11-20-2019 10:03
From: sigrid kok
Subject: KB31N Transaction - Entering actual Statistical Key Figures

Hi Len

I believe there's a simple fix for this.   The first time you go thru the tcode, it will pop-up asking you for a company code.  If you click to skip it if not present, it will work for the subsequent rows, since it only pop-ups for the first one.  You could also use an IF and choose if first row in the dropdown of the If.

It's always good to test more than one posting, because sometimes either the first, or not the first row, will be different.  You can find it if you run 2 postings thru Debug mode and see what's different as it walks thru your script in the tcode.

Am also attaching a version that uses a loop that I created quite some time ago in v11.  It uses the same skip if not present.

Hope that helps!

Best Regards,
Sigrid

------------------------------
Sigrid Kok
pse | Winshuttle North America

Original Message:
Sent: 11-19-2019 16:01
From: Len Landry
Subject: KB31N Transaction - Entering actual Statistical Key Figures

I have created a Winshuttle script to load statistical key figures into SAP from an excel template, but no matter what I try I can't get the script to post the data and then go back to the SAP prompt and process the next row in the load template.  In other words, I can only get the script to process 1 row of data at a time...all subsequent rows fail.

Any suggestions would be appreciated.

• Recording mode = Non-Batch with controls (10.7.3)
• The SAVE button acts as a POST function for this transaction and when it's triggered SAP returns an informational message with the document number that was posted.  Unfortunately when you perform this function in script recording mode, Winshuttle immediately terminates the recording and leaves you inside the transaction and not at the SAP prompt.  
• I was able to create a script with a Loop to allow for multiple entries within a specific fiscal period, but it also has the same issue.  i.e. I can't get the script to move to the next set of data points

------------------------------
Len Landry | Senior Financial Analyst
Clearwater Seafoods | 902-457-2364
------------------------------