Can we combine SD and MM open order qty report to single report?

[former_member200650]

Hi,

I have requirement from the business as below.User wants to combine below two reports and it should display the below mentioned fields

Already two Z reports existing in the system.

1.zsd_xxx_xxx (Open sales orders)

2.zmm_xxx_xxx ( vendor order book).

Fields to be displayed.

Sap sales order number -VBAK-VBELN

Customer PO number- VBKD-BSTKD

Material—--VBAP-MATNR

Customer PO qty--

Customer name-)

Supplier PO number--

PO Item -10--VBAP-POSNR

Doc date-VBAK-AUDAT

Vendor code—

Vendor name-

Status-AB-

PO qty-

Open qty-

Bill of lading/Airway Bill no.

HSS invoice no.

HSS invoice date.

Customer price unit.

As per my knowledge i don't see any connectivity between these two reports.

Please advise me is there any possibility to combine the SD &MM  reports  to get single one ?

thanks,

Rakesh.

[andrea_brusarestelletti · Accepted solution]

Hello,

  the information required can be obtained only if in your process, the schedule line category in configured to determine the creation of a Purchase requesition, then converted into a Purchase order. In that case you will be able to get the link between Sales Order item and Purchase Order through table VBFA (Purchase Order has Subs.doc.categ. in VBFA-VBTYP_N = 'V').

Best regards,

Andrea

[former_member200650]

Hi All,

Sorry for trouble . Today only i got the complete information from the business,

This is related to only 3rd party sales orders only, hence i think now i can achieve this,

Thank you Andrea you have rightly predicted.

Thank you all for your time, am closing the thread

regards,

Rakesh.

[former_member184701]

mate, the information you've provided is not enough.

it would be another custom report but we need to know some typical scenarios it needs to reflect.

please provide the business process example.

regards,

[srinu_s1]

I think in the selection screen if it contains both order and PO documents as input parameter you may acieve this. Am not sure let others reply on this.