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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |