Facing Problem to make a FI/CO Report

We are generating a customized report for getting the debtor's debit and credit balance profit center wise which is not available from the standard report.But currently we are facing one problem.If any one document contains multiple profit center then the table is not getting update with all these profit centers.Profit center field is getting updated one of these profit center. We use BSEG, BSID, BSAD, BSIK, BSAK Table. Please advice how to solve this problem or how we will be able to track the profit center or which of the database tables should be taken in consideration.

In the selection screen of the report we are giving Reconcilation account,Fiscal year,Period Range and Profit center.