Skip to Content
avatar image
Former Member

Relation Between FI Document and FICA Document no


I am trying to find a link between FI Document which are stored in 0FI_GL_14 extractor and FICA Document stored in 0FC_BP_ITEMS extractor.

My clients requirement is to be able to link each invoice items from the 0FC_BP_ITEMS to each GL document line number in 0FI_GL_14.

I am able to link the invoice item to GL document number using 0FC_BP_ITEMS.fikey = 0FI_GL_14.awkey but this only lets me know what the GL document is whereas I need to link this to the document line number as well.

Any ideas?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 23, 2017 at 08:13 AM

    The FICA subadministration is only posted in compressed form in GL. So the level of detail you are searching is not available in the system. The way the items from FICa are compressed is determined by the posting area:

    If you realy need this information I would recommend basing your report on FICA data and derive the GL conversion yourself.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for your response Bastiaan.

      I should have stated that I am trying to extract this data out from ERP system and into another database for the purpose of reporting.

      Now, I could see that the ERP system itself could link these FI-CA invoice documents to the FI GL document line item if I go into FB03 -> Enter GL Document number -> Browse Document header -> Click on the reference Key field -> This then takes to the screen that I am trying to replicate where each invoice items can be viewed under its respective GL Document line item.

      Is there any way of extracting this relationship?