Procedure documentation Configuring Size of Data Packets and Frequency

Use

To upload large sized flat files, the setting of the following parameters within the BW Customizing is important:

• Size of data packets
• Frequency

For data transfer into BW, the individual data records are sent in packets of variable size. Using the parameters for the size of data packets you can control how large a data packet typically is. If no entry is maintained, the data is transferred with the default setting of 10,000 Kbytes per data packet. Within BW Customizing you can increase this setting to 40,000 Kbytes or higher.

By specifying the frequency, you determine after how many data IDocs an Info IDoc is sent, or how many data IDocs are described by an Info IDoc. Choose a frequency of between 5 and 10, but not greater than 20.

Procedure

1. Open the customizing tree from the SAP Easy Access menu under the folder Tools
® Business Engineer.
2. Double-click on BW Customizing and select SAP Reference IMG.
3. Expand the tree BW Customizing Implementation Guide
® Business Information Warehouse ® Links to Other Systems ® Maintain Control Parameters for the data transfer.
4. Change the parameters as required.

Expanding Table Spaces

Use

SAP recommends that the following table spaces should be expanded:

• PSAPSTABD
• PSAPSTABI
• PSAPFACTD
• PSAPFACTI
• PSAPDIMD
• PSAPDIMI
• PSAPCLUD
• PSAPODSI
• PSAPTEMP

The following table can be used as a guide. It illustrates the table space sizes that are used to upload 1,8 million records based on an Oracle database.

Table space sizes

Table space	Size (kb)	Free
PSAPSTABD	2.048.000	At least 1.6 GB free
PSAPSTABI	2.048.000	At least 1.6 GB free
PSAPFACTD	716.800
PSAPFACTI	965.904
PSAPDIMD	102.400
PSAPDIMI	117.744	At least 40 MB free
PSAPCLUD	51.200
PSAPODSI	2.702.824
PSAPTEMP	5.013.480	At least 5 GB free

Procedure

For detailed information, see SAP note number 184905.

Customizing BW for the Usage of the D&B Marketing Universe

Procedure

1. In your BW system, select transaction rsmonitor_db.
2. From the Environment menu, choose D&B Registration.
3. Create a new scenario using the Create icon.
4. If you are using a SAP CRM system, choose the logical system name of your CRM system. If you use a 3^rd party CRM leave the logical system blank.
5. In the field CRM Scenarios choose D&B Integration of external Data.
6. Save your scenario.

Customizing for Business Partner Creation from BW in SAP CRM

Procedure

1. In your CRM system, register the InfoObject DUNS Number 0DBDUNS_NUM as an identification object for the business partner.

Use transaction sm30 to maintain the table RSCRMEXTERN as follows:

• Logical System: system name of the CRM system
• InfoObject: 0DBDUNS_NUM
• InfoObject: 0BPARTNER
• ID Category: BUP001 (provided with the customizing of your CRM system)
• Maximal allowed age of master data (in calendar days): for example 365 for 1 year

2. Bear in mind that the D&B scenario is a B2B scenario. Therefore only companies and organizations are considered as business partner. To check if the ID category BUP001 is valid for organizations proceed as follows:

• In your CRM system, use transaction sm30 to display the table v_tab039A.
• Mark the row with BUP001 and click on the Details icon.

The Identificationtype should be relevant for organizations only.