Skip to Content
avatar image
Former Member

Field that integrate FICA and FI

Hi Experts,

I am trying to create a report through SAP query in which fields from FICA and FI are included. I am unable to find the link between through tables and fields. As on reunning FPG1, reconciliation keys are transferred to Finance which are supposed to transfer from DFKKSUM TO any FI table. But not clear on that.

One field reference key AWKEY in the table BKPF contains the information of reconciliation key but I am unable to find the exact link of this field to FICA.

Regards,

OZAIR ANWER SHAMSI

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 08, 2014 at 02:17 PM

    Do you need the query?  Why not just run FPG5 to get the desired report?

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Oazir,

      The report that you are looking for will involve a complex query.

      The only identifier b/w a FI and FICA document is the reconciliation key.

      To start with, you can join tables BKPF (in FI) and DFKKKO (in FICA) based on the reconciliation key to find the corresponding document numbers in both the modules.

      On the FICA part, since DFKKKO contains the document number, you can easily join it with DFKKOP to retrieve the required fields.

      Also, the reference field of the table DFKKKO contains the print document no. for Invoicing documents,so you can join ERDK to retrieve the required fields.

      On the FI part, you can take the combination of doc#/Company Code/Fiscal year to retrieve the information from BSIS table.

      Hope it helps...

      Thanks,

      Amlan