Precisely Software Inc.
Original Message:
Sent: 08-15-2023 18:47
From: Moazzam Mubarak
Subject: Upload template for tax codes (t-code FTXP)
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
------------------------------
Moazzam Mubarak
De Beers Consolidated Mines
AB
Original Message:
Sent: 08-15-2023 16:23
From: Sigrid Kok
Subject: Upload template for tax codes (t-code FTXP)
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
------------------------------
Sigrid Kok
Precisely Software Inc.
Original Message:
Sent: 08-08-2023 15:14
From: Moazzam Mubarak
Subject: Upload template for tax codes (t-code FTXP)
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!
------------------------------
Moazzam Mubarak
De Beers Consolidated Mines
AB
------------------------------