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

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.

 

 

SCREEN 11.20

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

 

 

SCREEN 11.21

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

 

 

SCREEN 11.22

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

 

 

SCREEN 11.23

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

 

 

SCREEN 11.24

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

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

Категории