FPG5 - FICA to FICO table
Is there any table which would give me the information of FICA document and its corresponding FICO document in reference with Reconciliation key.
Amlan Banerjee replied
There is no straightline way to relate the FICA documents vis-a-vis the exact reference key field against the FI-GL document header.
What you can do is use the summarisation rules as the filtering criteria for relating the FI-GL document no. with the corresponding FICA document no(s).
Say for example, In a normal scenario, if a reconciliation key contains non-statistical transactions with multiple posting dates, then as per the Standard SAP summarisation rule, it creates a FI-GL document no. for each of the posting dates.
These posting dates gets captured in the BKPF-BUDAT.So when querying table DFKKKO, you can give the reconciliation key and the posting date and it will give you the FICA documents only for those posting dates.
Hope it helps..