Automate

 View Only
  • 1.  Upload template for tax codes (t-code FTXP)

    Posted 08-15-2023 11:11

    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
    ------------------------------


  • 2.  RE: Upload template for tax codes (t-code FTXP)

    Employee
    Posted 08-15-2023 16:23

    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.
    ------------------------------



  • 3.  RE: Upload template for tax codes (t-code FTXP)

    Posted 08-15-2023 18:47

    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
    ------------------------------



  • 4.  RE: Upload template for tax codes (t-code FTXP)

    Employee
    Posted 08-15-2023 18:54

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

    Best Regards,

    Sigrid



    ------------------------------
    Sigrid Kok
    Precisely Software Inc.
    ------------------------------