Item warehouse wise stock query in SAP Business One HANA

[nikunjmehta2290]

Dear all,

Need to help on query report which gives item warehouse wise stock quantity. SAP Business one HANA

Regards,

Nikunj

[LoHa · Accepted solution]

Hi Nikun

try

SELECT T0.[WhsCode], T0.[ItemCode], T0.[OnHand] FROM OITW T0 WHERE T0.[OnHand] <> 0 ORDER BY T0.[WhsCode] ASC

regards Lothar

[hdolenec]

Hi,

You can get this from OIVL table where all stock movement is stored.

[nikunjmehta2290]

Thank you.