SAP Business One query to retrieve inventory items by serial number

 SELECT 

    T0.ItemCode, 

    T0.ItemName, 

    T1.SerialNum

FROM 

    OITM T0 

    INNER JOIN OSRN T1 ON T0.ItemCode = T1.ItemCode

WHERE 

    T1.SerialNum IN ('serial_number_1', 'serial_number_2', 'serial_number_3')