ARE1 Print

[Former Member]

Hi,

I want to fetch export invoice no. (VF01) in ARE1 print but i am not getting eaxct table n field. if u see in ARE1 document at item level, in referance document view there you will get Delivery no. & excise invoice no. (J1iin) but not Export invoice no.

So how to fetch Export invoice no.(VF01)?

we tried J_1IEXCHDR & J_1EXCDTL

BUT form both the table we are getting Excise invoice (J1IIN) number only.

Regards,

Akshay

[jpfriends079 · Accepted solution]

Try with Table J_1IEXCDTL.

There you will find the delivery document number (RDOC1) and excise invoice number (RDOC2) for the ARE1 Form number (EXNUM) or ARE1 internal document number (DOCNO).

Use TRNTYP as ARE1 while using tcode SE16.

Hope it can assist you.

Thanks & Regards

JP

[Former Member · Accepted solution]

Hi,

Thnx for your reply.

We already tried that but that fetch Excise invoice(J1IIN)

Not an Invoice number (VF01)

my client wants Export invoice number which he is getting through in Tcode - VF01.

Regards,

Akshay

[jpfriends079 · Accepted solution]

Ok.

As per my above responds, you can get delv number. Right?

Then with reference to delv number look for invoice number.

Use Table: VBFA

Thanks & Regards

JP