Hi Together,
since SAP B1 10 2305 the B1upf.xml does not containing the UserNames in clear form anymore.
For years I use a query to get a complete overview about licenses assigned to my users. Now it is not possible anymore.
Did someone has an ...
Hi All,
since the last versions in SAP Business one, it is possible to reopen an invoice manually.
I tried to figure out to get this documents, by query, but can't find a field for it.
Any suggestion?
Thank you
Hi All,
I'am facing the issue that the function "GetSystemPermission" is not working anymore in SAP10.
I want to receive the effective permisssion, not the user permission, because he was added to a group.
Using this Code:
SAPbobsCOM.SBObob...
Hi Community,
I'am facing a problem with min/max values in ItemMasterData Warehouse lines.
When adding min/max to the lines.(Manage Inventory by Warehouse is ticked)
Starting to fill the min. Inventory (OITW.MinStock) leads to the Minimum (OITM...
Hi Community,
I'd like to introduce the customer influence to you.It gives us the possibility to propose new features and improvements in SAP.
The problem is, it will only work if enough people vote for a new idea and often enough the feature is ...
Hi Johan, normally I would say you are right, but at least the user is weakest part of the chain. Meanwhile I found every kind of possibilities in our DB
Hi,if you want it complete real icluding the dates you can make a function. It returns Y/NUSE [YOURNAME]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:
-- Create date:
-- Description: ...
Hi Bradderz,best practice for boms is a recurisve query.WITH Data as
(
SELECT
1 AS [Level]
, OITT.Code AS [HeadCode]
, OITT.Code AS [LevelCode]
, ITT1.Code AS [ItemCode]
, OITM.ItemName
, ITT1.Quantity
FROM
OITT
INNER JOIN ITT1 ON
...
Hi,it seems that you use HANA. Normally in SQL i would say th best practice would be a pivot table but it is not avaiable in HANA but here is a workaroundhttps://community.sap.com/t5/technology-blogs-by-sap/how-to-pivot-unpivot-in-sap-hana/ba-p/13420...
Hi perhaps they changed the times in their personal settings.And I can remember in the past, there has been a function: if you lose the alert window by X you 'll get asked if it should be closed without opening again. I don't if it is still possible ...
