How to get FICA documents given only the FI document
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.
FI Document Recon Key Posting Date
900000001 1-0000000001 09/01/2010
900000002 1-0000000001 09/01/2010
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.