cancel
Showing results for 
Search instead for 
Did you mean: 

Creation of substitution rule in CJ8G

anitha_ganesh
Explorer
0 Kudos

how to create the substitution rule for GL'12345' in CJ8G tcode and transaction type 'ABCD'. pleaselet me know which option i need to select in Cost accounting in GGB1 tcode for CJ8G tcode

Accepted Solutions (0)

Answers (1)

Answers (1)

sanilbhandari
Product and Topic Expert
Product and Topic Expert

Hello anitha_ganesh

I think the allocation type of substitution rule will work. If you need to write a complex logic, user exit COOM003 will work

Thanks & regards

Sanil Bhandari

anitha_ganesh
Explorer
0 Kudos

Hi Sanil Bhandari,

Thanks for the reply. Any Financial doc will get generate during settlement using CJ8G tcode?

because transaction type I can't see in CJ8G tcode I'm not sure how to create this. please help me out.

sanilbhandari
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello anitha_ganesh

If there is a settlement from WBS to AuC/COPA etc, a financial document will be generated. CJ8G is a transaction for running WBS settlement collectively. You need to create a variant and than run it in CJ8G. CJ88 is the transaction for running individual settlement. The way settlement is done in both is the same. The transaction type is picked by the system on the kind of processing you do for the WBS Element.

Hope this clarifies

Thanks & Regards

Sanil Bhandari

anitha_ganesh
Explorer
0 Kudos

Hi Sanil sir,

Please let me how transaction type came into picture I'm not understanding this please help me out.

sanilbhandari
Product and Topic Expert
Product and Topic Expert

Hello anitha_ganesh

The settlement run is executed for a WBS Element based on the settlement rule defined. The below is a settlement rule defined for settlement to a Fixed Asset

Now when you settlement of WBS to AuC at month end, system determines the transaction type automatically. For Asset Acquisitions they are defined in AO73.

This is one of the many transaction type that are defined to configure what type of settlement should take place. In the case of first settlement for a WBS Element which has definition of settlement to a fixed asset, system has code written to determine the transaction type. You can debug the standard code if you wish to. However, the transaction type determines that the expenses of the WBS Element must be settled to AuC with transaction type 114. If you see the screen shot of transaction type 114, it is used for settlement to an AUC with document type as AA.

Hope this clarifies.

Thanks & Regards,

Sanil Bhandari

anitha_ganesh
Explorer
0 Kudos

Hi Sanil,

Thanks a lot for your response with screenshot.

In GGB1 while creation it wl go with the table COBL in that case how can I select this conditional transaction type.

I am not sure how to update could you please help me on that

sanilbhandari
Product and Topic Expert
Product and Topic Expert

Hello anitha_ganesh

I am not sure, what you exactly want to achieve in your substitution rule, but when i check your original question, your issue can also be resolved by FI Substitution. You should have the fields available in Table GB01 with Substitution class 9 and NOT marked with the checkbox "excluded" for them to be available as substitution.

I would not recommend key fields as Transaction type, GL Account or Profit center etc to be substituted since they are called up from other applications most of the time and FI substitution can cause unwarranted results. If you provide a bit more details of the process that you want to achieve with substitution, may be I can better help you. You need to tell what exactly you want to achieve in substitution.

Similarly for CO Allocations, the substitution class is 500, 501 and 502 if the results are to be updated in CO Document only. If however, you expect the impact in FI Document as well, i would recommend using FI Substitution.

Thanks & Regards

Sanil Bhandari

anitha_ganesh
Explorer
0 Kudos

Hi Sanil Sir,

Discussed with user and came to know the if they use Gl '123' and tcode 'CJ8G' then the Transaction type should pic automatically i.e '123'. is FI substituion is sufficient for this? please help me out.

Regards,

Anitha Ganesh

sanilbhandari
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello anitha_ganesh

It would be helpful if you could explain what exactly are you trying to settle from WBS? As i said it may not be correct to substitute the transaction type if the data is originating from a different module like SD or FA. The use of transaction type has a definite impact on data and one has to be really sure, what exactly is being done. Could you provide more info on what you are trying to achieve by settltment of WBS?

Regards

Sanil Bhandari

anitha_ganesh
Explorer
0 Kudos

Hi Sanil Sir,

GL is not set as recon GL so while settling WBS( all type) they are manually inserting the Transaction type as '123' for one report so they want us to populate transaction type for that GL

sanilbhandari
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello anitha_ganesh

Are you trying to settle expenses booked to a WBS and posted into expense account to AuC? Please confirm.

if my understanding is correct, I would not recommend to use substitution rule to post the transaction and instead correct the set up of GL Account for AuC Asset and have it set as recon account for asset. The transaction type should be picked up automatically based on your configuration.

Thanks & Regards

Sanil

anitha_ganesh
Explorer
0 Kudos

Hi Sanil,

Thanks a lot for your response.

Got your point