Advanced SAP Features

The Native interface for SAP has been enhanced to handle the user ID and password in the following syntax:

ENGINE SQLSAP SET CONNECTION_ATTRIBUTES system/user,password:'client'

This feature allows you to run a secured request that involves the following:

• One or more BAPIs, as BAPIs are secured by SAP.
• SAP delivered logical databases, as the server code is secured by SAP.
• Function modules (either SAP or customer) that are fully prototyped, including the proper AUTHORITY-CHECK statements.

This release supports most read-only BAPIs, including joins, as described in the following example:

CREATE SYNONYM baseapp/BUS0002_GETLIST
FOR BUS0002/GETLIST
BAPI DBMS SQLSAP AT I46
END
CREATE SYNONYM baseapp/BUS0002_GETDETAIL
FOR BUS0002/GETDETAIL BAPI
DBMS SQLSAP AT I46
END
JOIN BAPI0002_COMP_CODE IN COMPANYCODE_GETLIST TO
CCGD2_COMP_CODE IN OMPANYCODE_GETDETAIL
END
TABLE FILE COMPANYCODE_GETLIST
PRINT
CCGL0_TYPE NOPRINT
BAPI0002_COMP_CODE
BAPI0002_COMP_NAME
CCGD2_CURRENCY
CCGD2_LANGU
IF BAPI0002_COMP_CODE NE '2300' OR '6000'
END

The Native Interface supports all joins from and to SAP. For performance reasons, we do not recommend joining to an SAP data source from a non-SAP data source. It is more efficient to hold the keys in a sequential file, and then use the following code:

TABLE FILE SAP PRINT FIELDS IF KEYS IS (HOLD) END