Back in the 90s, calling SAP RFC function modules was pretty straightforward. There were import, export, and table parameters. The imports and exports could either be scalar or structured—and that was the end of the story.
Over the years, more complex parameters where pressed into this structure, and “Changings” became supported by modern SAP systems.
In today’s article, we’ll cover multi-nested tables and how to handle them in XQL. This is one of the XQL features that is supported from Peakboard version 3.8 or later.
The RFC function module
For this article, we’ll have a look at a sample RFC with an import parameter called I_SELOPT. This parameter is a table-like import parameter. But it’s not just a simple table—it’s a mutli-nested table.
That means each row can have a cell that is itself another table. The most common use case for this are tables designed for dynamic data selection. Each row refers to a certain field, and the table per row refers to a set of select options. Multi-nested tables provide a complete generic selection without the need for changing the import parameters when an additional filter field is necessary.
Let’s dig deeper into the associated type, ZTABRANGE. It points to the structure ZSINGLERANGE.
Within the line type ZSINGLERANGE, we find the scalar field name called FIELDNAME, and also the table for the generic filter called SELOP.
The table type ZTRSDSSELOPT refers to the line type RSDSSELOPT.
The standard line type RSDSSELOPT contains four single values to represent a filter line:
SIGN:Ifor include,Efor exclude.OPTION: An operator (for example,EQfor equals, orBTfor between).LOW: the lower value.HIGH: the optional upper value.
How to build the XQL
We start with a very simple version and build a non-multi-nested XQL table to call the function module. The table we build has just one column called FIELDNAME and two rows with values, MATNR and WERKS.
EXECUTE FUNCTION 'Z_PB_MAT_SELECTION'
EXPORTS
I_SELOPTS = ((FIELDNAME),
('MATNR'),
('WERKS'))
CHANGING
C_MATTAB INTO @RETVALNow, we need to add one more table to each selection row. The column name for the set of tables is called SELOP. And each SELOP cell is a table with the four columns mentioned earlier.
In our example, the first SELOP table has exactly one row. It contains a select option row for the material number 100-100.
The second SELOP row has two filter rows. In the first filter, we have the criteria EQUALS 1000, and the second filter row is BETWEEN 2000 and 3000.
Note that you have to be very careful with the brackets, and it’s highly recommended to use the notation that’s shown in this example, with the correct line breaks and indents.
EXECUTE FUNCTION 'Z_PB_MAT_SELECTION'
EXPORTS
I_SELOPTS = ((FIELDNAME, SELOP),
('MATNR', ((SIGN,OPTION,LOW,HIGH),
('I','EQ','100-100', '')) ),
('WERKS', ((SIGN,OPTION,LOW,HIGH),
('I','EQ','1000', ''),
('I','BT','2000', '3000'))
))
CHANGING
C_MATTAB INTO @RETVAL