Data Source 0FI_GL_14 for BCS

Hi,

I'm currently working on a BCS project, the client requested line item data(or maybe some customized fields) for consolidation, so we planned to use 0FI_GL_14 to serve this purpose.

However, item level data is not suitable for consolidation, we need the balance / cumulative balance for BCS. Is it the case? Does anyone have experience in solving this kind of problem?