Skip to Content
0

P&L (cost center) + Balance sheet GL Accounts

Feb 26 at 10:20 AM

41

avatar image
Former Member

Hi all,

I am looking for a report in which I could download all GL accounts with their respective cost center. I found this using FBL3N, but for the balance sheet (BS) accounts, this does not seem like the right transaction to use? As I get the impression that this transaction only shows the movements on the accounts during the selected period?

Does anybody know of a report in which I could get:

- all movement on P&L GL account within a certain period with their cost center

- all BS GL accounts (not the movement per month, but the actual amount that is booked on that GL account)

Any help would be much appreciated.

Thanks,

Tom

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

3 Answers

Eli Klovski
Feb 26 at 10:22 AM
0

Hi,

What is your issue with BS accounts in FBL3N? Of course, most probably you wouldn't find there cost centre, unless you force it on these accounts, as not being cost elements BS accounts don't store this information by default. But, posting on those accounts would be visible, unless these GL accounts are defined without 'line item management' flag.

Could you specify your problem?

Regards,

Eli

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

I'm rather new to SAP, so it's more of a search than an actual problem.

From what I've seen so far, FBL3N is perfect for the reporting I want to do on P&L level: GL accounts with a split per cost center. (because I do need this level of detail)

Our BS GL accounts do not have CCs, which is not the problem. I thought I could use FBL3N to get the YTD information of my P&L accounts and at the same time get the end balance of my BS accounts. As I see it now, this transaction only displays the movement on these accounts within the time frame chosen by me.

Therefore I am now using S_ALR_87012284 to get a better view of my BS accounts, whilst using FBL3N for my P&L YTD movement.

If this makes any sense to you..

0

I suggest that you search SCN a bit, then. Also, try consulting help.sap.com - plenty of information for beginners.

Balances, indeed, are better to be viewed via F.01 transaction or its similar.

I'm closing the thread...

0
UZMA FAROOQ Feb 26 at 11:34 AM
0

- all movement on P&L GL account within a certain period with their cost center?

you can get the desired data by following:

1. RUN MB51 with MVT 201 in selection with your date range. pick all Cost centers.

2. Run KSB1, Give cost centers in selection ,Execute report.

3. Pick materials document number from MB51 report and give it in Field Reference doc num, the cost center posting will be summarised just for materials document with MVT.

4. in KSB1 you would be having Cost element (GL ) with all cost centers.

- all BS GL accounts (not the movement per month, but the actual amount that is booked on that GL account).

1. Get all BS GL from Account detective report S_ALR_87101048.

2. Run FS10N to check the amount posted.

Best Regards,

Uzma Farooq.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 26 at 12:31 PM
0

Hi Tom,

You can get the Profit Center and Cost Center for the P&L GLs and B/S GLs ( of course the B/S GLs would have been pushed with the cost center during posting) at KE5Z report level.

Regards,

Balu.

Share
10 |10000 characters needed characters left characters exceeded