In this article, we explain the B1UP entries in the User-defined-windows, why there are so many and why you from B1UP2022.06/SBO FP2202 might not see them anymore
Q: What are User-defined windows / User-defined Tables?
A: In SAP Business One you can have User-defined Tables (UDT). These can be created by the users or by Add-ons, and when done so they are shown under Tools > User-defined Windows
Q: Why do you have so many UDTs?
A: B1 Usability Package is a big Add-on, and for that, we need various tables to store our configurations
Q: But still why (other Add-ons do not have this many tables listed)?
A: That is because many other Add-ons are actually not using UDTs, but instead be making custom Database tables and they are not listed in the above screenshot.
Q: Why do you display them there, I have no need for them?
A: Prior to SBO10 FP2202 we had no choice as such. If we made a UDT it would automatically be listed in Tools > User-defined Windows list (we had no control)
Q: Why are some UDTs missing (For example I do not see Function Button Tables there)?
A: Some of our UDTs are of type UDO and that is never shown in the Tools > User-defined Windows list, so that is the reason.
Q: So, what is so special about B1UP 2022.06 and SBO10 FP2202 released in this matter?
A: In SBO10 FP2202 SAP added the ability for us to choose if a UDT should be listed in the menu or not, making it finally possible to do something about this.
B1UP 2022.06 is the first version that will leverage this above new feature in two ways:
1. We are providing a small external tool for you to mass Show and Hide User-tables
2. We are hiding almost all our UDTs by default if you are a new system and are running the required SBO10 FP2202 or higher version of SAP Business One.
Q: I'm on B1UP2022.06 and SBO10 FP2202 and I'm still seeing your UDT?
A: This is because we are only applying the new hidden by default to newly created tables in your system. We have chosen this for backward compatibility reasons, should someone be dependent on our tables for some reason... So only new systems are hiding the tables and for existing systems, you can instead use the external tool to hide the tables you wish.
Q: With almost all tables now hidden, how can I see the data or turn on/off the special features?
A: The tables are still there in the database so you can see the data if needed via SQL. We have the following article on Handy SQLs to be used with B1UP.
Q: I would like to still see some of your tables, can I bring them back?
A: Yes, just use the external tool provided in the B1UP Download. It is OK to hide any table with the BOY_ Prefix
Q: Can I use your external tool on my own Tables and UDTs from other Add-on providers?
A: Yes, But please read know limitations at the bottom of this FAQ + Ask the other Add-on providers if they have any known issues hiding their tables.
Q: Will I lose my data in the tables if I hide them?
A: No, it is just the menu item and the screen that are not visible anymore. The table itself is not affected in any way.
Q: Can I show a UDT again if I regret hiding it?
A: Yes, you can do it using our external tool on in SAPs own User-tables - Setup window
Q: Is there any features that do not work if I hide my own tables?
A: We know of 3 limitations if you hide tables in terms of B1UP (but of cause please consult other add-on vendors about their tables and whether it is "safe" to hide them)
- Known limitation: If you have a Field that is linked to the UDT and you place it on the main screen using our Item Placement Tool, the "Define new" feature will not work as it requires the menu + GUI to present the options to make new entries.
- Known limitation: If you have a Field that is linked to the UDT as part of a UDT Handler Configuration, the "Define new" feature will not work as it requires the menu + GUI to present the options to make new entries.
- Known limitation: You can't use the UF Macro Activate(table name) as that rely on the menu item being there.
Please sign in to leave a comment.