Show TOC

 Adapting Actual Reporting in SAP Simple Finance On-Premise Edition

 

Your operating concern in Profitability Analysis (CO-PA) contains characteristics that are typically needed for your company-specific financial reporting. For reporting purposes it can be necessary to add some of your customer-specific CO-PA characteristics to the delivered reporting queries.

This document describes how to adapt the existing reporting queries on actuals in SAP Accounting to suit your needs (specifically, queries /ERP/SFIN_V01_Q2xxx based on virtual provider /ERP/SFIN_V01).

Note Note

This adaptation is also a prerequisite for using your new fields in financial planning. For more information, see Adapting Planning Applications in the SAP Smart Finance Add-On for SAP Business Suite powered by SAP HANA.

End of the note.

Procedure

  1. To assign new characteristics to your CO-PA operating concern, you first need to extend the corresponding HANA views, if required. Refer to the document Adding New Fields to HANA Views Based on Journal Entry Table, especially step 4.

  2. In transaction FCOM_GEN, generate missing InfoObjects and HANA views corresponding to the new CO-PA operating concern fields.

    You can either generate new InfoObjects for the CO-PA fields or assign existing ones. The generated InfoObjects belong to the namespace /RKE/ and also benefit from in-memory planning as they have a predefined HANA view for master data access generated in package system-local.sap.erp.sfin.co.pl.

    For more information, see the documentation of the SAP BW Data Warehousing Workbench at http://help.sap.comInformation published on SAP site under Start of the navigation path SAP NetWeaver Next navigation step SAP NetWeaver Platform Next navigation step SAP NetWeaver 7.4 Next navigation step Application Help Next navigation step SAP NetWeaver Business Warehouse Next navigation step Integration, Storage and Management of Data Next navigation step Data Storage and Data Flow Next navigation step Modeling Next navigation step Enterprise Data Warehouse Layer Next navigation step Creating InfoProviders End of the navigation path.

    Existing InfoObjects with other data access types can be used too, but in that case all planning functions are executed in ABAP and not within HANA.

    Of course, you can also create these HANA views yourself. Package sap.erp.sfin.co.pl contains the calculation views that belong to SAP’s /ERP/* InfoObjects. These master data calculation views typically join a master data table with its corresponding text table. As BW always needs the characteristic value # (not assigned), this entry has to be added unless it is part of the master data table. If you want to define your own InfoObjects based on HANA views, you can create your own Calculation views in a similar way.

    For more information, see the documentation for SAP HANA models under Start of the navigation path SAP In-Memory Computing Next navigation step SAP HANA Next navigation step SAP HANA Platform SPS 07 Next navigation step Modeling Information Next navigation step SAP HANA Modeling Guide Next navigation step 6.1 Creating Views End of the navigation path.

    Generate missing InfoObjects and HANA views as follows:

    1. Use transaction FKOM_RKEGEN to open the mapping tool.

      For more information, see InfoObject Assignment for Operating Concern.

    2. Select your operating concern and click Continue.

      Note Note

      Only account-based operations are allowed as input. The tool displays a list of CO-PA characteristics and proposes an equivalent BW characteristic for each one.

      End of the note.

    3. In the field list, check your new characteristics. They should have a yellow generation status and the proposed InfoObject should be /RKE/<field name>. If the proposal does not meet your requirements, click Change next to the entry you want to change and assign your own choice to the field name of the InfoObject.

      The proposed characteristic can be one of the following:

      • A delivered characteristic in the /ERP/ namespace

      • A generated or yet-to-be generated characteristic in the /RKE/ namespace

      • A customer-specific BW characteristic if the customer already has assigned a BW InfoObject to a CO-PA characteristic

      Note Note

      Keep in mind that you are changing the assignment for the field name for all operating concerns in the system.

      End of the note.

      Accept your changes to close the dialog box.

    4. Finally, generate missing InfoObjects and corresponding HANA views by pressing F8.

  3. In transaction RSA1, include the new InfoObjects into the VirtualProvider /ERP/SFIN_V01, replace view sap.erp.sfin.co.pl.FCO_C_IBP_ACDOCA with your view yyy.Z_FCO_C_IBP_ACDOCA and maintain the mapping to the new HANA view fields using the context menu on the assigned InfoObject.

  4. Adapt queries (such as /ERP/SFIN_V01_Q2xxx) using the query designer. For more information about the BEx Query Designer, see the SAP Help Portal at http://help.sap.comInformation published on SAP site under Start of the navigation path SAP NetWeaver Next navigation step SAP NetWeaver Platform Next navigation step SAP NetWeaver 7.4 Next navigation step Application Help Next navigation step SAP NetWeaver Business Warehouse Next navigation step Analyzing and Planning Data End of the navigation path.