Easy steps to perform the DataSource Enhancement for the standard FI_GL/AR/AP Extractors/DataSource without using ABAP Code. Part -1

[former_member222937]

Applies to:

SAP NetWeaver Business Warehouse (formerly BI) - SAP BW 3.5 & 7.x. Versions.

Summary:

The article explains the step by step procedure for the DataSource Enhancement without using ABAP Code for the standard FI_GL/AR/AP extractors.

Table of Contents:

1. Introduction

2. Test Scenario for adding the extra fields of base table into the standard 0FI_GL_4 extractor

3. Describing the Test Scenario

4. Related content

Introduction:

In many BW Projects, we have seen that most of the time we need to enhance the standard FI_GL/AR/AP extractors and pull the data for additional fields of the base/origin tables. In this scenario, enhancing the 0FI_GL_4 DataSource and adding the extra fields from the BSEG table. Since the extra/additional fields are not available in the standard extractor.

Test Scenario:

Below are the simple steps to achieve the DataSource Enhancement without ABAP code.

The DataSource 0FI_GL_4  has already the standard INCLUDE "CI_BSIS" is available in the standard structure. Likewise, we can add/append the additional fields from their base table for the following Extractors using Customer Include.

DataSource	ECC R/3 Table	Extract Structure	Customer Include
0FI_AP_4	BSIK/BSAK	DTFIAP_3	CI_BSIK
0FI_AR_4	BSID/BSAD	DTFIAR_3	CI_BSID
0FI_GL_4	BSEG	DTFIGL_4	CI_BSIS

Note: In this case we don't need to write any ABAP Code for pulling the data for the extra/additional fields. Since we are pulling the data from the base/origin table of the Extractor.

Now adding the two fields in the extract structure from the BSEG table below.

Go to T-Code: RSA6

Select the DataSource and go inside the extract structure.

Then,

Select the include "CI_BSIS" and

Add the MATNR & MENGE fields from BSEG Table.

After adding the MENGE field in the structure, probably you will face a following error.

"CI_BSIS-MENGE (specify reference table AND reference field)"

To overcome from this error we need to specify reference tables and reference fields for the fields which containing the currencies, amounts or quantity etc...

The Structure/Table name would be the same if unit or currency field is already available in the table. If not, then define for example:
ZZMEINS and refer it to standard MEINS (which is a standard domain).

Or refer to original/base Structure/Table:

Again Go to: RSA6 and select the DataSource in edit mode.

Unchecked the additional fields, which is newly added in the structure.

Save & Activate the DataSource.

Go to: RSA3 and Extract the Data.

Replicate/Import the DataSource in the BW/etc. Targets  (Destination) and load the data into respectively Data Targets.

Related content:

https://scn.sap.com/

https://help.sap.com/