Automate

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



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

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

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

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:
Sent: 03-05-2019 11:50
From: Younus Ahmed
Subject: FB01 Posting

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

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:
Sent: 03-05-2019 12:34
From: James Tobin
Subject: FB01 Posting

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:
Sent: 03-05-2019 11:50
From: Younus Ahmed
Subject: FB01 Posting

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

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

Original Message:
Sent: 03-06-2019 15:49
From: James Tobin
Subject: FB01 Posting

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:
Sent: 03-05-2019 12:34
From: James Tobin
Subject: FB01 Posting

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:
Sent: 03-05-2019 11:50
From: Younus Ahmed
Subject: FB01 Posting

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

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

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:
Sent: 03-07-2019 13:19
From: James Tobin
Subject: FB01 Posting

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

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

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.






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

Original Message:
Sent: 03-07-2019 14:57
From: Younus Ahmed
Subject: FB01 Posting

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:
Sent: 03-07-2019 13:19
From: James Tobin
Subject: FB01 Posting

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

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