We are currently loading with 0FI_GL_1. We now realize we need the cumulated balance at a plant level for specific GL Accounts. 0FI_GL_1 does not have plant, but 0FI_FL_4 does. Problem is GL_1 has cumulated balance and GL_4 does not. I noticed that GL_1 reads from table GLT0 while GL_4 reads from BSEG. The documentation states GL_1 is for transaction while GL_4 is direct line items.
Comparing extracted data from GL_1 and GL_4...none of the data matches.
Any ideas on the above?