Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 02, 2010 at 11:14 AM

    Hi,

    the corresponding FI-CA documents for a FI documents you get for example as follow:

    tr. FB03 --> button: document list:

    Company code

    Fiscal Year

    Reference Transaction: FKKSU

    Reference key: "rec. key"* (after rec.-key write a *)

    Enter: now you see all FI documents to the rec.key

    choose one

    Menue: Environment --> Document Environment --> Original Document

    I hope I could help you, I think the problem was that you has forgot the "*"

    Christiane

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Denver,

      If you have the reconciliation key, go to transaction FPF3, enter the reconciliation key, go to document itemization. Here you will have all the FICA documents that are included in that reconciliation key.

      Regards,

      Cristóbal.