Loading Data from R/3 into BW

Loading Data from R 3 into BW

Previously, we defined the characteristic ZVENDOR and its DataSources, ZVENDOR_ATTR and ZVENDOR_TEXT. Loading the source system data is relatively easy, as noted in Chapter 3. To save space, here we show only those procedures that are special to characteristic ZVENDOR.

This section also provides an example demonstrating how to use the BW Monitor to troubleshoot data load failures.

Work Instructions

Step 1. To load the master data, first we follow the procedure in Section 3.3, "Creating an InfoSource for Characteristic Data," to create transfer rules for the DataSource ZVENDOR_ATTR. Screen 11.26 shows the activated transfer rules.

 

 

SCREEN 11.26

graphics/11fig26.gif

Step 2. To load the texts, follow the procedure in Section 3.3 again to create transfer rules for the DataSource ZVENDOR_TEXT. Screen 11.27 shows the activated transfer rules.

 

 

SCREEN 11.27

graphics/11fig27.gif

Step 3. Follow the procedure in Section 3.4, "Creating InfoPackages to Load Characteristic Data," to create InfoPackages.

Screen 11.28 shows the first InfoPackage for master data. Notice the two fields (LIFNR and EKORG) that we selected when we created the ZVENDOR_ATTR DataSource (Screen 11.17).

 

 

SCREEN 11.28

graphics/11fig28.gif

Step 4. Click graphics/start1.gif to load the data immediately

 

 

SCREEN 11.29

graphics/11fig29.gif

Step 5. BW Monitor indicates that the load attempt failed. Click graphics/errormessage.gifto display the error.

 

 

SCREEN 11.30

graphics/11fig30.gif

Step 6. Click graphics/question.gif to display the error messages in detail.

 

 

SCREEN 11.31

graphics/11fig31.gif

Step 7. The error message indicates that the incoming data to the attribute INCO2 have small/lowercase letters, which is not allowed.

 

 

SCREEN 11.32

graphics/11fig32.gif

Step 8. To allow small/lowercase letters in the upload, modify the attribute INCO2's definition. Under the General tab, check the Lowercase letters option.

 

 

SCREEN 11.33

graphics/11fig33.gif

Step 9. If we allow lowercase letters, the attribute INCO2 can no longer have its own master data and texts.

 

 

SCREEN 11.34

graphics/11fig34.gif

Result

If we load the data again, this time the operation will succeed. Screen 11.35 shows BW Monitor status.

SCREEN 11.35

graphics/11fig35.gif

Compared with the data in the R/3 source system (Screen 11.10), the BW master data table /BIC/PZVENDOR contains correct contents (Screen 11.36).

SCREEN 11.36

graphics/11fig36.gif

Next, create an InfoPackage to load the texts. Compared with Screen 11.12, the text table /BIC/TZVENDOR contains the correct texts as well (Screen 11.37).

SCREEN 11.37

graphics/11fig37.gif

At this point, we have achieved the goal set at the beginning of this chapter.

Part I. Guided Tours

Business Scenario and SAP BW

Creating an InfoCube

Loading Data into the InfoCube

Checking Data Quality

Creating Queries and Workbooks

Managing User Authorization

Part II. Advanced Topics

InfoCube Design

Aggregates and Multi-Cubes

Operational Data Store (ODS)

Business Content

Generic R/3 Data Extraction

Data Maintenance

Performance Tuning

Object Transport

Appendix A. BW Implementation Methodology

Object Transport

Appendix B. SAP Basis Overview

Object Transport

Appendix C. Glossary

Appendix D. Bibliography



SAP Bw. A Step-By-Step Guide
Sap Bw: a Step By Step Guide for Bw 2.0
ISBN: B000LZM8CM
EAN: N/A
Year: 2002
Pages: 106

Flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net