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 LFM1 Field Attribute||Characteristic||Attribute||Compound|
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.
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.
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 to create the attribute.
Step 3. Select the Create attribute as key figure option, and then click to continue.
Step 4. Make selections as shown in this screen, and then click to continue.
Step 5. After creating other attributes, go to the Compounding tab.
Step 6. Enter 0PURCH_ORG as the compound attribute, and then go to the Master data/texts tab.
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.
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
Aggregates and Multi-Cubes
Operational Data Store (ODS)
Generic R/3 Data Extraction
Appendix A. BW Implementation Methodology
Appendix B. SAP Basis Overview
Appendix C. Glossary
Appendix D. Bibliography