Automate

 View Only

  • 1.  FB01 Posting

    Posted 03-01-2019 11:49
    My recording uses FB01 and if Profit Center is a required field in the account then there are no issues.  However if Profit Center is optional it doesn't appear on the first screen and instead will only appear if you click on More in FB01.  

    I cannot include PRCTR in both screens using the same upload field.  Any suggestions on how to make a condition work or any other suggestion?  Thanks

    Isevb5WQru1vBachtXns_FB01.jpg

    ------------------------------
    James Tobin
    ------------------------------


  • 2.  RE: FB01 Posting

    Posted 03-05-2019 04:40
    ​The way I got around this was to get the field status group of the account, and then only post the fields needed (or enter the more data screen)

    It's unfortunately a two script process that way..I think there may be a BAPI solution as well.

    ------------------------------
    Stephen Butler | Systems Analyst
    RSA Insurance Group Plc
    ------------------------------

    Original Message


  • 3.  RE: FB01 Posting

    Posted 03-05-2019 11:51
    As Stephen mentioned, it depends on the Field Status Group (FSG) assigned to the G/L account you are using. 

    To overcome this issue, I recorded a script using a specific G/L account where all fields were optional. In my case, the field status group of this G/L account was G999 and I think this is not standard SAP so might not be same in your organization. You can check all FSGs in SKB1 table and go from there. 

    @Winshuttle Support might have a better solution. ​

    ------------------------------
    Younus Ahmed | Data Quality Analyst
    Smith & Nephew, Business Services
    ------------------------------

    Original Message


  • 4.  RE: FB01 Posting

    Posted 03-05-2019 12:35
    Stephen, Younus,
    thank you both for your responses.  We have an "all optional" FSG created so can give it a go.

    Where do you include the code (condition) to check the FSG for each line item?  Can you send an example of the code you use?

    For now we made the account as Profit Center required but there will no doubt be another situation like this yet undetected.  It must be a common issue if using FB01 but not so if using FB50 or the other enjoy transactions.

    ------------------------------
    James Tobin
    ------------------------------

    Original Message


  • 5.  RE: FB01 Posting

    Posted 03-06-2019 15:49
    I tried posting to an account where all fields are optional but Profit Center is still under the More tab.  

    In the script I cannot reference the same template field twice.  One solution is to use an additional column over to the right hand side on the template with a simple formula to reference the Profit Center updated in Column I for example.  I would use COBL-PRCTR in both screens.

    This must be a common problem so I'm interested in hearing other solutions.

    ------------------------------
    James Tobin
    ------------------------------

    Original Message


  • 6.  RE: FB01 Posting

    Posted 03-07-2019 12:14

    Hi James,

    Unfortunately, it wasn't straight forward when I recorded a similar script as well. I just realized I had to change some of the cursor positions on the script to ensure it works on all FSGs. Please see the screenshot attached. 

    Please note that this will only work for FSGs where Profit Center is optional or mandatory. It will still fail for some where Profit Center has been suppressed. 




    ------------------------------
    Younus Ahmed | Data Quality Analyst
    Smith & Nephew, Business Services
    ------------------------------

    Attachment(s)

    TxR
    FBS1_new.TxR   79 KB 1 version
    Original Message


  • 7.  RE: FB01 Posting

    Posted 03-07-2019 13:19

    Hi Younus,

    If the account has profit center mandatory then you will find that COBL-PRCTR appears in SAPMF05A as well as SAPLKACB.  How would you handle it in that case? 

     

    As a side note I found turning off the BDC_CURSOR fixed some issues around if the field didn't appear on screen but sometimes it is required

     

    James

     




    Original Message


  • 8.  RE: FB01 Posting

    Posted 03-07-2019 14:57
    I recorded my script using "all fields optional" FSG so it worked if the Profit Center is mandatory or optional. If you are doing the same thing, then you should see Profit Center only once. Disable the profit center at the main screen SAPMF05A and only enable the one from the More screen SAPLKACB.

    ------------------------------
    Younus Ahmed | Data Quality Analyst
    Smith & Nephew, Business Services
    ------------------------------

    Original Message


  • 9.  RE: FB01 Posting

    Posted 03-11-2019 01:17
    Appreciate you sticking with me on this!

    If an account has an FSG with all optional I do not see Profit Center on the main SAPMF05A 0300 screen only under more (1st screenshot). 

    If I change the account to Profit Center mandatory then only then it appears on SAPMF05A 0300 (2nd screenshot).

    I'm toying with the idea of using the Fast Data Entry screen but its going to be a total re-write of my scripts and trying to avoid that.  If I could somehow get COBL-PRCTR from both screens to reference difference excel cells then I'll simply add an additional column but in Studio 11.4.1 it seems that only one value can be referenced even though they are different screens.

    FB01_FSGAllOptional


    FB01_FSGPCMandatory

    ------------------------------
    James Tobin
    ------------------------------

    Original Message