Creating a Characteristic in BW

Now we need to create a characteristic, which we will name ZVENDOR. Table 11.3 shows how we match the R/3 table fields to the characteristic ZVENDOR and its attributes.

Table 11.3. CHARACTERISTIC ZVENDOR AND ITS ATTRIBUTES

Table LFM1 Field Attribute Characteristic Attribute Compound
MANDT      
LIFNR ZVENDOR    
EKORG     EKORG
VERKF   VERKF:  
MINBW   MINBW  
ZTERM   ZTERM  
INCO1   INCO1  
INCO2   INCO2  
WAERS   WAERS  

The characteristic ZVENDOR does not need to have an attribute for the field MANDT. The field MANDT is used to group the LFM1 data into clients (see Section 10.1.1). Our earlier replication of DataSources from the source system SND_250 (Screen 11.18) has already determined the client from which to extract data.

Section 2.3 provided the procedure for creating a characteristic. To save space, the work instructions here focus only on what is special to ZVENDOR.

Work Instructions

Step 1. Repeat the procedure in Section 2.3, "Creating InfoObjects – Characteristics," to create the ZVENDOR characteristic.

Select CHAR as the DataType, enter 10 as the field Length, and then click the Attributes tab to add the attributes.

 

 

SCREEN 11.19

graphics/11fig19.gif

Step 2. Create attributes as described in Section 2.3. Here, however, the attribute MINBW is of type currency, not type character.

Enter MINBW as the attribute name, and then click graphics/attribute.gif to create the attribute.

 

 

SCREEN 11.20

graphics/11fig20.gif

Step 3. Select the Create attribute as key figure option, and then click graphics/continue.gif to continue.

 

 

SCREEN 11.21

graphics/11fig21.gif

Step 4. Make selections as shown in this screen, and then click graphics/continue.gif to continue.

 

 

SCREEN 11.22

graphics/11fig22.gif

Step 5. After creating other attributes, go to the Compounding tab.

 

 

SCREEN 11.23

graphics/11fig23.gif

Step 6. Enter 0PURCH_ORG as the compound attribute, and then go to the Master data/texts tab.

 

 

SCREEN 11.24

graphics/11fig24.gif

Step 7. Check off Short, Medium, and Long to create three fields in the text table /BIC/TZVENDOR; these fields will store the view ZVENDOR_TEXT's NAME1, NAME2, and NAME3, respectively (Screen 11.11).

Check and activate the characteristic.

 

 

SCREEN 11.25

graphics/11fig25.gif

Next, we will load the R/3 data into the characteristic ZVENDOR.

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