link table to get sale order invoice document for a GR document

[former_member257766]

Dear All,

We are using drop shipment process where purchase order assigned to a sale order , when we do GR on PO cost will be booked on sale order then further we will do invoice on sale order . Now we need to find a table where we can find sale order invoice document for a GR document posted on sale order.

we need this help <text removed by Moderator to normalized the priority> , thanks in advance for your suggestion.

Regards

Kamal

Message was edited by: Jyoti Prakash

[former_member186385]

Hi Puneet,

As I understood, you are posting the GR value to the Sales order condition types. After that you are doing Sales Order related Billing document. Now you want to link Billing document and GR document ?

Is my understanding correct ?

thanks

santosh

[former_member257766]

hi santosh

yes , your understanding is correct.

I need to know link between billing document and GR document

Regards

Kamal

[siva_vasireddy2]

Hi,

Confirm if the GR is created with reference to the delivery document

did you check in the table -VBFA with subsequent document category- i

[former_member186385]

Hi ,

There is no direct link. You have to write a Query

If you have GR number, then get the sales order number from MSEG -KDAUF. Pass this sales order to VBFA table VBFA-VBELV and get VBELN where VBTYP_N = M

try this and revert with your feedback

thanks

santosh