-------------------------------------------------------------------------------

-- Pivot Table Part 1:

-- Put together the item number, the notes and all the

-- BU's each item number may be associated with

--

-------------------------------------------------------------------------------

SELECT DISTINCT

FPRSNOTES.ITEM_NUMBER MATERIAL_NUMBER ,

IBMCU BRANCH_PLANT ,

'OU_SPECIFIC' TEXT_SECTION ,

'EN' LANGUAGE ,

ITEM_NOTE NOTES

FROM FPRSNOTES

INNER JOIN SDT7311IB/F4101 ON ITEM_NUMBER = IMITM

INNER JOIN SDT7311IB/F4102 ON ITEM_NUMBER = IBITM

ORDER BY 2, 1