Access to Tables

Procedure

In the next step you call the CompanyCode.GetList BAPI and a table of all the company codes is displayed. The corresponding RFM is called BAPI_COMPANYCODE_GETLIST. This RFM does not contain any import parameters.

First, get the table by accessing the table parameter list (getTableParameterList()).
Within this list, access the actual table (getTable()). The interface JCoTable contains all methods that are available for JCoStructure, together with additional methods for navigation in a table. A table can have any number of rows, or can also have no rows. The diagram below shows navigation with the method setRow(), in which the current row pointer is moved to every row in the table in turn. The method getNumRows() specifies how many rows exist in total. Instead of setRow(), you can also use the method nextRow(), as displayed in the lower section of the diagram.

Syntax Syntax

Accessing a Table

public static void step4WorkWithTable() throws JCoException

```
    {
```

        JCoDestination destination = JCoDestinationManager.getDestination(DESTINATION_NAME2);

        JCoFunction function = destination.getRepository().getFunction("BAPI_COMPANYCODE_GETLIST");

```
        if(function == null)
```

            throw new RuntimeException("BAPI_COMPANYCODE_GETLIST not found in SAP.");

```
        try
```
```
        {
```

            function.execute(destination);

```
        }
```
```
        catch(AbapException e)
```
```
        {
```

            System.out.println(e.toString());

```
            return;
```
```
        }
```
```
        
```

        JCoStructure returnStructure = function.getExportParameterList().getStructure("RETURN");

        if (! (returnStructure.getString("TYPE").equals("")||returnStructure.getString("TYPE").equals("S"))  )

```
        {
```

           throw new RuntimeException(returnStructure.getString("MESSAGE"));

```
        }
```
```
        
```

        JCoTable codes = function.getTableParameterList().getTable("COMPANYCODE_LIST");

        for (int i = 0; i < codes.getNumRows(); i++)

```
        {
```
```
            codes.setRow(i);
```

            System.out.println(codes.getString("COMP_CODE") + '\t' + codes.getString("COMP_NAME"));

```
        }
```

End of the code.