Creating InfoSpokes 

Procedure

...

       1.      In the main menu of the Administrator Workbench, choose Tools ® Open Hub Service ® Edit InfoSpoke Enter a technical name for your InfoSpoke. You can also select a template.

       2.      Choose  Create InfoSpoke...

       3.      Enter a technical name for your InfoSpoke.

Tab Page: General

       4.      On the General tab page, select a data source. You can choose from an InfoCube, ODS objects, MultiProviders or InfoObjects (attributes or texts).

       5.      Select a destination. You can also enter the technical name of a destination that you are about to create.

       6.      Select an extraction mode. See InfoSpoke Extraction Mode.

       7.      Specify the number of rows per data package for the data records to be extracted. You can use this parameter to control the maximum size of a data package, and hence also how many main memories need to be made available to structure the data package.

Tab Page: Destination

       8.      Choose the Destination tab page and enter a description.

       9.      Select a Logical Target System.

   10.      Select one of the following destination types:

¡        Database table: For the settings Deleting the Table Before the Extraction and Technical Key, read Extraction to a Database Table. Using the indicator Notification to Third-Party Tools you also have the option of extracting data from a third-party tool. See also Extraction to Non-SAP Systems. Enter the name of the RFC destination for your third-party tool into the RFC Destination field. You can then display the parameter table for the third-party tool using Parameters.

¡        File (CSV). Either choose Application Server or specify a local directory; specify a delimiter of type Character. If you choose the application server as the storage for the file, you can select a Logical File Name or Logical File Name from the dropdown box. If you choose Logical File Name, you get to the transaction for creating logical file names by double clicking on the field for the file name. See Extraction to Flat Files.

Tab Page: InfoObjects

   11.      On the InfoObjects tab page, select the InfoObjects that need to be transferred. In doing so, the available fields are displayed in the right half of the screen, and you can transfer them into the left half of the screen by using the arrow keys.

The pushbutton Key Fields for the Table Start enables you to place key fields at the start of the field list. When extracting in database tables, it is necessary to extract such a field list. With flat files, you need to specify the field list sequence yourself.

Tab Page: Selection

   12.      From the Selection tab page, you can restrict the selected fields even further. As a restriction, only simple selections of single values and intervals are possible. After confirming you selection, you can also exclude single values or intervals via Selection Category. Do so by clicking only the icon  or  (included) and then switch to  or  (excluded). The default setting is Included.

Extraction of InfoCubes with non-cumulative key figures:

Set the filter value for 0RECORDTP (record type) to ‘1’. In this way, all markers are extracted that are in the compressed data from the InfoCube. You can extract non-cumulatives in which you compress the InfoCube in regular intervals and, afterwards, extract with 0RECORDTP = ‘1’.

Tab Page: Transformation

   13.      From the tab page Transformation, you can transform the data to be transferred using a BAdI. See InfoSpoke with Transformations using BAdI.

Activating and Executing InfoSpokes

   14.      Choose Activate InfoSpoke .

   15.      After successful activation, choose  Extraction in the Dialog Process. A status log is displayed.

If you do not want to start extraction straight away, that is, you want to schedule it, you need to include the InfoSpoke into a process chain. See also Including InfoSpokes in Process Chains.

Result

You have extracted data from an open hub data source into a database table or a flat CSV file.