Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to get FICA documents given only the FI document

Hi,

I would like to ask how can I get the corresponding lines from table DFKKOP/DFKKOPK given only the FI document number?

I tried to use the Recon Key to connect from FI to DFKKKO then DFKKOP/DFKKOPK. However, it is not sufficient so I added the Posting date in the criteria.

BKPF-AWKEY(12) = DFKKKO-FIKEY

BKPF-BUDAT = DFKKKO-BUDAT

This is already working. However, I saw a new scenario that a Recon Key with its corresponding posting dates appear to have more than 1 FI document.

Example:

BKPF TABLE

FI Document Recon Key Posting Date

900000001 1-0000000001 09/01/2010

900000002 1-0000000001 09/01/2010

DFKKKO TABLE

FICA Document Recon Key Posting Date

13000000000 1-0000000001 09/01/2010

13000000001 1-0000000001 09/01/2010

From the example above, if I get the corresponding DFKKKO entry for FI document 900000001, I will get 2 entries in DFKKKO table. But when I drilled down from the FB03 transaction to display corresponding FICA documents, it only shows one document - 13000000000.

The question is how can I know all the corresponding FICA documents for a given FI document knowing that they are some FI documents with the same recon keys to others.

Appreciate your help.

Thanks in advance.

Former Member
Not what you were looking for? View more on this topic or Ask a question