Enhancing New Financial GL (Leading) Data Source: 0FI_GL_10

Introduction:

This document explains the enhancement approach for the New Financial General Ledger (Leader Ledger) data source – 0FI_GL_10.

Standard Approach:

Normally in the general practices the extract structure is enhanced with the required fields and the data is populated using the external logic in the CMOD. New FL leader ledger will follow a different approach in populating the data and the same is explained in the further sections.

Prerequisites:

In the Source system, you have activated new General Ledger Accounting in Customizing for Financial Accounting under Financial Accounting Global Settings.

Steps Involved:

New GL Leader Ledger is based out of the table FAGLFLEXT – General Ledger – Totals

If the requirement is to include the additional fields then the fields has to be included in the Customer Include using the transaction: FAGL_GINS or using the following Navigation from SPRO:

SPRO –> SAP Customizing Implementation Guide –> Financial Accounting (New) –> Financial Accounting Global Settings (New) –> Ledger –> Fields –> Customer Fields –> Include Fields in Totals Table

This will take you to the transaction FAGL_GINS to enhance the Total Table – FAGLFLEXT.

Next screen will allow you to add the required Customer fields which will further added to the Totals table.

Totals Table – FAGLFLEXT will be automatically enhanced with the Customer Enhancement – CI_FAGLFLEX04.

Once this is done, in order to extract the customer fields in the data source 0FI_GL_10, the Customer Include CI_COBL needs to be added as an Append in the Extract structure – FAGL_EXTSTRUCT_LEAD

TCode: RSA6 –> Select data source 0FI_GL_10 –> Double click to see the details of the data source.

Coding Block has to be added in the above extract structure as an Append Structure in order to pull the data.

Coding Block CI_COBL can be found as below:

This contains two sections, one for the standard Account Assignments fields and the other one is for the customer fields.

Extract structure – has to be enhanced with the Coding block as an Include or using the Append Structure:

Using Append Structure at the extract structure level with the same name CI_COBL:

Or   —  Using Include CI_COBL:

Preferred one is to use the Append Structure.

Once this is done then, unhidden the fields from the data source in RSA6 and inverse option. Once done, extract can be used to extract the enhanced fields. The fields of the APPEND structure are then filled automatically without any additional logic.

Replicate the data source changes in BW and add the corresponding IOBJ’s in the data flow in order to use it for further reporting.

References:

Help.sap.com – Link