Need Excise Inv num in Accounting Doc

[Former Member]

Hi,

My business wants the excise invoice number to populate in reference field of relevant accounting document for further reconciliation process but in J1IS both the documents are creating simultaneously so its impossible to call from table level.

I can control and release the accounting document in J1IV manually. Then I can link J1exchdr and BKPF tables but the configuration level is at excise group which affects the remaining business process. So is there any User exits or badi which fulfill my clients requirement.

Thanks & Regards,

Chandra Sekhar S 

[former_member192897 · Accepted solution]

You may create a Custom Program and Update the Excise invoice number created through J1IS/J1IV into Accounting document reference field of BKPF using tables J_1IEXCHDR and J_1IPART2 Excise tables.

You can have a Selection screen for the Custom Program with Excise Transaction type ( MATD or OTHR), Excise Group, Excise Invoice Entry date etc.

You can also run the program in Background if required. Talk to your ABAPER.

[Former Member · Accepted solution]

Hi Ashok,

Thanx for your reply...i want to know is it possible with user exit if possible can you please tell me the user exit?

and my abaper is suggesting to go with Business Transaction Events is it possible with BTE?If so how..

[former_member192897 · Accepted solution]

You cannot update the Excise invoice number into Accounting document while Posting J1IV as the Excise invoice number will Accounting document will get updated at the same time.

I have used the said Custom program to update the Excise invoice number earlier and sucessful.

I am not sure about BTE's.

[Former Member]

Hi Chandra,

Kindly try on below user exit

J_1I7_USEREXIT_EXINV_ADDL_DATA: User Exit for excise invoice additional data in J1IS & J1IG

J_1I7_USEREXIT_J1I5_MATFORM

User exit for J1I5 material form changes

J_1I7_USEREXIT_J1IEX_CHANGE    User exit for changing data before display 

Regards,

Sanjeet Kumar

[Former Member]

Hi,

   J_1IEXCHDR, BKPF tables join In SQVI(Quickviewer) tcode

its help full you.

[Former Member]

Hi Prathap,

Thanx for your reply...business is running with automatic process and this process will happen in background, i have to call the values from table and insert in the existing program however during JIIS excice inv num is not updating in the table J_1IEXCHDR until the accounting doc is generated.