Skip to Content
0

Mass Close of Payment, Return and Check Lots in FICA

Mar 10 at 02:40 PM

120

avatar image
Former Member

Dear Mates,

I would like to know the procedure/process to close Payment Lot, Return Lot and Check Lot (FP05, FP09 and FP25) in SAP FICA in bulk. There are lakhs of records in the system and we need to do close each and every lot.

Thanks in advance.

Regards,

Sravan

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Tammy Powlas
Mar 10 at 03:05 PM
0

For closing reconciliation keys? Please use FPG4 transaction

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Tammy,

FPG4 is used to close the reconciliation keys. But I would like to know the closure of Payment Lot, Return Lot and Check Lot. After we perform this step, we need to execute FPG4 for closing of reconciliation key.

Regards,

Sravan

0
Tammy Powlas
Mar 10 at 04:25 PM
0

Assuming the payment lots are data transfer (e.g. payments coming from the bank) you could try FPB3 (payment lots) and FPB5 (return lots)

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Tammy,

The t-codes FPB3 and FPB5 are used to upload new items where as my requirement is there are payment/return/check lots already created in the system which are not closed. Now we need to close, post and close the recon key to effect the General Ledger. And there are lakhs of records to be processed. So I am looking out for a mass processing of closing of Payment/Returns/Check Lot and posting the same, so that I can execute FPG4 followed by FPG1.

Thanks,

Regards,

Sravan

0

You can try doing an LSMW or a custom program

1
Former Member

Hi Tammy,

Thanks for the suggestion.

There is another issue observed.

When system executed FPB3 for bulk payments, there is an error which was left unnoticed. And that particular file triggered 32 times to create a payment lot which again failed and created a multiple lots with just one header. In short, if the FPB3 file get fails due to any reason, system is trying to re-push the same everyday. How can I prevent this happening?

Regards,

Sravan

0
Amlan Banerjee
Mar 12 at 09:35 PM
0

Hi Sravan,

When a Payment Lot/Check Lot/Return Lot is posted in SAP FICA, the recon key automatically get closed.

Now, there can be scenarios, where a part of the Payment Lot/Check Lot/Return Lot has gone into clarification.

So, we don't send these items to FI-GL.

Hence in this scenario, there are two standard Transactions-FP05FIK and FP09FIK, which are used to create new recon keys for the payment and return lot respectively. These transactions are being executed before the FPG1 transaction.

The new recon key contains the items which are in still in clarification and the old recon key is then, released for tranferring it to FI-GL.

Hope its clear

With your second, issue, I guess, you are not respecting the standard Structure of how the standard program RFKKZE00 accepts the internal file for creating the payment lot.

Thanks,

Amlan

Show 4 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Amlan,

Thanks for the detailed explanation. We are following the SAP Standard Structure and we found the issue from where it is coming.

I have a query in this regard actually, the system executes FPB3 in background for all the lots and there are success scenarios and failure scenarios. For failure ones, we can go to t-code FPB4 and do a root cause analysis. For success ones, is there any t-code where I can see the content/transactions under one identification. This really helps me in analyzing the different payment lots coming from RTGS/Paytm or BillDesk.

Thanks,

Sravan

0

Hi Sravan,

For the success scenarios, the payment lots are already getting posted in SAP. So there is no such transactions which would display the lot items under the identification.

May be you can have develop a custom report for the same.

Thanks,

Amlan

0
Former Member

Hi Amlan,

The reason for asking this is because, there are 2 additional line items (DR/CR to the same GL) are created in FICO when we are transferring the two modes of payments whereas it is not for another mode of payment. So if there is any t-code to see the success records, it will be helpful to cross verify for the unsuccessful records.

The structures are BFKKZK, BFKKZP, BFKKZS and BFKKZV. There is one BP number getting flowed ZS* table. So I am suspecting this structure. Please correct me if I am wrong.

Thanks,
Sravan

0

Hi Sravan,

To start with, I am not getting your requirement; Are you trying to perform a Bank Reconciliation?

Anyways, structure, BFKKZS, is populated, when you want to utilize additional criteria, for clearing the payment.

Say for example, you have a payment which you want to clear with the first two print documents.

So then you populate the BFKKZP, with only the BP and contract account and BFKKZS structure with the Contract account and the two print document no , so that it clears on these two Print Documents.

Can you elaborate your requirement?

Thanks,

Amlan

0