Can any one tell me on which fields shell i put join . specially in likp

[Former Member]

Hi,

I have to create dispatch intimation report. tables i m using r vbrk,vbrp,likp,liks,vbpa,kna1(for customer name ref to likp),lfa1(for transporter name, makt (for material description.).

Can any one tell me on which fields shell i put join . specially in likp , vbrp and lips.

i am not getting desired output.i m joining vbrp and likp by vbeln and vbelv.

Regarda,

ranu

[Former Member · Accepted solution]

Hi,

If you put VBELN(invoice no which you are using in VBRP-VBELN) in VBFA table you will get Delivery no from VBFA-VBELV. This delivery no you can put in LIKP and LIPS tables in VBELN field.

Regards,

Suresh

[Former Member]

Hello,

In the Billing document at Item level there is a reference field which contains the Delivery document number . VBRP-VGPOS

Or else,

You can also get the delivery number from the VBFA which is the document flow, From the VBRK get the VBELN number and enter the value in the VBFA and give the document category as J which lists the Delivery document

Pick the Delivery number and goto LIPS and get the value which you require.

thanks,

santosh