“Pixel Perfect” Financial Statements inside SAP ERP? Yes, with Crystal Reports

[TammyPowlas]

Yes you can run pixel perfect reports inside SAP using Crystal Reports.  This is something to consider for financial statements, for those that are not already in your SAP BW system, for example.

First you will need to follow the steps inside this blog (being on enhancement package 5).

Then configure your financial statement version via OB58 transaction inside ECC/ERP

Run the financial statement report in ALV mode so you can see the data - here I am using transaction S_ALR_87012284:

Note the first column hierarchy level – this will be needed for formatting Crystal Reports

Change the layout to Crystal Reports

Export the report to Crystal

Open up Crystal Reports 2011 (you will need a Crystal Reports Designer license)

The field names in Field Explorer took some getting used to.  TLEVEL is the hierarchy level while REPVAL is the dollar amount

I put in some formulas to control the fonts and the underlines:

The formula above displays if level is less than 4 then bold the font

If level equals 3 then underline

After making formatting changes, save the report in Crystal and import inside SAP:

Sample final output:

You can save this to a variant so it the report will automatically run in Crystal Reports, inside your ECC / ERP system.