Skip to Content
0
Former Member
Jul 28, 2016 at 02:01 PM

Hi All

24 Views

Hi All,

I want a simple Select query in OITM where i can selct 100 particular barcodes from the whole oitm table using where statement and i want run query in SAP B1 query generator.

i tried below but not correct .Please assist me

SELECT T0."ItemCode", T0."ItemName", T0."FrgnName", T0."CodeBars", T0."OnHand" FROM OITM T0 WHERE T0."CodeBars" ='104782,

104783,

109684,

113265'

201716'