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

P1.jpg

Select the DataSource and go inside the extract structure.

Then,

Select the include “CI_BSIS” and

P2.jpg

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)”

P3.jpg

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…

/wp-content/uploads/2014/09/p4_548053.jpg

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 M
EINS (which is a standard domain).

/wp-content/uploads/2014/09/p5_548055.jpg

Or refer to original/base Structure/Table:

/wp-content/uploads/2014/09/p6_548056.jpg

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

/wp-content/uploads/2014/09/p7_548060.jpg

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

Save & Activate the DataSource.

Go to: RSA3 and Extract the Data.


/wp-content/uploads/2014/09/p8_548061.jpg

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/


To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply