Zreport- Open raw material PO's tracking based on Finished Product

[Former Member]

Hi all,

My client want to track open raw materials PO's based on Finished product. We developed Z report according to that.

For understanding, I have attached file please go through that.

In my report i am unable to segregate raw materials PO's based on finished product.

Could you please suggest me how can segregate raw materials PO's based on finished product ?

Thanks & Regards,

GKR

[thanga_prakash]

Hello GKR,

As I understand your internal table will have the records like this.

Finished	Raw material	Open PO
FN1	RM1	100001
FN1	RM1	100009
FN1	RM1	100011
FN1	RM1	100014
FN1	RM1	100018
FN1	RM2	100008
FN1	RM2	100007
FN2	RM3	100008
FN2	RM3	100012
FN2	RM1	100001
FN2	RM1	100009
FN2	RM1	100011
FN2	RM1	100014
FN2	RM1	100018

You can achieve this by using DELETE DUPLICATES FROM itab COMPARING raw material and Open PO.

The result table will have the records as per your expectation.

Regards,

Thanga