Another option:
SELECT
BKARHINV.BKAR_INV_NUM,
BKARHINV.BKAR_INV_SONUM,
BKARHIVL.BKAR_INVL_PCODE,
BKICMSTR.BKIC_PROD_CLASS
FROM (BKARHINV INNER JOIN BKARHIVL ON BKARHINV.BKAR_INV_NUM = BKARHIVL.BKAR_INVL_INVNM)
INNER JOIN BKICMSTR ON BKARHIVL.BKAR_INVL_PCODE = BKICMSTR.BKIC_PROD_CODE
This query will pull the information of SO that have been shipped (Well, with DBA tables structure you never now)
Anyways, here ya go!!!
Kelloggs