Skip to Content

Relation Between FI Document and FICA Document no

May 22, 2017 at 04:34 AM


avatar image
Former Member


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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Bastiaan Jansen 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.

Show 1 Share
10 |10000 characters needed characters left 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?