Excise Invoice number aginat sales order

[Former Member]

Hi,

Is there any report available in SAP where as we can be excise invoices raised against particular sales order or scheduling agreement

Rgds,

Saurabh

[Former Member · Accepted solution]

Hi,

that is not possible i feel...

bt u can get deleivery no. from sales order (VBFA table)

then in table J_1IRG23D u can get excise invoice no.. by putting delivery no...

thanks

mk

[Former Member]

thanks.

[Former Member]

hi

To get the Sales order number from excise invoice you have to use the below table

Pass the EXNUM (official excise invoice number) into table J_1IEXCDTL and get RDOC2(billing doc number)

Now pass this RDOC2 to into table VBRP-VBELN and fetch the data for VBRP-AUBEL (sales order No)

regards

Edited by: PRASHANTHgoud on Mar 19, 2010 1:24 AM

[Former Member]

Hi

Kindly use thed tables

J_1IEXCHDR

VBRK

VBRP

REgards

Damu