Amruta,

to link 'order confirmation' with 'invoice' follow this:

Selection screen -> AFRU -> AUFK -> VBRP

1) Selection screen: 'Order Confirmation'

  Field 'RUECK'

2) Select table 'AFRU - Order Confirmations'

  Where AFRU-RUECK = RUECK (from selection screen)

3) Get 'Order Number' from AFRU table

  Field: AFRU-AUFNR

4) Select 'AFRU - Order master data' table

  Where AUFK-AUFNR = AFRU-AUFNR

5) Get 'Sales Order Number' and 'Item Number in Sales Order'

  Fields AUFK-KDAUF and AUFK-KDPOS

6) Select 'VBRP - Billing Document: Item Data'

  Where: VBRP-AUBEL = AUFK-KDAUF

  VBRP-AUPOS = AUFK-KDPOS

7) Get 'Billing Document' and 'Billing item'

  Field VBRP-VBELN and VBRP-POSNR

Hi,

AUFK - AUFNR will have PM order number

AUFK - KDAUF will have the sales order number

Populate sales order number in VBFA-VBELV with VBTYP_V = C (or sales order doc type which you have used) and VBTYP_N = M  (or invoice doc type which you have used).

VBFA-VBELN will give you the invoice number.

Then VBRK and VBRP tables can be used to get invoice details with VBELN = Invoice number.

Hope this helps !

Hi

What is your process from PM order to SD billing document? How do you link PM and SD in this process? Do you know how to find the links and data base tables? Please search for SAP tables first and create a link using SE11 or SE16N and if you find any link you can create report easily using SAP query Tools. As suggested by Lakshmipathi SD tables are VBFA, VBRK and VBRP.

Thank$

If you know how to execute SQVI, there you can table join the PM table with SD tables VBRK & VBRP

G. Lakshmipathi