Creation of 2 Security Deposits with different GL accounts

[Former Member]

Dear Experts,

I have a requirement to post 2 security deposits for the customer.

One security deposit is related to Connections which costs for 1000/- this should go to GL account "Connections Security Deposit" gl account.

Second Security deposits is related to Damage which costs for 2000/- this should go to GL account "Damage Security Deposits" gl account.

I am able to create 2 security reasons like "Connection Security Deposit" and "Damage Security Deposit", but both the security deposits are hitting to one gl account through FPSEC1

Could you please guide on how we can make the postings to different gl accounts base on the security deposit reasons, please assist.

Note: in case if i need to make any extra config to enable this, please guide me.

Thanks and regards,

Aditya Viswanath

[AmlanBanerjee · Accepted solution]

Hi Aditya,

I don't think you can cater your requirement through standard configuration.

You can have a look at event 800 for catering your requirement.

Hope it helps...

Thanks,

Amlan

[Former Member]

Dear Amlan,

Could you please provide some more information on how to proceed with the event 800, as i am new to FICA.

I have enabled "FKK_ACCOUNT_DETERMINE_0800", so based on the security deposit reason, can i enable two different gl accounts with this event.

pls guide.

Thanks

Aditya Viswanath

[AmlanBanerjee]

Hi Aditya,

As per Standard SAP functionality, when you are posting a SD request through FPSEC1, the main\sub that  is used is coming from the following SPRO Config-

IMG--->Financial Accounting-->Contract Accounts Receivable and Payable-->Basic Functions

-->Contract Accounts--->Postings and Documents--->Document--->Maintain Document Assignments

-->Maintain Transactions for IS-U-->Maintain Transactions for Cash Security Deposits/Interest

Double-click on "Allocate Transactions to Internal Transactions"

Check for the mapping of the IMTR\ISTR for the following combination-

0020\0020-Request Cash Sec Dep.

In here, you can map only one main\sub combination, and so by standard configuration, its not possible.

Now in event 800, there are two import structures-

(a) I_FKKOP

(b) I_FKK_SEC

Structure I_FKK_SEC, contains the request reason.

Now what you need to do is as follows-

(a)  Create a new main\sub combination which is statistical in nature and which should point to the GL A/c that you want it to go. It should have the same properties as that of the standard Security Deposit. Main tr\Sub Tr

(b) Maintain the new main tr\sub tr in posting area 1010

(c) Create a custom FM by Copying the FM,ISU_EVENT_0800. In there, once the  values of the E_HVORG and E_TVORG are exported from the FM, ISU_DB_TEIVV_SELECT, then based on the FKK_SEC-REASON, you can pass the main tr and sub tr of your choice in parameter, E_HVORG and E_TVORG respectively.

Assign this custom FM in event 800 and activate it will post SD to a different GL A/c based on the security reason.

Hope it helps...

Cheers,

Amlan

[Former Member]

Thanks a lot for your update Amlan.

Small issue is while maintaining the details of another main and sub transaction in the posting are 1010, system is throwing an error saying that "statistical key "H" entry already exists  (H: Cash Security Deposit Request).

So can i select any other statistical item like "A" and use this for cash security deposit through FPSEC1?, or is there any alternative. please suggest.

Thanks

Aditya

[AmlanBanerjee]

Hi Aditya,

You have to maintain statistical key H only, as there are some SAP standard validation in many SD related processes, where Statistical key H is checked, like during SD release.

Ideally you should be able to maintain another set of main/sub against Statistical key H in 1010.

Say your new Debit main\sub is Z020\0020 and Credit main\sub is Z020\0010, then the entries would be

H Z020 0020 Z020 0010

H 0020 0020 0020 0010

The only issue that I could see here is with the setting of clearing restriction 2 as SAP standard allows only 1 string in 1010  to have the clearing restriction 2 set.

If you are using this clearing restriction 2 functionality, then you have to find an event to pass tht for the new main\sub.

Thanks,

Amlan

[Former Member]

Hi Amlan,

Thanks for your help, now i am able to post to gl accounts based on the security reasons, as the system is not allowing to update another value in 1010 posting area, i have enabled the changes by copying the fm: FKK_SAMPLE_0800 using the fqevent 0800, its working fine as per the requirement.

Thanks n regards,

Aditya Viswanath

[Former Member]

Hi Amlan,

We are doing a similar enhancment by creating two different security deposits and we have gone exactly same path for deposit request which is another type of deposit we want to implement.

We are able to leverage 0800 event also.

But we are getting error at LFKK_SECF00 (FORM BUILD_POST_ITEM).

Somehow it is not clearing the flag (Item is a Down Payment/Down Payment Request), which is causing the system to populate tax jurisdiction code. And when FM 'FKK_FKKOP_CMPLETE_CHECK' see tax jursdction value populated it gives error message:

E194:  Taxes with jurisdiction code not permitted with down payments.

Please suggest any way out. Thanks much.!

Best Regards,

Mandeepak

[AmlanBanerjee]

Hi Mandeepak,

If you have maintained posting area 1010 for the main\sub combination for which you are posting SD, then it will be posted as a downpayment.

Check event 0112, if it helps...

Thanks,

Amlan