Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Facing Problem to make a FI/CO Report

Former Member
0 Kudos

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.

4 REPLIES 4

kiran_k8
Active Contributor
0 Kudos

Debojit,

BSEG will definitely have all the profit centers assinged to a paritcular FIDOC line item wise.Check the way you have written the select query.

K.Kiran.

Former Member
0 Kudos

Dear SAP Expert,

I have checked BSG Table entries with the help of T.Code: SE11 but there the profit center field is not getting properly updated.

Thanks...

Debojit

kiran_k8
Active Contributor
0 Kudos

Debojit,

Just fetch the FIDOC from BKPF table depending on the posting date and then fetch the corresponding line item data from BSEG.

Profit center maintenance depends on the GL Account.May be for those GL accounts maintaining profit center is not mandatory and hence the user didn't allocate any profit center in the Transaction.So,it might not have got updated.Check for GL Accounts for which profit center is maintained while testing.

For more info check with the FI Consultant.

K.Kiran.

GauthamV
Active Contributor
0 Kudos

hi,

check the table CEPC.