Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Subtransaction Type updatin in J_1IEXCHDR table and not picking correct G/L account

venugopal_v3
Explorer
0 Kudos

Dear Masters,

We've new concern here like for Stock transfer case we've created on new subtransaction type here two scenarios are there

1. Stock transfer from Plant to Yard(depot)

2. Stock transfer from plant to plant.

We're using same sales area like 0001/ST/99 for both the cases.

My concern is to update Subtransaction type in J_1IEXCHDR for plant to plant transfer and it has to hit G/L which is defined in

SPRO --> Logistics - General --> Tax on Goods Movements -->India --> Specify Excise Accounts per Excise Transaction & mentioned Subtransaction type as ST for DLFC (TRNTYP) for second case & For first case blank it's.

If I'm generating Proforma using VF01 & generating manually excise using J1IIN by passing subtransaction type it's taking correct G/L but I've to do it automatically by using VF01.

How to update Subtransaction type automatically using VF01 (proforma & Excise will generate automatically) and at the same time it should pick G/L account which we've configured & mapped with

Subtransaction type ST.

where to do enhancement.

Please help me to over come from this issue.

1 ACCEPTED SOLUTION

venugopal_v3
Explorer
0 Kudos

Correct answer:


Include: LJ1I4AF01

Function Module:(SE37) J_1I4A_CREATE_SD_INVOICE

in This we've developed enhancement at run time it's updating excise header table's subtransaction type ST and then based on ST G/L is picking....

Myself found solution and spot.


Thank you masters for your support.

7 REPLIES 7

Lakshmipathi
Active Contributor
0 Kudos

Moved from SAP ERP SD Sales to Internationalization and Unicode.  Post all your CIN related queries here

Lakshmipathi
Active Contributor
0 Kudos

In configuration, there would be one more assignment "Specify G/L Accounts per Excise Trsnaction".  Here which G/L Account is assigned.  Moreover, for depot process, you should have different Series Group atleast if not, Sales Area.

G. Lakshmipathi

0 Kudos

Thank you for your reply Sir.

I've already defined in configuration 'Specify G/L Accounts per Excise Transaction' like 11/DLFC/1001/ST with different CENVAT & MODVAT Accounts.


I can't over ride in sales area mapping with subtransaction type ST if I'll update in "Maintain Default Excise Groups and Series Groups" then it will effect to all stock transfer orders but my case is different

1.if I'm sending to depots then I'm not giving any subtransaction type leaving blank and updating all G/L accounts in "G/L Accounts per Excise Transaction" &

2. If I'm sending to another plants then I'm updating subtransaction type in G/L Accounts per Excise Transaction it should pick automatically while creation of Excise using VF01 with reference delivery i'm generating proforma & excise automatically.


If I'll create new sales area then how I can define for one plant multiple in configuration Shipping Data for Plants. There for one plant only one shipping data will allow.


Here for plant to plant transfer delivery type is different can I get any user exit to update subtransaction type in J_1IEXCHDR table before hitting G/L account.

This only the option I feel.

Please help me out.

0 Kudos

Try with any of the following exits

  • J_1I7_USEREXIT_EXCISE_BEF_SAVE   
  • J_1I7_USEREXIT_UPDATE_STYPE

G. Lakshmipathi

0 Kudos

1st Exit will update after hitting G/L in runtime then it'll update only table field but I need before hitting G/L account subtransaction type should update in runtime then pick GL accordingly this will not work.

2nd while generating excise invoice using VF01 with reference delivery number not going in this block we kept break point.

0 Kudos

J_1I7_USEREXIT_UPDATE_STYPE may be used to influence the subtransaction type in Excise transactions. Discuss with your Programmer and and get it checked the feasibility.

venugopal_v3
Explorer
0 Kudos

Correct answer:


Include: LJ1I4AF01

Function Module:(SE37) J_1I4A_CREATE_SD_INVOICE

in This we've developed enhancement at run time it's updating excise header table's subtransaction type ST and then based on ST G/L is picking....

Myself found solution and spot.


Thank you masters for your support.