Extracting Data from R/3
There are several possibilities of extracting data from R/3. The following example is one method. How you actually carry out this process depends on which functions you use in R/3.
This scenario is based on the S260 InfoStructure that contains data from sales orders. You modify the generic data source to include fields for the names of the characteristics and an equal number of fields for the value in the individual sales order.
The procedure described below requires ABAP programming knowledge. If you are not familiar with ABAP, consult someone who is.
In SAP R/3
In the R/3 System go to Customizing for BW by choosing Basis Components ®
Business Information Warehouse.
Choose Subsequent Processing of DataSources ®
Edit DataSources and enter SD as the application component on the next screen. Choose .
Select the DataSource (in this case 2LIS_01_S260) and choose Enhance Extrct Strc. to add new fields to the DataSource. Create three fields called CHAR1, CHAR2 and CHAR3 with type ATNAM (data type CHAR, length 30) for the names of three characteristics. Similarly create three fields called VALU1, VALU2, and VALU3 with type ATWRT (data type CHAR, length 30) to contain the values of the characteristics. Save the new append structure. Return to the selection screen.
Choose Function Enhancement to create a customer enhancement with which the fields that you created in the previous step are filled. For more information on creating customer enhancements see Customer Exits. in the Basis SAP Library. You can find a coding example in Note 304265. Save your entries.
Continue as described in Transfer of Historical Data for CBF.