Connection between J1IJ and J1IG

[Former Member]

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?

Regards

Iyer Kartik

[former_member187965]

Hi,

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.

[Former Member]

Hello Shailesh

I want this for traded items and only for Depot to Depot stock transfer scenario.

These materials are not manufactured in any of our plants.

In you last sentence you mentioned making AED mandatory.

But how to do it selectively only a particular logic?

[former_member187965]

Hi,

You have to validate below points,

1) AED field value for the excise invoice in J_1IRG23D table.

2) Material codes from the EI with traded items material group or material type

If above two conditions are satisfied then make the AED field as mandatory in J1IG.

As soon as user enters 'Excise invoice' number (which was generated in J1IJ) in J1IG, through user exit or BADI, pass the EI number to J_1IRG23D table and check field EXAED (AED), if this field has values (other than 0%) then (first condition is satisfied) proceed to validate materials (Second condition).

As you said, these are traded items, so i assume, it will have same material group or material type. Define the applicable material group or material type (of traded items) in the user exit or BADI logic. Now, pass the material codes from EI to MARA table to check whether the EI materials belongs to traded item material group or material type (which are defined in the user exit or BADI logic). This way you can restrict this validation for traded items only.

Check this logic with your abaper and let me know if it works for you.

[Former Member]

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?

[Former Member]

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?

[Former Member]

Hi Karthik,

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

Regards,

S.Himavanth.

[Former Member]

Hello Himavath

I had checked J_1IRG23D also but is there any user exit that will validate against this table while posting J1IG??

With RG23D table I can pass entries to VBFA and put validation.

Regards

Iyer Kartik

[Former Member]

Hi Kartik,

Both J_1IRG23D and VBFA tables are totally different. J_1IRG23D contains all excise transactions that are held at depot for all materials but VBFA  table sales document flows it will carries

sales document ->Deliveries -> Billing document details not excise details. it is not possible to pass the entries in to this table.

The available User exits in J1IG  are

J_1I7_USEREXIT_EXCISE_BEF_SAVE which you have already mentioned in your above post.

check the below thread regarding user exits in J1IG.

http://scn.sap.com/thread/177224

Regards,

S.Himavanth.

[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