Procedure documentation Uploading Data from OLTP Systems

Procedure

First you have to upload the relevant master and transactional data. This step involves:

• Extraction of master data for the InfoObject Customer number (0CUSTOMER) from SAP R/3 (table KNA1) or other 3rd party source systems into BW
• Extraction of master data for the InfoObject Business Partner (0BPARTNER) from SAP CRM or another 3rd party CRM system into BW
• Extraction of the transactional data into the InfoCube 0SD_C03. The D&B Marketing Universe for SAP BW solution uses the billing information for the InfoCube. Therefore you should use at least InfoSource 2LIS_13_VDHDR and 2LIS_13_VDITM for filling the InfoCube.

The uploads are a prerequisite for any subsequent steps.