SAP FICA - How to report Miss applied payments that done using FP40

[ravindranath_arusam]

Hi FICA gurus,

Is there any report in FICA that I can get the reports of the miss applied payments done via FP40 (Transfer reason 01 - Payment miss applied', need the report containing 'original payment date' , ' payment doc ' , ' Source Contract account, Target Contract account'

if no report, how do i get them ? Please suggest what FICA tables should I query ..

Thanks in Advance

thank you

Ravi

[ravindranath_arusam]

Thank you Anand and Alman for the directions...Appreciated for the responses....

[former_member406383 · Accepted solution]

Hi Ravindranath,

One of the simple ways is to query table DFKKKO with the posting reason you are trying to look for (01) (DFKKKO- ABGRD field). The field for posting reason column is populated in case of transfer of open items and writeoffs.

Subsequently to backtrack the details of the original document against which the transfer was conducted you can pass as the clearing document in table DFKKOP (AUGBL).

Thanks,

Anand

[AmlanBanerjee]

Hi Ravi,

There is no standard SAP reports available for transfer payments using FP40.

I am not sure, whether your requirement is a one-off or your are looking for a Transfer payments report on a periodic basis.

If you are looking for a one-off scenario, then as mentioned by Anand-Query table DFKKKO with origin key as 34 and posting reason as and take the FICA Doc no to DFKKOP

• Put it in DFKKOP-OPBEL to get the Target Contract Account relevant details
• Put it in DFKKOP-AUGBL to get the Source Contract Account,relevant details

However, if you are looking for Transfer payments report that you would require on a periodic basis, then I would suggest to create a custom table based on the fields that you require and enhance event 5090 to populate the table, which is called during FP40 transfer posting.

Then you can run a simple SQVI query on this custom table to extract the report as and when you require it.

Hope it Helps.

Thanks

Amlan