cancel
Showing results for 
Search instead for 
Did you mean: 

To get ARE1 NO

Former Member
0 Kudos

Dear frnz,

I have a requirement to show the ARE1 number in my invoice based on the Billing Document (VBRP-VBELN)

I am trying to pick ARE1 document number based on the delivery number and excise number.

The field is J_1IEXHEAD-DOCNO.

I tried with table J_1IEXCHDR. I tried with function J_1IEX_GET_ARE_DOCUMENT also.

But I can't pick correct ARE1 number.

Is any other table has ARE1 no along with the refernce no's.

Is there any way to pick the ARE1 number based on delivery(J_1IEXITEM-RDOC1) or excise number(J_1IEXITEM-RDOC2).

Points will be rewarded.

Regards.

siva

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

select data from J_1IEXCHDR where RDOC = p_vbeln.

select data from j_1iexcdtl

where rdoc2 = J_1IEXCHDR-exnum

and exyear = J_1IEXCHDR-exyear.

select ( are1 no ) from j_1iexchdr

where trntyp = 'ARE1'

and docno = j_1iexcdtl-docno

and docyr = j_1iexcdtl-docyr.

Answers (1)

Answers (1)

Former Member
0 Kudos

I got the solution.

Thank you.

siva

0 Kudos

Hi Siva

i want to know how you are picking the ARE1 Doc. no. with ref. to Excise Invoice no.

let me know the name of table.

Thanks in advance