on 07-16-2008 11:17 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I got the solution.
Thank you.
siva
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.