Additional Reference Fields

For Level 1 to Level 5 tables, views, balance reports, and reconciliation reports, the following additional columns are added for the source and target fields:

• For source:
  • Dimensions: Source Ref 1 to Source Ref 25
  • Measures: Source Ref 26 to Source Ref 30

  

• For target:
  • Dimensions: Target Ref 1 to Target Ref 25
  • Measures: Target Ref 26 to Target Ref 30

  

• For the exception views, only for source: 
  • Dimensions: Reference 1 to Reference 25
  • Measures: Reference 26 to Reference 30

  

For the mapping between reference fields and custom columns, refer to the Reference Fields for Reconciliation Objects section in the SAP Central Finance Transaction Replication by insightsoftware Administrator Guide.

Updating Column Names for Reference Fields on SAP Fiori

For each of the newly added reference fields, there is a unique data element in the ABAP component. To update the column name in the reports on SAP Fiori, change the field label of the corresponding data element and the same will be reflected in SAP Fiori.

The data elements of the reference fields are as per the following naming conventions:

• L1 to L5 Report:/MAGSW/APF_LV<RN>_<TAR/SRC>_REF_<FN>
• GL Balances Report:/MAGSW/APF_GL_BAL_<TAR/SRC>_REF_<FN>
• Conversion Report:/MAGSW/APF_GL_BAL_CON_<TAR/SRC>_REF_<FN>
• Exception Report :/MAGSW/APF_EXCEPTION_REF_<FN>

where

• RN: Report Number (1 for level1, 2D for level 2 Detail, 2S for level 2 summary, 4 for level4 and so on)
• FN: Field Number ( 01 to 30 )
• <TAR/SRC>: TAR for target fields, SRC for source fields

For example, to update the name of the Source Ref 1 field of the Level-5 Reconciliation Summary Report, refer to the data element /MAGSW/APF_LV5S_SRC_REF_01.

Similarly, to update the name of the Target Ref 26 field of the Level-4 Reconciliation Report, refer to the data element /MAGSW/APF/LV4_TAR_REF_26.

To update the column names for the reference fields on SAP Fiori

1. In SAP GUI, go to T-code SE11, and open the data element /MAGSW/APF_LV5S_SRC_REF_01 in the change mode.
2. Go to the Field Label tab and change the text. In the following screenshots, the column name is updated from Source Ref 1 to Translation Date.
   
3. Open the reconciliation report in SAP Fiori to confirm that the column name is updated.