Skip to Content
avatar image
Former Member

Simple Profit Center ALV Report

Dear Experts,

I want to create a simple Profit Center wise ALV Report.

Well, it should be like all the P&L GLs or those P&L GLs required should be like a list (Rows) and the Profit Centers should in Headers (Columns).

Therefore, there will be totals per Rows (horizontally) and totals per Columns (vertically).

The Profit Centers are very few, so we can assign it in the Columns.

This is the Client requirement, as they are not so comfortable to use Standard Drill Down Reports like S_ALR_87013336, etc.

I have tried doing this using Standard Report Painter options & Report Layouts, but could not find this type of option.

Please can you help, if this is possible & if I have missed something or do we have to go with custom development.

Regards,

Hussein.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 18, 2017 at 08:07 AM

    Hi

    Are you on S/4HANA? If yes, CDS view C_TRIALBALANCEQ0001 can help.

    regards

    Sanil

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2017 at 10:54 AM

    Hi Sanil,

    Thank you for your answer.

    Yes we are using S4 HANA 1610.

    Just wanted to know, if in S4 HANA Report Painter shall no more be used ?

    As you know, in parallel we have started to develop a CDS for this requirement, but I was looking if this is not available in SAP's Standard Profit Center Layouts.

    Regards,

    Hussein.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi

      The report painter functionality is there as well if you really want to use that. You should look at library 0FL and 0FS to create your own report. However, I would still suggest to use CDS if you want the flexibility to run the reports in FIORI and the UI is really great. That's my two cents on the same !!

      regards

      Sanil Bhandari

  • avatar image
    Former Member
    Oct 23, 2017 at 02:28 PM

    Hello Hussein,

    Not ideal but try SE16H against ACDOCA. You will be able to view GL and Profit Center in rows and will also have ability to drilldown. Else FBL3H could do something similar with the right layout. CDS would be good but as I am starting to experience, not everyone is ready to consume data through a different UI yet :-)

    Cheers

    Kris

    Add comment
    10|10000 characters needed characters exceeded