Data sources
Reading SAP Tables with Many Columns
Here you will find instructions for the manual installation of the function module Z_XTRACT_IS_TABLE.
Step 1 - Create module
Start transaction SE37 and create a new module called Z_XTRACT_IS_TABLE. You can store it in an existing function group or create a new function group for it. The same applies to the development class.
On the Attributes tab, set the execution type to remote callable.
Step 2 - Import parameters
Define the import parameters as shown in the following screenshot.
Step 3 - Table parameters
Define the table parameters as shown in the following screenshot.
Step 4 - Exceptions
Define the exceptions as shown in the following screenshot.
Step 5 - Code
You can find the ABAP code in the file Z_XTRACT_IS_TABLE.txt which can be downloaded here. You can copy the code into the source code editor simply by pressing Ctrl+C and Ctrl+V.
Save and activate the module.
Alternatively, you can install the function module using the transport request thtrans.zip, which is delivered with the system. This is located in the ABAP subfolder of the installation folder.
Step 6 - Using the module in Peakboard Designer
Once the module is active in SAP, you tell Peakboard to use it instead of the default RFC_READ_TABLE directly in the XQL statement. Append the clause WITH-OPTIONS(CUSTOMFUNCTIONNAME = '...') to your SELECT and specify the name of your module:
SELECT * FROM MARA WITH-OPTIONS(CUSTOMFUNCTIONNAME = 'Z_XTRACT_IS_TABLE')
The clause works with any table and can be combined with the usual XQL elements such as TOP, a column list, or a WHERE condition. Once the module is installed in your SAP system, it can be referenced from any number of data sources.
