How to get procurement supplier number from supply plan

Hi CCC,

My requirement is to get supplier number for the suppliers in the supply plans. I could see the order_number in MSC_SUPPLIES but for some it is empty. SUPPLIER_ID in the MSC_SUPPLIES is the supplier identifier in plan not the same as POZ_SUPPLIERS. Can someone suggest the best approach/practices to get the supplier number for the suppliers in the supply plans?

Thanks,

Vishnupriya