Hello
I have serial number who has status "allocated" .
They are two main table for serial number
"OSRN" = The Column "Status" give no value and is empty (i don'kt know why ?)
"OSRI" = The Column "Status" only give two value ('0' when availab...
Hello
We have set up the branch management in SAP B1 10 version Hana
We want the user who is assigned to a branch to only see Warehouse or stock related to his Branch
We activated the option " Enable Filtering Mecanisme" but it only work for Do...
Hello Can you please help me fix this query :
SELECT T1."Price" into pght FROM ITM1 T1 WHERE T1."PriceList" = '1';
UPDATE "ITM1"
SET ITM1."Factor" = T2."U_COEFFICIENT" , ITM1."Price" = T2."U_COEFFICIENT" * pght
FROM ITM1
INNER JOIN OI...
Hello
We have a customer which we implemented SAP B1 HANA in High availibility (2 Hana server in a Cluster)
And they request a new <SID>adm password that they will share to a compagny for monitoring the server .
My question is , what is the imp...
Hello
I would like to have a query that give me the bin location (BinCode) for Good Receipt document .
I tried this one :
SELECT
T0."DocNum" "NumeroDocument" ,
T4."SL1Code" "StockDesti",
T1."Quantity" "QteMvt",
T1."U_SerialNum" "NumSer...
UPDATE : I tried to change the password of "sid"adm in a test environnement using the command passwd with the shell command after loggin . HANA server was down and i had "connect refused error" and could not use any command (HDB stop or HDB start)...
Hello LotharThanks for the info but the problem is more related with serial number and bin allocationIs it possible to copy and paste directly the serial number , the correct bin allocation and warehouse in Goods issue document ?
