Skip to Content
author's profile photo Former Member
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.



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 08, 2014 at 02:17 PM

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

    Add a 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...



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.