Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 26 at 10:22 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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...

  • Feb 26 at 11:34 AM

    - 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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 26 at 12:31 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded