Skip to Content
avatar image
Former Member

Connection between J1IJ and J1IG

Hello Friends

I have a query while preparing logic for a check I need in J1IG transaction.

The check is that I want to make Additional Excise Duty(AED) mandatory while posting J1IG for a certain range of products.

For this I am making use of J_1I7_USEREXIT_EXCISE_BEF_SAVE function module

I am stuck in below scenario

5 Materials moves from one Depot to another Depot, sending depot creates delivery, does PGI and posts J1IJ with multiple materials in the document.

Now receiving depot posts goods receipt and posts J1IG. In our business practice, J1IG is posted only for 1 material at a time.

Thus for above case against one J1IJ, 5 different J1IG documents will be posted

Here I want to check while posting each J1IG, whether AED is captured in the J1IJ document, if not then I will give an error message.

I am trying to use J_1IEXCDTL and J_1IEXCHDR tables.

How do I achieve this?


Iyer Kartik

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 14, 2013 at 07:55 AM


    Linking J1IG with J1IJ may create problems, such as, if you receive material from mfg plant and in mfg plant there will not be J1IJ, there will be J1IIN. Also if you purchase a material from vendor at Depot then in this case there will not be J1IJ. So, i think, linking J1IG with J1IJ is not a good option.

    Instead of this, you can make the AED field mandatory in J1IG by validating the AED field of excise invoice in J_1IEXCDTL table.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member shailesh kurdukar

      Hi Shailesh

      I am searching for the user exit.

      I worked up a logic for J_1IRG23D but if one EI number contains multiple material entries(same material code) how do I validate the same?

  • avatar image
    Former Member
    May 14, 2013 at 09:35 AM

    Hi Karthik,

    Check is there any possibility with J_1IRG23D table. Also check the concerns of shailesh.



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks Himavath,

      I was just trying to use VBFA to establish one to one relation with Material Document, line item and Delivery line item.

      I checked the exit J_1I7_USEREXIT_EXCISE_BEF_SAVE but it accesses only J_1IEXCDTL and J_1IEXCHDR TABLES.

      Now I am trying for J_1I7_USEREXIT_DEPOT_BEF_SAVE table, I think it will solve my purpose.

      I set the breakpoint and it is triggering at the time of saving the J1IG document.

      I will let you know how it works out.

      Thanks again Himavat and Shailesh.

      Your reply has been very helpful