Show TOC

Example documentationExtracting Data from an ERP System Locate this document in the navigation structure

 

There are several possibilities of extracting data from an ERP system. The following example is one method. How you actually carry out this process depends on which functions you use in the ERP system.

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.

Note Note

The procedure described below requires ABAP programming knowledge. If you are not familiar with ABAP, consult someone who is.

End of the note.

Procedure

In SAP R/3

  1. In the ERP system go to Customizing for BI by choosing   Basis Components   Business Information Warehouse.  

  2. Choose   Subsequent Processing of DataSources   Edit DataSources  and enter SD as the application component on the next screen. Choose Enter.

  3. 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 and return to the selection screen.

  4. Choose Function Enhancement to create a customer enhancement with which the fields that you created in the previous step are filled. You can find a coding example in SAP note 304265.

  5. Save your entries.

  6. Continue as described in Transfer of Historical Data for CBF.