from which table shell i fetch invoice no i.e exnum.(vbrk,likp,j_ix...)

[Former Member]

fromHi,

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 from which table shell i fetch invoice no i.e exnum. i find it in vbrk , likp and j_ix... but dont know which is correct and what field shell i put join to fetch it properly.

Regarda,

ranu

[Former Member · Accepted solution]

Hi,

If your trying to fetch invoice number you'll get it in VBRK & VBRP itself.

If you are fetching excise invoice wrt to invoice you can establish link between VBRK & J_1IEXCHDR with VBELN & RDOC of both tables respectively.

In table J_1IEXCHDR you will get EXNUM, etc.

Hope this helps.

Regards,

Amit

[Former Member]

Hi ,

Question is not clear,

Is this the External document number, if so then you have to get the vale from VBRP-XBLNR

If it is Acconting document number, then you have to get it from the VBRK-BELNR.

If the above two are not correct then please mention the name clearly, so that we can give the soltion.

regrds,

santosh