Regarding Report on purchase order purchase requesition and GRN No.

Dear All,

I am creating ALV report in which. I want all purchase order (EBELN), their respetive Purchase Requesition(BANFN)

And GRN No(MBLNR)., if they are created. But all purchase order should be displayed evenif their GRN have not been

made. GRN only haveing movement type 101 and 102. i.e. of 50 series and not 49 series.

i want tlike this

For Ex:-

EBELN BANFN MBLNR

45000223 1000223 5000080

45000245 5000056

45000676

45000848 .