how to provide relation b/w sales order number & purchase order number

[Former Member]

hi.....

i created one report based on sales order number and displayed by alv grid then by selecting one sales record using bdc i created purchase order number ,then i have to display that purchase order in alv again,hoe to provide relation b/w sales order and purchase order

[kesavadas_thekkillath]

This is what VA05 Does

 SELECT bstkd  
               vbeln  "Sale order Number
               posnr
          FROM m_vmvaa
          INTO TABLE i_m_vmvaa
          FOR ALL ENTRIES IN i_bstkd
          WHERE bstkd = i_bstkd-bstkd.   "Your PO Number

[Former Member]

hi thanks for u r reply

what are all the database tables required for extracting the data vbeln & bstkd .

Moderator Message: Consult your Functional Specifications/Consultant.

Edited by: kishan P on Sep 16, 2010 9:46 AM