The figure shows the automated data retrieval mechanism. You design and run the mapping in Oracle Warehouse Builder. The ABAP code gets run in the SAP system, and the data is retrieved and loaded to the target table.