Show TOC

 Adding New Fields to HANA Views Based on Journal Entry Table

 

If you add fields to your operating concern, you need to adapt the HANA views based on the journal entry table so that you can report on these fields.

The relevant views for the journal entry table are:

  • sap.erp.sfin.fi.gl.FAC_ACDOCA_COM

  • sap.erp.sfin.fi.gl.FAC_GLACCT_LINE_ITEM_COM

  • sap.erp.sfin.co.pl.FCO_C_IBP_ACDOCA

Procedure

Carry out the following steps for the views listed above in the order the views are listed:

  1. Install the SAP HANA studio locally. You can find the installation guide for the SAP HANA studio at http://help.sap.com/hanaInformation published on non-SAP site under SAP HANA Appliance Software. The documentation for the SAP HANA studio is located at http://help.sap.com/hana/SAP_HANA_Developer_Guide_for_SAP_HANA_Studio_en.pdfInformation published on SAP site (chapter 6).

  2. Copy the HANA calculation views to new calculation views named yyy.Z_xxx, where xxxx is the name of the original view in your own package with yyy representing your package.

  3. For yyy.Z_FAC_ACDOCA_COM, select the fields to be added from database table ACDOCA and choose Propagate to semantics from the context menu.

    Activate the views.

  4. For all other views, replace the original source with your new view. For example, in yyy.Z_FAC_GLACCT_LINE_ITEM_COM replace the source FAC_ACDOCA_COM with your new view yyy.Z_FAC_ACDOCA_COM.

  5. Select the fields to be added from the new source and choose Propagate to semantics from the context menu.