DATASOURCE ENHANCEMENT
Datasources reside in the source system. So, to customize DataSource, we need to go to source system, one can directly login to Source System (R/3 in our case) or From BW also can remotely login to Source System.
- Logon to BW
a. Go to Administrator Workbench (RSA1).
b. Go to Source systems.
c. Choose R/3 Source System (where the user DataSource resides) - Right Click &
go to “Customizing for Extractors”.
- It shall take the user to Source System ( R/3)
- Choose “Edit Datasources and Application Component Hierarchy”
4. Go to “0CUSTOMER_ATTR” Customer Number DataSource (or whatever
DataSource the user decide to customize)
5. Click on DataSource
6. Scroll down to reach the appended structure
7. Double Click on appended structure – ZBIW_KNA1_S1 (or the user chosen one) &
add the fields (which the users wish to add to DataSource)
8. Check, save & activate - It will append this to Extract Structure of DataSource.
9. Go Back
10. Click on 0CUSTOMER_ATTR (DataSource)
11. Now Click on Extract Structure – BIW_KNA1_S (in my case), check out the
appended field below append structure
Filling up the Appended Structure
1. Post appending the structure, we need to fill this Append with data – For this
a. LOGON to Source System (R/3)
b. Go to T Code – CMOD
c. Choose the project – Which the user is using for Master Data Enhancement.
Project “ZSDBWNEW” in my case. (the user need to create project in case the
User are doing enhancement on this BW system for the first time)
d. Click on Enhancement Assignments
e. Click on Change
2. Press Continue – In case it prompts for some confirmation like “Enhancement
Project already active” etc
3. Choose the following -
a. Enhancement – RSAP0001
b. Click on Components.
4. It will take the user to –
5. Choose”EXIT_SAPLRSAP_002” & Click on this.
6. Choose”EXIT_SAPLRSAP_002” & Click on this.
7. We need to write ABAP Code to fill up Appended Fields in “0Customer_Attr”
through the Include mentioned here i.e. include zxrsau02.
8. Double Clicking on this will take to ABAP Editor to put in the code.
9. Go to Change Mode.
10. This Code is to be inserted before “endcase” of already written code.
11. Make Sure Tables KNVV, BIW_KNVV_S, KNKK, KNA1, KNVP (these are table
From which I need to extract values of appended fields) are declared at the start of
the code.
12. Do the “Check” before Save, if no errors are found the Save & Activate”.
13. Go Back.
14. Do the Check again & if no errors then activate.
15. Go Back and then Activate. (Keep activating while going back on every step).
16. Come out.
Regenerate & Check the Customized Objects
1. Now Final Step – We need to regenerate the DataSource & make sure Newly Added
Attributes (Starting with ZZ) are not HIDE.
2. Logon to BW System – Go to Administrator Workbench (RSA1) – Go to Source
systems – Choose Source System (R/3 in our case) - Right Click & go to
“Customizing for Extractors”.
3. Choose “Edit Datasources and Application Component Hierarchy”
4. Go to “0CUSTOMER_ATTR” Customer Number DataSource & Click on CHANGE.
Scroll Down.
5. Keep clicking on Right Sign if it prompts for any confirmation.
6. Scroll down & Go to Fields starting with ZZ & make sure these are not HIDE
(remove the sign from HIDE check box).
7. Click on DataSource & Generate.
8. Go back. Next Steps are Checking Extractors & Loading data.
*******************