Automate

Hi all, I'm wondering if anyone has created an upload template for updating sales tax rates (t-code FTXP). I'm trying to create one for US but the problem I'm running into is there are 23 rows on the screen (see attached screen shot 1 for the full screen). When I create the recording, the recording assigns a sequential number to each row L_KBETR(01), L_KBETR(02), L_KBETR(03) and so on and everything appears to be fine but when I upload the file, I get the error 

Cursor field (L_KBETR)(21) is not enabled, or is missing from screen (SAPMF82T 0131 Taxes: Tax rates (jurisdiction codes)) - sreen shot 3.

On debugging I find that the screen gets resized (shortened) when the upload runs and the upload can only find/ update the fields that are available in this resized screen -screen shot 2 hence it says the fields is not enabled or missing from the screen. In other words, it cannot access the fields that are not visible in the resized screen. I tried created a new script using tabs, hoping the cursor gets moved to the next row which is not visible in the resized screen but that didn't work either.

I used an option in the past to show the full screen at the time of screen recording or debugging but the script I will create will be used by other business users so I'm looking for a better option which could work for all users. Using a BAPI could be a better option in this situation but I searched and could not find a BAPI for t-code FTXP. 

Can someone help with a screen recording or BAPI solution whatever has worked for them. I am using Winshuttle Studio 12.1, WinshuttleFM 20.2 in an S/4 environment.

Thank you!

Hi Moazzam

In programmers logic, you have 23 rows, so you use an index from 1-23. 

But SAP doesn't always work that way in grids. 

Please see screen shot below - after I page down, it's restarting from (01),(02) - so that's how it works - with each page down, it restarts numbering from 01:

In my quick test I edited the first row that was editable for me - row 3 and then did a page down (note I could have edited every row if that was the purpose).

After that, it restarts numbering 01, 02, etc - the first 2 rows on the next page full.

I did a quick search and didn't find a BAPI/rFM, but there may be one out there if you look for it.

Hope that helps,

Sigrid

Hi Sigrid, 

Thanks so much for the tip. I never used the Page Down key for any of my scripts and had no idea it can be used in cases like this. I created a new script with this option and it worked like a charm :)

I already checked BAPI's and couldn't find any BAPI for FTXP. 

I appreciate your help.

Moazzam

That's so great, Moazzam, well done!  And thanks for letting us know it worked!

Best Regards,

Sigrid