My Requirement :
I have 4 material. MAT1, MAT2, MAT3, MAT4.
MAT1 - has an Open Purchase Order.
MAT2 - No Purchase Order Placed.
MAT3 - No Purchase Order Placed.
MAT4 - has a Closed Purchase Order.
Could any one help me from which tables and fields I can get these information, that for a material number there has not been a purchase order placed and which has an open or a closed one.
Will Reward on helpful answers.